[HACKERS] Another naive question, inheritance and foreign key

[Shridhar Daithankar[EMAIL PROTECTED]]

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

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Another naive question, inheritance and foreign key

[Stephan Szabo]

On Wed, 19 Mar 2003, Shridhar Daithankar[EMAIL PROTECTED] wrote:

 Just stumbled upon this. Is it correct to conclude that foreign keys are not
 inherited from this text?

Yes. If you want more info, check out the archives.


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]