On Thu, 10 May 2001, Tom Lane wrote:
> Philip Warner <[EMAIL PROTECTED]> writes:
> > Can anyone suggest why this might be happening (I think it's in 7.1b4):
>
> Can't duplicate in current sources:
>
> regression=# SELECT definition as viewdef,
> regression-# (select oid from pg_rewrite where
> regression(# rulename='_RETstreet') as view_oid
> regression-# from pg_views where viewname = 'street';
> viewdef
> | view_oid
>
>-------------------------------------------------------------------------------------------------+----------
> SELECT r.name, r.thepath, c.cname FROM ONLY road r, real_city c WHERE (c.outline ##
>r.thepath); | 4001276
> (1 row)
>
> regression=# SELECT definition as viewdef,
> regression-# (select oid from pg_rewrite where
> regression(# rulename='_RET' || 'street') as view_oid
> regression-# from pg_views where viewname = 'street';
> viewdef
> | view_oid
>
>-------------------------------------------------------------------------------------------------+----------
> SELECT r.name, r.thepath, c.cname FROM ONLY road r, real_city c WHERE (c.outline ##
>r.thepath); | 4001276
> (1 row)
>
> What does EXPLAIN show for your two queries? (Maybe you'd better make
> it EXPLAIN VERBOSE.)
I attached both.
Kov\'acs, Zolt\'an
[EMAIL PROTECTED]
http://www.math.u-szeged.hu/~kovzol
ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz
exp-bad.out
exp-good.out
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
