Revision 14158
Added by Aaron Marcuse-Kubitza over 10 years ago
| util.sql | ||
|---|---|---|
| 1606 | 1606 |
-- |
| 1607 | 1607 |
|
| 1608 | 1608 |
CREATE FUNCTION derived_cols_sync(table_ regclass) RETURNS void |
| 1609 |
LANGUAGE sql |
|
| 1609 |
LANGUAGE plpgsql
|
|
| 1610 | 1610 |
SET search_path TO util |
| 1611 | 1611 |
AS $_$ |
| 1612 |
SELECT util.eval($$ |
|
| 1613 |
CREATE OR REPLACE FUNCTION $$||(table_::text||%'__fill_derived')||$$() |
|
| 1612 |
DECLARE |
|
| 1613 |
trigger_name_sql text = table_::text||%'__fill_derived'; |
|
| 1614 |
BEGIN |
|
| 1615 |
PERFORM util.eval($$ |
|
| 1616 |
CREATE OR REPLACE FUNCTION $$||trigger_name_sql||$$() |
|
| 1614 | 1617 |
RETURNS trigger AS |
| 1615 | 1618 |
$BODY1$ |
| 1616 | 1619 |
BEGIN |
| ... | ... | |
| 1629 | 1632 |
LANGUAGE plpgsql VOLATILE |
| 1630 | 1633 |
COST 100; |
| 1631 | 1634 |
$$); |
| 1635 |
END; |
|
| 1632 | 1636 |
$_$; |
| 1633 | 1637 |
|
| 1634 | 1638 |
|
Also available in: Unified diff
schemas/util.sql: derived_cols_sync(): set the trigger name in a var