Error when creating tables

Поиск
Список
Период
Сортировка
От Kevin Heflin
Тема Error when creating tables
Дата
Msg-id Pine.LNX.4.10.9906021658310.12353-100000@mercury.shreve.net
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Mike Frisch
Дата:
Сообщение: Implementing hierarchy
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Re: [GENERAL] create table bug: the "no" string can't be a column