Foreign Keys

Started by <No Name>about 25 years ago8 messagesgeneral
Jump to latest
#1<No Name>
bobmarley4u2c@yahoo.com

I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems to
be the problem?

In reply to: <No Name> (#1)
Re: Foreign Keys

As far as I know foreign keys are not supported by 6.5.

That's why I use 7.x.x =)

It does not make any complaints about putting the foreign keys there but it
does not do anything with them either.

Regards

Per-Olof Pettersson

"<No Name>" <bobmarley4u2c@yahoo.com> wrote in message
news:<95d0k3$13v7$2@news.tht.net>...

I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems to

be the problem?

"<No Name>" <bobmarley4u2c@yahoo.com> wrote in message
news:95d0k3$13v7$2@news.tht.net...

Show quoted text

I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems to
be the problem?

#3<No Name>
bobmarley4u2c@yahoo.com
In reply to: <No Name> (#1)
Re: Foreign Keys

So with 7.xx foreign keys don't work???

Per-Olof Petterson wrote in message <95dar7$15nu$1@news.tht.net>...

As far as I know foreign keys are not supported by 6.5.

That's why I use 7.x.x =)

It does not make any complaints about putting the foreign keys there but it
does not do anything with them either.

Regards

Per-Olof Pettersson

"<No Name>" <bobmarley4u2c@yahoo.com> wrote in message
news:<95d0k3$13v7$2@news.tht.net>...

I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems

to

be the problem?

"<No Name>" <bobmarley4u2c@yahoo.com> wrote in message
news:95d0k3$13v7$2@news.tht.net...

I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems

to

Show quoted text

be the problem?

#4Brett W. McCoy
bmccoy@chapelperilous.net
In reply to: <No Name> (#1)
Re: Foreign Keys

On Thu, 1 Feb 2001, <No Name> wrote:

I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems to
be the problem?

They are not supported in that version. You need to upgrade to 7.x for
foreign key support.

-- Brett
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
She often gave herself very good advice (though she very seldom followed it).
-- Lewis Carroll

#5Jose Manuel Lorenzo Lopez
jose-manuel.lorenzo-lopez@conti.de
In reply to: Brett W. McCoy (#4)
Re: Foreign Keys

"" schrieb:

I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems to
be the problem?

Foreign keys are support from postgresql version 7.x! You have to
upgrade
to postgresql 7.x if you want to use this feature!

Best Regards,

Jos� Manuel Lorenzo L�pez

--
**********************************************************************
** Jos� Manuel Lorenzo L�pez **
** **
** ICA Informationssysteme Consulting & Anwendungsgesellschaft mbH **
** Dept. SAP Basis R/3 VBue **
** **
** e-mail to: jose-manuel.lorenzo-lopez@conti.de **
**********************************************************************

#6Brett W. McCoy
bmccoy@chapelperilous.net
In reply to: <No Name> (#3)
Re: Re: Foreign Keys

On Fri, 2 Feb 2001, <No Name> wrote:

So with 7.xx foreign keys don't work???

They most certainly do. Not sure what Per-Olof Petterson meant by this:

It does not make any complaints about putting the foreign keys there but it
does not do anything with them either.

I use them all the time and they will scream if you tryo to violate
integrity.

-- Brett
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
The solution of problems is the most characteristic and peculiar sort
of voluntary thinking.
-- William James

#7Gregory Wood
gregw@com-stock.com
In reply to: <No Name> (#1)
Re: Foreign Keys

Foreign keys *do* work with 7.x.x. I think he means that 6.5 doesn't
complain about the foreign keys... it just ignores them.

Greg

So with 7.xx foreign keys don't work???

As far as I know foreign keys are not supported by 6.5.

That's why I use 7.x.x =)

It does not make any complaints about putting the foreign keys there but

it

Show quoted text

does not do anything with them either.

I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems

to

be the problem?

#8Einar Karttunen
ekarttun@cs.Helsinki.FI
In reply to: <No Name> (#3)
Re: Re: Foreign Keys

On Fri, 2 Feb 2001, <No Name> wrote:

So with 7.xx foreign keys don't work???

version 7.0
Foreign keys are implemented, with the exception of PARTIAL MATCH foreign keys.
in 7.1 beta
Allow PRIMARY/FOREIGN Key definitions on inherited columns.

- Einar