| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | LUC PHEMBA <luc(dot)phemba(at)gmail(dot)com> |
| Cc: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: PostgreSQL 17 default value assignment doesn't work in pgAdmin4 v9.4 |
| Date: | 2025-05-31 21:14:03 |
| Message-ID: | CAKFQuwbvK1ad4Gz5pYVUFttJDqF9uzsYX6NAc3TeyfJyeMd=OA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On Sat, May 31, 2025 at 1:23 PM LUC PHEMBA <luc(dot)phemba(at)gmail(dot)com> wrote:
> 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>*
>
> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2025-05-31 21:22:07 | Re: PostgreSQL 17 default value assignment doesn't work in pgAdmin4 v9.4 |
| Previous Message | LUC PHEMBA | 2025-05-31 19:58:33 | PostgreSQL 17 default value assignment doesn't work in pgAdmin4 v9.4 |