An INSERT can kill the PostgreSQL server

Richi Plana <richip@mozcom.com>

From: Richi Plana <richip@mozcom.com>
To: pgsql-bugs@postgresql.org
Date: 2000-05-28T17:01:06Z
Lists: pgsql-bugs
Your name		:	Richi Plana
Your email address	:	richip@mozcom.com


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

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

  PostgreSQL version (example: PostgreSQL-6.5.1):   PostgreSQL-7.0

  Compiler used (example:  gcc 2.8.0)		:   gcc 2.91.66


Please enter a FULL description of your problem:
------------------------------------------------
While INSERTing a row into a TABLE, the backend would die and restart


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

create table devices (brand varchar(30), model varchar(30), serial
varchar(30), ro_community varchar(50)[], rw_community varchar(50)[], primary
key (brand, model, serial));

create table routers (lo_address inet) inherits (devices);

Query:

insert into routers values ('Cisco', '7206VXR', '72498595', '{"Butterflies",
"Intehsoijfeijfjf"}', NULL, '10.2.3.4');


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

-- 

L   L Richi Plana, CCNA 8^)   ,-,-.     ,-,-.     ,-,-.     ,-,-.     ,-
LL LL Systems Administrator  / / \ \   / / \ \   / / \ \   / / \ \   / /
LLLLL Mosaic Communications, Inc. \ \ / /   \ \ / /   \ \ / /   \ \ / / 
LLLLL mailto:richip@mozcom.com     `-'-'     `-'-'     `-'-'     `-'-'