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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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;
From | Date | Subject | |
---|---|---|---|
Next Message | Roman Kononov | 2008-04-19 06:25:25 | Inconsistent shift operator |
Previous Message | Terry Lee Tucker | 2008-04-18 16:32:44 | Re: Request |