Reset ACL to default for pg 8.0

From: "Juan C(dot) Aragon" <juan(at)keisercomputers(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Reset ACL to default for pg 8.0
Date: 2010-04-12 23:24:48
Message-ID: 000001cada97$581fb3f0$085f1bd0$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi Guys:

I need to know how to reset the ACL to default (null) for a function. This
is for PostgreSQL 8.0.14 and 8.4.1 on Windows.

I used the User Interface to removed all the Privileges, but the ACL is
still = {}

I need to make the ACL to be blank (null), nothing in there.

Because if the ACL = {} and I do a db restore, it sets the ACL = <owner>,
but I need it to be blank.

Any help I will appreciate it.

Thanks,

Juan C. Aragon

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message y.y.chen 2010-04-13 01:03:07 BUG #5414: pg_dump failure from database 8.4.3 to 8.4.3
Previous Message Robert Haas 2010-04-12 13:23:56 Re: initdb stores default client_encoding from environment-variable