Re: Triggers and Domains

ekekakos <ekekakos@hol.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