[BUGS] foreign key constraint not working when index tablespace is not default.

2005-03-26 Thread Joel Krajden
CES dept_map( code ), FOREIGN KEY( title ) REFERENCES fis_title_map( fis_title ) ); -- | Joel Krajden | Rm: LB-915, Tel: 514 848-2424 3052 | | | Fax: 514 848-2830 | | Senior Systems Analyst| Email: [EMAIL PROTEC

Re: [BUGS] foreign key constraint not working when index tablespace

2005-03-29 Thread Joel Krajden
+--- fis| postgres | /local/data/pgsql-8.0/fis | fis_index | postgres | /local/data/pgsql-8.0/fis_index | {postgres=C/postgres,=C/postgres} Thanks for looking into it. Regards joel Tom Lane wrote: Joel Krajden

Re: [BUGS] foreign key constraint not working when index tablespace

2005-03-30 Thread Joel Krajden
t the schema search path changed after the user logged in. There was no other table with a duplicate name in another schema. Thanks for doing the sanity check. Joel Tom Lane wrote: Joel Krajden <[EMAIL PROTECTED]> writes: But if I create the tables as a mortal user or create them as post