Another naive question, inheritance and foreign key
От | Shridhar Daithankar |
---|---|
Тема | Another naive question, inheritance and foreign key |
Дата | |
Msg-id | 200303191939.34276.shridhar_daithankar@persistent.co.in обсуждение исходный текст |
Ответы |
Re: Another naive question, inheritance and foreign key
|
Список | pgsql-hackers |
Hi, Just stumbled upon this. Is it correct to conclude that foreign keys are not inherited from this text? -------------------- phd=# create table perbookings(type smallint) inherits (bookings); CREATE TABLE phd=# \d perbookings; Table "public.perbookings"Column | Type | Modifiers --------+-----------------------------+----------------------------------rid | integer |uid | integer |stime | timestamp without time zone |etime | timestamp without time zone |bid | integer | default nextval('bid_seq'::text)type | smallint | Check constraints: "bookings_etime" (etime > stime) phd=# \d bookings; Table "public.bookings"Column | Type | Modifiers --------+-----------------------------+----------------------------------rid | integer |uid | integer |stime | timestamp without time zone |etime | timestamp without time zone |bid | integer | default nextval('bid_seq'::text) Check constraints: "bookings_etime" (etime > stime) Foreign Key constraints: $1 FOREIGN KEY (rid) REFERENCES resource(id) ON UPDATE CASCADE ON DELETE CASCADE, $2 FOREIGN KEY (uid) REFERENCES users(userid) ON UPDATE CASCADE ON DELETE CASCADE phd=# select version(); version ---------------------------------------------------------------------PostgreSQL 7.3.2 on i386-portbld-freebsd4.7, compiledby GCC 2.95.4 (1 row) -------------------- TIA..Shridhar
В списке pgsql-hackers по дате отправления: