Re: Converting to identity columns with domains on PK columns

On 7/5/19 4:38 AM, PegoraroF10 wrote:
> Well, I think it´ll not as easy as you said. That tables has dependencies.
> So, if I try to alter type it gives me ERROR: cannot alter type of a column
> used in a trigger definition. I dropped all Triggers of that table and it
> gives me ERROR: cannot alter type of a column used by a view or rule.
> Then, if I need to drop everything to change that thing I think is better
> just have an empty structure and copy entire database data to it.
>
> And why do we used domains, because we were Firebird and on that database a
> integer or a domain based on an integer is the same, so we converted to
> Postgres using that way.

That is not what the Firebird docs say:

https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-datatypes-custom.html

https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-domn.html

https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-ddl-enhance.html

>
> Thanks
>
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com