From: Ivo Anon <ivoa72@hotmail.com>
To: " <pgsql-novice@postgresql.org.pgsql-sql>
Subject: nextval problem
Date: Fri, 13 Feb 2004 01:54:21 GMT
Message-ID: <h7WWb.13725$2Z2.1853@amsnews05.chello.com> (raw)
I'm new to postgresql and I'm having problems with the 'nextval' function
(or whatever it is called in postgresql).
I created a table (called ADDRESS) using 'pgadmin' which has a serial field
(called addressid). When I tried the sql statement:
select nextval('public."ADDRESS_addressid_seq"')
everything seemed to be working fine.
I then used the create table statement (displayed in pgadmin when the table
'ADDRESS' is selected) to create the same table (of course after first
dropping 'ADDRESS'). When I try the same select-statement I suddenly got an
error message saying:
ERROR: Relation "public"."ADDRESS_addressid_seq" does not exist
Can anybody help me with this problem?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ivoa72@hotmail.com, pgsql-novice@postgresql.org.pgsql-sql
Subject: Re: nextval problem
In-Reply-To: <h7WWb.13725$2Z2.1853@amsnews05.chello.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox