X-Original-To: pgsql-novice-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP
	id B5B59D1B4D2; Fri, 13 Feb 2004 02:16:35 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 05838-02; Thu, 12 Feb 2004 22:16:33 -0400 (AST)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by svr1.postgresql.org (Postfix) with ESMTP
	id 01DCAD1B4BE; Thu, 12 Feb 2004 22:16:30 -0400 (AST)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by news.hub.org (8.12.9/8.12.9) with ESMTP id i1D2GT1Y038099;
	Fri, 13 Feb 2004 02:16:29 GMT (envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.12.9/8.12.9/Submit) id i1D1sJ5v032857;
	Fri, 13 Feb 2004 01:54:19 GMT
From: "Ivo Anon" <ivoa72@hotmail.com>
X-Newsgroups: comp.databases.postgresql.novice,
	comp.databases.postgresql.questions,
	comp.databases.postgresql.sql
Subject: nextval problem
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <h7WWb.13725$2Z2.1853@amsnews05.chello.com>
Date: Fri, 13 Feb 2004 01:54:21 GMT
X-Complaints-To: abuse@chello.nl
Organization: chello broadband
To: "pgsql-novice@postgresql.org.pgsql-sql"@postgresql.org
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200402/103
X-Sequence-Number: 9574

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?