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

2025-05-31 Thread LUC PHEMBA
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* (whe

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

2025-05-31 Thread David G. Johnston
On Sat, May 31, 2025 at 1:23 PM LUC PHEMBA wrote: > 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

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

2025-05-31 Thread David G. Johnston
On Sat, May 31, 2025 at 2:14 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > It's quite annoying that you didn't just copy the relevant SQL commands > and error messages into the email. Having to go through file share and > deal with images is quite annoying. > Although I suppose see