Al correr el script para generar crosstab obtengo este error

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/

In response to

Responses

Browse pgsql-es-ayuda by date

  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