X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id A8F2DDA670
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Fri, 18 Nov 2005 07:20:41 -0400 (AST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 97936-09
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Fri, 18 Nov 2005 11:20:43 +0000 (GMT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25])
	by svr1.postgresql.org (Postfix) with ESMTP id EBB3BDB97F
	for <pgsql-admin@postgresql.org>; Fri, 18 Nov 2005 07:20:38 -0400 (AST)
Received: from smtp1.netmagicians.com (smtp1.netmagicians.com [202.87.39.91])
	by svr2.postgresql.org (Postfix) with ESMTP id 50A37F0B93
	for <pgsql-admin@postgresql.org>; Fri, 18 Nov 2005 11:20:41 +0000 (GMT)
Received: from mailserver.tatashare.com (unknown [202.149.193.242])
	by smtp1.netmagicians.com (Postfix) with ESMTP id E4E89374A78
	for <pgsql-admin@postgresql.org>; Fri, 18 Nov 2005 16:50:15 +0530 (IST)
Received: from aftabn463 (unknown [172.16.16.236])
	by mailserver.tatashare.com (Postfix) with SMTP id 6B5423E5E06
	for <pgsql-admin@postgresql.org>; Fri, 18 Nov 2005 16:48:25 +0530 (IST)
Reply-To: <aalam@tatashare.com>
From: "Aftab Alam" <aalam@tatashare.com>
To: <pgsql-admin@postgresql.org>
Subject: trigger 
Date: Fri, 18 Nov 2005 16:46:24 +0530
Message-ID: <000701c5ec31$8366c430$ec1010ac@aftabn463>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0008_01C5EC5F.9D23BB20"
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0)
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-NetMagic-MailScanner-Information: Powered By NetMagic Mail Protection v1.0
X-NetMagic-MailScanner: Found to be clean
X-NetMagic-MailScanner-From: aalam@tatashare.com
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001]
X-Spam-Score: 0.001
X-Spam-Level: 
X-Archive-Number: 200511/235
X-Sequence-Number: 19608

This is a multi-part message in MIME format.

------=_NextPart_000_0008_01C5EC5F.9D23BB20
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello,

I want to create a trigger in PostgresSQL

In trigger, Before inserting the record, if data is already in the table,
the trigger fire the mesaage that data is already there, and after that
trigger ckeck for next insert statement.

Pleae help me in this regard , kindly  reply.

Regards,

_____

Aftab Alam


------=_NextPart_000_0008_01C5EC5F.9D23BB20
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">


<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV>
<DIV>
<P>Hello,</P>
<P>I want to create a trigger in PostgresSQL </P>
<P><SPAN class=3D921122105-18112005>In trigger, Before inserting the =
record, if=20
data is already in the table, the trigger fire the mesaage that data is =
already=20
there, and after that trigger ckeck for next insert =
statement.</SPAN></P>
<P><SPAN class=3D921122105-18112005></SPAN><SPAN =
class=3D921122105-18112005><SPAN=20
class=3D953484808-18112005>Pleae help me in this=20
regard</SPAN>&nbsp;,&nbsp;</SPAN><SPAN class=3D953484808-18112005>kindly =

</SPAN>&nbsp;reply.</P>
<P>Regards, </P>
<P>_____ </P>
<P>Aftab Alam </P></DIV></DIV></BODY></HTML>

------=_NextPart_000_0008_01C5EC5F.9D23BB20--