Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-hackers by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group