Message-ID: <1331722455.5503.166.camel@elliot>
Subject: Re: Update actions (with user name) inside PostgreSQL DB -
	any version on postgreSQL
From: Robin Iddon <robin@edesix.com>
To: pgsql-admin@postgresql.org
Date: Wed, 14 Mar 2012 10:54:15 +0000
In-Reply-To: <8ecc4155e8754edef35e260a60a4a8db@mail.gmail.com>
References: <8ecc4155e8754edef35e260a60a4a8db@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0

What do you want to have happen to the timestamp/user?

You can obviously do:

update test set t4 =3D 9, user =3D <someuser>, timestamp =3D <sometimestamp=
>
where t1 =3D 001;

I'm assuming you're trying to store the user and timestamp somewhere
else, though?

Robin

On Wed, 2012-03-14 at 12:44 +0200, Khangelani Gama wrote:
> =20
>=20
> Hi
>=20
> =20
>=20
> =20
>=20
> Is it possible to have an update query that will specify actions,
> timestamp, user who=E2=80=99s making the update inside the database. Can =
this
> be done without any script but just in the transaction block=20
>=20
> =20
>=20
> Example:
>=20
> =20
>=20
> dbtest=3D# UPDATE table test set t4 =3D 9 where t1 =3D 001 then specify
> user_name,  timestamp() ;
>=20
> =20
>=20
> =20
>=20
> =20
>=20
> =20
>=20
> Thanks in advance
>=20
> =20
>=20
> =20
>=20
> =20
>=20
> =20
>=20
> =20
>=20
> =20
>=20
> C O N F I D E N T I A L I T Y   N O T I C E=20
> 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.
>=20
> =20
>=20
>=20
>=20
>=20
>=20
> 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 (Propri=
etary) Limited and/or its subsidiaries. Any review, use or dissemination th=
ereof 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 subsidiari=
es distance themselves from and accept no liability for unauthorised use of=
 their e-mail facilities or e-mails sent other than strictly for business p=
urposes.