If you are unable to start RHDB Administrator, run the following command:
rhdb-admin -l filename |
This logs error messages to filename so that you can determine the problem.
If you start RHDB Administrator with DISPLAY set to an invalid address (such as toronto:0.0), this error is generated:
_X11TransSocketINETConnect: Can't get address for toronto
Application initialization failed: couldn't connect to
display "toronto:0.0"
Error in startup script: can't find package Tk
while executing
"package require Tk"
(file "./rhdb-admin.tcl" line 29) |
To overcome this problem, ensure that your DISPLAY environment variable is set to a valid screen.
RHDB Administrator is designed to run only as a single copy. The first copy creates a lock file that prevents other copies from saving configuration data. All other functions behave normally.
Suppose that you try to create a table aaa with a column "COL1" of type integer and add a check to determine if COL1 > 0. The SQL generated is:
CREATE TABLE "aaa" ("COL1" integer CHECK (COL1 > 0)) |
The backend will return the error:
Attribute 'col1' not found |
What has happened is that PostgreSQL has converted the unquoted name COL1 in the CHECK to lower case. (This behavior is incompatible with the SQL standard, which says that unquoted names should be folded to upper case.) To overcome this problem, either use lowercase names or ensure that you apply double-quotes to all names that contain uppercase letters.