Forum OpenACS Q&A: Re: "select failed"(exception NSDB,....

Collapse
2: Re: "select failed"(exception NSDB,.... (response to 1)
Posted by Don Baccus on 01/23/03 08:41 PM
It looks like you've got a query with Oracle rather than Postgres syntax.

"acs_permission.permission_p" in Oracle sez "the permission_p package which is part of the acs_permission package".

Postgres doesn't have packages.  What we've done is to map such functions into a form using double underbars, as in "acs_permission__permission_p"

(if the HTML rendering doesn't make it clear, the double underbar separates "acs_permission" and "permission_p")

Collapse
3: Re: "select failed"(exception NSDB,.... (response to 2)
Posted by Pol Vilarmau on 01/23/03 08:45 PM
Thanks Don! That's the solution!!! :)