Re: Sequence name with capital letters issue

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Thibaut BOULDOIRE <thibaut(dot)bouldoire(at)gmail(dot)com>
Cc: "depesz(at)depesz(dot)com" <depesz(at)depesz(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>, "magnus(at)hagander(dot)net" <magnus(at)hagander(dot)net>
Subject: Re: Sequence name with capital letters issue
Date: 2024-04-05 13:58:01
Message-ID: CAKFQuwZ5O9-9Fdw6ww7LH+RCVB6z82hRtotORji2KL-NMYY_Rg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Friday, April 5, 2024, Thibaut BOULDOIRE <thibaut(dot)bouldoire(at)gmail(dot)com>
wrote:

>
> Maybe it's the tool that I'm using ( DBeaver ) that is transforming the
> capital letters into lowercase ?
>

No, as the docs you were pointed to say, it’s the server that folds to
lowercase any identifier that isn’t double-quoted.

David J.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Daniel Verite 2024-04-05 17:34:31 Re: Sequence name with capital letters issue
Previous Message Baehler Thomas SBB CFF FFS 2024-04-05 13:40:45 Detach Partition produces a --> SQL-Fehler [XX000]: ERROR: could not find ON INSERT check triggers of foreign key constraint 76908