X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 097449F9FE3 for ; Thu, 22 Jun 2006 10:09:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 75208-05 for ; Thu, 22 Jun 2006 10:09:03 -0300 (ADT) X-Greylist: delayed 03:49:56.519899 by SQLgrey- Received: from deliver.hol.gr (deliver.hol.gr [194.30.193.26]) by postgresql.org (Postfix) with ESMTP id E16919F9ED6 for ; Thu, 22 Jun 2006 10:09:03 -0300 (ADT) Received: from auth-smtp.hol.gr (takeit01.mail.dc.hol.net [192.168.20.71]) by deliver.hol.gr (8.12.11/8.11.6) with ESMTP id k5MD8N3T005925 (using TLSv1/SSLv3 with cipher DHE-RSA-AES256-SHA (256 bits) verified OK) for ; Thu, 22 Jun 2006 16:08:23 +0300 Received: from pimp (static223128.dsl.hol.gr [62.38.223.129]) by auth-smtp.hol.gr (8.13.1/8.12.11) with ESMTP id k5MD90S3007695 for ; Thu, 22 Jun 2006 16:09:00 +0300 Message-Id: <200606221309.k5MD90S3007695@auth-smtp.hol.gr> From: "Forums @ Existanze" To: Subject: Re: Start up question about triggers Date: Thu, 22 Jun 2006 16:09:04 +0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_003A_01C69616.2EC3F940" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 Thread-Index: AcaV3OWJA7BamFQKTyKs/mlx8cNgEQAIBQyQ In-reply-to: <200606220918.k5M9IuAs001850@auth-smtp.hol.gr> X-Virus-Scanned: ClamAV 0.87/1560/Thu Jun 22 12:07:47 2006 on takeit01.mail.dc.hol.net X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/249 X-Sequence-Number: 25485 This is a multi-part message in MIME format. ------=_NextPart_000_003A_01C69616.2EC3F940 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Sorry This is the complete message Hello all, I know that this question may be really simple, but I have decided to ask here due to fact that I don't know how to search for this on google or on the docs. I created a trigger fuction which updates a specific row in some table A. Is it possible to retain the query that was used to trigger the function. For example Table A query_row_id query_row TABLE B id name If I create a trigger on table B that says that after the insert command to write the query into table A. So if I do insert into B values(1,"Blah") this will trigger my trigger. Is there any way to get the "insert into B values(1,"Blah")? At the moment I can see only the type of query that it is (INSERT UPDATE DELETE) best regards, Fotis _____ From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Forums @ Existanze Sent: 22 June 2006 12:19 To: pgsql-sql@postgresql.org Subject: [SQL] Start up question about triggers Hello all, I know that this question may be really simple, but I have decided to ask here due to fact that I don't know how to search for this on google or on the docs. I created a trigger fuction which updates a specific row in some table A. Is it possible to retain the query that was used to trigger the function. For example Table A query_row_id query_row TABLE B id name ------=_NextPart_000_003A_01C69616.2EC3F940 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Sorry This is the complete = message
 
Hello=20 all,
 
I know = that this=20 question may be really simple, but I have decided to ask here due to = fact that I=20 don't know how to search for this on google or on the = docs.
 
I = created a trigger=20 fuction which updates a specific row in some table A. Is it possible to = retain=20 the query that was used to trigger the function. For = example
 
Table=20 A
query_row_id
query_row
 
 
 
TABLE=20 B
id
name
 
 
 
 
 
If I = create a=20 trigger on table B that says that after the insert command to write the = query=20 into  table A. So if I do
 
insert = into B=20 values(1,"Blah")
 
this = will trigger my=20 trigger. Is there any way to get the "insert into B values(1,"Blah")? At = the=20 moment I can see only the type of query that it is (INSERT UPDATE=20 DELETE)
 
best=20 regards,
Fotis

From: = pgsql-sql-owner@postgresql.org=20 [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Forums @=20 Existanze
Sent: 22 June 2006 12:19
To:=20 pgsql-sql@postgresql.org
Subject: [SQL] Start up question = about=20 triggers

Hello=20 all,
 
I = know that this=20 question may be really simple, but I have decided to ask here due to = fact that=20 I don't know how to search for this on google or on the=20 docs.
 
I = created a=20 trigger fuction which updates a specific row in some table A. Is it = possible=20 to retain the query that was used to trigger the function. For=20 example
 
Table=20 A
query_row_id
query_row
 
 
 
TABLE=20 B
id
name
= ------=_NextPart_000_003A_01C69616.2EC3F940--