> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 27 September 2006 17:09 > To: Dave Page > Subject: RE: [BUGS] BUG #2644: pgadmin III foreign key > > ---------- Initial Header ----------- > > From : "Dave Page" dpage@vale-housing.co.uk > To : [EMAIL PROTECTED] > Cc : > Date : Tue, 26 Sep 2006 17:03:18 +0100 > Subject : RE: [BUGS] BUG #2644: pgadmin III foreign key > > > OK thank you. > I try Version 1.6 beta 1 and I find very good improvements but > I'm sorry Foreign key wizard still do not work properly. > > Access the db with user postgres; > Create DB test; > create schema postgres; > drop schema public; > Disconnect; > Access the db with user postgres; > create table1; > create table2; > > > create foreign key on table1 for table2 does not work with > GUI, you need to write the SQL CODE.
That works perfectly for me. Are you trying to reference properly indexed columns? What do your table definitions look like? > I download the sources, if i have time i will search where is > the problem. OK, thanks. Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org