Re: [HACKERS] CURRENT_USER - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] CURRENT_USER
Date
Msg-id 34FABBF7.7C2D90AB@alumni.caltech.edu
Whole thread Raw
In response to CURRENT_USER  (sferac@bo.nettuno.it)
List 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.


pgsql-hackers by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] Rule plan size for views?
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Last minute reminders (hope they're not too late...)