00:32:14.407 (1) PostgreSQL 8.3devel JDBC3g with SSL (build 601) 00:32:14.415 (1) Trying to establish a protocol version 3 connection to localhost:5820 00:32:14.435 (1) FE=> StartupPacket(user=jurka, database=jurka, client_encoding=UNICODE, DateStyle=ISO) 00:32:14.439 (1) <=BE AuthenticationOk 00:32:14.454 (1) <=BE ParameterStatus(client_encoding = UNICODE) 00:32:14.454 (1) <=BE ParameterStatus(DateStyle = ISO, MDY) 00:32:14.454 (1) <=BE ParameterStatus(integer_datetimes = off) 00:32:14.455 (1) <=BE ParameterStatus(is_superuser = on) 00:32:14.455 (1) <=BE ParameterStatus(server_encoding = LATIN1) 00:32:14.455 (1) <=BE ParameterStatus(server_version = 8.2rc1) 00:32:14.455 (1) <=BE ParameterStatus(session_authorization = jurka) 00:32:14.455 (1) <=BE ParameterStatus(standard_conforming_strings = off) 00:32:14.455 (1) <=BE ParameterStatus(TimeZone = Navajo) 00:32:14.455 (1) <=BE BackendKeyData(pid=18476,ckey=1848590853) 00:32:14.456 (1) <=BE ReadyForQuery(I) 00:32:14.456 (1) compatible = 8.3 00:32:14.456 (1) loglevel = 2 00:32:14.456 (1) prepare threshold = 1 getConnection returning driver[className=org.postgresql.Driver,org.postgresql.Driver@2fe4cbc4] 00:32:14.482 (1) simple execute, handler=org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler@70329f3d, maxRows=0, fetchSize=0, flags=17 00:32:14.482 (1) FE=> Parse(stmt=null,query="CREATE TEMP TABLE tt (a text, b date)",oids={}) 00:32:14.483 (1) FE=> Bind(stmt=null,portal=null) 00:32:14.483 (1) FE=> Describe(portal=null) 00:32:14.483 (1) FE=> Execute(portal=null,limit=0) 00:32:14.483 (1) FE=> Sync 00:32:14.501 (1) <=BE ParseComplete [null] 00:32:14.501 (1) <=BE BindComplete [null] 00:32:14.501 (1) <=BE NoData 00:32:14.501 (1) <=BE CommandStatus(CREATE TABLE) 00:32:14.502 (1) <=BE ReadyForQuery(I) 00:32:14.504 (1) batch execute 2 queries, handler=org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler@43256ea2, maxRows=0, fetchSize=0, flags=20 00:32:14.504 (1) FE=> Parse(stmt=S_1,query="INSERT INTO tt VALUES ($1, $2)",oids={1043,0}) 00:32:14.505 (1) FE=> Describe(statement=S_1) param types = 1043 0 00:32:14.505 (1) FE=> Bind(stmt=S_1,portal=null,$1=,$2=<1969-12-31 -07:00:00>) 00:32:14.505 (1) FE=> Execute(portal=null,limit=1) 00:32:14.506 (1) FE=> Parse(stmt=S_2,query="INSERT INTO tt VALUES ($1, $2)",oids={26,1082}) 00:32:14.506 (1) FE=> Bind(stmt=S_2,portal=null,$1=,$2=) 00:32:14.506 (1) FE=> Describe(portal=null) 00:32:14.506 (1) FE=> Execute(portal=null,limit=1) 00:32:14.506 (1) FE=> Sync 00:32:14.508 (1) <=BE ParseComplete [S_1] 00:32:14.509 (1) <=BE ParameterDescription 1043 1082 00:32:14.509 (1) <=BE NoData 00:32:14.509 (1) <=BE BindComplete [null] 00:32:14.509 (1) <=BE CommandStatus(INSERT 0 1) 00:32:14.509 (1) <=BE ParseComplete [S_2] 00:32:14.509 (1) <=BE BindComplete [null] 00:32:14.509 (1) <=BE NoData 00:32:14.510 (1) <=BE CommandStatus(INSERT 0 1) 00:32:14.510 (1) <=BE ReadyForQuery(I) 00:32:14.510 (1) simple execute, handler=org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler@33dff3a2, maxRows=0, fetchSize=0, flags=20 00:32:14.510 (1) FE=> CloseStatement(S_1) 00:32:14.510 (1) FE=> Describe(statement=S_2) param types = 1043 0 00:32:14.510 (1) FE=> Bind(stmt=S_2,portal=null,$1=,$2=<1969-12-31 -07:00:00>) 00:32:14.510 (1) FE=> Execute(portal=null,limit=1) 00:32:14.510 (1) FE=> Sync 00:32:14.511 (1) <=BE CloseComplete 00:32:14.511 (1) <=BE ParameterDescription 26 1082 Exception in thread "main" java.lang.IllegalArgumentException: Can't change resolved type for parameter: 1 Orig types: 1043 0 New Types: 26 1082 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1227) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:190) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304) at ParamTypeProb.main(ParamTypeProb.java:26)