Ouch, crash confirmed --- studying the cause now. ---------------------------------------------------------------------------
Javier Hernandez wrote: > > The following bug has been logged online: > > Bug reference: 4113 > Logged by: Javier Hernandez > Email address: [EMAIL PROTECTED] > 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; > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
