From: | "Shridhar Daithankar<shridhar_daithankar(at)persistent(dot)co(dot)in>" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Another naive question, inheritance and foreign key |
Date: | 2003-03-19 14:09:34 |
Message-ID: | 200303191939.34276.shridhar_daithankar@persistent.co.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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, compiled by GCC 2.95.4
(1 row)
--------------------
TIA..
Shridhar
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-03-19 14:34:27 | Re: Win32 native port |
Previous Message | Michael Meskes | 2003-03-19 12:15:46 | Mail problem |