Dean Schulze wrote:
> Here are the duplicate records that violate this constraint:
>
> select county, year, idnumber, count(0) from table1 group by county, year,
> idnumber having (count(0) > 1) order by county, count(0);
>
>
> "county","year","idnumber","count"
> "AD",2009,"A57504",2
> "AD",20
The following bug has been logged online:
Bug reference: 5005
Logged by: Dean Schulze
Email address: dean.w.schu...@comcast.net
PostgreSQL version: 8.3.7
Operating system: Win XP
Description:unique constraint considers nulls to be equal
Details:
When I apply this co
On 23/08/2009 12:42 PM, Greg Stark wrote:
On Sun, Aug 23, 2009 at 4:48 AM, Craig
Ringer wrote:
Interestingly, though, the test program does appear to be leaking - at
least, the peak working set slowly climbs. It's all private working set. Not
sure why yet since the memory use looks like it _sho
veneti wrote:
The following bug has been logged online:
Bug reference: 4991
Logged by: veneti
Email address: annita.ven...@qs-unisolution.com
PostgreSQL version: 1.82
Operating system: Windows
Description:problem with ODBC driver 8.4
Details:
When you upgrade to t
> "Greg" == Greg Stark writes:
Greg> Either of two things are true.
Greg> Either transaction 6179 committed,
[snip]
This is all missing the point. The row should have been killed by
transaction 4971, NOT 6179. By the time transaction 6179 tried to
do anything with it, it was almost certain
Greg Stark [2009-08-23 03:44]:
> 2009/8/22 Radoslaw Zielinski :
>> $ seq 11 | xargs -ti psql bug -c "select {}, (x).* from (select
>> bt_page_items('promocje_pkey',{}) as x ) as y"
>> [...]
>> psql bug -c select 11, (x).* from (select bt_page_items('promocje_pkey',11)
>> as x ) as y
>> ERROR
Greg Stark [2009-08-23 03:40]:
> 2009/8/22 Radoslaw Zielinski :
>> bug=# select length(opis_szczeg) from promocje where id = 4300;
>> ERROR: missing chunk number 0 for toast value 120741 in pg_toast_29644
> Sorry, what datatype is this again? And what encoding?
text, UTF-8 (locale C).
> Perha
