Re: Strange SERIAL / Sequence error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Christian Marschalek" <cm(at)chello(dot)at>
Cc: "[GENERAL] PostgreSQL" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Strange SERIAL / Sequence error
Date: 2001-05-02 22:10:28
Message-ID: 17095.988841428@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Christian Marschalek" <cm(at)chello(dot)at> writes:
> (NEXTVAL('""tab_asdf_seq""'::text), 'asdf')

> ERROR: Relation '"tab_asdf_seq"' does not exist

Don't double those double quotes (you don't really need 'em at all,
but in any case not more than one...)

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-05-02 22:25:48 Re: update ... from where id in (..) question
Previous Message Andy Koch 2001-05-02 22:08:09 Re: DROP TABLE wildcard