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
______________________________________________________________________
