Horton
Menu

Re: [HACKERS] CURRENT_USER

Thomas Lockhart <lockhart@alumni.caltech.edu>

View thread
From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
To: sferac@bo.nettuno.it
Cc: hackers@postgresql.org
Date: 1998-03-02T14:02:31Z
Lists: pgsql-hackers 
> 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.