Yes, I've seen "serial" used in other places than the primary key,
but I was referring to Greg's output. The data type for the sequence
is listed as "bigint". My thought was that the data type was listed
as "serial" for sequences. I just looked at my database and I was
wrong about that. It does list the data type as an integer when you
"describe" the table.
Carol
On May 10, 2007, at 5:17 PM, Jim Nasby wrote:
On May 10, 2007, at 9:01 AM, Carol Walter wrote:
And this is more than a question than an answer, but I thought
that sequences had to designated as data type "serial."
Nope... sequences are actually completely un-related to tables. You
can define a sequence that's not referenced by any table. The
serial data type is essentially a 'macro' that:
Creates a sequence
Sets the default value for the field to be the nextval() of that
sequence
Sets the field to be NOT NULL
--
Jim Nasby [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
