Re: [GENERAL] Variable not found

2016-01-22 Thread Adrian Klaver
On 01/21/2016 10:48 PM, Sachin Srivastava wrote: Dear Adrian, So, how the effective way to search this because I have around 1300 tables. See Gilles response. From that I gather global variables are not automatically transferred and it is up to you to decide where to put them. Per your origi

Re: Fwd: Re: [GENERAL] Variable not found

2016-01-22 Thread Gilles Darold
Hi, > > On 01/20/2016 07:35 PM, Sachin Srivastava wrote: > > Dear Folks, > > I have a question about global variables in Oracle pl/sql package. > Where > are these variables when package is converted to schema from Oracle to > Postgres through Ora2PG Tool? > Ora2Pg doesn't exp

Re: [GENERAL] Variable not found

2016-01-21 Thread Sachin Srivastava
Dear Adrian, So, how the effective way to search this because I have around 1300 tables. Regards, SS On Thu, Jan 21, 2016 at 8:48 PM, Adrian Klaver wrote: > On 01/20/2016 07:35 PM, Sachin Srivastava wrote: > >> Dear Folks, >> >> I have a question about global variables in Oracle pl/sql package

Re: [GENERAL] Variable not found

2016-01-21 Thread Adrian Klaver
On 01/20/2016 07:35 PM, Sachin Srivastava wrote: Dear Folks, I have a question about global variables in Oracle pl/sql package. Where are these variables when package is converted to schema from Oracle to Postgres through Ora2PG Tool? For example, package Best guess it is stored in a table i

[GENERAL] Variable not found

2016-01-20 Thread Sachin Srivastava
Dear Folks, I have a question about global variables in Oracle pl/sql package. Where are these variables when package is converted to schema from Oracle to Postgres through Ora2PG Tool? For example, package

Re: [GENERAL] variable not found in subplan target list

2011-11-02 Thread Tom Lane
Roger Niederland writes: > I stripped enough out of the database that it is only good for a test > case. Here is a public url for getting at the database backup: I've committed a fix for this: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e4e60e7b6125e77f679861ebf43cc6b9f9db

[GENERAL] variable not found in subplan target list

2011-11-02 Thread Roger Niederland
Hello, I stripped down the original query to what is below. I am not saying that the query below is useful except to show an error I am getting in Postgresql 9.1.1 on both SL6.1 (64 bit) and Windows 2008 server 9.1.1 (32-bit and 64-bit). The error I am getting is: ERROR: variable not found

Re: [GENERAL] variable not found in subplan target list

2011-11-01 Thread Roger Niederland
On 11/1/2011 8:30 PM, Tom Lane wrote: Roger Niederland writes: I extracted the tables from the database which generates the error above I eliminated most of the columns such that this query still exhibits this behavior to reduce the file size. I have a zipped file from windows postgresql 9.1

Re: [GENERAL] variable not found in subplan target list

2011-11-01 Thread Tom Lane
Roger Niederland writes: > I extracted the tables from the database which generates the error above > I eliminated most of the columns such that this query still exhibits > this behavior to reduce > the file size. I have a zipped file from windows postgresql 9.1.1 > (32-bit) which is about 1.5

Re: [GENERAL] variable not found in subplan target list

2011-11-01 Thread Roger Niederland
On 11/1/2011 3:54 PM, Roger Niederland wrote: Hello, I stripped down the original query to what is below. I am not saying that the query below is useful except to show an error I am getting in Postgresql 9.1.1 on both SL6.1 (64 bit) and Windows 2008 server 9.1.1 (32-bit and 64-bit). The e

Re: [GENERAL] variable not found in subplan target list

2011-11-01 Thread Tom Lane
Roger Niederland writes: > I stripped down the original query to what is below. I am not saying > that the query below > is useful except to show an error I am getting in Postgresql 9.1.1 on > both SL6.1 (64 bit) and > Windows 2008 server 9.1.1 (32-bit and 64-bit). The error I am getting is:

[GENERAL] variable not found in subplan target list

2011-11-01 Thread Roger Niederland
Hello, I stripped down the original query to what is below. I am not saying that the query below is useful except to show an error I am getting in Postgresql 9.1.1 on both SL6.1 (64 bit) and Windows 2008 server 9.1.1 (32-bit and 64-bit). The error I am getting is: ERROR: variable not found