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

An INSERT can kill the PostgreSQL server

From: Richi Plana <richip(at)mozcom(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: An INSERT can kill the PostgreSQL server
Date: 2000-05-28 17:01:06
Message-ID: Pine.LNX.4.21.0005290059570.3285-100000@jaguar.mozcom.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Your name		:	Richi Plana
Your email address	:	richip(at)mozcom(dot)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(at)mozcom(dot)com     `-'-'     `-'-'     `-'-'     `-'-' 


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2000-05-28 17:25:28
Subject: Re: An INSERT can kill the PostgreSQL server
Previous:From: Tom LaneDate: 2000-05-26 22:48:04
Subject: Re: [SQL] is limit a reserved keyword?

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