pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr

Function: _add_raster_constraint

Schema

public

Owner

postgres

Descriptions

There is no description for function _add_raster_constraint

Options

Definition

CREATE OR REPLACE FUNCTION public._add_raster_constraint (
 cn name,
 sql text
)
RETURNS boolean AS
$span$
BEGIN
BEGIN
EXECUTE sql;
EXCEPTION
WHEN duplicate_object THEN
RAISE NOTICE 'The constraint "%" already exists.  To replace the existing constraint, delete the constraint and call ApplyRasterConstraints again', cn;
WHEN OTHERS THEN
RAISE NOTICE 'Unable to add constraint: %', cn;
RAISE NOTICE 'SQL used for failed constraint: %', sql;
RAISE NOTICE 'Returned error message: % (%)', SQLERRM, SQLSTATE;
RETURN FALSE;
END;

RETURN TRUE;
END;
$span$
LANGUAGE 'plpgsql'
VOLATILE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST 100;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23