prepare statement w/o values

[dvv]

Hi!

How do I prepare a statement w/o binding values and executing it, just for future use as named query? The absense of values key in configuration parameters causes unhandled error event so far

TIA,
--Vladimir

[brianc]

dang! I'll take a look at this after work today.

[brianc]

I cannot reproduce. Can I get a code sample, version of pg you're using, version of node you're using, and operating system?

[dvv]

Sure. Please, take a look at https://gist.github.com/929626

[brianc]

Okey dokey...thanks for the awesome gist. I see the issue.

With node-postgres the first time you issue a named query it is parsed, bound, and executed all at once. Every subsequent query issued on the same connection with the same name will automatically skip the "parse" step and only rebind and execute the already planned query.

Currently node-postgres does not support a way to create a named, prepared query and not execute the query. This feature is supported within libpq and the client/server protocol (used by the pure javascript bindings), but I've not directly exposed it in the API. I thought it would add complexity to the API without any real benefit. Since named statements are bound to the client in which they are created, if the client is disconnected and reconnected or a different client is returned from the client pool, the named statement will no longer work (it requires a re-parsing).

Here's an example of how it works currently:

https://github.com/brianc/node-postgres/blob/master/test/integration/client/prepared-statement-tests.js#L18

[dvv]

In fact, I've found the current behavior quite well-suited. I can perfectly live with this "lazy-preparation" way. Thanks. Closing