pgx pool exec errors with "cannot insert multiple commands into a prepared statement" and "mismatched param and argument count"

[kalensk]

@jackc When I use sql.DB to do an Exec() with the following queries it just works. However, switching to pgxpool I get all kinds of errors. (I was hoping it could be essentially a direct replacement with my existing code.) What am I doing wrong or how can I fix things? Or what is the better approach?

query := `DROP TABLE IF EXISTS my_table_one CASCADE; CREATE TABLE my_table_one (id SERIAL);`
_, err = conn.Pool().Exec(context.Background(), query)
if err != nil {
	return err
}

This errors with: cannot insert multiple commands into a prepared statement

When I update the query to do each statement one at a time as follows:

query := `DROP TABLE IF EXISTS my_table_one CASCADE;`
_, err = conn.Pool().Exec(context.Background(), query)
if err != nil {
	return err
}

query = `CREATE TABLE my_table_one (id SERIAL);`
_, err = conn.Pool().Exec(context.Background(), query)
if err != nil {
	return err
}

The first query errors with mismatched param and argument count

Looks like setting a break-point in extended_query_builder.go for (eqb *ExtendedQueryBuilder) Build shows that sd.ParamOIDs has len 0, but args has len 1 with an empty interface with []interface{interface{}}. Thus, the two lengths don't match. :/ Why does args have a length of 1 when passed nothing?

[kalensk]

Errr I think it's a bug in my end. Sorry about that!!!