Functions and Features

GS_209030003

errmsg:Sequence %s retry %d times to connect GTM on DataNode %s.

errhint: Need reduce the num of concurrent Sequence request.

level:ERROR

GS_209100010

errmsg:The definition of the function is null.

errhint: Check whether the definition of the function is complete in the pg_proc system table.

level:ERROR

GS_209100039

errmsg:case not found.

errhint: CASE statement is missing ELSE part.

level:ERROR

GS_209100052

errmsg:query has no destination for result data.

errhint: If you want to discard the results of a SELECT

level:ERROR

GS_209100088

errmsg:missing argument.

errhint: Use NONE to denote the missing argument of a unary operator.

level:ERROR

GS_209100089

errmsg:too many arguments.

errhint: Provide two argument types for operator.

level:ERROR

GS_209100112

errmsg:invalid OWNED BY option.

errhint: Specify OWNED BY table.column or OWNED BY NONE.

level:ERROR

GS_209100157

errmsg:Sort method %s is not supported.

errdetail: Not support the given sort method.

errhint: Please check and revise your nlssort parameter.

level:ERROR

GS_209110032

errmsg:trigger functions cannot have declared arguments.

errhint: The arguments of the trigger can be accessed through TG_NARGS and TG_ARGV instead.

level:ERROR

GS_209110106:

errmsg:could not determine which collation to use for regular expression.

errhint: Use the COLLATE clause to set the collation explicitly.

level:ERROR

GS_209110108

errmsg:could not determine which collation to use for ILIKE.

errhint: Use the COLLATE clause to set the collation explicitly.

level:ERROR

GS_209110110

errmsg:invalid escape string.

errhint: Escape string must be empty or one character.

level:ERROR

GS_209110178

errmsg:invalid multibyte character for locale.

errhint: The server's LC_CTYPE locale is probably incompatible with the database encoding.

level:ERROR

GS_209110184

errmsg:"query_band" is invalid or the length of query_band exceeds the maximum(%d) limit.

errhint:alid format is key=value.

level:ERROR

GS_209120040

errmsg:unrecognized reset target: %s.

errhint: Target must be \bgwriter\.

level:ERROR

GS_209120067

errmsg:boundary values mismatch partitioning columns.

errhint: number of boundary value items should be equal to the number of partitioning columns.

level:ERROR

GS_209120068

errmsg:partitioned table has too many partition keys.

errhint: start/end syntax requires a partitioned table with only one partition key.

level:ERROR

GS_209120069

errmsg:number of start value items in partition %s is more than one.

errhint: must be single start value for start/end partition defination.

level:ERROR

GS_209130018

errmsg:Unrecognized function type code: %d.

errhint: This node type is expected to be a function or trigger.

level:ERROR

GS_209130070

errmsg:RETURN cannot have a parameter in function returning set.

errhint: Use RETURN NEXT or RETURN QUERY.

level:ERROR

GS_209130087

errmsg:column %s is not an advised partitioning column since its datatype [%s].

errhint: floating-point number cannot be accurately represented.

level:WARNING

GS_209130088

errmsg:datatype of column %s is unsupported for partition key in start/end clause.

errhint: 'valid datatypes are: smallint'.

level:ERROR

GS_209140002

errmsg:could not set up XML error handler.

errhint: This probably indicates that the version of libxml2 being used is not compatible with the libxml2 header files that PostgreSQL was built with.

level:ERROR

GS_209140015

errmsg:can't %s partition since index %s is unusable.

errhint: reindex the unusable index first.

level:ERROR

GS_209140017

errmsg:Range partitioned table with INTERVAL is unsupported.

errhint: Only support pure range partitioned table.

level:ERROR

GS_209140037

errmsg:[WDRReport] Snapshot id is invalid.

errhint: begin snapshot id must be smaller than end snapshot id.

level:ERROR

GS_209140053

errmsg:It is not supported to use function 'GS_UPDATE_BLOCKLIST_HASH_INFO' in distributed query.

errhint: Please use simple query without joining with distributed table.

level:ERROR

GS_209140062

errmsg:EXECUTE of SELECT ... INTO is not implemented.

errhint: You might want to use EXECUTE ... INTO or EXECUTE CREATE TABLE ... AS instead.

level:ERROR

GS_209180019

errmsg:no pg_constraint entry for trigger %s on table %s.

errhint: Remove this referential integrity trigger and its mates.

level:ERROR

GS_209200144

errmsg:Trigger function with non-plpgsql type is not recommended.

errdetail: Non-plpgsql trigger function are not shippable by default.

errhint: Unshippable trigger may lead to bad performance.

level:WARNING

GS_209200219

errmsg:Failed to drop the user.

errhint: Failed to cancel backend process for privilege.

level:ERROR

GS_209240007

errmsg:cannot begin/end transactions in PL/pgSQL.

errhint: Use a BEGIN block with an EXCEPTION clause instead.

level:ERROR

GS_209240028

errmsg:referential integrity query on %s from constraint %s on %s gave unexpected result.

errhint: This is most likely due to a rule having rewritten the query.

level:ERROR

GS_209240060

errmsg:cannot begin/end transactions in PL/pgSQL.

errhint: Use a BEGIN block with an EXCEPTION clause instead.

level:ERROR

GS_209240063

errmsg:cannot begin/end transactions in PL/pgSQL.

errhint: Use a BEGIN block with an EXCEPTION clause instead.

level:ERROR

GS_209240064

errmsg:SPI_execute failed executing query %s: %s.

errhint: You might want to use EXECUTE ... INTO or EXECUTE CREATE TABLE ... AS instead.

level:ERROR