Forum OpenACS Q&A: select sec_rotate_last_visit

Collapse
1: select sec_rotate_last_visit
Posted by Otto Solares on 05/03/00 11:37 PM
hi,

i am unable to run acspg but i did everything in the install,
when i attempt my first connection to the server it gives me the
following error:

Notice: Querying 'select sec_rotate_last_visit(17, 957389500);'
Error: Ns_PgExec: result status: 7 message: ERROR:  No such function
'bpchar' with the specified attributes
Notice: nsd.db: sql(localhost::acspg):  select
sec_rotate_last_visit(17, 957389500)Error: Filter
sec_read_security_info returned error #1: Database operation "1row"
failed (exception NSDB, "Query was not a statement returning rows.")
Error: nsd.tcl: Invalid return code from filter proc: Critical filter
sec_read_security_info failed. (must be filter_ok, filter_return, or
filter_break)

when i run the following query from psql it gives me the same error:

acspg=> select sec_rotate_last_visit(17, 957389500);
ERROR:  No such function 'bpchar' with the specified attributes

any help??

Collapse
2: Response to select sec_rotate_last_visit (response to 1)
Posted by Ben Adida on 05/03/00 11:39 PM
you're using Postgres 6.5, correct? Roberto, make sure to add
this to the FAQ.

Try upgrading to 7.0. It's in Release Candidate now, and it's very
very good.

Collapse
3: Response to select sec_rotate_last_visit (response to 1)
Posted by Otto Solares on 05/04/00 02:24 AM
yes, that fix it. thank you.
the pgsql7 is really nice.

well, the only problem are searchs now, any idea how is going
this?

Collapse
4: Response to select sec_rotate_last_visit (response to 1)
Posted by Don Baccus on 05/04/00 06:37 AM
Yeah, how going is this is that we don't have it going...(searches).

Hang on to your hat, we're still babies, learning to pin our own diapers!

Everything will come with time.  We'll hit the millenium deadline for sure (the REAL one that starts in 2001).