postgresql - After RENAME(ing) a Table I'm forced to use quoted identifiers -

after renaming table in postgres i'm experiencing strange behaviour: if reference table without quotes doesn't work.

for example: original name «devices», after i've altered «devices» following select breaks:

select * devices 

but one

select * "devices" 

works expected.

any idea?

per manual, identifiers lower-cased unless quoted.

when renamed did rename "devices", making name mixed-case. must refer in quoted mixed case everywhere.

to postgresql these names devices table:

• devices
• devices
• devices
• devices

but these names separate tables mixed-case names:

• "devices"
• "devices"

this according sql standard except sql requires implementations upper case un-quoted names, postgresql historical reasons lower cases them instead.