hi, 
i have relation with 3 int's and 1 text :
\d newstexts
                           Table "newstexts"
 Attribute |  Type   |                    Modifier
-----------+---------+-------------------------------------------------
 id        | integer | not null default nextval('newstexts_seq'::text)
 news_id   | integer | not null default ''
 class_id  | integer | not null default ''
 text      | text    | not null default ''

i also have a rather complicated trigger which does some trick *AFTER*
inserting data to this table.
when i try to insert something i got:
ERROR:  newses_seq.nextval: bad magic (00000000)

i know it's my fault. but what should i look for to trace the problem, and kill
the bug?
i would really appreciate quick answers or suggestions (i'm running out of time
...)

depesz

-- 
hubert depesz lubaczewski                          http://www.depesz.pl/
------------------------------------------------------------------------
     najwspanialszďż˝ rzeczďż˝ jakďż˝ daďż˝o nam nowoczesne spoďż˝eczeďż˝stwo,
      jest niesamowita wrďż˝cz ďż˝atwoďż˝ďż˝ unikania kontaktďż˝w z nim ...

Wed, 28 Feb 2001 14:54:45 +0100
hubert depesz lubaczewski <depesz@depesz.pl>
strange error
hubert depesz lubaczewski <depesz@depesz.pl> writes:
> ERROR:  newses_seq.nextval: bad magic (00000000)

Hmm, something bad has happened to your sequence object.

It would be interesting to try to figure out what caused that, but if
you're in a hurry, try dropping and recreating that sequence.

			regards, tom lane

Wed, 28 Feb 2001 10:18:50 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] strange error 