Обсуждение: [pgAdmin III] #338: ALTER statements for sequences act like tables
#338: ALTER statements for sequences act like tables ----------------------+----------------------------------------------------- Reporter: thom | Owner: dpage Type: bug | Status: new Priority: minor | Milestone: Component: pgadmin | Version: trunk Keywords: sequence | Platform: ----------------------+----------------------------------------------------- If editing an existing sequence via its properties, attempts to change its name or owner results in ALTER TABLE statements instead of ALTER SEQUENCE. Creating a sequence and setting the owner results in the same invalid SQL. Also the SQL pane for sequences also shows this behaviour for setting the owner. This was tested on 1.14.0 RC1. -- Ticket URL: <http://code.pgadmin.org/trac/ticket/338> pgAdmin III <http://code.pgadmin.org/trac/> pgAdmin III
#338: ALTER statements for sequences act like tables ----------------------+----------------------------------------------------- Reporter: thom | Owner: dpage Type: feature | Status: new Priority: minor | Milestone: Component: pgadmin | Version: trunk Keywords: sequence | Platform: ----------------------+----------------------------------------------------- Changes (by thom): * type: bug => feature Comment: Okay, I should have checked this a little more carefully. ALTER TABLE statements are valid for SEQUENCES, so treat this as a request to change it to ALTER SEQUENCE for renaming, and preferably for setting the owner from 8.4. -- Ticket URL: <http://code.pgadmin.org/trac/ticket/338#comment:1> pgAdmin III <http://code.pgadmin.org/trac/> pgAdmin III
#338: ALTER statements for sequences act like tables ----------------------+----------------------------------------------------- Reporter: thom | Owner: dpage Type: feature | Status: closed Priority: minor | Milestone: Component: pgadmin | Version: trunk Resolution: fixed | Keywords: sequence Platform: | ----------------------+----------------------------------------------------- Changes (by thom): * status: new => closed * resolution: => fixed Comment: And now I realise I have already submitted a patch to fix this... and it was already committed on master. I guess I shouldn't rely on the pgAdmin bug tracker to find all fixed bugs. :) -- Ticket URL: <http://code.pgadmin.org/trac/ticket/338#comment:2> pgAdmin III <http://code.pgadmin.org/trac/> pgAdmin III
#338: ALTER statements for sequences act like tables ----------------------+----------------------------------------------------- Reporter: thom | Owner: dpage Type: feature | Status: closed Priority: minor | Milestone: Component: pgadmin | Version: trunk Resolution: fixed | Keywords: sequence Platform: | ----------------------+----------------------------------------------------- Comment(by gleu): That's right, you shouldn't :) -- Ticket URL: <http://code.pgadmin.org/trac/ticket/338#comment:3> pgAdmin III <http://code.pgadmin.org/trac/> pgAdmin III