Search Postgresql Archives
Re: delete query using CTE
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: delete query using CTE
From
: Michael Lewis <mlewis@xxxxxxxxxxx>
Date
: Sun, 13 Mar 2022 08:50:00 -0600
Cc
: PostgreSQL General <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to
: <
CAPV07m-_L6Ssi4YkiFVkej94fzOWwK2RbGCLS6SZum0WwW2PLw@mail.gmail.com
>
References
: <
CAPV07m-_L6Ssi4YkiFVkej94fzOWwK2RbGCLS6SZum0WwW2PLw@mail.gmail.com
>
You can't delete rows that are in a CTE. You want to delete rows that are in the table. Do you have a primary key that you can reference? Else, you may need to reference the system column ctid.
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
References
:
delete query using CTE
From:
Roger Bos
Prev by Date:
delete query using CTE
Next by Date:
Re: delete query using CTE
Previous by thread:
delete query using CTE
Next by thread:
Re: delete query using CTE
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
