From: | Thibaut BOULDOIRE <thibaut(dot)bouldoire(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Sequence name with capital letters issue |
Date: | 2024-04-05 09:35:45 |
Message-ID: | CAJG-3PT3Hn6pq7hGpWLSpkK8bKCvv3gG4OmpkDJfD1+S6HA_JA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hello,
I'm using a PostgreSQL database.
PostgreSQL 10.17 on x86_64-redhat-linux-gnu
I have some sequences called like that :
app_user_SEQ
app_address_SEQ
...
The issue is that when I call the next value of the sequence, I receive an
error.
When I try :
SELECT nextval("app_user_SEQ");
I have the following error :
SQL Error [42703]: ERROR: column "app_user_SEQ' does not exist
I don't understand why ? So I try to rename my sequences by writing them in
lowercase.
So now my sequences are like that :
app_user_seq
app_address_seq
...
And now the SELECT nextval("app_user_seq"); is working.
I also tried to add again a sequence with a part in capital letters and I
kept the lowercase one in the DB. Now I have these 4 sequences :
app_user_SEQ
app_address_SEQ
app_user_seq
app_address_seq
But now, something interesting happened.
When I call this query : SELECT nextval("app_user_SEQ"); , it's the
app_user_seq sequence that is incremented and not the app_user_SEQ.
I didn't find in the documentation something that mentioned this issue
regarding sequence names with capital letters.
Is it a bug ? or is it something that I didn't find in the documentation ?
Thank you in advance
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2024-04-05 10:00:01 | BUG #18422: Assert in expandTupleDesc() fails on row mismatch with additional SRF |
Previous Message | Wolfgang Walther | 2024-04-04 19:09:30 | Re: Building with musl in CI and the build farm |