(hopefully this doesn't double post... stupid mail system)
On Tue, 11 Sep 2001, Christof Glaser wrote:
> On Tuesday, 11. September 2001 10:04, Kevin Way wrote:
> > I'm having a little trouble with some inherited tables and a foreign
> > key. Here's a simplified case, to show the trouble.
> >
>
On Tuesday, 11. September 2001 11:12, I wrote before I thought:
> On Tuesday, 11. September 2001 10:04, Kevin Way wrote:
> > I'm having a little trouble with some inherited tables and a foreign
> > key. Here's a simplified case, to show the trouble.
> >
> > CREATE TABLE node (
> > node_id
On Tuesday, 11. September 2001 10:04, Kevin Way wrote:
> I'm having a little trouble with some inherited tables and a foreign
> key. Here's a simplified case, to show the trouble.
>
> CREATE TABLE node (
> node_id SERIAL NOT NULL,
> nameTEXT NOT NULL,
> PRIMARY KEY (node_i
I'm having a little trouble with some inherited tables and a foreign key. Here's
a simplified case, to show the trouble.
CREATE TABLE node (
node_id SERIAL NOT NULL,
nameTEXT NOT NULL,
PRIMARY KEY (node_id)
);
-- works just fine
CREATE TABLE users (
email TEXT
