From: "Andrei N(dot)Sobchuck" <andrei(at)mart(dot)cherkassy(dot)ua>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject:
Date: 1999-12-10 14:27:31
Message-ID: 001701bf431a$b16721c0$0101a8c0@mart
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Your name :Andrei N.Sobchuck
Your email address :andrei(at)mart(dot)cherkassy(dot)ua

System Configuration
---------------------
Architecture (example: Intel Pentium) :Intel Celeron
Operating System (example: Linux 2.0.26 ELF) :Linux 2.2.13, glibc 2.1.1
PostgreSQL version (example: PostgreSQL-6.5.2):PostgreSQL-6.5.3
Compiler used (example: gcc 2.8.0) :egcs-2.91.66

Please enter a FULL description of your problem:
------------------------------------------------
1.
-------------------------------
=>select * into proba from ot;
SELECT
=> create unique index u ON proba (id_object,tel);
CREATE
=> select count(*) from proba;
count
-----
3770
(1 row)
=>cluster u ON proba;
ERROR: Cannot create unique index. Table contains non-unique values
=> select count(*) from proba;
count
-----
0
(1 row)
=> \d proba
Table = proba
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| id_object | int4 | 4 |
| tel | varchar() | 15 |
| prim | varchar() | 254 |
+----------------------------------+----------------------------------+-------+
Index: u
--------------------------
I was very surprised when all rows disappeared.

2. I use PostODBC v.06-40-0007, MS Access.
When I have access to a database, in log appear many messages:
"pq_recvbuf: unexpected EOF on client connection"
3.
>From MS Access I use query like 'SELECT o.id,op.dt from o,op where op.id=o.id AND op.dt=(select max(op2.dt) from op as op2 where op2.id=o.id);'. When query is executed 5 (or 6, or 7 i'm not sure) times, postmaster increase in size for 4kb (1 page?). For one day it increase for more than 2Mb. And I should restart postgres every night.

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrei N.Sobchuck 1999-12-11 10:47:56
Previous Message Bruce Momjian 1999-12-08 11:45:07 Re: [BUGS] uniqueness not always correct