hello team! I'm using

stream_maps

(tap-postgres) to drop a column and sync the data into

target-postgres

. Config:

- name: tap-postgress
  config:
    stream_maps:
      public-table:
        column1_text: column1
        column1: __NULL__
  metadata:
    public-*:
      replication-method: FULL_TABLE
  select:
    - public-table.*

On the target side the table has been created manually (not from meltano) and has all the columns (

column1

and

column1_text

) When I run the sync

meltano run tap-postgres target-postgres

it fails with the error that enum already exist (column1 is type ENUM). If I drop the

column1

(on target side) the sync works correctly and in the

Inserting with SQL

logs I can see that the data doesn't have any info regarding

column1

.

column1_text

has the data of

column1

as it's setup on stream_maps tap side. Is there any configuration I'm missing in order to have

column1

column on target side as well or no?

Hi @TomasB! Which variant of target-postgres is this? MeltanoLabs?

yes

<https://github.com/MeltanoLabs/target-postgres.git@v0.0.14>

I logged https://github.com/MeltanoLabs/target-postgres/issues/419 and will try to reproduce it later today. It's not clear to me at this point why the target would try to create an ENUM.

ok, let me add some more info in the issue