Re: pg_dump and Postgres 8.0.0 Release on cygwin - Mailing list pgsql-cygwin

From Reini Urban
Subject Re: pg_dump and Postgres 8.0.0 Release on cygwin
Date
Msg-id 422D4F90.10608@x-ray.at
Whole thread Raw
In response to pg_dump and Postgres 8.0.0 Release on cygwin  (laurie.burrow@powerconv.alstom.com)
List pgsql-cygwin
laurie.burrow@powerconv.alstom.com schrieb:

> 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?

I have an experimental 8.0.0 version on my site, but I encounter
IPC permissions problems (only related to cygwin).
It works for most installations though.

Point setup to http://xarch.tu-graz.ac.at/publ/cygwin/

--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban
http://phpwiki.org

pgsql-cygwin by date:

Previous
From: Reini Urban
Date:
Subject: Re: Building DBD::Pg fails at make test
Next
From: "Eric J. Schwarzenbach"
Date:
Subject: unicode support vs native install