information_schema.columns

We are sorry, but an error occurred while generating this page. You should contact the site's administrator.

In "dwui/table/information_schema.columns.sql": Failed to set variable records_count: In "dwui/table/information_schema.columns.sql": The following error occurred while executing an SQL statement:
error returned from database: ODBC emitted an error calling 'SQLExecDirect':
State: 42704, Native error: 1, Message: ERROR: type "sql_identifier" does not exist;
Error while executing the query

The SQL statement sent by SQLPage was:
SELECT COUNT(*) FROM information_schema.columns WHERE (CAST(? AS TEXT) IS NULL OR (((CAST(? AS TEXT)::JSONB) ->> 'table_catalog' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'table_catalog')::sql_identifier = table_catalog) AND ((CAST(? AS TEXT)::JSONB) ->> 'table_schema' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'table_schema')::sql_identifier = table_schema) AND ((CAST(? AS TEXT)::JSONB) ->> 'table_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'table_name')::sql_identifier = table_name) AND ((CAST(? AS TEXT)::JSONB) ->> 'column_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'column_name')::sql_identifier = column_name) AND ((CAST(? AS TEXT)::JSONB) ->> 'ordinal_position' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'ordinal_position')::cardinal_number = ordinal_position) AND ((CAST(? AS TEXT)::JSONB) ->> 'column_default' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'column_default')::character_data = column_default) AND ((CAST(? AS TEXT)::JSONB) ->> 'is_nullable' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'is_nullable')::yes_or_no = is_nullable) AND ((CAST(? AS TEXT)::JSONB) ->> 'data_type' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'data_type')::character_data = data_type) AND ((CAST(? AS TEXT)::JSONB) ->> 'character_maximum_length' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'character_maximum_length')::cardinal_number = character_maximum_length) AND ((CAST(? AS TEXT)::JSONB) ->> 'character_octet_length' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'character_octet_length')::cardinal_number = character_octet_length) AND ((CAST(? AS TEXT)::JSONB) ->> 'numeric_precision' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'numeric_precision')::cardinal_number = numeric_precision) AND ((CAST(? AS TEXT)::JSONB) ->> 'numeric_precision_radix' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'numeric_precision_radix')::cardinal_number = numeric_precision_radix) AND ((CAST(? AS TEXT)::JSONB) ->> 'numeric_scale' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'numeric_scale')::cardinal_number = numeric_scale) AND ((CAST(? AS TEXT)::JSONB) ->> 'datetime_precision' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'datetime_precision')::cardinal_number = datetime_precision) AND ((CAST(? AS TEXT)::JSONB) ->> 'interval_type' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'interval_type')::character_data = interval_type) AND ((CAST(? AS TEXT)::JSONB) ->> 'interval_precision' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'interval_precision')::cardinal_number = interval_precision) AND ((CAST(? AS TEXT)::JSONB) ->> 'character_set_catalog' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'character_set_catalog')::sql_identifier = character_set_catalog) AND ((CAST(? AS TEXT)::JSONB) ->> 'character_set_schema' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'character_set_schema')::sql_identifier = character_set_schema) AND ((CAST(? AS TEXT)::JSONB) ->> 'character_set_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'character_set_name')::sql_identifier = character_set_name) AND ((CAST(? AS TEXT)::JSONB) ->> 'collation_catalog' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'collation_catalog')::sql_identifier = collation_catalog) AND ((CAST(? AS TEXT)::JSONB) ->> 'collation_schema' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'collation_schema')::sql_identifier = collation_schema) AND ((CAST(? AS TEXT)::JSONB) ->> 'collation_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'collation_name')::sql_identifier = collation_name) AND ((CAST(? AS TEXT)::JSONB) ->> 'domain_catalog' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'domain_catalog')::sql_identifier = domain_catalog) AND ((CAST(? AS TEXT)::JSONB) ->> 'domain_schema' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'domain_schema')::sql_identifier = domain_schema) AND ((CAST(? AS TEXT)::JSONB) ->> 'domain_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'domain_name')::sql_identifier = domain_name) AND ((CAST(? AS TEXT)::JSONB) ->> 'udt_catalog' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'udt_catalog')::sql_identifier = udt_catalog) AND ((CAST(? AS TEXT)::JSONB) ->> 'udt_schema' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'udt_schema')::sql_identifier = udt_schema) AND ((CAST(? AS TEXT)::JSONB) ->> 'udt_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'udt_name')::sql_identifier = udt_name) AND ((CAST(? AS TEXT)::JSONB) ->> 'scope_catalog' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'scope_catalog')::sql_identifier = scope_catalog) AND ((CAST(? AS TEXT)::JSONB) ->> 'scope_schema' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'scope_schema')::sql_identifier = scope_schema) AND ((CAST(? AS TEXT)::JSONB) ->> 'scope_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'scope_name')::sql_identifier = scope_name) AND ((CAST(? AS TEXT)::JSONB) ->> 'maximum_cardinality' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'maximum_cardinality')::cardinal_number = maximum_cardinality) AND ((CAST(? AS TEXT)::JSONB) ->> 'dtd_identifier' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'dtd_identifier')::sql_identifier = dtd_identifier) AND ((CAST(? AS TEXT)::JSONB) ->> 'is_self_referencing' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'is_self_referencing')::yes_or_no = is_self_referencing) AND ((CAST(? AS TEXT)::JSONB) ->> 'is_identity' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'is_identity')::yes_or_no = is_identity) AND ((CAST(? AS TEXT)::JSONB) ->> 'identity_generation' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'identity_generation')::character_data = identity_generation) AND ((CAST(? AS TEXT)::JSONB) ->> 'identity_start' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'identity_start')::character_data = identity_start) AND ((CAST(? AS TEXT)::JSONB) ->> 'identity_increment' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'identity_increment')::character_data = identity_increment) AND ((CAST(? AS TEXT)::JSONB) ->> 'identity_maximum' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'identity_maximum')::character_data = identity_maximum) AND ((CAST(? AS TEXT)::JSONB) ->> 'identity_minimum' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'identity_minimum')::character_data = identity_minimum) AND ((CAST(? AS TEXT)::JSONB) ->> 'identity_cycle' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'identity_cycle')::yes_or_no = identity_cycle) AND ((CAST(? AS TEXT)::JSONB) ->> 'is_generated' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'is_generated')::character_data = is_generated) AND ((CAST(? AS TEXT)::JSONB) ->> 'generation_expression' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'generation_expression')::character_data = generation_expression) AND ((CAST(? AS TEXT)::JSONB) ->> 'is_updatable' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'is_updatable')::yes_or_no = is_updatable)))
dwui/table/information_schema.columns.sql: line 48
dwui/table/information_schema.columns.sql: line 48

Failed to set variable records_count

In "dwui/table/information_schema.columns.sql": The following error occurred while executing an SQL statement:
error returned from database: ODBC emitted an error calling 'SQLExecDirect':
State: 42704, Native error: 1, Message: ERROR: type "sql_identifier" does not exist;
Error while executing the query

The SQL statement sent by SQLPage was:
SELECT COUNT(*) FROM information_schema.columns WHERE (CAST(? AS TEXT) IS NULL OR (((CAST(? AS TEXT)::JSONB) ->> 'table_catalog' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'table_catalog')::sql_identifier = table_catalog) AND ((CAST(? AS TEXT)::JSONB) ->> 'table_schema' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'table_schema')::sql_identifier = table_schema) AND ((CAST(? AS TEXT)::JSONB) ->> 'table_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'table_name')::sql_identifier = table_name) AND ((CAST(? AS TEXT)::JSONB) ->> 'column_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'column_name')::sql_identifier = column_name) AND ((CAST(? AS TEXT)::JSONB) ->> 'ordinal_position' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'ordinal_position')::cardinal_number = ordinal_position) AND ((CAST(? AS TEXT)::JSONB) ->> 'column_default' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'column_default')::character_data = column_default) AND ((CAST(? AS TEXT)::JSONB) ->> 'is_nullable' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'is_nullable')::yes_or_no = is_nullable) AND ((CAST(? AS TEXT)::JSONB) ->> 'data_type' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'data_type')::character_data = data_type) AND ((CAST(? AS TEXT)::JSONB) ->> 'character_maximum_length' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'character_maximum_length')::cardinal_number = character_maximum_length) AND ((CAST(? AS TEXT)::JSONB) ->> 'character_octet_length' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'character_octet_length')::cardinal_number = character_octet_length) AND ((CAST(? AS TEXT)::JSONB) ->> 'numeric_precision' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'numeric_precision')::cardinal_number = numeric_precision) AND ((CAST(? AS TEXT)::JSONB) ->> 'numeric_precision_radix' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'numeric_precision_radix')::cardinal_number = numeric_precision_radix) AND ((CAST(? AS TEXT)::JSONB) ->> 'numeric_scale' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'numeric_scale')::cardinal_number = numeric_scale) AND ((CAST(? AS TEXT)::JSONB) ->> 'datetime_precision' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'datetime_precision')::cardinal_number = datetime_precision) AND ((CAST(? AS TEXT)::JSONB) ->> 'interval_type' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'interval_type')::character_data = interval_type) AND ((CAST(? AS TEXT)::JSONB) ->> 'interval_precision' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'interval_precision')::cardinal_number = interval_precision) AND ((CAST(? AS TEXT)::JSONB) ->> 'character_set_catalog' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'character_set_catalog')::sql_identifier = character_set_catalog) AND ((CAST(? AS TEXT)::JSONB) ->> 'character_set_schema' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'character_set_schema')::sql_identifier = character_set_schema) AND ((CAST(? AS TEXT)::JSONB) ->> 'character_set_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'character_set_name')::sql_identifier = character_set_name) AND ((CAST(? AS TEXT)::JSONB) ->> 'collation_catalog' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'collation_catalog')::sql_identifier = collation_catalog) AND ((CAST(? AS TEXT)::JSONB) ->> 'collation_schema' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'collation_schema')::sql_identifier = collation_schema) AND ((CAST(? AS TEXT)::JSONB) ->> 'collation_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'collation_name')::sql_identifier = collation_name) AND ((CAST(? AS TEXT)::JSONB) ->> 'domain_catalog' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'domain_catalog')::sql_identifier = domain_catalog) AND ((CAST(? AS TEXT)::JSONB) ->> 'domain_schema' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'domain_schema')::sql_identifier = domain_schema) AND ((CAST(? AS TEXT)::JSONB) ->> 'domain_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'domain_name')::sql_identifier = domain_name) AND ((CAST(? AS TEXT)::JSONB) ->> 'udt_catalog' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'udt_catalog')::sql_identifier = udt_catalog) AND ((CAST(? AS TEXT)::JSONB) ->> 'udt_schema' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'udt_schema')::sql_identifier = udt_schema) AND ((CAST(? AS TEXT)::JSONB) ->> 'udt_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'udt_name')::sql_identifier = udt_name) AND ((CAST(? AS TEXT)::JSONB) ->> 'scope_catalog' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'scope_catalog')::sql_identifier = scope_catalog) AND ((CAST(? AS TEXT)::JSONB) ->> 'scope_schema' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'scope_schema')::sql_identifier = scope_schema) AND ((CAST(? AS TEXT)::JSONB) ->> 'scope_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'scope_name')::sql_identifier = scope_name) AND ((CAST(? AS TEXT)::JSONB) ->> 'maximum_cardinality' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'maximum_cardinality')::cardinal_number = maximum_cardinality) AND ((CAST(? AS TEXT)::JSONB) ->> 'dtd_identifier' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'dtd_identifier')::sql_identifier = dtd_identifier) AND ((CAST(? AS TEXT)::JSONB) ->> 'is_self_referencing' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'is_self_referencing')::yes_or_no = is_self_referencing) AND ((CAST(? AS TEXT)::JSONB) ->> 'is_identity' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'is_identity')::yes_or_no = is_identity) AND ((CAST(? AS TEXT)::JSONB) ->> 'identity_generation' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'identity_generation')::character_data = identity_generation) AND ((CAST(? AS TEXT)::JSONB) ->> 'identity_start' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'identity_start')::character_data = identity_start) AND ((CAST(? AS TEXT)::JSONB) ->> 'identity_increment' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'identity_increment')::character_data = identity_increment) AND ((CAST(? AS TEXT)::JSONB) ->> 'identity_maximum' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'identity_maximum')::character_data = identity_maximum) AND ((CAST(? AS TEXT)::JSONB) ->> 'identity_minimum' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'identity_minimum')::character_data = identity_minimum) AND ((CAST(? AS TEXT)::JSONB) ->> 'identity_cycle' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'identity_cycle')::yes_or_no = identity_cycle) AND ((CAST(? AS TEXT)::JSONB) ->> 'is_generated' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'is_generated')::character_data = is_generated) AND ((CAST(? AS TEXT)::JSONB) ->> 'generation_expression' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'generation_expression')::character_data = generation_expression) AND ((CAST(? AS TEXT)::JSONB) ->> 'is_updatable' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'is_updatable')::yes_or_no = is_updatable)))
dwui/table/information_schema.columns.sql: line 48

Note: You can hide error messages like this one from your users by setting the 'environment' configuration option to 'production'.