> java=> CREATE TABLE tabella(campo VARCHAR(30) DEFAULT CURRENT_USER);
> ERROR:  DEFAULT: type mismatched
> I had this error. PostgreSQL CURRENT_USER returns a type "name",
> but SQL-Standard says that niladic builtin function CURRENT_USER returns a
> CHARACTER string representing the current authorization ID and "name" isn't
> an SQL type. I think this is a bug. What do you think about?

Yup.

In response to

• CURRENT_USER at 1998-02-27 17:25:46 from sferac

pgsql-hackers by date

Next:	From: Bruce Momjian	Date: 1998-03-02 16:49:42
	Subject: Re: [HACKERS] Last minute reminders (hope they're not too late...)
Previous:	From: Thomas G. Lockhart	Date: 1998-03-02 13:57:37
	Subject: Re: [HACKERS] Rule plan size for views?