On Wed, Mar 3, 2010 at 8:48 AM, Gurjeet Singh singh.gurj...@gmail.com wrote:
On Wed, Mar 3, 2010 at 8:37 AM, Robert Haas robertmh...@gmail.com wrote:
On Wed, Mar 3, 2010 at 7:29 AM, Gurjeet Singh singh.gurj...@gmail.com
wrote:
I just realized that it is the subquery pull-up that is leading
Robert Haas robertmh...@gmail.com writes:
Normally this kind of reordering doesn't actually affect the result of
the query because normally the quals that are being evaluated don't
have any side-effects, but in your query you've chosen something that
can throw an exception, so it's
On Tue, Mar 2, 2010 at 10:24 PM, Gurjeet Singh singh.gurj...@gmail.comwrote:
On Tue, Mar 2, 2010 at 7:51 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Gurjeet Singh singh.gurj...@gmail.com writes:
select relname, pg_relation_size( 'public.' || relname || '' )/1024
from (select distinct relname
On Wed, Mar 3, 2010 at 7:29 AM, Gurjeet Singh singh.gurj...@gmail.com wrote:
I just realized that it is the subquery pull-up that is leading to this
problem, not predicate push-down. Sleeping over it does really help I guess
:)
So instead of the LIMIT 1000, OFFSET 0 clause is the right choice
On Wed, Mar 3, 2010 at 8:37 AM, Robert Haas robertmh...@gmail.com wrote:
On Wed, Mar 3, 2010 at 7:29 AM, Gurjeet Singh singh.gurj...@gmail.com
wrote:
I just realized that it is the subquery pull-up that is leading to this
problem, not predicate push-down. Sleeping over it does really help I
The following bug has been logged online:
Bug reference: 5358
Logged by: Gurjeet Singh
Email address: singh.gurj...@gmail.com
PostgreSQL version: 8.4.2
Operating system: Windows Vista 64bit
Description:Throwing unexpected ERROR
Details:
I am using Postgres Plus
Gurjeet Singh singh.gurj...@gmail.com writes:
select relname, pg_relation_size( 'public.' || relname || '' )/1024
from (select distinct relname
from (select r.relname, c.attname, c.attnotnull, t.typname
from pg_namespace as s, pg_class as r, pg_attribute as c,
pg_type as
On Tue, Mar 2, 2010 at 7:51 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Gurjeet Singh singh.gurj...@gmail.com writes:
select relname, pg_relation_size( 'public.' || relname || '' )/1024
from (select distinct relname
from (select r.relname, c.attname, c.attnotnull, t.typname