Re: Connecting sequence to table column

From: "Quan Zongliang(Gmail)" <quanzongliang(at)gmail(dot)com>
To: "Rohit Khare" <rpk(dot)general(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Connecting sequence to table column
Date: 2007-04-02 05:42:01
Message-ID: 20070402143858.ECAB.QUANZONGLIANG@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support


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(dot)general(at)gmail(dot)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(at)gmail(dot)com,quanzongliang(at)hotmail(dot)com
Admin by
http://postgresql.oss.tw
http://postgresql-chinese.blogspot.com

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Hiroshi Saito 2007-04-02 05:48:28 Re: Problem restoring backup file
Previous Message Rohit Khare 2007-04-02 05:20:26 Connecting sequence to table column