Re: [SQLObject] PostgreSQL and Serial, foreign keys for self-reference

[Bud P. B. <bu...@si...>]

On 31 Mar 2003 11:12:16 -0600
Ian Bicking <ia...@co...> wrote:

> AFAIK (but I'm not a Postgres expert), SERIAL is equivalent to creating
> a sequence in the same way SQLObject expects.  Maybe it'll even work. 
> It's easier for SQLObject to use the sequence directly rather than let
> the ID be generated implicitly by the default, but obviously you don't
> have to use the default.

I thought of just trying it in the CREATE statement:

CREATE TABLE person(
  id INT PRIMARY KEY SERIAL,
  ....

and will let you know if it works the same as when creating a sequence
explicitly.    (Or did I misunderstand the doc and SQLObject actually
generates the CREATE statements?).

thanks

--b