Re: [HACKERS] fkey + primary key does not work in current

2000-10-16 Thread Bruce Momjian
That's strange. I didn't see it. Can you send it over. The archives don't seem to be working again. > > I believe that I sent a patch on Sep 17 for this to -patches although > I don't know if anyone saw it (it's in the archives, so I know it > went through). > > Stephan Szabo > [EMAIL PROTEC

Re: [HACKERS] fkey + primary key does not work in current

2000-10-16 Thread Stephan Szabo
I believe that I sent a patch on Sep 17 for this to -patches although I don't know if anyone saw it (it's in the archives, so I know it went through). Stephan Szabo [EMAIL PROTECTED] On Mon, 16 Oct 2000, Bruce Momjian wrote: > Has this been resolved? > > > On Fri, 15 Sep 2000, Tatsuo Ishii wro

Re: [HACKERS] fkey + primary key does not work in current

2000-10-16 Thread Bruce Momjian
Has this been resolved? > > On Fri, 15 Sep 2000, Tatsuo Ishii wrote: > > > It seems that foreign key does not work in current, if specified with > > primary key definition. Take a look at following example(works in > > 7.0.2.): > > > > test=# CREATE TABLE PKTABLE ( ptest1 int, ptest2 int, pte

Re: [HACKERS] fkey + primary key does not work in current

2000-09-15 Thread Stephan Szabo
On Fri, 15 Sep 2000, Tatsuo Ishii wrote: > It seems that foreign key does not work in current, if specified with > primary key definition. Take a look at following example(works in > 7.0.2.): > > test=# CREATE TABLE PKTABLE ( ptest1 int, ptest2 int, ptest3 int, ptest4 text, >PRIMARY KEY(ptest1

[HACKERS] fkey + primary key does not work in current

2000-09-15 Thread Tatsuo Ishii
It seems that foreign key does not work in current, if specified with primary key definition. Take a look at following example(works in 7.0.2.): test=# CREATE TABLE PKTABLE ( ptest1 int, ptest2 int, ptest3 int, ptest4 text, PRIMARY KEY(ptest1, ptest2, ptest3) ); NOTICE: CREATE TABLE/PRIMARY KEY