"Corin" writes:
> CREATE INDEX fanobjects_amazon_product_id_index
> ON fanobjects
> USING btree
> (amazon_product_id)
> WHERE NOT amazon_product_id IS NULL;
Try it like
WHERE amazon_product_id IS NOT NULL;
> I'd consider this a bug as "NOT x IS NULL" is the same as "x IS NOT NULL".
The following bug has been logged online:
Bug reference: 5702
Logged by: Corin
Email address: i...@netskin.com
PostgreSQL version: 9.0
Operating system: linux 64 bit
Description:pg fails to use a conditional index even the where
clause matches the condition
Details:
On 10/09/2010 05:36 PM, Didier URBAN wrote:
The following bug has been logged online:
Bug reference: 5701
Logged by: Didier URBAN
Email address: ur...@issendis.com
PostgreSQL version: 9.0.1
Operating system: Windows 7
Description:CREATE TABLE ERROR
Details:
Hello,
The following bug has been logged online:
Bug reference: 5701
Logged by: Didier URBAN
Email address: ur...@issendis.com
PostgreSQL version: 9.0.1
Operating system: Windows 7
Description:CREATE TABLE ERROR
Details:
Hello,
If we set client_encryption to 'Latin9', CRE
On fre, 2010-10-08 at 16:13 -0700, Bryson Holland wrote:
> what other information do you need from me to make this useful?
Platform, version, command line
> configure: WARNING: uuid.h: present but cannot be compiled
> configure: WARNING: uuid.h: check for missing prerequisite headers?
> confi
