strange error

Started by hubert depesz lubaczewskialmost 25 years ago2 messages

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 ...

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: hubert depesz lubaczewski (#1)
Re: [HACKERS] 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