Forum OpenACS Q&A: Re: Function bittoint4(bit) does not exist
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?
"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.