Forum OpenACS Development: HOw to calculate line numbers in plpgsql

Collapse
1: HOw to calculate line numbers in plpgsql
Posted by Dave Bauer on 06/27/01 03:02 AM
I got this error message:

<pre>
NOTICE:  plpgsql: ERROR during compile of static_page__new_folder near line 54
[26/Jun/2001:21:02:55][1485.6150][-conn1-] Error: Ns_PgExec: result status: 7 message: ERROR:  parse error at or near "("

[26/Jun/2001:21:02:55][1485.6150][-conn1-] Error: dbinit: error(localhost::openacs-4,ERROR:  parse error at or near "("
): '
    </pre>

How do I figure out where line 54 of a pl/pgsql procedure is? Do I start from the function(  or begin?

Thanks!

Collapse
2: Response to HOw to calculate line numbers in plpgsql (response to 1)
Posted by Dan Wickstrom on 06/27/01 03:46 AM
The 'declare' statement is line 1, or if there is no 'declare' statement then start at the 'begin' statement.

I've also created a view that you can use to look at the numbered source for pl/pgsql functions. Do the following: 

select * from acs_func_defs where fname = 'static_page__new_folder';
Collapse
3: Response to HOw to calculate line numbers in plpgsql (response to 1)
Posted by Dave Bauer on 06/27/01 04:07 AM
Wow,  great! Let's put that in the porting guide.

I found the error, I was looking in the wrong place.  Thanks alot.