Re: [NOVICE] Insert Only Postgresql

From: "Brandon Aiken" <BAiken(at)winemantech(dot)com>
To: "Solomon Asare" <solomonasare(at)gmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: [NOVICE] Insert Only Postgresql
Date: 2006-09-08 21:17:05
Message-ID: F8E84F0F56445B4CB39E019EF67DACBA2F1C8D@exchsrvr.winemantech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Solomon Asare
Sent: Friday, September 08, 2006 4:51 PM
To: pgsql-novice(at)postgresql(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel T. Staal 2006-09-08 21:18:41 Re: Insert Only Postgresql
Previous Message Vivek Khera 2006-09-08 20:59:32 Re: Determining right size for max_fsm_pages on large setup?

Browse pgsql-novice by date

  From Date Subject
Next Message Daniel T. Staal 2006-09-08 21:18:41 Re: Insert Only Postgresql
Previous Message Eric M. Cherry 2006-09-08 21:14:38 Re: Progress and Questions