Обсуждение: [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