Re: [BUGS] BUG #3605: impossible loading

2007-09-10 Thread Dave Page
Christian PANEL wrote: > I have tried 7 mirrors sites (2 france, others usa and deutchland) that > totalize more than 7 hours of connection in several days and have enough. > My ISP is Free. I have soon dowload big files (15Mo) with it but perhaps > have they changed since that. > I precise I have

[BUGS] partially effective revoke on pg_catalog

2007-09-10 Thread hubert depesz lubaczewski
user depesz is superuser. i connect to depesz database, and: ([EMAIL PROTECTED]:5830) 14:20:34 [depesz] # revoke usage on schema pg_catalog from public; REVOKE now, i reconnect to the same database with test user (which is not superuser): ([EMAIL PROTECTED]:5830) 14:23:55 [depesz] > \d ERROR: p

Re: [BUGS] partially effective revoke on pg_catalog

2007-09-10 Thread Tom Lane
hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > # revoke usage on schema pg_catalog from public; > REVOKE This is not a supported operation. regards, tom lane ---(end of broadcast)--- TIP 1: if posting/reading throug

Re: [BUGS] partially effective revoke on pg_catalog

2007-09-10 Thread hubert depesz lubaczewski
On Mon, Sep 10, 2007 at 10:38:34AM -0400, Tom Lane wrote: > hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > > # revoke usage on schema pg_catalog from public; > > REVOKE > This is not a supported operation. ok, but i belive it should either dont allow admin to do so, or, if it does allow,

Re: [BUGS] partially effective revoke on pg_catalog

2007-09-10 Thread Tom Lane
hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > On Mon, Sep 10, 2007 at 10:38:34AM -0400, Tom Lane wrote: >> hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: >>> # revoke usage on schema pg_catalog from public; >>> REVOKE >> This is not a supported operation. > ok, but i belive it sho

Re: [BUGS] partially effective revoke on pg_catalog

2007-09-10 Thread hubert depesz lubaczewski
On Mon, Sep 10, 2007 at 11:17:21AM -0400, Tom Lane wrote: > > ok, but i belive it should either dont allow admin to do so, or, if it > > does allow, it should behave more consistently. > There are few "training wheels" for superuser mode. Try something like > "delete from pg_proc" if you are looki