db 자체로 수정하려면 primary는 geom이어야
ALTER TABLE temp.mission ADD PRIMARY KEY (geom);
Cannot Delete Error
Data provider does not support deleting features for PostGIS tables?
Thanks for contributing an answer to Geographic Information Systems Stack Exchange! Please be sure to answer the question. Provide details and share your research! Asking for help, clarification, or responding to other answers. Making statements based on opinion; back them up with references or personal experience.
https://gis.stackexchange.com/questions/286103/data-provider-does-not-support-deleting-features-for-postgis-tables
PostgreSQL Primary Key
Summary: in this tutorial, we will show you what the primary key is and how to manage PostgreSQL primary key constraints through SQL statements. A primary key is a column or a group of columns used to identify a row uniquely in a table. You define primary keys through primary key constraints.
https://www.postgresqltutorial.com/postgresql-primary-key/
Remove Data - duplicated
Postgres could not create unique index, key is duplicated
I'm trying to add a column to a table in my Postgres 9.3 database with this seemingly simple SQL: ALTER TABLE quizzes ADD COLUMN deleted BOOLEAN NOT NULL DEFAULT false; However, I'm getting the following error: ERROR: could not create unique index "quizzes_pkey" DETAIL: Key (id)=(10557462) is duplicated.
https://stackoverflow.com/questions/45315510/postgres-could-not-create-unique-index-key-is-duplicated
