Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-cygwin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group