View Single Post

   
  #1 (permalink)  
Old 04-17-2008, 07:56 PM
=?ISO-8859-1?Q?K=D6PFERL_Robert?=
 
Posts: n/a
Default pg_dump from pgadmin and Postgres 8.0

Hi,
I am currently using pg_dump which was delivered with the 14.1.-Version of
PgAdmin III on a 8.0 database.

Issuing the following command:
C:\tools\PGADMI~1>pg_dump.exe -i -h pgv8host -p 5432 -U admin -F p -v
somedb

Results in:
pg_dump.exe: reading schemas
pg_dump.exe: SQL command failed
pg_dump.exe: Error message from server: ERROR: column "nsptablespace" does
not exist
pg_dump.exe: The command was: SELECT tableoid, oid, nspname, (select usename
from pg_user where nspowner = usesysid) as usename, nsp
acl, (SELECT spcname FROM pg_tablespace t WHERE t.oid = nsptablespace) AS
nsptablespace FROM pg_namespace
pg_dump.exe: *** aborted because of error


What's wrong?

Has it to do with template0/1?

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply With Quote