Skip site navigation (1) Skip section navigation (2)

Re: Bug in PostrgeSQL 8.0beta

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Alexander Zhiltsov" <ayz(at)ems(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug in PostrgeSQL 8.0beta
Date: 2004-10-01 15:20:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
"Alexander Zhiltsov" <ayz(at)ems(dot)ru> 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 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 were you
expecting to get?

			regards, tom lane

In response to


pgsql-bugs by date

Next:From: Michael FuhrDate: 2004-10-01 15:23:12
Subject: Re: Bug in PostrgeSQL 8.0beta
Previous:From: Tom LaneDate: 2004-10-01 15:06:39
Subject: Re: Disk space is consumed by UPDATE query

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group