Postgres Pro
Downloads
Home   >   mailing lists

Re: Conditional INSERT - Mailing list pgsql-general

From Michel Pelletier
Subject Re: Conditional INSERT
Date
Msg-id CACxu=vKcVZdjsmMQyGf2tAcVAt8vyz2X1b+ynPb=_==AATjbVA@mail.gmail.com
Whole thread Raw
In response to Conditional INSERT  (basti <mailinglist@unix-solution.de>)
Responses Re: Conditional INSERT  (Michael Lewis <mlewis@entrata.com>)
List pgsql-general
Tree view
Well, the obvious question is, why are you inserting data into your database you don't want?  It makes more sense to just not do the insert.

But, assuming perhaps you have no control over the client, you can create a BEFORE INSERT trigger that rejects the inserts that don't match your condition:




On Fri, Mar 15, 2019 at 10:55 AM basti <mailinglist@unix-solution.de> wrote:
Hello,

I want to insert data into table only if condition is true.
For example:

INSERT into  mytable (domainid, hostname, txtdata)
  VALUES (100,'_acme.challenge.example', 'somedata');

The insert should only be done if Hostname like %_acme.challenge%.

How can it be done? I dont want that the user/script can insert any value.

Best regards.

pgsql-general by date:

Previous
From: basti
Date:
Subject: Conditional INSERT
Next
From: Michael Lewis
Date:
Subject: Re: Conditional INSERT