Обсуждение: 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
______________________________________________________________________
Le mardi 17 novembre 2009 à 12:40:33, ROWLEY David, Stranraer a écrit : > [...] > Not quite sure if this is the right place to file a bug report or not. > Please let me know if it's not. > This is a good place to report bugs :) > 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 > > [...] This is fixed since 2009-07-29. See http://code.pgadmin.org/trac/ticket/21 for more details. > 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 > This is fixed since 2009-07-19. See http://code.pgadmin.org/trac/ticket/16 for more details. What we really need here is a 1.10.1 release... (hint to Dave :) ). -- Guillaume.http://www.postgresqlfr.orghttp://dalibo.com