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

Re: Re: " for read only" clause appended for safety when UseDeclareFetch=1 breaks some sql statements with trailing semicolons

From: alepaes - aldeia digital <alepaes(at)aldeiadigital(dot)com(dot)br>
To:
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Re: " for read only" clause appended for safety when UseDeclareFetch=1 breaks some sql statements with trailing semicolons
Date: 2008-06-10 14:45:59
Message-ID: 484E93A7.7000708@aldeiadigital.com.br (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi,

Postgresql 8.2.3 have the same problem:

<192.168.1.10>ERROR:  syntax error at or near "read" at character 487
<192.168.1.10>STATEMENT:  declare "SQL_CUR01B5BDE8" cursor for  SELECT 
ct12emp04, ct12numlot, ct12numlan, ct12dtlanc, ct12docume, ct12empcc1, 
ct12empcc2,   ct12empcc3, ct12emptr1, ct12emptr2, ct12emptr3, ct12dtdig, 
ct12tradu1, ct12ccust1,   ct12tradu2, ct12ccust2, ct12tradu3, 
ct12ccust3, ct12valor, ct12histo1, ct12histo2,   ct12histo3, ct12histo4, 
ct12histo5, ct12histo6, ct12renume, ct12origem  FROM CT12T   WHERE 
ct12emp04 = '500' AND ct12numlot = '20080532' AND ct12numlan = '52' 
FOR UPDATE OF CT12T  for read only;fetch 100 in "SQL_CUR01B5BDE8"

The check box in page 2 is turned off.

Thanks,


Alexandre


Jack Wilson wrote:
> 
> Hiroshi,
> 
> I get slightly different error now:
> 
> Error: 42601 ERROR: syntax error at or near "a";
> 
> Here is the sql statement with the trailing semicolon I'm testing 
> with--substitute a valid table name for the word 'my_table' below:
> 
> SELECT  pg_attribute.attname, pg_attribute.attnotnull, 
> pg_attribute.atttypmod, pg_type.typname  
> FROM  pg_attribute  
> JOIN  pg_class ON pg_attribute.attrelid = pg_class.oid  
> JOIN  pg_namespace ON pg_namespace.oid = pg_class.relnamespace  
> JOIN  pg_type on pg_type.oid = pg_attribute.atttypid  
> where  pg_namespace.nspname = 'public'
> AND  pg_class.relname = 'my_table' and  pg_class.relkind = 'r' and 
>  pg_attribute.attnum > 0  
> ORDER BY  pg_attribute.attnum;
> 
> Thanks...jack
> -- 
> ********************************************
> Who:    L Jack Wilson
> Where:  ljwilson(at)dNiOgSiPtAaMlav(dot)com
> How:    Remove Capital Letters from above for a valid email address
> Why:    Standard Disclaimer fits nicely here.

In response to

Responses

pgsql-odbc by date

Next:From: alepaes - aldeia digitalDate: 2008-06-10 17:32:01
Subject: Re: Re: " for read only" clause appended for safety when UseDeclareFetch=1 breaks some sql statements with trailing semicolons
Previous:From: Richard BroersmaDate: 2008-06-10 14:24:13
Subject: Strange ODBC error & statement in Server log

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