Forum OpenACS Q&A: Re: Function bittoint4(bit) does not exist

Posted by Eric Wolfram on
Thanks. That fixed it as far as I can tell.

psql -f packages/acs-kernel/sql/postgresql/postgesql.sql DBNAME

I was sure I already ran that and I didn't want to try it again. Upon running it again, I got a lot of errors "function ___ already exists" or "ERROR: Relation ____ already exists", but it also did create and drop a few functions. Maybe it missed those first time around and I didn't notice the errors?


Posted by Jun Yamog on
Hi Eric,

"already exists" errors should be ok and expected if you run packages/acs-kernel/sql/postgresql/postgesql.sql

The create and drop of functions must be the inline_* functions.

Posted by Tom Craftino on
What`s file atrebute of postgesql.sql?
Nasty Credit Cards - Training Courses at UK Virtual College