Filter:
Submit Search

Messages and limitations of the PostgreSQL connector

Message code list of PostgreSQL category

The following message codes correspond to errors that occur in PostgreSQL Connector.

 

POSTGRESQL0000E

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

 

POSTGRESQL0001E

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:

  • Check whether the cause/solution of the error is described in "Exception messages" below.

  • Check whether the cause/solution of the error is described in Limitations of the applied connector.

  • Check whether you can find information related to the error in documents of the connected database.

Corresponding error

  • java.sql.SQLException

  • org.postgresql.util.PSQLException

 

Exception messages of PostgreSQL category

 

Exception name

Cause

Solution

InputDataNotFoundException

Input data isn't specified.

Specify Input data or draw data flow.

InvalidPropertyConfigurationException

SQL statement isn't set.

Specify SQL statement.

InvalidPropertyConfigurationException

Target column is not selected.

Target for Schema definition isn't selected in the Write Table operation.

Select one or more Target for Schema definition.

InvalidPropertyConfigurationException

Target column is not selected.

Target for Schema definition isn't selected in the Read Table operation.

Select one or more Target for Schema definition.

InvalidPropertyConfigurationException

Table name isn't set.

Specify Table name.

ResourceNotFoundException

Destination isn't specified.

Specify Destination.

java.sql.SQLException

A database access error or some other one has occurred.

Check the SQLException message. SQLException message is based on the specifications of the driver. The cause of the error might be output in SQLException message.

ResourceNotFoundException

Resource definition could not be found. Name: []

Destination isn't specified.

Specify Destination.

ResourceNotFoundException

Resource definition could not be found. Name: [<connection resource name>]

The resource definition selected in Destination isn't found.

Check the connection resource specified in Destination.

java.sql.SQLException

Batch entry 0 insert into "<table name>" ("<column names>") values ( <column values>) was aborted: <error message> Call getNextException to see other errors in the batch.

The table name is invalid or the table doesn't exist.

Check the table name specified in Table name.

org.postgresql.util.PSQLException

Connection to "<host name>:<port number>" refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

Can't connect to the database.

Check Port number of the connection resource.

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 or the password is incorrect.

Check User name and Password of the connection 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 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.

The server does not support SSL.

The PostgreSQL server doesn't support SSL connection.

Check the PostgreSQL server settings.

The connection attempt failed.

Can't connect to the database server.

Check Host name of the connection resource.

FATAL: no pg_hba.conf entry for host "<host name>", user "<user name>", database "<database name>", SSL off

Client certificate for standard (non-SSL) connection to PostgreSQL server isn't found.

Check the settings for the connection resource specified in Destination, or the settings for PostgreSQL server.

FATAL: no pg_hba.conf entry for host "<host name>", user "<user name>", database "<database name>", SSL on

Client certificate for SSL connection to PostgreSQL server is not found.

Check the settings for the connection resource specified in Destination, or the settings for PostgreSQL server.

 

Limitations of PostgreSQL category

 

Supported types

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

 

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

    • 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.

 

Execute Select SQL

Specification limits

  • CHARACTER VARYING, CHARACTER, TEXT

    • The maximum byte length is 10,485,760.

  • BYTEA

    • Backslashes (\) and apostrophes (') aren't supported.

  • The default value for Fetch size is 500.

 

Write Table

Specification limits

  • The following types aren't 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

    • 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.

 

Execute Update SQL

Specification limits

  • The following types aren't 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

    • Backslashes (\) and apostrophes (') aren't supported.

Select SQL Wizard

Specification Limits

  • Tables which include "." in the schema name or the table name on the database can't be used.

  • Test execution may be failed if the data amount is huge.

  • The maximum record count shown in the Execution result tab is 100.

  • SQL statements can be re-edited only if the tables in the SQL statement exist.

Update SQL Wizard

Specification Limits

  • When the connection resource is XAResource, testing can't be executed.

  • Tables which include "." in the schema name or the table name on the database can't be used.

  • SQL statements can be re-edited only if the tables in the SQL statement exist.

  • In connection resources for JDBC connector, when Execute transaction processing is not selected, rollback is not performed in test execution, and the data is updated.

 

Policies     (c) Saison Technology Co.,Ltd. 2021

TOP