Scott Frankel wrote: > I've found that, for a table with a > serial sequence key as its first column, I have to specify the key in > my prepared statement or I get type errors: ERROR: column "foo_id" > is of type integer but expression is of type character varying.
Let's try: test=> create table t(a serial, b int); NOTICE: CREATE TABLE will create implicit sequence "t_a_seq" for serial column "t.a" CREATE TABLE test=> prepare a as insert into t(b) values($1); PREPARE test=> execute a(2); INSERT 0 1 test=> select * from t; a | b ---+--- 1 | 2 (1 row) No error here... Best regards, -- Daniel PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
