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:

public_.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;

Also available in: Unified diff