<div class="Section1"><p class="MsoNormal">Hi,<p class="MsoNormal"> <p class="MsoNormal">Not quite sure if this is the
rightplace to file a bug report or not. Please let me know if it’s not.<p class="MsoNormal"> <p
class="MsoNormal"><b>Bug1:</b><p class="MsoNormal"> <p class="MsoNormal"><b>Description:</b><p class="MsoNormal">When
rightclicking a sequence and asking for a Report -> dependencies report, PgAdmin sends an invalid query to the
database.<p class="MsoNormal"> <p class="MsoNormal"><b>Details:</b><p class="MsoNormal"><span
style="font-family:"CourierNew"">2009-11-17 11:24:31.030 GMT ERROR: syntax error at or near "att" at character
97</span><pclass="MsoNormal"><span style="font-family:"Courier New"">2009-11-17 11:24:31.030 GMT STATEMENT: SELECT
</span><pclass="MsoNormal"><span style="font-family:"Courier New""> CASE WHEN att.attname IS NOT NULL AND
ref.relnameIS NOT NULL THEN ref.relname || '.' att.attname</span><p class="MsoNormal"><span style="font-family:"Courier
New""> ELSE ref.relname </span><p class="MsoNormal"><span style="font-family:"Courier New""> END AS
refname,</span><p class="MsoNormal"><span style="font-family:"Courier New""> d2.refclassid, d1.deptype AS
deptype</span><pclass="MsoNormal"><span style="font-family:"Courier New""> FROM pg_depend d1</span><p
class="MsoNormal"><spanstyle="font-family:"Courier New""> LEFT JOIN pg_depend d2 ON d1.objid=d2.objid AND
d1.refobjid!= d2.refobjid</span><p class="MsoNormal"><span style="font-family:"Courier New""> LEFT JOIN pg_class
refON ref.oid = d2.refobjid</span><p class="MsoNormal"><span style="font-family:"Courier New""> LEFT JOIN
pg_attributeatt ON d2.refobjid=att.attrelid AND d2.refobjsubid=att.attnum</span><p class="MsoNormal"><span
style="font-family:"CourierNew""> WHERE d1.classid=(SELECT oid FROM pg_class WHERE relname='pg_attrdef')</span><p
class="MsoNormal"><spanstyle="font-family:"Courier New""> AND d2.refobjid NOT IN (SELECT d3.refobjid FROM
pg_dependd3 WHERE d3.objid=d1.refobjid)</span><p class="MsoNormal"><span style="font-family:"Courier New""> AND
d1.refobjid=27062::oid</span><pclass="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal"><b>Notes:</b><p
class="MsoNormal">Noticethis missing || after ‘.’<p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal"><b>Bug2:</b><p class="MsoNormal"> <p class="MsoNormal"><b>Description:</b><p class="MsoNormal">When
addingthe schedule for a pgAgent job in PgAdmin III after clicking [OK] PgAdmin closes with no messages.<p
class="MsoNormal"> <pclass="MsoNormal"><b>Details:</b><p class="MsoNormal">Right click Jobs and click [new Job]<p
class="MsoNormal">Entera job named “test”<p class="MsoNormal">Click on [Schedules] tab, click [Add] enter the schedule
name“test” and set the start date to today.<p class="MsoNormal">Click [OK], then [OK] again.<p class="MsoNormal"> <p
class="MsoNormal">Observecrash<p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal">DavidRowley<p class="MsoNormal">System Analyst and Developer<p class="MsoNormal">McLelland Cheese
Packing<pclass="MsoNormal">Commerce Road<p class="MsoNormal">Stranraer<p class="MsoNormal">DG9 7DD<p
class="MsoNormal"> <pclass="MsoNormal">Tel: 01776 706790<p class="MsoNormal"> </div><br />
______________________________________________________<br/> The contents of this e-mail and any attachments are
confidentialto the intended recipient. If you are not the intended recipient of this e-mail, please notify the sender,
deleteit and do not read, act upon, print, disclose, copy, retain or redistribute it. <br />
______________________________________________________<br/> Lactalis McLelland Limited, registered in Scotland,
registerednumber 14583, registered office New Cheese Market, Townhead, Glasgow, G4 0EF, VAT No. 894862658.<br />
______________________________________________________<br/> This email has been scanned by the MessageLabs Email
SecuritySystem.<br /> For more information please visit http://www.messagelabs.com/email <br />
______________________________________________________________________<br/>
