From: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de> |
---|---|
To: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de>, Joe Conway <mail(at)joeconway(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | RE: removing "serial" from table definitions. |
Date: | 2021-06-24 14:03:54 |
Message-ID: | ab8f18cfd94a48568f0bb3d50a6d61e5@intershop.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>serial is not an actual data type -- it is essentially an integer with a default and an automatically created sequence. See:
>>
>>https://www.postgresql.org/docs/13/datatype-numeric.html#DATATYPE-SERIA
>>L
>
>Yes, I undersand that serial is just a hint at table creation time, but is there a place in catalog where we can see if the table was created using 'serial' ?
>if yes, I'm looking for a way to remove that.
>
>Another cause for my problem may be in the way how the default value information is stored in pg_attrdef.
>The difference we see between the source and target database is that a schema prefix is displayed with the sequence on one side, and not on the other..
>I'm not sure yet if this really come directly from the catalog or from the way how the client read the table definition, maybe along with some search_path differences Were there any change in this area between PG 9.6 and PG 11 ?
>
>example:
>
>The Default value of column 'id' in table 'db_jobs_history' in database 'oms_db' is different on source and target servers.
>It's 'nextval('admin.db_jobs_history_id_seq'::regclass)' on source and 'nextval('db_jobs_history_id_seq'::regclass)' on target.
I've probably found the origin of our problem:
https://www.postgresql.org/docs/9.3/release-8-1.html
=> Add proper dependencies for arguments of sequence functions (Tom)
But I won't be able to check that in the next few days..
best regards,
marc Mamin
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2021-06-24 14:13:54 | Re: insert ..... returning <column> problem |
Previous Message | Дмитрий Иванов | 2021-06-24 13:55:44 | Re: OSX: migrating Postgres db from one Mac to another |