pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #16381: create table in pgAdmin4 but unable to use it in SQL
2+ messages / 2 participants
[nested] [flat]
* BUG #16381: create table in pgAdmin4 but unable to use it in SQL
@ 2020-04-20 00:55 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2020-04-20 00:55 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: wangzehao1007@qq.com
The following bug has been logged on the website:
Bug reference: 16381
Logged by: Wang Zehao
Email address: wangzehao1007@qq.com
PostgreSQL version: 12.0
Operating system: win10
Description:
When I was using pdAdmin4(Web UI) to create a table named 'Example' (with
capital E), it executed successfully and I can saw the table on the sidebar.
But when I opened the query tool on this table and tried to run ```insert
into Example with value(a, b, c)```,it raises an error telling 'the table
can't be found'. Then I changed the name of that table to 'example'(with
lowercase e) (I changed it by right-clicking this table on sidebar and
rename) and ran the exactly same SQL sentence, it executed perfectly.
Maybe there should be a warning or a prevention when anyone try to create a
table using GUI with capital letters in the name of it. Or maybe it's just a
wrong operation by myself?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #16381: create table in pgAdmin4 but unable to use it in SQL
@ 2020-04-20 05:32 David G. Johnston <david.g.johnston@gmail.com>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2020-04-20 05:32 UTC (permalink / raw)
To: wangzehao1007@qq.com <wangzehao1007@qq.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
On Sunday, April 19, 2020, PG Bug reporting form <noreply@postgresql.org>
wrote:
> The following bug has been logged on the website:
>
> Bug reference: 16381
> Logged by: Wang Zehao
> Email address: wangzehao1007@qq.com
> PostgreSQL version: 12.0
> Operating system: win10
> Description:
>
> When I was using pdAdmin4(Web UI) to create a table named 'Example' (with
> capital E), it executed successfully and I can saw the table on the
> sidebar.
> But when I opened the query tool on this table and tried to run ```insert
> into Example with value(a, b, c)```,it raises an error telling 'the table
> can't be found'. Then I changed the name of that table to 'example'(with
> lowercase e) (I changed it by right-clicking this table on sidebar and
> rename) and ran the exactly same SQL sentence, it executed perfectly.
> Maybe there should be a warning or a prevention when anyone try to create a
> table using GUI with capital letters in the name of it. Or maybe it's just
> a
> wrong operation by myself?
>
PgAdmin has its own list/support channels where problems and suggestions
can be sent. This list is for reporting bugs (which this is not) on the
PostgreSQL server and the projects official related programs.
That said everything is working as it should. Warnings like what you
suggest become annoying once you’ve learned how things work, for which the
documentation is the place to reference. In this case the syntax of
identifiers.
David J.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-04-20 05:32 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-04-20 00:55 BUG #16381: create table in pgAdmin4 but unable to use it in SQL PG Bug reporting form <noreply@postgresql.org>
2020-04-20 05:32 ` David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox