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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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