From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Kovacs Zoltan <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu> |
Cc: | Philip Warner <pjw(at)rhyme(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Odd results in SELECT |
Date: | 2001-05-10 20:57:11 |
Message-ID: | 24766.989528231@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Kovacs Zoltan <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu> writes:
> On Fri, 11 May 2001, Philip Warner wrote:
>> Can anyone suggest why this might be happening (I think it's in 7.1b4):
>>
>> SELECT definition as viewdef,
>> (select oid from pg_rewrite where
>> rulename='_RETszallitolevel_tetele_ervenyes') as view_oid
>> from pg_views where viewname = 'szallitolevel_tetele_ervenyes';
>>
>> => view_oid is 133652.
>>
>>
>> SELECT definition as viewdef,
>> (select oid from pg_rewrite where
>> rulename='_RET' || 'szallitolevel_tetele_ervenyes') as view_oid
>> from pg_views where viewname = 'szallitolevel_tetele_ervenyes';
>>
>> => view_oid is NULL
> I get the same result in 7.1 final. Tom, isn't this in relation with my
> complex query you solved yesterday?
Not in that form --- there isn't any parameter being passed down to the
subquery. What plan does EXPLAIN show for the failing query?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-05-10 21:19:44 | Re: Regression tests for OBSD scrammed.. |
Previous Message | Jon Lapham | 2001-05-10 20:53:19 | Problem with a rule on upgrade to v7.1.1 |