Unanswered: Postgres better for foreign key implementation??
Hi all, I am hoping you can give me some insight.
I am very new to working with databases. I have taken courses, read some books, and am now ready to start developing some databases for web pages.
My question is this:
I was always taught that to maintain referential integrity, and other reasons, in a complex database, foreign keys were recommended.
I have planned a database design with foreign keys, and now i fine (apparently?) that mysql cannot use foreign keys, unless compiled a certain way, etc...
My question is this: Is postgres better for foreign key implementation?
( I also posted this in mysql forum as well)
Yes, I would say Postgres is the way to go for foreign keys and a better overall standards compliant database.
(I'm only available at the email address provided in my profile on weekdays, if you have questions or advice, during off hours use AIM). Also any views I provide here or on my website are mine and not representative of any views of my work, family, friends and sometimes even myself.