On 4/3/06, Ottavio Campana <ottavio@campana.vi.it> wrote:
3) faq 4.11.1 says
> CREATE TABLE person (
> id SERIAL,
> name TEXT
> );
>
>is automatically translated into this:
>
> CREATE SEQUENCE person_id_seq;
> CREATE TABLE person (
> id INT4 NOT NULL DEFAULT nextval('person_id_seq'),
> name TEXT
> );
how can I do it with a INT8 instead of a INT4?
Thank you
Is there a reason not to write explicitly?
CREATE SEQUENCE person_id_seq;
CREATE TABLE person (
id INT8 NOT NULL DEFAULT nextval('person_id_seq'),
name TEXT
);
Tomislav