Request a Demo
Home   >   mailing lists

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

From David G. Johnston
Subject Re: PostgreSQL 17 default value assignment doesn't work in pgAdmin4 v9.4
Date
Msg-id CAKFQuwbvK1ad4Gz5pYVUFttJDqF9uzsYX6NAc3TeyfJyeMd=OA@mail.gmail.com
Whole thread Raw
In response to PostgreSQL 17 default value assignment doesn't work in pgAdmin4 v9.4  (LUC PHEMBA <luc.phemba@gmail.com>)
Responses Re: PostgreSQL 17 default value assignment doesn't work in pgAdmin4 v9.4
List pgsql-docs
Tree view
On Sat, May 31, 2025 at 1:23 PM LUC PHEMBA <luc.phemba@gmail.com> 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
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.

The "format" of the command has nothing to do with it - you would have gotten a straight syntax error if you didn't have a valid format.
 
The system seems to believe that 'SYSINIT' is a column name - so the curly-quotes you are using are messing things up.  Using normal single quotes to represent text literals.

David J.

pgsql-docs by date:

Previous
From: LUC PHEMBA
Date:
Subject: PostgreSQL 17 default value assignment doesn't work in pgAdmin4 v9.4
Next
From: "David G. Johnston"
Date:
Subject: Re: PostgreSQL 17 default value assignment doesn't work in pgAdmin4 v9.4