[pgadmin-support] kinda weird

2002-12-01 Thread pippo
An error has occurred in pgAdminII:frmConnect.cmdConnect_Click: Number: -2147467259 Descriprion: Could not connect to the server; Could not connect to remote socket. Same problem trying to access either of two servers. On one of them, I get the message that there is no "test" database installed.

[pgadmin-support] altering the name of the public schema

2002-12-01 Thread Jochem van Dieten
[restarting the "Renaming schema's" thread from pgsql-general] Using pgAdminII version 1.4.2 with PostgreSQL 7.3 I can alter the name of a schema using: test=# update pg_catalog.pg_namespace test-# set nspname = 'newname' test-# where nspname = 'oldname'; This works without a problem unt