Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
Andreas,Thank you for your advice--query and other:This query:CREATE OR REPLACE FUNCTION "sp_SetScenario"(scen character varying) RETURNS void AS$BODY$DECLARE sqlStatement varchar(500);BEGIN SET sqlStatement = 'ALTER USER postgres WITH DEFAULT_SCHEMA = $1'; EXECUTE(sqlStatement);END;$BODY$LANGUAGE 'pgpsql' VOLATILECOST 100; returns: ERROR: language "pgpsql" does not exist********** Error **********ERROR: language "pgpsql" does not existSQL state: 42704 The only language options in the New Function “wizard” in pgAdmin III are:internalcsqlI would be grateful for any further suggestions from you or others.Kind regards,Jim
Andreas,
Thank you for your advice--query and other:
This query:
CREATE OR REPLACE FUNCTION "sp_SetScenario"(scen character varying) RETURNS void AS
$BODY$DECLARE
sqlStatement varchar(500);
BEGIN
SET sqlStatement = 'ALTER USER postgres WITH DEFAULT_SCHEMA = $1';
EXECUTE(sqlStatement);
END;
$BODY$
LANGUAGE 'pgpsql' VOLATILE
COST 100;
returns:
ERROR: language "pgpsql" does not exist
********** Error **********
SQL state: 42704
The only language options in the New Function “wizard” in pgAdmin III are:
internal
c
sqlI would be grateful for any further suggestions from you or others.
В списке pgsql-novice по дате отправления: