El Lunes, 28 de Diciembre de 2009, Iñaki Baz Castillo escribió:
> El Lunes, 28 de Diciembre de 2009, Iñaki Baz Castillo escribió:
> > Hi, I'm testing Sequel with 'pg' driver using Posgres-8.4 database. I use
> > prepared statements.
>
> Note that even using 'pg' module, I don't use $name__text syntax as
> specified in:
> http://sequel.rubyforge.org/rdoc/files/doc/prepared_statements_rdoc.html
>
> Does it mean that I'm using bound variables rather than prepared
> statements?
>
> This is what my I see in the postgres log:
>
> -------------------------------------------------------
> 2009-12-28 18:48:47 CET LOG: sentencia: SET standard_conforming_strings =
> ON 2009-12-28 18:48:47 CET LOG: sentencia: SET client_min_messages =
> 'WARNING' 2009-12-28 18:48:47 CET LOG: sentencia: SET DateStyle = 'ISO'
> 2009-12-28 18:48:47 CET LOG: ejecutar ps1: SELECT "doc", "etag" FROM
> "pres_rules" WHERE (("user" = $1) AND ("doc_uri" = $2)) LIMIT 1
> 2009-12-28 18:48:47 CET DETALLE: parámetros: $1 = 'alice', $2 = 'doc.xml'
> -------------------------------------------------------
>
> Is it using bound variables rather than prepared statements?
Now I add "__type" and get this in the log:
--------------------------------------------
2009-12-28 19:08:32 CET LOG: ejecutar ps1: SELECT "id", "etag" FROM
"pres_rules" WHERE (("user" = $1::varchar) AND ("doc_uri" = $2::varchar))
LIMIT 1
2009-12-28 19:08:32 CET DETALLE: parámetros: $1 = 'alice', $2 = 'doc.xml'
--------------------------------------------
Does it mean that now I'm using prepared statements?
Thanks a lot.
--
Iñaki Baz Castillo <[email protected]>
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
