From: | Anand Surelia <anand(at)bytekinc(dot)com> |
---|---|
To: | kai qu <kaiq(at)flex(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: where is the "applied"? |
Date: | 1999-08-09 23:41:06 |
Message-ID: | 37AF6712.D566CB9D@bytekinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Kai,
It beats me too. I was under the impression that the patch was applied for
all versions greater than 6.3.2. I haven't bothered to upgrade since then so
I don't know if it was ever actually applied. Here is a working copy of
refint.c which I am using now, you can try using it but I haven't tested it
for V6.5.
-- 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
>
> ##########################################################
> From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
> To: anand(at)bytekinc(dot)com (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 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 entry in the parent too ( it will be
> > successful if there are no no-null fields in the parent apart from the
>
> > primary key).
> > The way to use it now is:
> > /*
> > * check_primary_key () -- check that key in tuple being
> > inserted/updated
> > * references existing tuple in "primary" table.
>
> > * Though it's called without args You have to specify referenced
> > * table/keys while creating trigger: key field names in triggered
> > table,
> > * referenced table name, referenced key field names,type of action
> > [automatic|dependent]:
> > * EXECUTE PROCEDURE
> > * check_primary_key ('Fkey1', 'Fkey2', 'Ptable', 'Pkey1', 'Pkey2',
> > '[automatic|dependent]').
> > */
> > I am attaching the new ../contrib/spi/refint.c file which will do
> this.
> > I will be glad to help in case of any problems.
> >
> > - Anand.
> >
> >
Attachment | Content-Type | Size |
---|---|---|
refint.c | application/x-unknown-content-type-textpad.c | 19.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | David Bryant | 1999-08-09 23:41:10 | |
Previous Message | Rex McMaster | 1999-08-09 23:03:14 | Re: [GENERAL] Speed of joins using sparse indexes |