pg_dump and Postgres 8.0.0 Release on cygwin

[email protected] Mon, 07 Mar 2005 17:05:07 +0000
Newsgroups gmane.comp.db.postgresql.cygwin
Message-ID <OF2666034A.BC0C3A8E-ON80256FBD.0052C86A-80256FBD.005E494F@transport.alstom.com>
I use many bash scripts running on cygwin to support postgres
administration operations in a Windows 2000 server.

Unfortunately the pg_dump contained in the cygwin port of Postgres 8 is
version 8.0.0.beta3 which gives error
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR:  column "nsptablespace" does not
exist
pg_dump: The command was: SELECT tableoid, oid, nspname, (select usename
from pg
_user where nspowner = usesysid) as usename, nspacl, (SELECT spcname FROM
pg_tab
lespace t WHERE t.oid = nsptablespace) AS nsptablespace FROM pg_namespace

As I recall this was an error in pg_dump that is corrected in Postgres
8.0.0 release. Will the postgres 8.0.0 release be ported to cygwin and any
ideas about when?

Thanks
Laurie







:.________________
CONFIDENTIALITY : This  e-mail  and  any attachments are confidential and
may be privileged. If  you are not a named recipient, please notify the
sender immediately and do not disclose the contents to another person, use
it for any purpose or store or copy the information in any medium.



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [email protected])