strange error

From: hubert depesz lubaczewski <depesz(at)depesz(dot)pl>
To: pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: strange error
Date: 2001-02-28 13:54:45
Message-ID: 20010228145445.A15473@depeszws.depesz.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2001-02-28 14:15:02 Re: store procedure in pl/pgsql
Previous Message Martijn van Oosterhout 2001-02-28 13:29:05 Re: Re: vacuum and backup

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-02-28 15:08:47 Re: stuck spinlock
Previous Message Tatsuo Ishii 2001-02-28 13:00:05 Re: Idea for reducing planning time