Strange SERIAL / Sequence error

From: "Christian Marschalek" <cm(at)chello(dot)at>
To: "[GENERAL] PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Subject: Strange SERIAL / Sequence error
Date: 2001-05-02 19:53:26
Message-ID: 000c01c0d341$8da7e720$0200a8c0@server
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug Ostgard 2001-05-02 19:55:26 RPM won't install
Previous Message Andy Koch 2001-05-02 19:52:57 DROP TABLE wildcard