Forum OpenACS Q&A: Response to Bookmarks - revised for postgresql

Collapse
Posted by Kjell Wooding on

Hi Cathy. I noticed this when I dropped your package on top of a (virginal) OpenACS snapshot:

     
 Database operation "0or1row" failed (exception NSDB, "Query was not     
a statement returning rows.")     
    while executing     
"ns_pg_bind 0or1row nsdb0 {     
     
        select bookmark__initialize_in_closed_p (2581, 2581);     
             
      }"     

Some digging turned up this:

    
 select bookmark__initialize_in_closed_p (2581, 2581);    
NOTICE:  identifier "bookmark__initialize_in_closed_p" will be    
truncated to "bookmark__initialize_in_closed_"    
ERROR:  Function 'bookmark__initialize_in_closed_(int4, int4)' does    
not exist    
        Unable to identify a function that satisfies the given    
argument types    
        You may need to add explicit typecasts    

I haven't dug into it any more than this (no diff yet, sorry ;), but I though you might want to test the virginal, uninitialized case...