Strange SERIAL / Sequence error - Mailing list pgsql-general

From Christian Marschalek
Subject Strange SERIAL / Sequence error
Date
Msg-id 000c01c0d341$8da7e720$0200a8c0@server
Whole thread Raw
Responses Re: Strange SERIAL / Sequence error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I create a table with:
CREATE TABLE "tab" ("asdf" SERIAL, "asdf2" char (20) NOT NULL );

Then I try to insert some data:
INSERT INTO "tab" ("asdf", "asdf2") VALUES
(NEXTVAL('""tab_asdf_seq""'::text), 'asdf')

ERROR: Relation '"tab_asdf_seq"' does not exist

(done with phpPgAdmin 2.3)


pgsql-general by date:

Previous
From: pgsql@itsbruce.uklinux.net
Date:
Subject: Security and performance
Next
From: "Albertson, Chris"
Date:
Subject: "group by" is quite expensive