PostgreSQL 17 default value assignment doesn't work in pgAdmin4 v9.4

From: LUC PHEMBA <luc(dot)phemba(at)gmail(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: PostgreSQL 17 default value assignment doesn't work in pgAdmin4 v9.4
Date: 2025-05-31 19:58:33
Message-ID: CAHz--SudNXLcphbk-noZRhT1uNSBT-9XBFNFV2s91hMnXO69gw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hi,

According to the official PosgreSQL 17 documentation
(https://www.postgresql.org/docs/current/ddl-default.html) default
values are listed after the column data type following this format :

*column_name column_data_type DEFAULT default_value*

For example :

*price numeric DEFAULT 9.99* (where *price* is the column_name,
*numeric *the column_data_type, and *9.99* the default_value)

Can then someone explain me why the same format works in this case
:*https://transfert.free.fr/P6wOY5x
<https://transfert.free.fr/P6wOY5x>*

but not in this other one :

*https://transfert.free.fr/66abCAs <https://transfert.free.fr/66abCAs>*

Sincerely.

Envoyé depuis l'application Gmail pour Android

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2025-05-31 21:14:03 Re: PostgreSQL 17 default value assignment doesn't work in pgAdmin4 v9.4
Previous Message PG Doc comments form 2025-05-28 20:20:51 logial replication - drop subscription.