How to disable prepared statements

[katcipis]

I had some troubles integrating with a pgbouncer that did not had support for prepared statements, I researched a little and found this:

http://stackoverflow.com/questions/17614441/pq-driver-prepared-statement-does-not-exist

Is there a way to disable prepared statements on the driver ?

[johto]

Is there a way to disable prepared statements on the driver ?

pgbouncer should be able to deal with what pq does if the (unfortunately undocumented) option binary_parameters added here is turned on. This has, however, some effects on your application; whenever it passes a byte slice as a parameter, it's assumed to be in the binary input format instead of textual.

[katcipis]

Thanks @johto

[rskumar]

If you turn binary_parameters on, you cannot save JSONB data in PG.

[jonomacd]

@rskumar did you ever find a solution for this? We are hoping to use pgbouncer but we also use JSONB.

[tobischo]

If you turn binary_parameters on, you cannot save JSONB data in PG.

Maybe to add to this:
It seems to work if you typecast the []byte slice to string before passing it into Execute/Query/...

e.g.

jsonbData, err = json.Marshal(someStruct)

row := db.QueryRow(
  UpdateQuery,
  id,
  string(jsonbData),
)