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
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
"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
"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
