pg_dump and Postgres 8.0.0 Release on cygwin

From: laurie(dot)burrow(at)powerconv(dot)alstom(dot)com
To: pgsql-cygwin(at)postgresql(dot)org
Subject: pg_dump and Postgres 8.0.0 Release on cygwin
Date: 2005-03-07 17:05:07
Message-ID: OF2666034A.BC0C3A8E-ON80256FBD.0052C86A-80256FBD.005E494F@transport.alstom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

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.

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Reini Urban 2005-03-08 07:07:10 Re: Building DBD::Pg fails at make test
Previous Message Magnus Hagander 2005-03-06 20:08:26 Re: PostgreSQL installation problem on Windows XP Home