Re: Renaming sequence auto generated by SERIAL type don't update pg_attrdef

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Renaming sequence auto generated by SERIAL type don't update pg_attrdef
Дата
Msg-id 20795.1236655715@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Renaming sequence auto generated by SERIAL type don't update pg_attrdef  ("Dickson S. Guedes" <listas@guedesoft.net>)
Ответы Re: Renaming sequence auto generated by SERIAL type don't update pg_attrdef  (Oliver Jowett <oliver@opencloud.com>)
Re: Renaming sequence auto generated by SERIAL type don't update pg_attrdef  ("Dickson S. Guedes" <listas@guedesoft.net>)
Список pgsql-jdbc
"Dickson S. Guedes" <listas@guedesoft.net> writes:
> Shouldn't the JDBC driver use another query instead that, since docs
> alerts[1] to this problem?

What's the default value being used for anyway?  If it's to determine
which sequence is associated with the column, I think you shouldn't be
looking at pg_attrdef at all; you should look for a dependent sequence
via pg_depend.  But maybe it's only being used to check if the column
has a default, in which case the possible staleness of the string
value isn't important.

            regards, tom lane

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

Предыдущее
От: "Dickson S. Guedes"
Дата:
Сообщение: Renaming sequence auto generated by SERIAL type don't update pg_attrdef
Следующее
От: Scott Carey
Дата:
Сообщение: Re: [PERFORM] Query much slower when run from postgres function