Forum OpenACS Q&A: Re: PG 7.2->7.3 upgrade gotcha?

Collapse
36: Re: PG 7.2->7.3 upgrade gotcha? (response to 1)
Posted by Don Baccus on 03/23/04 01:18 AM
The PG group changed the type conversion rules (again) and some expressions in postgresql.sql (in acs-kernel/sql/postgresql) were no longer valid.

It's been fixed ... pull postgresql.sql from CVS HEAD. I just changed all the "create function" statements to "create or replace function" - just ignore the table def errors you get when you run it through PSQL.

Collapse
37: Re: PG 7.2->7.3 upgrade gotcha? (response to 36)
Posted by Richard Hamilton on 03/23/04 11:01 AM
Don,

Thank you for your reply.

I pulled down the postgresql.sql file from cvs with tag set to HEAD and on looking through it seemed that only some of the functions were changed to CREATE OR REPLACE. When I ran it through postgres it only created 3 functions, and tree_right wasn't one of them.

I have obviously pulled down the wrong file although I checked it and it was last edited just 5 days ago. Sorry if I have I misunderstood your instructions.

For now I will edit my version of postgresql.sql to change all function declarations to CREATE OR REPLCE and see what happens.

R.