Troubleshooting
Problem
The customer reported that they can create a table with name beginning with underscore as below. $ nzsql -d test -c 'create table _BTS_111 ( A INTEGER );' CREATE TABLE $ nzsql -d test -c '\d' List of relations Schema | Name | Type | Owner --------+----------+-------+------- ADMIN | _BTS_111 | TABLE | ADMIN But they cannot read from the table as below. $ nzsql -d test -c 'select * from _BTS_111;' ERROR: relation does not exist TEST.ADMIN._BTS_111 They also cannot drop it as below. $ nzsql -d test -c 'drop table _BTS_111;' ERROR: relation does not exist TEST.ADMIN._BTS_111 In addition they cannot backup database due to it as below. $ nzbackup -db test -dir /nzscratch/Backup Error: DB SQL 'lock table ADMIN._BTS_111 in access share update mode;' failed - DB error - ERROR: relation does not exist TEST.ADMIN._BTS_111. Database User's Guide mentions below. ---------------------------------------------------------------------- Regular identifiers must begin with a letter; they cannot begin with a digit, underscore, or dollar sign. ----------------------------------------------------------------------
Log InLog in to view more of this document
Was this topic helpful?
Document Information
Modified date:
03 June 2022
UID
swg22004960