Skip site navigation (1) Skip section navigation (2)

Re: refint.sql

From: Marc Tardif <intmktg(at)CAM(dot)ORG>
To: Anand Raman <araman(at)india-today(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: refint.sql
Date: 2000-04-28 16:39:59
Message-ID: Pine.LNX.4.10.10004281233360.31860-100000@Gloria.CAM.ORG (view raw or flat)
Thread:
Lists: pgsql-general
Those are all the files you need. First, run gmake in contrib/spi and
you'll notice two more files are created:
refint.so
refint.sql

Also, take note that referential integrity on postgresql 6.5.3 works by
using triggers. So you must first CREATE FUNCTION which is detailed in
refint.sql which, in turn, was created from refint.source by the Makefile.
Then, you must CREATE TRIGGER for which there is an example in
refint.example.

On Fri, 28 Apr 2000, Anand Raman wrote:

> Hi guys
> I have been trying to get refrential integrity working on postgre
> 6.5.3.. I understand after reading all the manuals and lot of posts on
> the mailing list that i have to run refint.sql .. However the tar ball i
> downloaded doesnt have this. The only refint files present in
> contrib/spi are 
> refint.c        
> refint.example  
> refint.source
> 
> Can any one of u please mail it to me..
> 
> I am using SuSE 6.2 and postgresql 6.5.2
> 
> Thanx for ur time..
> Anand
> 


In response to

  • refint.sql at 2000-04-28 10:00:56 from Anand Raman

pgsql-general by date

Next:From: Marcel SierraDate: 2000-04-28 16:56:47
Subject: GTK or TCL/TK ... what do you prefer ? (beginner)
Previous:From: Travis BauerDate: 2000-04-28 16:38:57
Subject: problem with nested views

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group