On Thu, Oct 06, 2005 at 10:10:14AM -0500, Scott Marlowe 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.
Are you aware of the MySQL Gotchas website (just google it)? Any time
you see MySQL being stupid about something you should probably check
there first to see if it's a "feature".
http://sql-info.de/mysql/gotchas.html
Of course, one should probably also look at the PostgreSQL Gotchas page
(same guy) just to be fair :-)
http://sql-info.de/postgresql/postgres-gotchas.html
Now whether or not those are still valid or not I have no idea...
-philip
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
