Messages and limitations of the Amazon Aurora for PostgreSQL connector
For operations, refer to Amazon Aurora for PostgreSQL (the top page for operations).
Message code list of AMAZONAURORAPOSTGRESQL category
The following message codes correspond to errors that occur in Amazon Aurora for PostgreSQL Connector.
This message code is output when an undefined error occurs.
|
Cause |
Solution |
|---|---|
|
An undefined error occurred. |
Check the error message or the help of the operation in which the error has occurred. |
Corresponding error
-
None
This message code corresponds to errors that occur during database processing.
|
Cause |
Solution |
|---|---|
|
The cause differs according to each error message. |
Check the error message and perform the following:
|
Corresponding error
-
java.sql.SQLException
-
org.postgresql.util.PSQLException
Exception messages of AMAZONAURORAPOSTGRESQL category
|
Exception name |
Cause |
Solution |
|
|---|---|---|---|
|
org.postgresql.util.PSQLException |
FATAL: database "<database name>" does not exist. |
The database doesn't exist. |
Specify an existing database in Database name of the connection resource. |
|
FATAL: password authentication failed for user "<user name>" |
The user name, the password, or the SSL connection is incorrect. |
Check User name and Password of the connection resource. |
|
|
ERROR: syntax error at or near "<invalid character string included in table name>" |
The table name is invalid. |
Check the table name specified in Table name. |
|
|
ERROR: relation "<table name>" does not exist |
The table doesn't exist. |
Specify an existing table in Table name. |
|
|
ERROR: permission denied for table <table name> |
The user has no permission to read the table. |
Check the read permission for the table specified in Table name. |
|
|
Connection test failed. |
Can't connect to the database. |
Check Host name and Port number of the connection resource. |
|
|
SSL error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target |
The certificate is not imported to the keystore referenced by HULFT Square. |
Import the certificate to the keystore referenced by HULFT Square. |
|
Limitations of AMAZONAURORAPOSTGRESQL category
This connector supports the following types.
|
Type name |
Support |
Remarks |
|---|---|---|
|
BIGINT |
Yes | |
| BIGSERIAL | No | |
| BIT[(n)] | No | |
| BIT VARYING[(n)] | Limited | |
| BOOLEAN | Yes | |
| BOX | No | |
| BYTEA | Limited | |
| MONEY | No | |
| CHARACTER[(n)] | Limited | |
| CHARACTER VARYING[(n)] | Limited | |
| CIDR | Limited | |
| CIRCLE | Limited | |
| DATE | Yes | |
| DOUBLE PRECISION | Yes | |
| INET | Limited | |
| INTEGER | Yes | |
| INTERVAL[(p)] | Limited | |
| LINE | No | |
| LSEG | Limited | |
| MACADDR | Limited | |
| MACADDR8 | No | |
| NUMERIC[(p,s)] | Yes | |
| PATH | Limited | |
| POINT | Limited | |
| POLYGON | Limited | |
| REAL | Yes | |
| SMALLINT | Yes | |
| SERIAL | No | |
| SMALLSERIAL | No | |
| TEXT | Limited | |
| TIME[(p)] | No | |
| TIME[(p)] WITH TIME ZONE | No | |
| TIMESTAMP[(p)] | Yes | |
| TIMESTAMP[(p)] WITH TIME ZONE | Yes | |
| ARRAY | Limited | |
| UUID | No | |
| ENUM | No | |
| XML | No | |
| JSON | No | |
| JSONB | No | |
| RANGE | No | |
| TSQUERY | No | |
| TSVECTOR | No | |
| PG_LSN | No | |
| PG_SNAPSHOT | No |
-
Yes: Supported.
-
Limited: Supported with limitations.
-
No: Not supported.
Specification limits
-
BYTEA
-
Backslashes (\) and apostrophes (') aren't supported.
-
-
When the table name is enclosed with quotation marks, it's case-sensitive.
-
The default value for Fetch size is 500.
Specification limits
-
BYTEA
-
Backslashes (\) and apostrophes (') aren't supported.
-
-
The default value for Fetch size is 500.
Specification limits
-
The following types aren't supported.
-
CIDR
-
CIRCLE
-
INTERVAL
-
LSEG
-
PATH
-
POINT
-
POLYGON
-
BIT VARYING
-
BIT VARYING(n)
-
ARRAY
-
INET
-
MACADDR
-
-
BYTEA
-
Backslashes (\) and apostrophes (') aren't supported.
-
-
When the table name is enclosed with quotation marks, it's case-sensitive.
-
Insert before update of Update mode can't be used.
Specification limits
-
The following types aren't supported.
-
CIDR
-
CIRCLE
-
INTERVAL
-
LSEG
-
PATH
-
POINT
-
POLYGON
-
BIT VARYING
-
BIT VARYING(n)
-
ARRAY
-
INET
-
MACADDR
-
-
BYTEA
-
Backslashes (\) and apostrophes (') aren't supported.
-