Amazon RDS for PostgreSQL 11 Adapter Limitations

Supported Types
Read Table
Execute Select SQL
Write Table
Execute Update SQL
Major Exceptions

Supported Types

The types supported in this adapter are the following.

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
NUMERIC[(p,s)]	Yes
PATH	Limited
POINT	Limited
POLYGON	Limited
REAL	Yes
SMALLINT	Yes
SERIAL	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

Yes: Supported.
Limited: Supported with limitations.
No: Not supported.

Read Table

Specification Limits

CHARACTER VARYING, CHARACTER, TEXT
- The maximum byte length is 10,485,760.
BYTEA
- Backslash (“\”) and apostrophe (“'”) are not supported.
When the table name is enclosed with quotation marks, it is case-sensitive.

Default value of [Fetch size] is 500.

Execute Select SQL

Specification Limits

CHARACTER VARYING, CHARACTER, TEXT
- The maximum byte length is 10,485,760.
BYTEA
- Backslash (“\”) and apostrophe (“'”) are not supported.
Default value of [Fetch size] is 500.

Write Table

Specification Limits

The following types are not supported.
- CIDR
- CIRCLE
- INTERVAL
- LSEG
- PATH
- POINT
- POLYGON
- BIT VARYING
- BIT VARYING(N)
- ARRAY
- INET
- MACADDR
CHARACTER VARYING, CHARACTER, TEXT
- The maximum byte length is 10,485,760.
BYTEA
- Backslash (“\”) and apostrophe (“'”) are not supported.
When the table name is enclosed with quotation marks, it is case-sensitive.

[Insert before update] of [Update mode] cannot be used.

Execute Update SQL

Specification Limits

The following types are not supported.
- CIDR
- CIRCLE
- INTERVAL
- LSEG
- PATH
- POINT
- POLYGON
- BIT VARYING
- BIT VARYING(N)
- ARRAY
- INET
- MACADDR
CHARACTER VARYING, CHARACTER, TEXT
- The maximum byte length is 10,485,760.
BYTEA
- Backslash (“\”) and apostrophe (“'”) are not supported.

Major Exceptions

Exception name		Cause	Solution
org.postgresql.util.PSQLException	FATAL: database "<database name>" does not exist	The database is not found.	Specify an existing database in [Database name] of global resource.
	FATAL: password authentication failed for user "<user name>"	The user name or the password is incorrect.	Check [User name] and [Password] of the global resource.
	ERROR: syntax error at or near "<table name>"	The table name is invalid.	Check the table name specified in [Table name].
	ERROR: relation "<table name>" does not exist	The table does not 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.	Unable to connect to the database.	Check [Host name] and [Port number] of the global resource.
	SSL error: sun.security.validator.ValidatorException: 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 referred by DataSpiderServer.	Import a certificate to the keystore referred by DataSpiderServer. For more details on how to import a certificate, refer to “Import Certificate”.