pg_dump : problem with grant on table columns - Mailing list pgsql-sql

From Brice André
Subject pg_dump : problem with grant on table columns
Date
Msg-id CAOBG12knSUvQc9vA4m=ixmRX14OqcuTccXShAfU30LkXtg98uA@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump : problem with grant on table columns  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-sql
Hello,<br /><br />I sometimes define some access rights on table columns instead of whole table. Everything works fine
exceptwhen I perform a dump.<br /><br />When I dump a databse that contains such access rights, the pg_dump utility
generatescommands like this one : <br /> GRANT SELECT("Login") ON TABLE "Clients" TO "AgendaSubscript";<br /><br />But,
whenI execute the content of this dump in a fresh database (for backup and restore stuff), those commands are rejected
andthus, my restored database has not the proper access rights.<br /><br />Is this a bug with the pg_dump tool or am I
doingsomething wrong ?<br /><br />Regards,<br /><br />Brice André<br /> 

pgsql-sql by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Updatable view should truncate table fields
Next
From: John Fabiani
Date:
Subject: updating a sequence