| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Olivier Guilyardi <ml(at)xung(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Listing views |
| Date: | 2004-08-10 18:07:09 |
| Message-ID: | 29962.1092161229@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Olivier Guilyardi <ml(at)xung(dot)org> writes:
> Doug McNaught wrote:
>> 'SELECT version();' should work. There will be no permission issues
>> with calling that function unless you set the database up that way--it
>> has PUBLIC execute permission by default.
> Good
In theory it's possible for that to fail in 7.3: if someone makes their
own function named version() and then alters the default search path so
that their function is found before the one in pg_catalog, then the
wrong function would be invoked.
In practice I'd say this falls in the category of "don't do that then".
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Garamond | 2004-08-10 18:23:01 | psql: immediately exit after an error? |
| Previous Message | Marc G. Fournier | 2004-08-10 18:01:06 | Re: PostgreSQL 8.0.0 Officially Goes Beta |