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 wrote:

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 PROTECTED]

[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

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,