[BUGS] An INSERT can kill the PostgreSQL server

2000-05-28 Thread Richi Plana
Your name : Richi Plana Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : Intel PentiumIII-500 Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.15 ELF PostgreSQL v

Re: [BUGS] An INSERT can kill the PostgreSQL server

2000-05-28 Thread Tom Lane
Richi Plana <[EMAIL PROTECTED]> writes: > 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); > insert into rout

Re: [BUGS] An INSERT can kill the PostgreSQL server

2000-05-28 Thread Tom Lane
Richi Plana <[EMAIL PROTECTED]> writes: > 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); > insert into ro

[BUGS] Soalris 8 install problems

2000-05-28 Thread Toth Istvan
Hello! I've just installed PostgreSQL 8 on a Solaris 8 box, and I am having difficulties. I am using the bundled gcc and perl. Problem 1. I had to add #include to /include/c.h, the old varargs.h does not exist (I guess this is a gcc 2.95 issue) Problem 2. The bundled perl generates mefile

[BUGS] Postgresql 7.0 bug

2000-05-28 Thread root
POSTGRESQL BUG REPORT TEMPLATE Your name : Eric Prevost-Dansereau Your email address : [EM

Re: [BUGS] Postgresql 7.0 bug

2000-05-28 Thread Tom Lane
root <[EMAIL PROTECTED]> writes: > SELECT '2000-04-03'::timestamp - '2000-04-02'::timestamp; >?column? > -- >23:00 > (1 row) > Why april 2nd, 2000 don't last 1 day (or 24 hours) ? Here in the USA, that is the right answer because 4/2 was a daylight savin