Re: [GENERAL] inherit with foreign key reference

2005-05-06 Thread Scott Marlowe
On Fri, 2005-05-06 at 15:51, Aaron Steele wrote: > dear readers, > > i've created a simple Fooey table that inherits from Foo: > !--! > CREATE TABLE Foo( > fooid serial UNIQUE, > footype text); > CREATE TABLE Foo

Re: [GENERAL] inherit with foreign key reference

2005-05-06 Thread elein
On Fri, May 06, 2005 at 01:51:45PM -0700, Aaron Steele wrote: > dear readers, > > i've created a simple Fooey table that inherits from Foo: > !--! > CREATE TABLE Foo( > fooid serial UNIQUE, > footype text); > CRE

Re: [GENERAL] inherit with foreign key reference

2005-05-06 Thread Stephan Szabo
On Fri, 6 May 2005, Aaron Steele wrote: > dear readers, > > i've created a simple Fooey table that inherits from Foo: > !--! > CREATE TABLE Foo( > fooid serial UNIQUE, > footype text); > CREATE TABLE Fooey( >

[GENERAL] inherit with foreign key reference

2005-05-06 Thread Aaron Steele
dear readers, i've created a simple Fooey table that inherits from Foo: !--! CREATE TABLE Foo( fooid serial UNIQUE, footype text); CREATE TABLE Fooey( datatext); INHERITS(Foo); !---