Postgres Pro
Downloads
Home   >   mailing lists

Getting this error - Mailing list pgsql-general

From yatler sahri
Subject Getting this error
Date
Msg-id 1339568605.322.YahooMailNeo@web160204.mail.bf1.yahoo.com
Whole thread Raw
Responses Re: Getting this error
List pgsql-general
Tree view
Hi 

I'm running on a program as to migrate multiple tables to one table

the program seems worked on informix environment but not in postgress

Im getting the following error when running the program on postgress 


| pgs.c:01466(3)  : Nat stmt1 = declare cu4 cursor for 
 | pgs.c:01472(2)  : Could not prepare the statement.
 | pgs.c:01473(2)  : ERROR:  syntax error at end of input
LINE 1: declare cu4 cursor for 
                               ^

 | pgs.c:00321(3)  : Diagnostic info:
 | pgs.c:00322(3)  :   SQL State: 42601
 | pgs.c:00323(3)  :   Message  : syntax error at end of input
 | pgs.c:01801(2)  : Could not execute statement with result set.
 | sqlcode         : -201
 |   sqlstate      : 42601
 |   sqlerrd2      : -1
 |   sql message   : syntax error at end of input
 |   sql msg param : 
 | sql driver      : ident='dbmpgs83x'

Program stopped at 'db_upg77R060.4gl', line number 289.
SQL statement error number -201 (-1).

PREPARE q_cbdbaudit_tables FROM p_query
DECLARE c_cbdbaudit_tables CURSOR FOR q_cbdbaudit_tables

FOREACH c_cbdbaudit_tables INTO p_audittable<---line number 289
IF DOWNSHIFT(p_audittable) NOT MATCHES "cb_db[0-9][0-9][0-9][0-9][a-z][a-z]" THEN
CONTINUE FOREACH
END IF


need your help on this.thanks




pgsql-general by date:

Previous
From: Condor
Date:
Subject: Re: Question about load balance
Next
From: Alban Hertroys
Date:
Subject: Re: Create view is not accepting the parameter in postgres functions