Re: PostgreSQL 8.1 vs. MySQL 5.0?

On Thu, 2005-10-06 at 14:35, CSN wrote:
> --- Scott Marlowe <smarlowe@g2switchworks.com> wrote:
>

> >
> > But what really bugs me is that some things that ARE
> > bugs simply aren't
> > getting fixed and probably won't.  Specifically,
> > while mysql understands
> > fk references made at a table level, it simply
> > ignores, without error,
> > warning, or notice, fk references made in a column.
> > arg...  Very
> > frustrating.  If they just didn't support that
> > syntax it would be much
> > less bothersome, since I'd try it, get an error, and
> > try the other
> > syntax.  Instead, I spent an afternoon trying to
> > figure out why it
> > wasn't doing ANYTHING when I declared an FK
> > reference at column level.
> >
> > Things like that are, sadly, kinda rampant in MySQL.
> >
>
> What's the difference between a fk at the table level
> vs. column level? The only fk's I've used are one
> column referencing another.

It's just where they're defined.  See this bug for an explanation:

http://bugs.mysql.com/bug.php?id=13301