You must set the type of column to be serial or bigserial. Regards. Quan
On Mon, 2 Apr 2007 10:50:26 +0530 "Rohit Khare" <[EMAIL PROTECTED]> wrote: > I am using PGSQL 8.2.3 on Windows XP and pgAdmin 1.6.3. While adding columns > to a table from pgAdmin front-end, an option appears "sequence" with a > drop-down box on the column creation window, but it remains disabled. I have > already created a sequence but want to connect that sequence with this > column. How can I do this? Why this disabled drop-down box not enabling? ----------------------------------------------- Zongliang Quan [EMAIL PROTECTED],[EMAIL PROTECTED] Admin by http://postgresql.oss.tw http://postgresql-chinese.blogspot.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings