Thread

1. BIG grant problem

   Terry Mackintosh <terry@terrym.com> — 1998-11-15T04:37:33Z

   Hi all
   
   Minor detail, but when I did 'pg_dump -z -f dump.file dbname' and then
   went to restore it, I found that the grant statments are like:
   GRANT ALL on "tablename" to "tablename";
   instead of
   GRANT ALL on "tablename" to "username";
   
   I used vim to edit the dump file, so am ok.
   Just thought you might want to know.
   Oh, ya, that is the release version 6.4, just downloaded this afternoon.
   
   Have a great night
   Terry Mackintosh <terry@terrym.com>          http://www.terrym.com
   sysadmin/owner  Please! No MIME encoded or HTML mail, unless needed.
   
   Proudly powered by R H Linux 4.2, Apache 1.3, PHP 3, PostgreSQL 6.3
   -------------------------------------------------------------------
   Success Is A Choice ... book by Rick Patino, get it, read it!
   
   
   

2. Re: [HACKERS] BIG grant problem

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-11-15T05:25:23Z

   > Hi all
   > 
   > Minor detail, but when I did 'pg_dump -z -f dump.file dbname' and then
   > went to restore it, I found that the grant statments are like:
   > GRANT ALL on "tablename" to "tablename";
   > instead of
   > GRANT ALL on "tablename" to "username";
   > 
   > I used vim to edit the dump file, so am ok.
   > Just thought you might want to know.
   > Oh, ya, that is the release version 6.4, just downloaded this afternoon.
   
   Yikes, confirmed here.  We need to know how this got into the tree
   without showing up on our tests, are there any more pg_dump bugs we have
   not found, and a fix.
   
   This is our first major 6.4 bug, aside from large objects! 
   Congradulations.
   
   -- 
     Bruce Momjian                        |  http://www.op.net/~candle
     maillist@candle.pha.pa.us            |  (610) 853-3000
     +  If your life is a hard drive,     |  830 Blythe Avenue
     +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026