Re: Problem with Serial Columns

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: Problem with Serial Columns
Дата
Msg-id 46A85EFE.9000203@postgresql.org
обсуждение исходный текст
Ответ на Problem with Serial Columns  ("Luiz K. Matsumura" <luiz@planit.com.br>)
Список pgadmin-support
Luiz K. Matsumura wrote:
> The atacched diff file modify this (reference is the source of 1.6.3), 
> but I don't have sufficient skill to compile the source and I'm not a 
> C/C++ programmer to do a better change.

Thanks - I've applied a fix along these lines. It'll be in beta 3.

> I think that a better test to serial columns, may be to verify primarily 
> if there are a dependence between the column and the sequence, and then 
> verify if the default value of the column is a nextval of the this 
> sequence.

Yeah, that's been on the todo list for a while but noone got round to it 
yet:

- detect serial columns from pg_depend, not column default (observe 
deviating serial name)

Thanks, Dave


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

Предыдущее
От: "Luiz K. Matsumura"
Дата:
Сообщение: Problem with Serial Columns
Следующее
От: Dave Page
Дата:
Сообщение: pgAdmin III v1.8.0 Beta 2 released