Re: pg newbie stumped on sequences!

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg newbie stumped on sequences!
Дата
Msg-id 116.1053451146@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg newbie stumped on sequences!  ("Ben Joyce" <ben.joyce-pgsql@babelfish.co.uk>)
Список pgsql-general
"Ben Joyce" <ben.joyce-pgsql@babelfish.co.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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: disk space usage enlarging despite vacuuming
Следующее
От: jks@selectacast.net
Дата:
Сообщение: Re: sequence caches