Re: [BUGS] BUG #3882: unexpected PARAM_SUBLINK ID

2008-01-17 Thread Tom Lane
"Jan Mate" <[EMAIL PROTECTED]> writes: > Description:unexpected PARAM_SUBLINK ID If convenient, please try the 8.2 patch seen here: http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/subselect.c regards, tom lane --

Re: [BUGS] BUG #3882: unexpected PARAM_SUBLINK ID

2008-01-17 Thread Tom Lane
"Jan Mate" <[EMAIL PROTECTED]> writes: > I get the following error: > ERROR: unexpected PARAM_SUBLINK ID: 3 This is an interesting test case. The problem is coming from the part of the rule that has (new.number, new.limited, new."level") IN (SELECT ...) The parser transforms this to a

[BUGS] BUG #3882: unexpected PARAM_SUBLINK ID

2008-01-17 Thread Jan Mate
The following bug has been logged online: Bug reference: 3882 Logged by: Jan Mate Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.6 Operating system: Linux and Mac OS X Description:unexpected PARAM_SUBLINK ID Details: I am trying to create a row versioning