Thread: 1.12.0. bug

<div class="WordSection1"><p class="MsoNormal">In the server status screen.   If in the LOCKS section,  I click on the
usercolumn header I get this error.<p class="MsoNormal">All of the other columns seem to be working correctly.<p
class="MsoNormal">Ido not  have superuser credentials.<p class="MsoNormal"> <p class="MsoNormal"><img height="172"
id="_x0000_i1026"src="cid:image001.png@01CB5EDF.3A1F2A30" width="441" /><p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal">Thanksfor a major upgrade.   You guys have put a lot into it.  Just a bit more.<p
class="MsoNormal"> <pclass="MsoNormal">Thanks<p class="MsoNormal"> <p class="MsoNormal"><b><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">DougLittle</span></b><p class="MsoNormal"><b><span
style="font-size:12.0pt"> </span></b><pclass="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">Sr.Data Warehouse Architect | Enterprise Data Management |
OrbitzWorldwide </span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">500 W.
Madison,Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741</span><span
style="font-size:12.0pt;
font-family:"Times New Roman","serif""></span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif""><ahref="mailto:Douglas.Little@orbitz.com"
title="mailto:dlittle@orbitz.com"><b><spanstyle="color:blue">Douglas.Little@orbitz.com</span></b></a></span><b><u><span
style="font-size:13.5pt;font-family:"TimesNew Roman","serif";color:blue"></span></u></b><p class="MsoNormal"> <img
alt="cid:image001.jpg@01CABEC8.D4980670"border="0" height="61" id="Picture_x0020_1"
src="cid:image002.jpg@01CB5EDF.3A1F2A30"width="83" />  <a href="http://www.orbitz.com/"
title="http://www.orbitz.com/"><spanstyle="font-size:8.0pt;font-family:"Arial","sans-serif"; 
color:blue">orbitz.com</span></a> <span style="color:blue">|</span> <a href="http://www.ebookers.com/"
title="http://www.ebookers.com/"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">ebookers.com</span></a><span
style="color:blue">|</span><a href="http://www.hotelclub.com/" title="http://www.hotelclub.com/"><span
style="font-size:8.0pt;font-family:
"Arial","sans-serif";color:blue">hotelclub.com</span></a> <span style="color:blue">|</span> <a
href="http://www.cheaptickets.com/"title="http://www.cheaptickets.com/"><span style="font-size:8.0pt;font-family: 
"Arial","sans-serif";color:blue">cheaptickets.com</span></a> <span style="color:blue">|</span> <a
href="http://www.ratestogo.com/"title="http://www.ratestogo.com/"><span style="font-size:8.0pt;font-family: 
"Arial","sans-serif";color:blue">ratestogo.com</span></a><span style="color:blue"> |</span> <a
href="http://www.asiahotels.com/"title="http://www.asiahotels.com/"><span style="font-size:8.0pt;font-family: 
"Arial","sans-serif";color:blue">asiahotels.com</span></a><p class="MsoNormal"> </div>

Hi



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company

[Please keep the lis CC'd]

Oh, Greenplum. I don't have a copy here, but if you can grab the query pgAdmin is trying to run from the logfile (you might need to switch on Query Logging under File->Options->Logging), and figure out what will work on GPDB, I can special-case that in the code for the 1.12.1 build (due to be tagged on Thursday).


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company

Le 28/09/2010 16:54, Dave Page a écrit :
> [Please keep the lis CC'd]
> 
> On Tue, Sep 28, 2010 at 2:47 PM, Little, Douglas
> <DOUGLAS.LITTLE@orbitz.com>wrote:
> 
>>  Sorry,  to lazy to retype the version info and not sure if it was beta or
>> not.
>>
>>
>>
>> PGadmin env.  Win xp sp3.
>>
>> Server:  Greenplum 3.6.6.6 (pg 8.2.13)
>>
>> Version string    PostgreSQL 8.2.13 (Greenplum Database 3.3.6.6 build 2) on
>> x86_64-pc-solaris2.10, compiled by GCC gcc.exe (GCC) 4.1.1 compiled on Jul
>> 16 2010 18:38:06
>>
>>
>>
> 
> Oh, Greenplum. I don't have a copy here, but if you can grab the query
> pgAdmin is trying to run from the logfile (you might need to switch on Query
> Logging under File->Options->Logging), and figure out what will work on
> GPDB, I can special-case that in the code for the 1.12.1 build (due to be
> tagged on Thursday).
> 

In fact, it's reproducile quite easily;


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com

Le 29/09/2010 00:28, Guillaume Lelarge a écrit :
> Le 28/09/2010 16:54, Dave Page a écrit :
>> [Please keep the lis CC'd]
>>
>> On Tue, Sep 28, 2010 at 2:47 PM, Little, Douglas
>> <DOUGLAS.LITTLE@orbitz.com>wrote:
>>
>>>  Sorry,  to lazy to retype the version info and not sure if it was beta or
>>> not.
>>>
>>>
>>>
>>> PGadmin env.  Win xp sp3.
>>>
>>> Server:  Greenplum 3.6.6.6 (pg 8.2.13)
>>>
>>> Version string    PostgreSQL 8.2.13 (Greenplum Database 3.3.6.6 build 2) on
>>> x86_64-pc-solaris2.10, compiled by GCC gcc.exe (GCC) 4.1.1 compiled on Jul
>>> 16 2010 18:38:06
>>>
>>>
>>>
>>
>> Oh, Greenplum. I don't have a copy here, but if you can grab the query
>> pgAdmin is trying to run from the logfile (you might need to switch on Query
>> Logging under File->Options->Logging), and figure out what will work on
>> GPDB, I can special-case that in the code for the 1.12.1 build (due to be
>> tagged on Thursday).
>>
> 
> In fact, it's reproducile quite easily;
> 

And now my complete message. I reproduce it on 8.2, with the locks and
prepared transactions reports. I fixed both. And I fix the "SET
log_statement" query too.

Thanks for the report.


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com