postgresql - insert date in composite type during a @DatabaseSetup - Stack Overflow

admin管理员组

文章数量:1345322

In postgresql, I have a user defined type like that:

create type my_type as (
  ts  timestamptz,
  val int
)

Then a table using that type:

create table my_table (
  id serial,
  ds my_type
)

I can insert and query data into that table in sql easily, but I can't find a way to insert data into it through an xml dataset file used by @DatabaseSetup for a test. I tried a few different variations like:

<my_table id="1"
          ds='("2025-04-03 09:38:08", 2)'
          ds.ts="2025-04-03 09:38:08"
          ds.val="2">

Whatever the syntax I tried, it results in a .dbunit.dataset.NoSuchColumnException: my_table.ds - (Non-uppercase input column: ds) in ColumnNameToIndexes cache map. Note that the map's column names are NOT case sensitive.

I can't put data into that column with a composite type. Any idea how to solve that?

本文标签： postgresqlinsert date in composite type during a DatabaseSetupStack Overflow