Re: pg newbie stumped on sequences!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ben Joyce" <ben(dot)joyce-pgsql(at)babelfish(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg newbie stumped on sequences!
Date: 2003-05-20 17:19:06
Message-ID: 116.1053451146@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ben Joyce" <ben(dot)joyce-pgsql(at)babelfish(dot)co(dot)uk> writes:
> It's been suggested that ('""test_ID_seq""'::text) might be the issue,
> irregular quoting? Odd, as this is what phpPgAdmin spewed out.

Should be nextval('"test_ID_seq"') ... the ::text is unnecessary, though
harmless. If phpPgAdmin doubled the double quotes then it's wrong.

7.1.3 is a bit long in the tooth as far as Postgres versions go, and it
may be that you are overdue for a phpPgAdmin update too ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message jks 2003-05-20 17:22:19 Re: sequence caches
Previous Message Tom Lane 2003-05-20 17:13:00 Re: disk space usage enlarging despite vacuuming