On Tue, Feb 16, 2016 at 03:13:59PM +0000, 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.
The alter_table manual page says:
OWNER This form changes the owner of the table, sequence, view,
^^^^^^^^
materialized view, or foreign table to the specified user.
so it does work. You are right that ALTER SEQUENCE would be clearer,
though.
---------------------------------------------------------------------------
>
>
>
> -- 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 any
> 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
> opinions upon
> which reliance may be made by the addressee or any other party, and it should
> be
> considered to be a work in progress.
> ******************************************************************
>
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription +