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

backend crash with inet type

From: Chris Dunlop <chris(at)onthe(dot)net(dot)au>
To: bugs(at)postgreSQL(dot)org
Subject: backend crash with inet type
Date: 1999-03-21 02:59:02
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
                        POSTGRESQL BUG REPORT TEMPLATE

Your name		: Chris Dunlop
Your email address	: chris(at)onthe(dot)net(dot)au

System Configuration
  Architecture (example: Intel Pentium)  	: Intel-Pentium

  Operating System (example: Linux 2.0.26 ELF) 	: Linux 2.0.35

  PostgreSQL version (example: PostgreSQL-6.4)  : PostgreSQL-6.4.2, also snapshot-990320

  Compiler used (example:  gcc 2.8.0)		: gcc

Please enter a FULL description of your problem:

Attempting to delete from a table by inet, with rows containing NULL inet
types results in a backend crash

Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible: 

create table blah ( ip_address inet );

insert into blah values('');
INSERT 18761 1

delete from blah where ip_address = '';

insert into blah values(NULL);
INSERT 18762 1

delete from blah where ip_address = '';
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
We have lost the connection to the backend, so further processing is impossible.  Terminating.

If you know how this problem might be fixed, list the solution below:


pgsql-bugs by date

Next:From: Faisal Haji MustaffaDate: 1999-03-21 19:37:04
Subject: need help....
Previous:From: Unprivileged userDate: 1999-03-20 18:38:55
Subject: General Bug Report: createuser bails out with ERROR

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