Re: ALTER TABLE ... NOREWRITE option

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ALTER TABLE ... NOREWRITE option
Date: 2012-12-05 19:43:17
Message-ID: 50BFA3D5.5050909@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> You know, event triggers seem like an awfully good solution to this
> problem. All we'd need is a new event called table_rewrite:
>
> CREATE EVENT TRIGGER my_event_trigger
> ON table_rewrite
> EXECUTE PROCEDURE consider_whether_to_throw_an_error();

Oh, wow, that would be perfect. That also solves the problem of "I
don't care if I rewrite really_small_table, but I do care if I rewrite
really_big_table".

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2012-12-05 19:45:32 Re: json accessors
Previous Message Robert Haas 2012-12-05 19:43:03 Re: Dumping an Extension's Script