From: Arnau <arnaulist@andromeiberica.com>
To: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: [OT] Very strange postgresql behaviour
Date: Mon, 29 Jan 2007 16:40:57 +0100
Message-ID: <45BE1589.9030804@andromeiberica.com> (raw)
In-Reply-To: <20070129082706.0ef2df3b.wmoran@collaborativefusion.com>
References: <45BDE6E4.9050805@andromeiberica.com>
<20070129082706.0ef2df3b.wmoran@collaborativefusion.com>
Hi Bill,
> In response to Arnau <arnaulist@andromeiberica.com>:
>> I have postgresql 7.4.2 running on debian and I have the oddest
>> postgresql behaviour I've ever seen.
>>
>> I do the following queries:
>>
>>
>> espsm_asme=# select customer_app_config_id, customer_app_config_name
>> from customer_app_config where customer_app_config_id = 5929 or
>> customer_app_config_id = 11527 order by customer_app_config_id;
>>
>>
>> customer_app_config_id | customer_app_config_name
>> ------------------------+--------------------------
>> 5929 | INFO
>> (1 row)
>>
>>
>> I do the same query but changing the order of the or conditions:
>>
>>
>> espsm_asme=# select customer_app_config_id, customer_app_config_name
>> from customer_app_config where customer_app_config_id = 11527 or
>> customer_app_config_id = 5929 order by customer_app_config_id;
>>
>>
>> customer_app_config_id | customer_app_config_name
>> ------------------------+--------------------------
>> 11527 | MOVIDOSERENA TONI 5523
>> (1 row)
>>
>>
>>
>> As you can see, the configuration 5929 and 11527 both exists, but
>> when I do the queries they don't appear.
>
> [snip]
>
> Just a guess, but perhaps your index is damaged. Have you tried
> REINDEXing?
>
Yes, I have tried with:
reindex table customer_app_config
reindex index pk_cag_customer_application_id
but nothing changed. I also tried to drop the index:
espsm_asme=# begin; drop index pk_cag_customer_application_id;
BEGIN
ERROR: cannot drop index pk_cag_customer_application_id because
constraint pk_cag_customer_application_id on table customer_app_config
requires it
HINT: You may drop constraint pk_cag_customer_application_id on table
customer_app_config instead.
espsm_asme=# rollback;
ROLLBACK
But I can't remove the constraint as it's the primary key and there
are foreign keys over it
--
Arnau
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: arnaulist@andromeiberica.com
Subject: Re: [OT] Very strange postgresql behaviour
In-Reply-To: <45BE1589.9030804@andromeiberica.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox