kevalshah writes:
> At present whenever there is any error in syntax of fired query
> i get error message in terms of charcter "at char 53 "
> I also would like to have line no: from psql terminal..
Umm ... any reasonably recent version of psql will show syntax errors
like this:
regression=# se
Hi All,
I am using postgres sql.
At present whenever there is any error in syntax of fired query
i get error message in terms of charcter "at char 53 "
I also would like to have line no: from psql terminal..
I tried making changes in scan.l
Do u have any suggestive fix ?
to get error as "a
Richard Huxton writes:
> I thought it was the PERFORM statements, but it's not. The line number
> seems right, although the error message is misleading.
FWIW, things are better in HEAD:
regression=# create function foo() returns int as $$
regression$# begin
regression$# return;
regression$# e
On 19/02/10 07:52, iuri de araujo sampaio wrote:
Hi there,
i have got the followed error in the pgsql function bellow. Log messages
point to:
ERROR: syntax error at end of input
LINE 1: SELECT
^
QUERY: SELECT
CONTEXT: SQL statement in PL/PgSQL function
"cms_permission__revok
Hi there,
i have got the followed error in the pgsql function bellow.
Log messages point to:
ERROR: syntax error at end of input
LINE 1: SELECT
^
QUERY: SELECT
CONTEXT: SQL statement in PL/PgSQL function
"cms_permission__revoke_permission" near line 67
*