Re: Moving sequences to another schema

On Jun 30, 2005, at 8:13 PM, Bernd Helmle wrote:

> I currently recognized that a SERIAL column doesn't only create an
> implicit sequence, it creates an implicit composite type with the
> same name, too. I think this is the same for CREATE SEQUENCE?

Sequences are just special types of tables. All tables have a
corresponding composite type, so sequences do as well.

CREATE TABLE foo (foo_id serial); is a shorthand for

CREATE SEQUENCE foo_foo_id_seq;
CREATE TABLE foo (foo_id integer default nextval
('foo_foo_id_seq'::text));

Using SERIAL implies CREATE SEQUENCE.

Does this help?

Michael Glaesemann
grzm myrealbox com