Hi, i am working on ELT to postgres

Hi, i am working on ELT to postgres -

itamar s

06/02/2026, 2:18 PM

Hi, i am working on ELT to postgres - looking at this example : I have a unique key that is composite of 2 columns . If I understand correctly - this will create two indexes: 1. One for col1 and One for col2 my_schema.another_table: target_options: table_keys: index: [col1, col2]

flarco

06/03/2026, 11:24 AM

@itamar s a new feature is in the works to make this easier, will come next release. In upcoming release, you'll be able to do

index: [[col1, col2]]

For now you can use

target_options.table_ddl

for compiste index.

itamar s

06/03/2026, 11:25 AM

Thanks

itamar s

06/09/2026, 7:33 AM

@flarco Hi, i tested it and it works when you use one line. target_options: add_new_columns: false column_casing: snake table_keys: primary: [[user_id,brand_id]] when i use only the index: [[user_id,brand_id]] it works , when using primary or unique i get error: --- datatype.go:388 SetKeys --- could not set primary key. Did not find column available: ["id","user_id","brand_id"," Thanks

itamar s

06/17/2026, 1:14 PM

@flarco Hi, are the primary and unique are going to be adjust to work as well? or should i use hooks to create if not exist? Thanks

itamar s

06/29/2026, 3:12 PM

i guessed you miss that, I want to know if to wait for it or change my code...

flarco

06/29/2026, 8:24 PM

hi @itamar s yes apologies, this will be added into next release, the PK will accept the same as index

flarco

06/29/2026, 8:25 PM

Unique as well

itamar s

07/14/2026, 9:39 AM

@flarco Hi when will be the next release ?

flarco

07/15/2026, 11:36 AM

Hey @itamar s releasing today

itamar s

07/16/2026, 7:54 AM

@flarco thanks 🙂

itamar s

07/20/2026, 4:08 PM

@flarco hi it seems that unique doesnt work well. it still create seperated Also is there an option to set the ASC or DESC ?

flarco

07/27/2026, 1:55 AM

@itamar s try with 1.5.22

Previous Next