Opened 3 years ago
Closed 3 years ago
#5011 closed defect (invalid)
raster2pgsql lowers schema and table names
Reported by: | frafra | Owned by: | robe |
---|---|---|---|
Priority: | medium | Milestone: | PostGIS 3.1.5 |
Component: | raster | Version: | 3.1.x |
Keywords: | Cc: |
Description
When I load into a schema called "MySchema" (which I previosly created, raster2pgsql transform that into "myschema", which does not exist, so psql cannot find it.
The same problem happens for table names.
Change History (3)
comment:1 by , 3 years ago
comment:2 by , 3 years ago
Component: | postgis → raster |
---|---|
Owner: | changed from | to
comment:3 by , 3 years ago
Resolution: | → invalid |
---|---|
Status: | new → closed |
frafra,
This looks to be intentional behavior.
Have you tried with the -q switch. that should give you the behavior you are looking for. As noted in that bit of code you highlighted, the lowercasing is only done if quote identify is false.
-q Wrap PostgreSQL identifiers in quotes.
I'm going to mark this as invalid. If using -q doesn't work, feel free to reopen.
Note:
See TracTickets
for help on using tickets.
Relevant code: https://github.com/postgis/postgis/blob/f6def67654c25d812446239036cee44812613748/raster/loader/raster2pgsql.c#L2824-L2842