Re: pgAdminII support question

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: pgAdminII support question
Дата
Msg-id 4B4F835C.80804@lelarge.info
обсуждение исходный текст
Ответ на pgAdminII support question  (David Leikis <David.Leikis@sdl.usu.edu>)
Список pgadmin-support
Le 07/12/2009 18:09, David Leikis a écrit :
> I am trying to create auto-incrementing of the Primary Key within each record by using sequences.
> 
> Sometimes I can get the "add - sequence" to work by creating it with the name "tablename_columnname_seq".
> 
> There are many other times that this doesn't work.  (The table create SQL doesn't show up with the 'serial' command
wordin the column creation.)
 
> 
> The sequence name is there, but it doesn't seem to 'make connection' to that table/column.
> 
> I am using pgAdmin version 1.8.4 and PostGres version 8.3 in Winxp setting.
> 
> Some solution to this would be very helpful, please.
> 

Usually, you should use the serial datatype. It'll automatically create
a sequence and link it to your column default value.


-- 
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com


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

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: can't get pgpass.conf to work with pgagent
Следующее
От: Tzvi R
Дата:
Сообщение: Re: Slow connect due to some queries