Project

General

Profile

« Previous | Next » 

Revision 13470

bugfix: schemas/util.sql: save_drop_view(): util.show_create_view(): don't include `OR REPLACE` because that causes nonuniform errors (eg. invalid_table_definition), instead of the standard duplicate_table exception caught by util.create_if_not_exists()

View differences:

util.sql
3335 3335
	result text = NULL;
3336 3336
BEGIN
3337 3337
	BEGIN
3338
		result = util.show_create_view(view_);
3338
		result = util.show_create_view(view_, replace := false);
3339
			/* replace: no `OR REPLACE` because that causes nonuniform errors
3340
			(eg. invalid_table_definition), instead of the standard
3341
			duplicate_table exception caught by util.create_if_not_exists() */
3339 3342
		PERFORM util.drop_view(view_);
3340 3343
	EXCEPTION
3341 3344
		WHEN undefined_table THEN NULL;

Also available in: Unified diff