Port Bug Report: The postgres server crashes - Mailing list pgsql-ports

From Unprivileged user
Subject Port Bug Report: The postgres server crashes
Date
Msg-id 199901070135.UAA04502@hub.org
Whole thread Raw
List pgsql-ports
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        : Jixue Liu
Your email address    : j.liu@cis.unisa.edu.au

Category        : runtime: back-end: SQL
Severity        : serious

Summary: The postgres server crashes

System Configuration
--------------------
  Operating System   : Solaris 2.6.2

  PostgreSQL version : 6.0

  Compiler used      :

Hardware:
---------


Versions of other tools:
------------------------


--------------------------------------------------------------------------

Problem Description:
--------------------
After sending a select query with oid8out function in it,
 the server crashed.

--------------------------------------------------------------------------

Test Case:
----------
e.g.
create table cities (name text, population float, altitude int);
insert into cities values('x',1.2,100);
select oid8out(altitude) from cities;
now the server rashed.

The select query may not be correct, but the server should not crash,
instead, it should give a error message.


--------------------------------------------------------------------------

Solution:
---------


--------------------------------------------------------------------------


pgsql-ports by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PORTS] vacuum takes too long
Next
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Re: [PORTS] vacuum takes too long