Re: [GENERAL] Inheritance and referential integritry in 7.0.3

2001-04-08 Thread Eric G. Miller
On Sun, Apr 08, 2001 at 01:04:16PM +0800, Alastair D'Silva wrote: > I am using PostgreSQL 7.0.3 and have the following schema: > > CREATE TABLE "products" ( > "id" SERIAL NOT NULL PRIMARY KEY, > "name" text NOT NULL, > "description" text NOT NULL, > "brand" text NO

Re: [GENERAL] Inheritance and referential integritry in 7.0.3

2001-04-08 Thread Oliver Elphick
"Alastair D'Silva" wrote: >I am using PostgreSQL 7.0.3 and have the following schema: > >CREATE TABLE "products" ( ... >There are various other tables inheriting from "products". ... >There is also another table which references products: ... >Now, if I insert a row into one of "produ

[GENERAL] Inheritance and referential integritry in 7.0.3

2001-04-07 Thread Alastair D'Silva
I am using PostgreSQL 7.0.3 and have the following schema: CREATE TABLE "products" ( "id" SERIAL NOT NULL PRIMARY KEY, "name" text NOT NULL, "description" text NOT NULL, "brand" text NOT NULL, "url" text, "weight" float4 NOT NULL, "stock" in