create temporary sequence and ecpg

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        :    Edmund Bacon
Your email address    :    ebacon@onesystem.com


System Configuration
---------------------
  Architecture (example: Intel Pentium)      : Intel Pentium

  Operating System (example: Linux 2.0.26 ELF)     :  Linux 2.4.20

  PostgreSQL version (example: PostgreSQL-7.3.4):   PostgreSQL-7.3.4

  Compiler used (example:  gcc 2.95.2)        :  gcc 3.2.2


Please enter a FULL description of your problem:
------------------------------------------------

Trying to create a TEMPORARY SEQUENCE with ecpg produces
a runtime erorr.  the sqlprint error is:

sql error 'ERROR:  parser: parse error at or near "foo" at character 27'
in lin

A workaround is to use EXECUTE IMMEDIATE



Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

exec sql include sqlca;

$ cat tmpseq.pgc

int main()
{
    exec sql whenever sqlerror sqlprint;

    exec sql connect to test;

    exec sql create temporary sequence foo;

    exec sql disconnect;

    return 0;
}

Looking at the emitted C code we see:

 { ECPGdo(__LINE__, NULL, "create sequence temporary foo ", ECPGt_EOIT,
ECPGt_EORT);

Note that the tokens "sequence" and "temporary" have been reversed.

If you know how this problem might be fixed, list the solution below:

---------------------------------------------------------------------





--
Edmund Bacon <ebacon@onesystem.com>