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

Collapse
4: Re: Function bittoint4(bit) does not exist (response to 1)
Posted by Eric Wolfram on 09/02/06 04:36 AM
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?

Thanks!
e

Collapse
5: Re: Function bittoint4(bit) does not exist (response to 4)
Posted by Jun Yamog on 09/06/06 12:44 AM
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.

Collapse
6: Re: Function bittoint4(bit) does not exist (response to 5)
Posted by Tom Craftino on 09/06/06 01:47 PM
What`s file atrebute of postgesql.sql?
___________________________________________
Nasty Credit Cards - Training Courses at UK Virtual College