See my prior reply to Philip: the problem is that the given string is
longer than NAMEDATALEN. When you write
rulename = 'foo'
(rulename is of type NAME) the untyped literal string 'foo' gets coerced
to NAME, ie truncated to fit, and all is well. When you write
rulename = ('foo'
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
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
r
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';
=> v
