Обсуждение: strange error
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 ...
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