Request a Demo
Home   >   mailing lists

PostgreSQL 17 default value assignment doesn't work in pgAdmin4 v9.4 - Mailing list pgsql-docs

From LUC PHEMBA
Subject PostgreSQL 17 default value assignment doesn't work in pgAdmin4 v9.4
Date
Msg-id CAHz--SudNXLcphbk-noZRhT1uNSBT-9XBFNFV2s91hMnXO69gw@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL 17 default value assignment doesn't work in pgAdmin4 v9.4
List pgsql-docs
Tree view 
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

but not in this other one :
https://transfert.free.fr/66abCAs
Sincerely.

Envoyé depuis l'application Gmail pour Android

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: logial replication - drop subscription.
Next
From: "David G. Johnston"
Date:
Subject: Re: PostgreSQL 17 default value assignment doesn't work in pgAdmin4 v9.4