# Postgres Adapter incremental strategy delete+insert is not deleting rows

**URL:** <https://discourse.getdbt.com/t/postgres-adapter-incremental-strategy-delete-insert-is-not-deleting-rows/9230>\
**Category:** Help\
**Tags:** incremental, dbt-core\
**Created:** [July 20, 2023, 6:27pm UTC](https://discourse.getdbt.com/t/postgres-adapter-incremental-strategy-delete-insert-is-not-deleting-rows/9230 "2023-07-20T18:27:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mailshuvajit](https://avatars.discourse-cdn.com/v4/letter/m/df788c/32.png) [@mailshuvajit](https://discourse.getdbt.com/u/mailshuvajit)\
**Post date:** [July 20, 2023, 6:27pm UTC](https://discourse.getdbt.com/t/postgres-adapter-incremental-strategy-delete-insert-is-not-deleting-rows/9230/1 "2023-07-20T18:27:00Z")

</div>

## The problem I’m having: dbt incremental model is not able to delete row in target table

## The context of why I’m trying to do this: Trying to implement a SCD Type1 implementation. I have underlying Hub/satelite tables and using dbt vault package for that. I have to track change for a given dimension id and update the attribute value accordingly. As dbt does not support “merge” yet for postgres adapter the option is “delete+insert” strategy.

## What I’ve already tried: Updated model configuration as followed:

materialized = ‘incremental’,  
incremental\_strategy = ‘delete+insert’

## Some example code or error messages

```auto
{{
  config(
    materialized = 'incremental',
    unique_key = 'dim_id',
    incremental_strategy = 'delete+insert'
        
        
    )
}}

```

---

<div class="post-metadata">

**Author:** ![ggirineza](https://avatars.discourse-cdn.com/v4/letter/g/e274bd/32.png) [@ggirineza](https://discourse.getdbt.com/u/ggirineza)\
**Post date:** [June 2, 2025, 1:56pm UTC](https://discourse.getdbt.com/t/postgres-adapter-incremental-strategy-delete-insert-is-not-deleting-rows/9230/2 "2025-06-02T13:56:36Z")

</div>

Hey, I have the same issue, have you found anything ?