In my real query the ? was used in the where clause,
I moved it to the select while trying to come with a simplified test case.
>From: Dave Cramer <pg(at)fastcrypt(dot)com>
>To: JEAN-PIERRE PELLETIER <pelletier_32(at)sympatico(dot)ca>
>CC: List <pgsql-jdbc(at)postgresql(dot)org>, PostgreSQL-development
><pgsql-hackers(at)postgreSQL(dot)org>
>Subject: Re: [JDBC] server process (PID 1188) exited with exit code
>-1073741819, 8.2 beta1
>Date: Tue, 24 Oct 2006 18:11:18 -0400
>
>This is a server bug, I will post to hackers for you, it has little to do
>with JDBC, however the ? can't be a column in a prepared statement
>
>DAVE
>On 24-Oct-06, at 4:45 PM, JEAN-PIERRE PELLETIER wrote:
>
>>Hi,
>>
>>I have a query that throws "org.postgresql.util.PSQLException: An I/ O
>>error occured while sending to the backend". Here is a simplified version
>>of it where I used pg_database, but any table or view do the same.
>>
>>PreparedStatement pstmt = connection.prepareStatement("select ? from
>>(select * from pg_database) t");
>>pstmt.setObject(1, 1);
>>ResultSet rs = pstmt.executeQuery();
>>
>>It restarts PostgreSQL with this in the Log
>>2006-10-24 15:35:38 LOG: server process (PID 1188) exited with exit code
>>-1073741819
>>2006-10-24 15:35:38 LOG: terminating any other active server processes
>>2006-10-24 15:35:38 LOG: all server processes terminated; reinitializing
>>2006-10-24 15:35:39 LOG: database system was interrupted at 2006-10-24
>>15:34:54 Eastern Standard Time
>>2006-10-24 15:35:39 LOG: Windows fopen("recovery.conf","r") failed: code
>>2, errno 2
>>2006-10-24 15:35:39 LOG: Windows fopen("pg_xlog/ 00000001.history","r")
>>failed: code 2, errno 2
>>2006-10-24 15:35:39 LOG: Windows fopen("backup_label","r") failed: code
>>2, errno 2
>>2006-10-24 15:35:39 LOG: checkpoint record is at 0/31FDF0A0
>>2006-10-24 15:35:39 LOG: redo record is at 0/31FDF0A0; undo record is at
>>0/0; shutdown TRUE
>>2006-10-24 15:35:39 LOG: next transaction ID: 0/22535; next OID: 101011
>>2006-10-24 15:35:39 LOG: next MultiXactId: 1; next MultiXactOffset: 0
>>2006-10-24 15:35:39 LOG: database system was not properly shut down;
>>automatic recovery in progress
>>2006-10-24 15:35:39 LOG: record with zero length at 0/31FDF0F0
>>2006-10-24 15:35:39 LOG: redo is not required
>>2006-10-24 15:35:40 LOG: database system is ready
>>2006-10-24 15:35:40 LOG: Windows fopen("global/pg_fsm.cache","rb")
>>failed: code 2, errno 2
>>2006-10-24 15:35:40 LOG: transaction ID wrap limit is 2147484172,
>>limited by database "postgres"
>>2006-10-24 15:36:40 LOG: Windows fopen("global/pgstat.stat","rb")
>>failed: code 2, errno 2
>>2006-10-24 15:36:40 LOG: Windows fopen("global/pgstat.stat","rb")
>>failed: code 2, errno 2
>>
>>I am using PostgreSQL 8.2 beta1 on Windows XP, Service Pack 2
>>Both JDBC3 driver 8.1 build 407 and 8.2 build 503 do the same.
>>
>>Thanks,
>>Jean-Pierre Pelletier
>>e-djuster
>>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 6: explain analyze is your friend
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match