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 E74229FA430 for ; Thu, 22 Jun 2006 06:19:17 -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 42299-07 for ; Thu, 22 Jun 2006 06:19:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id E9E349F9ED6 for ; Thu, 22 Jun 2006 06:19:06 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from deliver.hol.gr (deliver.hol.gr [194.30.193.26]) by svr4.postgresql.org (Postfix) with ESMTP id 196C65AF024 for ; Thu, 22 Jun 2006 09:19:04 +0000 (GMT) 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 k5M9IMqR024601 (using TLSv1/SSLv3 with cipher DHE-RSA-AES256-SHA (256 bits) verified OK) for ; Thu, 22 Jun 2006 12:18:22 +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 k5M9IuAs001850 for ; Thu, 22 Jun 2006 12:18:59 +0300 Message-Id: <200606220918.k5M9IuAs001850@auth-smtp.hol.gr> From: "Forums @ Existanze" To: Subject: Start up question about triggers Date: Thu, 22 Jun 2006 12:19:00 +0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002D_01C695F6.0C7EFC60" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 Thread-Index: AcaV3OWJA7BamFQKTyKs/mlx8cNgEQ== X-Virus-Scanned: ClamAV 0.87/1559/Wed Jun 21 17:23:13 2006 on takeit01.mail.dc.hol.net X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/248 X-Sequence-Number: 25484 This is a multi-part message in MIME format. ------=_NextPart_000_002D_01C695F6.0C7EFC60 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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_002D_01C695F6.0C7EFC60 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
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
------=_NextPart_000_002D_01C695F6.0C7EFC60--