pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
get diagnostics not supported by ecpg?
2+ messages / 2 participants
[nested] [flat]

* get diagnostics not supported by ecpg?
@ 2003-10-09 17:29 Slava Gorski <slava_gorski@newmail.ru>
  2003-10-14 18:34 ` Re: get diagnostics not supported by ecpg? Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Slava Gorski @ 2003-10-09 17:29 UTC (permalink / raw)
  To: pgsql-novice@postgresql.org; +Cc: pgsql-sql

Hi all, 

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:

#include <stdio.h>

int main()
{   
    EXEC SQL BEGIN DECLARE SECTION;
    char msg[8191];
    int msg_len=0;
    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;

    return 0;
}

same if I use

EXEC SQL get diagnostics exception 1 
:msg=MESSAGE_TEXT,
:msg_len=MESSAGE_LENGTH;

What am I doing wrong? Or it's just not supported by ecpg in 7.3?

Thanks in advance, 
Slava
__________
www.newmail.ru -- всегда что-то новое.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: get diagnostics not supported by ecpg?
  2003-10-09 17:29 get diagnostics not supported by ecpg? Slava Gorski <slava_gorski@newmail.ru>
@ 2003-10-14 18:34 ` Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Eisentraut @ 2003-10-14 18:34 UTC (permalink / raw)
  To: Slava Gorski <slava_gorski@newmail.ru>; +Cc: pgsql-sql

Slava Gorski writes:

> What am I doing wrong? Or it's just not supported by ecpg in 7.3?

Indeed.

-- 
Peter Eisentraut   peter_e@gmx.net




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2003-10-14 18:34 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-10-09 17:29 get diagnostics not supported by ecpg? Slava Gorski <slava_gorski@newmail.ru>
2003-10-14 18:34 ` Peter Eisentraut <peter_e@gmx.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox