get diagnostics not supported by ecpg? - 10-09-2003 , 12:24 PM
It seems that get diagnostics is not supported by ecpg in postgresql
7.3, I always get the following error when trying to use it:
ERROR: parse error at or near "diagnostics"
For example, the following code does not compile:
EXEC SQL BEGIN DECLARE SECTION;
EXEC SQL END DECLARE SECTION;
EXEC SQL connect to 'test';
EXEC SQL get diagnostics :msg_len=ROW_COUNT;
fprintf(stderr, "SQL: %d\n", msg_len);
EXEC SQL disconnect current;
same if I use
EXEC SQL get diagnostics exception 1
What am I doing wrong? Or it's just not supported by ecpg in 7.3?
Thanks in advance,