Problemas con wikiql

De CidesaWiki

(Diferencias entre revisiones)
Saltar a navegación, buscar
 
(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 Informacion]]
+
 
 +
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

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;

Mas Información...

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;
Herramientas personales
Espacios de nombres
Variantes
Acciones
Navegación
Herramientas