Re: Triggers and Domains

--- On Sun, 8/30/09, ekekakos <ekekakos(at)hol(dot)gr> wrote:

From: ekekakos <ekekakos(at)hol(dot)gr>
Subject: Re: [NOVICE] Triggers and Domains
To: pgsql-novice(at)postgresql(dot)org
Date: Sunday, August 30, 2009, 6:25 PM

It does not work.
I run your script
create domain username as text default user;
through PGADMIN and I get the following
CREATE DOMAIN username
  AS text
  DEFAULT "current_user"();
ALTER DOMAIN username OWNER TO ekekakos;

I create a field in a table and I am getting the following script:
ALTER TABLE "Library"."Contacts" ADD COLUMN "LastUser" username;
ALTER TABLE "Library"."Contacts" ALTER COLUMN "LastUser" SET STORAGE
EXTENDED;

And it does not work during the update.

Thanks
Elias

Tom Lane-2 wrote:
>
> ekekakos <ekekakos(at)hol(dot)gr> writes:
>> Thanks but how, in SQL server you put the function USER() (if I remember
>> well) and it works.
>> Here it does not work.
>
> Define "does not work", please?
>
> regression=# create domain username as text default user; 
> CREATE DOMAIN
> regression=# create table foo(f1 int, lastupdateuser username);
> CREATE TABLE
> regression=# insert into foo(f1) values(42);
> INSERT 0 1
> regression=# select * from foo;
>  f1 | lastupdateuser
> ----+----------------
>  42 | postgres
> (1 row)
>
>
>             regards, tom lane
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
>

you can use "select current_user" to get the current user and use in the update trigger