[GENERAL] Re:Foreign Keys

1998-09-18 Thread Anand Surelia
Hi, I've managed to hack the code for check_primary_key. It now allows for a option [automatic|dependent]. It'll automatically insert into the parent table if the primary key doesn't exists in the parent table and if the option is "automatic". It works the same as before if the option is "dependen

[GENERAL] Foreign Key

1998-09-18 Thread Anand Surelia
Hi, I am using the triggers provided under contrib/spi/refint.* to implement referential integrity in my database. The check_primary_key function doesn't allow me to enter in a child table if a corresponding primary key doesn't exists in the parent table ( implements 'dependency'). However I also

[GENERAL] Re: "don't know how to print type 715"

1998-09-18 Thread Carilda A. Thomas
Since I have now seen two other people complain about this, I will join the fray. I am running Solaris 2.6, Postgresql v6.3.2. I have also gotten the same notice on FreeBSD 2.1.; the Solaris 2.6 was built with gcc 2.8.1. All the auxiliary programs (readline, history, etc.) are the latest version

Re: [GENERAL] slow queries

1998-09-18 Thread Thomas Good
On Fri, 18 Sep 1998, David Hartwig wrote: > I would like to see it! I was not aware that table aliasing could > have any impact on performance. Hello Oliver and David, I was a bit amazed myself. Federico Passaro, on the SQL list, helped me out some time ago when a query was failing. His co