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 по дате отправления: