Re: aparent bug with pgAdmin version 1.22.1 connected to pg 9.5: SQL Pane view of SEQUENCE object

Tom Puckett wrote:
> A sequence object was created successfully when I created a table with a column of type SEQUENCE. However, in the SQL pane, I see the below code, which has an ALTER TABLE statement for the assignment of ownership. The sequence object can be recreated (manually) only if I edit this statement to become ALTER SEQUENCE, so I'm convinced that this is a defect somewhere.
>
> -- Sequence: public.patient_patient_dbid_seq
>
> -- DROP SEQUENCE public.patient_patient_dbid_seq;
>
> CREATE SEQUENCE public.patient_patient_dbid_seq
> INCREMENT 1
> MINVALUE 1
> MAXVALUE 9223372036854775807
> START 1
> CACHE 1;
> ALTER TABLE public.patient_patient_dbid_seq
> OWNER TO wohcdrowner;

This exact series of commands works fine. Are you sure the command you
had to modify wasn't the OWNED BY one, rather than OWNER TO?

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services