Hi all
I am running an older snapshoot of 6.4, so this may not be relavent now.
I did a 'pg_dumpall -z > file.dump', then on another box destroyed all the
databases and did 'psql templet1 < file.dump' and got this:
REVOKE ALL on 'board' from PUBLIC;
ERROR: parser: parse error at or near "'"
GRANT ALL on "board" to "nobody";
CHANGE
It would seem that the single quotes should be double quotes?
Jan, is this your area?
I have notice that most all names now are quoted in dumps, but will work
just fine with out any quotes, so why the quotes?
Thanks, and have a great day
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!