Re: [ADMIN] A couple of errors encountered in 7.1.3=>7.2.1-2 data migration

2002-05-13 Thread Ray Ontko
Tom, et al, > > ERROR: cannot find attribute 1 of relation schedule_notification_log > > This is more disturbing. Can you provide the sequence of commands that > led up to it? Here are a few related datapoints. 1) We think that schedule_notification_log is the only table that we loaded fr

Re: [ADMIN] A couple of errors encountered in 7.1.3=>7.2.1-2 data migration

2002-05-10 Thread Nick Fankhauser
Tom- Thanks! your diagnosis was correct & the repair worked. -Nick & Ray > I'm beginning to think there is something seriously messed up about your > installation. The simplest theory is that the indexes on pg_attribute > are corrupted. ... > You should be able to recover using REINDEX

Re: [ADMIN] A couple of errors encountered in 7.1.3=>7.2.1-2 data migration

2002-05-10 Thread Tom Lane
Ray Ontko <[EMAIL PROTECTED]> writes: > develop=# select count(*) from temp_event ; > ERROR: cannot find attribute 1 of relation temp_event I'm beginning to think there is something seriously messed up about your installation. The simplest theory is that the indexes on pg_attribute are corrupte

Re: [ADMIN] A couple of errors encountered in 7.1.3=>7.2.1-2 data migration

2002-05-10 Thread Tom Lane
"Nick Fankhauser" <[EMAIL PROTECTED]> writes: > The load returned two errors that I don't understand: > ERROR: DefineIndex: index function must be marked iscachable This means what it says: add "with (iscachable)" to your function declaration. This is intended to remind you that it is not sens

[ADMIN] A couple of errors encountered in 7.1.3=>7.2.1-2 data migration

2002-05-10 Thread Nick Fankhauser
Hi- The background info: Debian 2.4.14 on both source & destination boxes PostgreSQL 7.1.3 on source PostgreSQL 7.2.1-2 on destination We are testing 7.2 with our application by installing it on a separate box & accessing it via the network. The 7.2 install is just a plain vanilla install using