Re: [HACKERS] CURRENT_USER

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: sferac(at)bo(dot)nettuno(dot)it
Cc: hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] CURRENT_USER
Date: 1998-03-02 14:02:31
Message-ID: 34FABBF7.7C2D90AB@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Browse pgsql-hackers by date

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