Bug Report: PgAdmin III v1.10.0

Hi,

Not quite sure if this is the right place to file a bug report or not.
Please let me know if it's not.

Bug 1:

Description:

When right clicking a sequence and asking for a Report -> dependencies
report, PgAdmin sends an invalid query to the database.

Details:

2009-11-17 11:24:31.030 GMT ERROR: syntax error at or near "att" at
character 97

2009-11-17 11:24:31.030 GMT STATEMENT: SELECT

CASE WHEN att.attname IS NOT NULL AND ref.relname IS NOT NULL
THEN ref.relname || '.' att.attname

ELSE ref.relname

END AS refname,

d2.refclassid, d1.deptype AS deptype

FROM pg_depend d1

LEFT JOIN pg_depend d2 ON d1.objid=d2.objid AND d1.refobjid !=
d2.refobjid

LEFT JOIN pg_class ref ON ref.oid = d2.refobjid

LEFT JOIN pg_attribute att ON d2.refobjid=att.attrelid AND
d2.refobjsubid=att.attnum

WHERE d1.classid=(SELECT oid FROM pg_class WHERE
relname='pg_attrdef')

AND d2.refobjid NOT IN (SELECT d3.refobjid FROM pg_depend d3
WHERE d3.objid=d1.refobjid)

AND d1.refobjid=27062::oid

Notes:

Notice this missing || after '.'

Bug 2:

Description:

When adding the schedule for a pgAgent job in PgAdmin III after clicking
[OK] PgAdmin closes with no messages.

Details:

Right click Jobs and click [new Job]

Enter a job named "test"

Click on [Schedules] tab, click [Add] enter the schedule name "test"
and set the start date to today.

Click [OK], then [OK] again.

Observe crash

David Rowley

System Analyst and Developer

McLelland Cheese Packing

Commerce Road

Stranraer

DG9 7DD

Tel: 01776 706790

______________________________________________________
The contents of this e-mail and any attachments are confidential to the intended recipient. If you are not the intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it.
______________________________________________________
Lactalis McLelland Limited, registered in Scotland, registered number 14583, registered office New Cheese Market, Townhead, Glasgow, G4 0EF, VAT No. 894862658.
______________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________