Re: [BUGS] BUG #4562: ts_headline() adds space when parsing url

2008-12-08 Thread Tom Lane
"Denis Monsieur" <[EMAIL PROTECTED]> writes: > The problem is a space being added to text in the form of > http://some.url/path > Compare the output: > shs=# SELECT ts_headline('http://some.url', to_tsquery('sometext')); >ts_headline > - > http://some.url > (1 row) > shs=# SE

Re: [BUGS] BUG #4565: nextval not updated during wal replication, leading to pk violations

2008-12-08 Thread Tom Lane
"Marc Schablewski" <[EMAIL PROTECTED]> writes: > A job tried to insert some records into a few tables and complained about a > PK violation. PK are of type bigint. The column is populated by a sequence > and a "default nextval()" on the PK column. We found that the sequence's > currval was lower th

Re: [BUGS] BUG #4565: nextval not updated during wal replication, leading to pk violations

2008-12-08 Thread Marc Schablewski
FYI: We found another anomaly in that database (duplicated record with a unique index on a column (non PK)) and so we did some more research. As before, the record got replicated, but this time, the index entry was not. Later, a job tried to check if that record was already there by querying the co

[BUGS] BUG #4568: sporadic error doing COUNT(*) on empty table

2008-12-08 Thread Sameer Mahajan
The following bug has been logged online: Bug reference: 4568 Logged by: Sameer Mahajan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4-1.3 Operating system: Suse Linux Description:sporadic error doing COUNT(*) on empty table Details: While performing COU