Project

General

Profile

« Previous | Next » 

Revision 13512

Added by Aaron Marcuse-Kubitza over 10 years ago

fix: schemas/util.sql: force_recreate(): renamed to just recreate(), because "force" normally implies that things will be deleted, which this function does not do

View differences:

vegbien.sql
2818 2818 
CREATE FUNCTION sync_analytical_stem_to_view() RETURNS void
2819 2819 
    LANGUAGE sql
2820 2820 
    AS $_$
2821 
SELECT util.force_recreate($$
2821 
SELECT util.recreate($$
2822 2822 
DROP TABLE IF EXISTS analytical_stem;
2823 2823 
CREATE TABLE analytical_stem AS SELECT * FROM analytical_stem_view LIMIT 0;
2824 2824 
ALTER TABLE analytical_stem ADD COLUMN taxon_occurrence__pkey serial PRIMARY KEY;
......
16810 16810 
CREATE FUNCTION "MatchedTaxon_modify"(view_query text) RETURNS void
16811 16811 
    LANGUAGE sql
16812 16812 
    AS $_$
16813 
SELECT util.force_recreate($$
16813 
SELECT util.recreate($$
16814 16814 
-- trigger the dependent_objects_still_exist exception
16815 16815 
DROP VIEW "TNRS"."MatchedTaxon"; -- *not* CASCADE; it must trigger an exception
16816 16816 

  		












Also available in:  Unified diff