information_schema.tables

Add record

No data

Error in query number 7

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

In "dwui/table/information_schema.tables.sql": Failed to set variable records_count: In "dwui/table/information_schema.tables.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.tables 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) ->> 'table_type' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'table_type')::character_data = table_type) AND ((CAST(? AS TEXT)::JSONB) ->> 'self_referencing_column_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'self_referencing_column_name')::sql_identifier = self_referencing_column_name) AND ((CAST(? AS TEXT)::JSONB) ->> 'reference_generation' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'reference_generation')::character_data = reference_generation) AND ((CAST(? AS TEXT)::JSONB) ->> 'user_defined_type_catalog' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'user_defined_type_catalog')::sql_identifier = user_defined_type_catalog) AND ((CAST(? AS TEXT)::JSONB) ->> 'user_defined_type_schema' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'user_defined_type_schema')::sql_identifier = user_defined_type_schema) AND ((CAST(? AS TEXT)::JSONB) ->> 'user_defined_type_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'user_defined_type_name')::sql_identifier = user_defined_type_name) AND ((CAST(? AS TEXT)::JSONB) ->> 'is_insertable_into' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'is_insertable_into')::yes_or_no = is_insertable_into) AND ((CAST(? AS TEXT)::JSONB) ->> 'is_typed' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'is_typed')::yes_or_no = is_typed) AND ((CAST(? AS TEXT)::JSONB) ->> 'commit_action' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'commit_action')::character_data = commit_action)))
dwui/table/information_schema.tables.sql: line 48
dwui/table/information_schema.tables.sql: line 48

Backtrace

Failed to set variable records_count

In "dwui/table/information_schema.tables.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.tables 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) ->> 'table_type' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'table_type')::character_data = table_type) AND ((CAST(? AS TEXT)::JSONB) ->> 'self_referencing_column_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'self_referencing_column_name')::sql_identifier = self_referencing_column_name) AND ((CAST(? AS TEXT)::JSONB) ->> 'reference_generation' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'reference_generation')::character_data = reference_generation) AND ((CAST(? AS TEXT)::JSONB) ->> 'user_defined_type_catalog' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'user_defined_type_catalog')::sql_identifier = user_defined_type_catalog) AND ((CAST(? AS TEXT)::JSONB) ->> 'user_defined_type_schema' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'user_defined_type_schema')::sql_identifier = user_defined_type_schema) AND ((CAST(? AS TEXT)::JSONB) ->> 'user_defined_type_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'user_defined_type_name')::sql_identifier = user_defined_type_name) AND ((CAST(? AS TEXT)::JSONB) ->> 'is_insertable_into' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'is_insertable_into')::yes_or_no = is_insertable_into) AND ((CAST(? AS TEXT)::JSONB) ->> 'is_typed' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'is_typed')::yes_or_no = is_typed) AND ((CAST(? AS TEXT)::JSONB) ->> 'commit_action' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'commit_action')::character_data = commit_action)))
dwui/table/information_schema.tables.sql: line 48

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