aparent bug with pgAdmin version 1.22.1 connected to pg 9.5: SQL Pane view of SEQUENCE object - Mailing list pgsql-bugs

From Tom Puckett
Subject aparent bug with pgAdmin version 1.22.1 connected to pg 9.5: SQL Pane view of SEQUENCE object
Date
Msg-id DA171538123EEF49B3DF312271D474C2311A522C@WEST-MBX03.milliman.com
Whole thread Raw
Responses Re: aparent bug with pgAdmin version 1.22.1 connected to pg 9.5: SQL Pane view of SEQUENCE object  (Bruce Momjian <bruce@momjian.us>)
Re: aparent bug with pgAdmin version 1.22.1 connected to pg 9.5: SQL Pane view of SEQUENCE object  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-bugs
A sequence object was created successfully when I created a table with a co=
lumn of type SEQUENCE.  However, in the SQL pane, I see the below code, whi=
ch has an ALTER TABLE statement for the assignment of ownership.  The seque=
nce object can be recreated (manually) only if I edit this statement to bec=
ome 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 communication is intended solely for the addressee and is confidential=
. If you
are not the intended recipient, any disclosure, copying, distribution or an=
y action taken
or omitted to be taken in reliance on it, is prohibited and may be unlawful=
. Unless
indicated to the contrary: it does not constitute professional advice or op=
inions upon
which reliance may be made by the addressee or any other party, and it shou=
ld be
considered to be a work in progress.
******************************************************************

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #13440: unaccent does not remove all diacritics
Next
From: miha.vrhovnik@cordia.si
Date:
Subject: BUG #13963: pg_clusterupgrade and materialized view