From: | Gabriel Colina <colina_movil(at)yahoo(dot)com> |
---|---|
To: | Gabriel Colina <colina_movil(at)yahoo(dot)com>, Leonel Nunez <lnunez(at)enelserver(dot)com> |
Cc: | David Primero Segundo <aberracion2001(at)hotmail(dot)com>, pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Al correr el script para generar crosstab obtengo este error |
Date: | 2007-02-24 01:22:49 |
Message-ID: | 257699.83358.qm@web34708.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Este es el error, no se por que sustituir
module_pathname
psql:crosstab.sql:78: ERROR: could not access file
"MODULE_PATHNAME": No such f
ile or directory
psql:crosstab.sql:83: ERROR: could not access file
"MODULE_PATHNAME": No such f
ile or directory
Esta es la forma que quiero ejecutar el script
C:\Archivos de programa\PostgreSQL\8.2\bin>
CREATE OR REPLACE FUNCTION normal_rand(int4, float8,
float8)
RETURNS setof float8
AS 'MODULE_PATHNAME','normal_rand'
LANGUAGE C VOLATILE STRICT;
-- the generic crosstab function:
CREATE OR REPLACE FUNCTION crosstab(text)
RETURNS setof record
AS 'MODULE_PATHNAME','crosstab'
LANGUAGE C STABLE STRICT;
-- examples of building custom type-specific crosstab
functions:
CREATE TYPE tablefunc_crosstab_2 AS
(
row_name TEXT,
category_1 TEXT,
category_2 TEXT
);
CREATE TYPE tablefunc_crosstab_3 AS
(
row_name TEXT,
category_1 TEXT,
category_2 TEXT,
category_3 TEXT
);
CREATE TYPE tablefunc_crosstab_4 AS
(
row_name TEXT,
category_1 TEXT,
category_2 TEXT,
category_3 TEXT,
category_4 TEXT
);
CREATE OR REPLACE FUNCTION crosstab2(text)
RETURNS setof tablefunc_crosstab_2
AS 'MODULE_PATHNAME','crosstab'
LANGUAGE C STABLE STRICT;
CREATE OR REPLACE FUNCTION crosstab3(text)
RETURNS setof tablefunc_crosstab_3
AS 'MODULE_PATHNAME','crosstab'
LANGUAGE C STABLE STRICT;
CREATE OR REPLACE FUNCTION crosstab4(text)
RETURNS setof tablefunc_crosstab_4
AS 'MODULE_PATHNAME','crosstab'
LANGUAGE C STABLE STRICT;
-- obsolete:
CREATE OR REPLACE FUNCTION crosstab(text,int)
RETURNS setof record
AS 'MODULE_PATHNAME','crosstab'
LANGUAGE C STABLE STRICT;
CREATE OR REPLACE FUNCTION crosstab(text,text)
RETURNS setof record
AS 'MODULE_PATHNAME','crosstab_hash'
LANGUAGE C STABLE STRICT;
CREATE OR REPLACE FUNCTION
connectby(text,text,text,text,int,text)
RETURNS setof record
AS 'MODULE_PATHNAME','connectby_text'
LANGUAGE C STABLE STRICT;
CREATE OR REPLACE FUNCTION
connectby(text,text,text,text,int)
RETURNS setof record
AS 'MODULE_PATHNAME','connectby_text'
LANGUAGE C STABLE STRICT;
-- These 2 take the name of a field to ORDER BY as 4th
arg (for sorting siblings)
CREATE OR REPLACE FUNCTION
connectby(text,text,text,text,text,int,text)
RETURNS setof record
AS 'MODULE_PATHNAME','connectby_text_serial'
LANGUAGE C STABLE STRICT;
CREATE OR REPLACE FUNCTION
connectby(text,text,text,text,text,int)
RETURNS setof record
AS 'MODULE_PATHNAME','connectby_text_serial'
LANGUAGE C STABLE STRICT;
Alguien sabe que debo hacer.
Atte.
Gabriel Colina
__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
Regístrate ya - http://correo.espanol.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Victor Lopez | 2007-02-24 01:25:12 | Estoy? |
Previous Message | Gabriel Colina | 2007-02-24 00:54:11 | Re: Modelo entidad relacion |