Thread: Getting this error
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
On 06/13/2012 02:23 PM, yatler sahri wrote:
HiI'm running on a program
Source code?
PostgreSQL version you're using?
Database driver (libpq, PgJDBC, psqlODBC, etc) you're using, and its version?
Im getting the following error when running the program on postgress
Error log from PostgreSQL server logs?
Try enabling log_statement='all' in postgresql.conf .
--
Craig Ringer