> It'll help if you provide more info, like what version of PostgreSQL, > what OS and version, example queries, etc.. Woop. The database that's working is a PostgreSQL 6.5 on Debian 2.1, the database that isn't is a PostgreSQL 6.5 on Suse 6.4, both x86 architecture machines. The PostgreSQL on the Suse box is a standard package, the PostgreSQL on the Debian box is compiled from scratch. An example of a query is "SELECT id FROM inmail WHERE mailsetup_id = 1". This is through the Python database adapter. I think I've maybe found the problem, the database adapter on the machine that is working is at 3.0, while the one that isn't is at 3.0 beta. Hmm. Anyways, if you guys have any ideas I'd appreciate to hear about them. -Morten
- [GENERAL] Foreign Keys Simon Drabble
- [GENERAL] foreign keys Radoslaw Stachowiak
- Re: [GENERAL] foreign keys Bruce Momjian
- Re: [GENERAL] foreign keys Radoslaw Stachowiak
- Re: [GENERAL] foreign keys Bruce Momjian
- Re: [GENERAL] foreign keys Stephan Szabo
- Re: [GENERAL] foreign keys Radoslaw Stachowiak
- Re: [GENERAL] foreign keys vectro
- [GENERAL] Morten W. Petersen
- Re: [GENERAL] Vince Vielhaber
- Re: [GENERAL] Morten W. Petersen
- Re: [GENERAL] Morten W. Petersen
- Re: [GENERAL] Tom Lane
- [GENERAL] Foreign Keys <No Name>
- Re: [GENERAL] Foreign Keys Adam Haberlach
- [GENERAL] Re: Foreign Keys Mitch Vincent
- Re: [GENERAL] Foreign keys Stephan Szabo
- Re: [GENERAL] Foreign Keys Bruce Momjian
- [GENERAL] Foreign keys Neal Lindsay
- Re: [GENERAL] Foreign keys Stephan Szabo
- [GENERAL] Foreign keys Matt Browne