Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    3

    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)

    Thanks!!!

  2. #2
    Join Date
    Dec 2002
    Posts
    65
    Yes, I would say Postgres is the way to go for foreign keys and a better overall standards compliant database.

    -b
    (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.

    http://www.bcyde.com

  3. #3
    Join Date
    Feb 2003
    Posts
    3

    Smile Re: Postgres better for foreign key implementation??

    Thanks, that is what I am finding... needed some reinforcement though.


    Originally posted by lisa3711
    Hi all, I am hoping you can give me some insight.
    <Snip>

    My question is this: Is postgres better for foreign key implementation?
    ( I also posted this in mysql forum as well)

    Thanks!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •