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

triggers

From: "Martin Kuria" <martinkuria(at)hotmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: triggers
Date: 2001-08-14 06:11:39
Message-ID: LAW2-F71b6KZmcK8r6b00008996@hotmail.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-general
Hi, I have a problem I am using postgresql database and I want to enforce
   >triggers between my related tables ( tables with relationship), one 
table
   >has a foreign key and the other the a primary key, I would like to use
   >triggers to update, delete, and insert in this tables but the table with 
the
   >foreign key should first check in the other table before any action is
   >taken, Which is the simplest sql or C language script can I use to 
enforce
   >triggers within my tables, please demonstrate a simple scenerio thanks

<br><br><br>Martin Wainaina Kuria
Programmer/Database Administrator
Bsc. Computer Science
Kenyaweb.com Ltd
www.kenyaweb.com


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


Responses

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2001-08-14 09:22:17
Subject: ECPG does not correctly identify pointer type
Previous:From: pgsql-bugsDate: 2001-08-14 06:11:24
Subject: triggers

pgsql-general by date

Next:From: John Clark Naldoza y LopezDate: 2001-08-14 06:47:03
Subject: Re: Case sensitivity
Previous:From: Scott GilbertDate: 2001-08-14 06:09:47
Subject: Case sensitivity

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