X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4244ADB96A for ; Fri, 18 Nov 2005 07:31:05 -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 99942-05 for ; Fri, 18 Nov 2005 11:31:07 +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 CA2DFDB921 for ; Fri, 18 Nov 2005 07:31:02 -0400 (AST) Received: from smtp1.netmagicians.com (smtp1.netmagicians.com [202.87.39.91]) by svr2.postgresql.org (Postfix) with ESMTP id 74493F0B8E for ; Fri, 18 Nov 2005 11:31:04 +0000 (GMT) Received: from mailserver.tatashare.com (unknown [202.149.193.242]) by smtp1.netmagicians.com (Postfix) with ESMTP id 8DD42374A7B for ; Fri, 18 Nov 2005 17:00:27 +0530 (IST) Received: from aftabn463 (unknown [172.16.16.236]) by mailserver.tatashare.com (Postfix) with SMTP id 515B53E568E for ; Fri, 18 Nov 2005 16:51:30 +0530 (IST) Reply-To: From: "Aftab Alam" To: Subject: trigger Date: Fri, 18 Nov 2005 16:49:26 +0530 Message-ID: <001801c5ec31$efeb3910$ec1010ac@aftabn463> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0019_01C5EC60.09A37510" 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/10 X-Sequence-Number: 3327 This is a multi-part message in MIME format. ------=_NextPart_000_0019_01C5EC60.09A37510 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_0019_01C5EC60.09A37510 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello,

I want to create a trigger in PostgresSQL

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.

Pleae help me in this=20 regard , kindly =  reply.

Regards,

_____

Aftab Alam

------=_NextPart_000_0019_01C5EC60.09A37510--