PostgreSQL 8.2 Adapter Limitations

Sales and inquiry support for PostgreSQL 8.2 adapter has ended.

Supported Types
Read Table Limitations
Execute Select SQL Limitations
Write Table Limitations
Execute Update SQL Limitations
Main exception messages

Supported Types

Supports types for this adapter are as follows.

Type name	Support	Remarks
BIGINT	Yes
BIGSERIAL	No
BIT[(n)]	No
BIT VARYING[(n)]	Limited
BOOLEAN	Yes
BOX	Limited
BYTEA	Yes
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)]-type	No
TIME[(P)] WITH TIME ZONE	No
TIMESTAMP[(P)]	Yes
TIMESTAMP[(P)] WITH TIME ZONE	Yes
ARRAY	Limited

Yes: Support.
Limited: Support with limitations.
No: Not support

Read Table Limitations

CHARACTER VARYING
- The maximum value is 10,485,760.

CHARACTER
- The maximum value is 10,485,760.

TEXT
- The maximum value is 10,485,760.

BYTEA
- Backslash (\) and apostrophes (') is not supported.

If the table name is enclosed by quotation marks, the table names are case-sensitive.

Execute Select SQL Limitations

CHARACTER VARYING
- The maximum value is 10,485,760.

CHARACTER
- The maximum value is 10,485,760.

TEXT
- The maximum value is 10,485,760.

BYTEA
- Backslash (\) and apostrophes (') is not supported.

Write Table Limitations

The following types are not supported.
- BOX
- CIDR
- CIRCLE
- INTERVAL
- LSEG
- PATH
- POINT
- POLYGON
- BIT VARYING
- BIT VARYING (N)
- ARRAY
- INET
- MACADDR

CHARACTER VARYING
- The maximum value is 10,485,760.

CHARACTER
- The maximum value is 10,485,760.

TEXT
- The maximum value is 10,485,760.

BYTEA
- Backslash (\) and apostrophes (') is not supported.

If the table name is enclosed by quotation marks, the table names are case-sensitive.

Does not support batch update.

Execute Update SQL Limitations

The following types are not supported.
- BOX
- CIDR
- CIRCLE
- INTERVAL
- LSEG
- PATH
- POINT
- POLYGON
- BIT VARYING
- BIT VARYING (N)
- ARRAY
- INET
- MACADDR

CHARACTER VARYING
- The maximum value is 10,485,760.

CHARACTER
- The maximum value is 10,485,760.

TEXT
- The maximum value is 10,485,760.

BYTEA
- Backslash (\) and apostrophes (') is not supported.

Does not support batch update.

Main exception messages

Exception Name	Message	Cause / Solution
java.sql.SQLException	Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP / IP connections.	Cannot connect to the database.Please check the host name and port number.
	Backend start-up failed: FATAL: database "<database name>" does not exist.	Make sure the specified database exists.
	Backend start-up failed: FATAL: user "<user name>" does not exist.	Make sure the specified table exists.
	ERROR: syntax error at or near "<table name>"	Please verify that the specified table name is correct.
	ERROR: relation "<table name>" does not exist	Make sure the specified table exists.
	ERROR: permission denied for relation <table name>	Please check the read permissions for the specified table.
java.lang.Exception	The server does not support SSL.	SSL connection is made, but PostgreSQL server side does not support SSL.Please check your PostgreSQL server side configuration.
	The connection attempt failed.	SSL connection is made, but certificate is not imported to DataSpiderServer side.Please import the certificate.
	FATAL: no pg_hba.conf entry for host <host name>, user <username>, database <database name>, SSL off	Standard connection is made, but PostgreSQL server side set to [Destination] support SSL only. Please check the settings for [Destination] or PostgreSQL server side settings.
	FATAL: no pg_hba.conf entry for host <host name>, user <username>, database <database name>, SSL on	SSL connection is made, but PostgreSQL server side set to [Destination] does not support SSL. Please check the settings for [Destination] or PostgreSQL server side settings.