Re: [BUGS] Bug in PostrgeSQL 8.0beta

2004-10-07 Thread Tom Lane
"Alexander Zhiltsov" <[EMAIL PROTECTED]> writes: > "Tom Lane" <[EMAIL PROTECTED]> wrote: >> I'm not convinced this is really a bug, because pg_index.indexprs is not >> an expression (it's a list of expressions) and so it's not clear that >> pg_get_expr should be expected to work on it. What result

Re: [BUGS] Bug in PostrgeSQL 8.0beta

2004-10-01 Thread Michael Fuhr
On Fri, Oct 01, 2004 at 02:46:33PM +0600, Alexander Zhiltsov wrote: > Executing the following query return an error 'ERROR: unrecognized node type: 656'. > SELECT pg_get_expr(i.indexprs, i.indrelid) AS expr > FROM pg_index i > INNER JOIN pg_class c ON i.indrelid = c.oid > WHERE c.relname = 'art

Re: [BUGS] Bug in PostrgeSQL 8.0beta

2004-10-01 Thread Tom Lane
"Alexander Zhiltsov" <[EMAIL PROTECTED]> writes: > Executing the following query return an error 'ERROR: unrecognized node ty= > pe: 656'. > SELECT pg_get_expr(i.indexprs, i.indrelid) AS expr > FROM pg_index i > INNER JOIN pg_class c ON i.indrelid =3D c.oid > WHERE c.relname =3D 'art' I'm not c