Postgres Pro
Downloads
Home   >   mailing lists

Re: [NOVICE] Insert Only Postgresql - Mailing list pgsql-general

From Brandon Aiken
Subject Re: [NOVICE] Insert Only Postgresql
Date
Msg-id F8E84F0F56445B4CB39E019EF67DACBA2F1C8D@exchsrvr.winemantech.com
Whole thread Raw
Responses Re: Insert Only Postgresql
Re: [NOVICE] Insert Only Postgresql
List pgsql-general
Tree view

Sure.  Any RDBMS can do that.  Just create a user account (login role for PostgreSQL) and only grant the INSERT privilege to them on your tables, then connect with that account with your program.  Any DELETE or UPDATE statements will automatically fail.

 

--

Brandon Aiken

CS/IT Systems Engineer

From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Solomon Asare
Sent: Friday, September 08, 2006 4:51 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Insert Only Postgresql

 

Hi All,
pls, is there an Insert only version of postgreql or any other known database? NO deletes, no updates. Inserts only! Any leads, please?

Best Regards,
solomon.

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: Determining right size for max_fsm_pages on large setup?
Next
From: "Karen Hill"
Date:
Subject: Re: Stored Procedure performance / elegance question