An INSERT can kill the PostgreSQL server

Поиск
Список
Период
Сортировка
От Richi Plana
Тема An INSERT can kill the PostgreSQL server
Дата
Msg-id Pine.LNX.4.21.0005290059570.3285-100000@jaguar.mozcom.com
обсуждение исходный текст
Ответы Re: An INSERT can kill the PostgreSQL server  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: An INSERT can kill the PostgreSQL server  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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     `-'-'     `-'-'     `-'-'     `-'-'

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Gabriel Russell
Дата:
Сообщение: is limit a reserved keyword?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: An INSERT can kill the PostgreSQL server