Problemas con wikiql
De CidesaWiki
(Diferencias entre revisiones)
(Una edición intermedia no se muestra.) | |||
Línea 22: | Línea 22: | ||
'''Soluccion:''' | '''Soluccion:''' | ||
- | Tiene que generar el lenguaje al esquema | + | Tiene que generar el lenguaje al esquema<br> |
+ | Por Consola: | ||
<pre> | <pre> | ||
$ createlang plpgsql "SIMA" | $ createlang plpgsql "SIMA" | ||
</pre> | </pre> | ||
- | [[wiki|Mas | + | |
+ | Por Script: | ||
+ | <pre> | ||
+ | CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' | ||
+ | HANDLER plpgsql_call_handler | ||
+ | VALIDATOR plpgsql_validator; | ||
+ | </pre> | ||
+ | [[wiki|Mas Información...]] | ||
*<br> | *<br> |
Última versión de 21:11 3 oct 2007
- Al momento de importa una base de datos en los log, genera el siguiente error:
Problema:
pg_restore: connecting to database for restore pg_restore: creating STDSTRINGS STDSTRINGS pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 9152; 0 0 STDSTRINGS STDSTRINGS pg_restore: [archiver (db)] could not execute query: ERROR: parameter "standard_conforming_strings" cannot be changed Command was: SET standard_conforming_strings = 'off'; pg_restore: creating SCHEMA SIMA055 pg_restore: creating COMMENT SCHEMA "SIMA055" pg_restore: creating SCHEMA SIMA_USER pg_restore: creating SCHEMA public pg_restore: creating COMMENT SCHEMA public pg_restore: creating PROCEDURAL LANGUAGE plpgsql pg_restore: [archiver (db)] Error from TOC entry 2364; 2612 16387 PROCEDURAL LANGUAGE plpgsql wiki pg_restore: [archiver (db)] could not execute query: ERROR: language "plpgsql" already exists Command was: CREATE PROCEDURAL LANGUAGE plpgsql; pg_restore: creating FUNCTION act_cpasiini00()
Soluccion:
Tiene que generar el lenguaje al esquema
Por Consola:
$ createlang plpgsql "SIMA"
Por Script:
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler VALIDATOR plpgsql_validator;
pg_restore: creating SEQUENCE OWNED BY acatencion_id_seq pg_restore: [archiver (db)] Error from TOC entry 9158; 0 0 SEQUENCE OWNED BY acatencion_id_seq wiki pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near "OWNED" at character 34 Command was: ALTER SEQUENCE acatencion_id_seq OWNED BY acatencion.id;