[GENERAL] Foreign key in composite values

[Vincent De Groote]

Hello,

I have a composite type with 2 fields.  I would like to check that one
of these fields exists in another table.

Foreign keys on a composite field does not seem to be supported.
Is there another way to do that ?

Thanks for your reply
Vincent De Groote

[GENERAL] create table within a schema

[Vincent De Groote]

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