Re: MySQLs' "FOREIGN KEYS¨

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
Cc: JanWieck(at)yahoo(dot)com, pgsql-advocacy(at)postgresql(dot)org
Subject: Re: MySQLs' "FOREIGN KEYS¨
Date: 2003-11-10 13:04:48
Message-ID: 20031110080448.567b4e5a.threshar@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

On Mon, 10 Nov 2003 08:42:13 +0530
Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> wrote:

>
> Oops! really sorry , the tables were not of InnoDB type
> that could have supported FKEYS. *Will post again* once
> i get to put FKEYS properly on InnoDB tables.
>
> Still in that case also the beast should tell loudly about
> whats going on behind.
>

Wow. You know, I'd really expect it to at least go
"Hey, you're using MyISAM tables, which don't actually do foriegn keys..
so.. heh. Hope you don't actually need them!"

instead of being led to believe (like what happened to you) that you
actually had FK's and started building an app that relies on that fact.

--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-11-10 14:16:39 Re: MySQLs' "FOREIGN KEYS¨
Previous Message Rajesh Kumar Mallah 2003-11-10 03:12:13 Re: MySQLs' "FOREIGN KEYS¨