Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 81D341B505EB for ; Wed, 14 Mar 2012 07:44:42 -0300 (ADT) Received: from eu1sys200aog101.obsmtp.com ([207.126.144.111]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1S7lhA-000625-NC for pgsql-admin@postgresql.org; Wed, 14 Mar 2012 10:44:42 +0000 Received: from mail-lpp01m010-f43.google.com ([209.85.215.43]) (using TLSv1) by eu1sys200aob101.postini.com ([207.126.147.11]) with SMTP ID DSNKT2B2igPbm9dPmpX9l0yp2mY3fKeDDbpy@postini.com; Wed, 14 Mar 2012 10:44:40 UTC Received: by mail-lpp01m010-f43.google.com with SMTP id r15so2477205lag.16 for ; Wed, 14 Mar 2012 03:44:26 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=from:mime-version:x-mailer:thread-index:date:message-id:subject:to :content-type:x-gm-message-state; bh=WFNqb0vOfRN4KzOfC3ZtYH4F7j72wKScL9m9pmK5aJk=; b=Z0p6a19r8xpEWHi6WdMXElgVTeKlcg4C+XRli8XIXMgeGoFOVHNXfZz0bEYR82z+Gh RUmKwkpFjcvoRCIRTT/rrIHdjKxVbenfpIx4h0qQ+XvtznxcelcIAtOQGZdmM728/6Wu hYQyQuRar7D1P3To2sneq4qUiyu/+DnPg1QGTUsz0xYHqTPBZeI6DcQ5UMGG5IDYDCfU z6U8Fv85aEDnaG3GGCxONZnvt0iHYgQpSl+kBvtbpBqa6bcuNhv+3KKEooC/FcQxi+7T qR4FlmnCEO6oivs+FLYMfe0WOqzNCk41UH4MlGV1YgMY7mElGfSPkQOWfhNUvVtm8iY6 gHEg== Received: by 10.112.46.202 with SMTP id x10mr747909lbm.39.1331721866150; Wed, 14 Mar 2012 03:44:26 -0700 (PDT) From: Khangelani Gama MIME-Version: 1.0 X-Mailer: Microsoft Outlook 14.0 thread-index: Ac0Bzz0SqthjblYvSG6kV3W58tTy7w== Date: Wed, 14 Mar 2012 12:44:54 +0200 Message-ID: <8ecc4155e8754edef35e260a60a4a8db@mail.gmail.com> Subject: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=bcaec55406acc584c304bb31a8da X-Gm-Message-State: ALoCoQnZTXUUD6uqkfWbmAOECw+BCaik3zCNZ5Ik7VvVWXyhaZLT99FfN7fSgaYnmpUqvH8VPY/a X-Pg-Spam-Score: -2.3 (--) X-Archive-Number: 201203/76 X-Sequence-Number: 39264 --bcaec55406acc584c304bb31a8da Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Hi Is it possible to have an update query that will specify actions, timestamp, user who=92s making the update inside the database. Can this be done without any script but just in the transaction block Example: dbtest=3D# UPDATE table test set t4 =3D 9 where t1 =3D 001 then specify user_name, timestamp() ; Thanks in advance * * * * * * * * * * *C O N F I D E N T I A L I T Y N O T I C E* The contents of and attachments to this e-mail are intended for the addressee only, and may contain the confidential information of Argility (Proprietary) Limited and/or its subsidiaries. Any review, use or dissemination thereof by anyone other than the intended addressee is prohibited. If you are not the intended addressee please notify the writer immediately and destroy the e-mail. Argility (Proprietary) Limited and its subsidiaries distance themselves from and accept no liability for unauthorised use of their e-mail facilities or e-mails sent other than strictly for business purposes. CONFIDENTIALITY NOTICE The contents of and attachments to this e-mail are intended for the addre= ssee only, and may contain the confidential information of Argility (Prop= rietary) Limited and/or its subsidiaries. Any review, use or disseminatio= n thereof by anyone other than the intended addressee is prohibited. If you are not the intended addressee please notify the writer immediatel= y and destroy the e-mail. Argility (Proprietary) Limited and its subsidia= ries distance themselves from and accept no liability for unauthorised us= e of their e-mail facilities or e-mails sent other than strictly for busi= ness purposes. =0D --bcaec55406acc584c304bb31a8da Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable

=A0

Hi

=A0

=A0

Is it possible to have an update query that will specify act= ions, timestamp, user who=92s making the update inside the database. Can th= is be done without any script but just in the transaction block

=A0

Example:

=A0

dbtest=3D# UPDATE table test s= et t4 =3D 9 where t1 =3D 001 then specify user_name, =A0timestamp() ;

=A0

=A0

=A0

=A0

Thanks in advance

=A0

=A0

=A0

=A0

=A0

=A0

C O N F I D = E N T I A L I T Y=A0=A0 N O T I C E =
The contents of and attachments to this e-mail are intende= d for the addressee only, and may contain the confidential information of A= rgility (Proprietary) Limited and/or its subsidiaries. Any review, use or d= issemination thereof by anyone other than the intended addressee is prohibi= ted. If you are not the intended addressee please notify the writer immedia= tely and destroy the e-mail. Argility (Proprietary) Limited and its subsidi= aries distance themselves from and accept no liability for unauthorised use= of their e-mail facilities or e-mails sent other than strictly for busines= s purposes.

=A0




CONFIDENTIALITY NOTICE
The contents of and attachments to this e-mail are intended for the addre=
ssee only, and may contain the confidential information of Argility (Prop=
rietary) Limited and/or its subsidiaries. Any review, use or disseminatio=
n thereof by anyone other than the intended addressee is prohibited.
If you are not the intended addressee please notify the writer immediatel=
y and destroy the e-mail. Argility (Proprietary) Limited and its subsidia=
ries distance themselves from and accept no liability for unauthorised us=
e of their e-mail facilities or e-mails sent other than strictly for busi=
ness purposes.
=0D
--bcaec55406acc584c304bb31a8da--