Re: " for read only" clause appended for safety when UseDeclareFetch=1

This is a multipart message in MIME format.
--=_alternative 006CE95C85257405_=
Content-Type: text/plain; charset="US-ASCII"

Hiro****,

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@[EMAIL PROTECTED]
    Remove Capital Letters from above for a valid email address
Why:    Standard Disclaimer fits nicely here.
--=_alternative 006CE95C85257405_=
Content-Type: text/html; charset="US-ASCII"


<br><font size=2 face="sans-serif">Hiro****,</font>
<br>
<br><font size=2 face="sans-serif">I get slightly different error
now:</font>
<br>
<br><font size=2 face="sans-serif">Error: 42601 ERROR: syntax error at
or near &quot;a&quot;;</font>
<br>
<br><font size=2 face="sans-serif">Here is the sql statement with the
trailing
semicolon I'm testing with--substitute a valid table name for the word
'my_table' below:</font>
<br>
<br><font size=2 face="sans-serif">SELECT &nbsp;pg_attribute.attname,
pg_attribute.attnotnull,
pg_attribute.atttypmod, pg_type.typname &nbsp; </font>
<br><font size=2 face="sans-serif">FROM &nbsp;pg_attribute &nbsp;</font>
<br><font size=2 face="sans-serif">JOIN &nbsp;pg_class ON
pg_attribute.attrelid
= pg_class.oid &nbsp;</font>
<br><font size=2 face="sans-serif">JOIN &nbsp;pg_namespace ON
pg_namespace.oid
= pg_class.relnamespace &nbsp;</font>
<br><font size=2 face="sans-serif">JOIN &nbsp;pg_type on pg_type.oid =
pg_attribute.atttypid &nbsp;</font>
<br><font size=2 face="sans-serif">where &nbsp;pg_namespace.nspname =
'public'
</font>
<br><font size=2 face="sans-serif">AND &nbsp;pg_class.relname = 'my_table'
and &nbsp;pg_class.relkind = 'r' and &nbsp;pg_attribute.attnum &gt; 0
&nbsp;</font>
<br><font size=2 face="sans-serif">ORDER BY
&nbsp;pg_attribute.attnum;</font>
<br><font size=2 face="sans-serif"><br>
Thanks...jack</font>
<br><font size=2 face="sans-serif">-- </font>
<br><font size=2
face="sans-serif">********************************************</font>
<br><font size=2 face="sans-serif">Who: &nbsp; &nbsp;L Jack Wilson</font>
<br><font size=2 face="sans-serif">Where:
&nbsp;ljwilson@[EMAIL PROTECTED]
>
<br><font size=2 face="sans-serif">How: &nbsp; &nbsp;Remove Capital
Letters
from above for a valid email address</font>
<br><font size=2 face="sans-serif">Why: &nbsp; &nbsp;Standard Disclaimer
fits nicely here.</font>
--=_alternative 006CE95C85257405_=--