[GENERAL] Foreign Key

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:Foreign Keys

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 Keys: check_primary_function

Hi All, I've changed the check_primary_key() function code to allow for either the "automatic insert key rule" or "dependent insert key rule". Previously it restricted the addtion of a child entry if the corresponding parent entry was not there. Now if the option is "automatic" it will add an entr

[GENERAL] SPI and Libpq

Hi, Can anyone tell me what is the difference between the SPI and the Libpq interfaces and when to use what? I am writing some functions that will be used by triggers. What interface should I use to implement those functions? Thanks, Anand

[GENERAL] Timestamp

Hi , Can anyone tell me how to add a constant time interval ( say 30 seconds ) to a timestamp field and convert the result back to a valid timestamp? Thanks, Anand

[GENERAL] Deadlock on Linux

e any idea what is happening? The script in question runs fine when I run it independent of the cron. Thanks for your help in advance, Anand Surelia.

[GENERAL] Regression test failing on Sparc Solaris 2.5.1

k/postgres/lib/plpgsql.so Did I miss something? I had set the PGLIB varialble and gone ahead and set the LD_LIBRARY_PATH to the same value also. No luck. Thanks, Anand Surelia.

[GENERAL] SPI

aster : fatal: relocation error: symbol not found: SPI_result: referenced in /bytek/po stgres/postgresql-6.4.2/src/test/regress/input/../../../../contrib/spi/refint.so Has the SPI interface been changed? Thanks for your help in advance, - Anand Surelia

[GENERAL] Postgres on Sun Solaris 2.5.1

We are trying to upgrade our present Postgres 6.3.2 database running on Linux/i386 to v6.4.2 on Sun Solaris 2.5.1. I tried to compile the server using GCC for Solris 2.5.1. Everything went well except while running the regression tests, which failed giving these messages: + ERROR: Load of file /b

[GENERAL] Database Connect Permission

Hi, Is there any way to specify connect permissions to a database for specific users? Right now, any user can connect to any database even though he may not be able to see any tables. Thanks, Anand Surelia.

[GENERAL] Check constraint

Hi, I have created a function "int fname(void)" in C. When I create this function in Postgres as returning int4 and then do a " create table dummy (level int4 check(fname() > 4));" the creation fails saying that : ERROR: There is no operator '>' for types 'bool' and 'int4' You will either

[GENERAL] How to increase shared memory buffers?

Hi All, I have been trying to increase the shared memory buffers used by Postgres by using the -B option to postmaster, but postmaster fails to start up for any value greater than 64 (which is the default in any case) saying "couldn't get shared memory - permission denied". So, (I know this shoul

[GENERAL] Re: where is the "applied"?

<[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] (Anand Surelia) > Subject: Re: [GENERAL] Foreign Keys: check_primary_function > Date: Sun, 14 Mar 1999 19:34:27 -0500 (EST) > > Applied. > > > Hi All, > > I've changed the check_primary_key() function

Re: [GENERAL] Re: where is the "applied"?

; > -- Anand. > > > > kai qu wrote: > > > > > hi, Anand, > > > > > > why I can not find it in the source code in V6.5? isn't it applied? Am I > > > missing something ? > > > > > > Kai > > > > > >

[GENERAL] Pg.pm for Windows?

How can I use Pg.pm in my perl scripts running on Windows through ActivePerl? Some of my developers are refusing to work on Linux machines for just writing perl scripts :-). Thanks, Anand.