From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Bo Lorentsen <bl(at)netgroup(dot)dk> |
Cc: | Vivek Khera <khera(at)kcilink(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Buglist |
Date: | 2003-08-19 21:10:35 |
Message-ID: | Pine.LNX.4.33.0308191500450.10475-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On 19 Aug 2003, Bo Lorentsen wrote:
> On Tue, 2003-08-19 at 18:17, Vivek Khera wrote:
>
> > Since the beginning of time (at least MySQL v3.22) MySQL has silently
> > ignored the foreign key references in table create statement. Now
> > that they have foreign key support (version 4.x), do they honor those
> > statements? Nope. You have to use their own syntax to declare your
> > FKs. They still silently ignore the references in the table create
> > statements.
> Is this really true ?? Does 4.x still not support FK, then how about
> transactions, does they that not work too ?
>
> Is this not just the MyISAM tables that still got the problem (they are
> verison 3.x) ?
No, the problem is that in SQL spec, you do it with the foreign key
declaration inside parnes in the create statement like:
create table abc123
(
id serial unique,
info text);
create table abc1234
(
moreinfo text,
ref_id int,
foreign key (ref_id)
references abc123(id)
on delete cascade
);
In MySQL this syntax is silently swallowed, while their own "proper"
syntax is like this:
create table abc123
(
id serial unique,
info text)
type=innodb;
create table abc1234
(
moreinfo text,
ref_id int)
foreign key (ref_id) references abc123(id)
on delete CASCADE
type=innodb;
So the syntaxes are different, and one is apparently swallowed without
error or anything, but in fact you have no fks in place.
From | Date | Subject | |
---|---|---|---|
Next Message | Bo Lorentsen | 2003-08-19 22:13:09 | Re: Buglist |
Previous Message | alvherre | 2003-08-19 20:39:11 | Re: My details |
From | Date | Subject | |
---|---|---|---|
Next Message | Bo Lorentsen | 2003-08-19 22:13:09 | Re: Buglist |
Previous Message | Bo Lorentsen | 2003-08-19 19:50:25 | Re: Buglist |