Skip site navigation (1) Skip section navigation (2)

BUG #4113: server closed the connection unexpectedly

From: "Javier Hernandez" <dba(at)loopone(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4113: server closed the connection unexpectedly
Date: 2008-04-18 20:15:50
Message-ID: 200804182015.m3IKFokG032474@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4113
Logged by:          Javier Hernandez
Email address:      dba(at)loopone(dot)com
PostgreSQL version: 8.3.1
Operating system:   Linux version 2.6.9-11.ELsmp; Red Hat 3.4.3-22; gcc
version 3.4.3
Description:        server closed the connection unexpectedly
Details: 

The following script generates an unexpected loss of connection. 


begin;

\echo "Creating a table to hold numeric values only"
create table numeric_col_table (
num_col numeric(6,0) primary key not null
);

\echo "Creating a table to hold integer values only"
create table int_col_table (
int_col integer primary key not null
);


\echo "Inserting data into our numeric-only table"
insert into numeric_col_table (num_col) values (1), (2), (3);

\echo "Inserting data into our integer-only table"
insert into int_col_table (int_col) values (1), (2), (3);

\echo "Show contents of the numeric table"
select * from numeric_col_table;

\echo "Show contents of the numeric table"
select * from int_col_table;

\echo "Select everything from the integer table where int_col =
numeric_col"
select * from int_col_table where int_col in (select num_col from
numeric_col_table);

\echo "Select everything from the numeric table where numeric_col =
int_col"
select * from numeric_col_table where num_col in (select int_col from
int_col_table);

rollback;

Responses

pgsql-bugs by date

Next:From: Roman KononovDate: 2008-04-19 06:25:25
Subject: Inconsistent shift operator
Previous:From: Terry Lee TuckerDate: 2008-04-18 16:32:44
Subject: Re: Request

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group