Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group