| From: | Vincent De Groote <vdg(dot)encelade(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | create table within a schema |
| Date: | 2011-05-06 11:10:44 |
| Message-ID: | 1304680244.4709.36.camel@portable-vdg |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello
I have the following code:
create schema test;
create type test.my_type as enum ( 'a', 'b' );
create table test.my_table_1 (
id bigserial not null,
type test.my_type not null,
length bigint,
primary key ( id )
);
create sequence test.my_sequence_id;
create table test.my_table_2 (
id bigint not null default public.nextval ( test.my_sequence_id ),
type test.my_type not null,
length bigint,
primary key ( id )
);
This last create operation fails with the message
ERROR: missing FROM-clause entry for table "test"
Could someone explain me that error ? What are the difference between
the table my_table_1 and the table my_table_2 ?
The documentation show that the table creation must be followed by a
statement like
ALTER SEQUENCE tablename_colname_seq OWNED BY tablename.colname;
but the table creation has been rejected.
Thanks for your reply
Vincent De Groote
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2011-05-06 11:22:57 | Re: create table within a schema |
| Previous Message | Asfand Qazi (Sanger Institute) | 2011-05-06 10:22:09 | Re: Generating fields in views with search/replace? |