Re: [GENERAL] Prepared statements and cursors

2014-01-28 Thread Andreas Lubensky
That is an interesting approach. However, I see the problem that the functions would have to be removed when no longer needed. If that fails (broken connection etc.), they would be orphaned. Prepared statements are bound to the connection, so when the connection is closed they are gone. On Thu,

Re: [GENERAL] Prepared statements and cursors

2014-01-28 Thread Merlin Moncure
On Tue, Jan 28, 2014 at 7:53 AM, Andreas Lubensky luben...@cognitec.com wrote: That is an interesting approach. However, I see the problem that the functions would have to be removed when no longer needed. If that fails (broken connection etc.), they would be orphaned. Prepared statements are

[GENERAL] Prepared statements and cursors

2014-01-23 Thread Andreas Lubensky
Hello, When implementing a database backend with libpq I realized that it seems to be impossible to declare a cursor on a prepared statement. Is this correct? What is the reason for this limitation? -- with best regards, Andreas Lubensky -- Sent via pgsql-general mailing list

Re: [GENERAL] Prepared statements and cursors

2014-01-23 Thread Susan Cassidy
pgpool-II may do what you want. On Thu, Jan 23, 2014 at 6:31 AM, Andreas Lubensky luben...@cognitec.comwrote: Hello, When implementing a database backend with libpq I realized that it seems to be impossible to declare a cursor on a prepared statement. Is this correct? What is the reason for

Re: [GENERAL] Prepared statements and cursors

2014-01-23 Thread Susan Cassidy
Sorry, answered wrong posting. On Thu, Jan 23, 2014 at 6:31 AM, Andreas Lubensky luben...@cognitec.comwrote: Hello, When implementing a database backend with libpq I realized that it seems to be impossible to declare a cursor on a prepared statement. Is this correct? What is the reason for

Re: [GENERAL] Prepared statements and cursors

2014-01-23 Thread Merlin Moncure
On Thu, Jan 23, 2014 at 8:31 AM, Andreas Lubensky luben...@cognitec.com wrote: Hello, When implementing a database backend with libpq I realized that it seems to be impossible to declare a cursor on a prepared statement. Is this correct? What is the reason for this limitation? I can't think