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