information_schema.sequences

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.sequences.sql": Failed to set variable records_count: In "dwui/table/information_schema.sequences.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.sequences WHERE (CAST(? AS TEXT) IS NULL OR (((CAST(? AS TEXT)::JSONB) ->> 'sequence_catalog' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'sequence_catalog')::sql_identifier = sequence_catalog) AND ((CAST(? AS TEXT)::JSONB) ->> 'sequence_schema' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'sequence_schema')::sql_identifier = sequence_schema) AND ((CAST(? AS TEXT)::JSONB) ->> 'sequence_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'sequence_name')::sql_identifier = sequence_name) 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) ->> '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) ->> 'start_value' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'start_value')::character_data = start_value) AND ((CAST(? AS TEXT)::JSONB) ->> 'minimum_value' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'minimum_value')::character_data = minimum_value) AND ((CAST(? AS TEXT)::JSONB) ->> 'maximum_value' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'maximum_value')::character_data = maximum_value) AND ((CAST(? AS TEXT)::JSONB) ->> 'increment' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'increment')::character_data = increment) AND ((CAST(? AS TEXT)::JSONB) ->> 'cycle_option' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'cycle_option')::yes_or_no = cycle_option)))
dwui/table/information_schema.sequences.sql: line 48
dwui/table/information_schema.sequences.sql: line 48

Backtrace

Failed to set variable records_count

In "dwui/table/information_schema.sequences.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.sequences WHERE (CAST(? AS TEXT) IS NULL OR (((CAST(? AS TEXT)::JSONB) ->> 'sequence_catalog' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'sequence_catalog')::sql_identifier = sequence_catalog) AND ((CAST(? AS TEXT)::JSONB) ->> 'sequence_schema' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'sequence_schema')::sql_identifier = sequence_schema) AND ((CAST(? AS TEXT)::JSONB) ->> 'sequence_name' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'sequence_name')::sql_identifier = sequence_name) 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) ->> '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) ->> 'start_value' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'start_value')::character_data = start_value) AND ((CAST(? AS TEXT)::JSONB) ->> 'minimum_value' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'minimum_value')::character_data = minimum_value) AND ((CAST(? AS TEXT)::JSONB) ->> 'maximum_value' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'maximum_value')::character_data = maximum_value) AND ((CAST(? AS TEXT)::JSONB) ->> 'increment' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'increment')::character_data = increment) AND ((CAST(? AS TEXT)::JSONB) ->> 'cycle_option' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'cycle_option')::yes_or_no = cycle_option)))
dwui/table/information_schema.sequences.sql: line 48

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