Thread: Connecting sequence to table column
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 optionappears "sequence" with a drop-down box on the column creation window, but it remains disabled. I have already createda sequence but want to connect that sequence with this column. How can I do this? Why this disabled drop-down boxnot enabling?
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" <rpk.general@gmail.com> 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 quanzongliang@gmail.com,quanzongliang@hotmail.com Admin by http://postgresql.oss.tw http://postgresql-chinese.blogspot.com