Error when creating tables - Mailing list pgsql-general

From Kevin Heflin
Subject Error when creating tables
Date
Msg-id Pine.LNX.4.10.9906021658310.12353-100000@mercury.shreve.net
Whole thread Raw
List pgsql-general
I read some posts regarding this error on some of the mailing lists
archives, but couldn't find an explanation.

After creating a table, I get the following error:

NOTICE:  _outNode: don't know how to print type 715

psql shows the table having been created however.

Anything to be concerned about?

Something else I'm wondering about is upgrading from postgresql 6.3.2 to
postgresql 6.4.2 or possibly 6.5

in the past what I've done is to backup a database with pg_dump (with some
options) on a database to create a backup along with the schema and
permisions etc.. then on the new postgresql server do a createdb 'dbname'
and run psql -e databasename < backupfile

Is this the correct way to do this or is there an easier way. I've got
about 50 databases to move over from 6.3.2 to 6.4.2


If this is the correct way to do this. I found before when moving from
some other version of postgres to 6.3.2 that sometimes the backed up file
would not restore correctly to the new postgresql server, and I had to
manually edit the backup file before running pgsql dbname < backupfile

Any suggestions would be appreciated.

Kevin



--------------------------------------------------------------------
Kevin Heflin          | ShreveNet, Inc.      | Ph:318.222.2638 x103
VP/Mac Tech           | 333 Texas St #175    | FAX:318.221.6612
kheflin@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------




pgsql-general by date:

Previous
From: Mike Frisch
Date:
Subject: Implementing hierarchy
Next
From: The Hermit Hacker
Date:
Subject: Re: [GENERAL] create table bug: the "no" string can't be a column