Thread: Question about cursor behavior and declare/fetch

pgsql-odbcHi,

    Use or not use declare/fetch -- what's the difference? What cursor behaviors they support, respectively? Why
defaultto not use declare/fetch? When should I set it to true? I can not find a detailed doc about this. 
    Thanks!

　　　　　　　　


　　　　　　　　Han
　　　　　　　　zhouhanok@vip.sina.com
　　　　　　　　　　2003-01-15

> -----Original Message-----
> From: Han
>
> pgsql-odbcHi,
>
>     Use or not use declare/fetch -- what's the difference? What
> cursor behaviors they support, respectively? Why default to not
> use declare/fetch? When should I set it to true? I can not find a
> detailed doc about this.

Unfortunately PostgreSQL doesn't support cross transaction cursors.
The option is mainly for read-only applications.

regards,
Hiroshi Inoue
    http://www.geocities.jp/inocchichichi/psqlodbc/