Hello...

Поиск
Список
Период
Сортировка
От Cristian Prieto
Тема Hello...
Дата
Msg-id 200502112057.j1BKvWfw001772@mail.clickdiario.com
обсуждение исходный текст
Ответы Re: Hello...  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
Hello, I migrated a database from postgresql 7.4 to postgresql 8.0.1 in a
Linux Fedora Core 3.
The tables and objects in the database schema are working ok...
I was just writing that function:

--- Begin of my function ---
CREATE OR REPLACE FUNCTION "public"."sp_insert_users_new" (varchar, varchar,
varchar, varchar, smallint, date, smallint, smallint, varchar, varchar,
varchar, varchar, varchar, varchar, varchar) RETURNS integer AS
$body$
DECLARE
    nombre ALIAS FOR $1;
    apellido ALIAS FOR $2;
    pass ALIAS FOR $3;
    e_mail ALIAS FOR $4;
    sexo ALIAS FOR $5;
    fecha_creacion ALIAS FOR $6;
    status_user ALIAS FOR $7;
    edad ALIAS FOR $8;
    pais_origen ALIAS FOR $9;
    ocupacion_user ALIAS FOR $10;
    estado_civil_user ALIAS FOR $11;
    ip ALIAS FOR $12;
    comentario_user ALIAS FOR $13;
    intereses_user    ALIAS FOR $14;
    foto        ALIAS FOR $15;
    returnValue integer;
    idusr INTEGER := nextval('users_iduser_seq');

BEGIN
    BEGIN
        INSERT INTO users (iduser,
firstname,lastname,password,email,sex,datecreate,status,age,pais,ocupacion,e
stado_civil,remote_ip,comentario,intereses,fotoext) VALUES (idusr,
nombre,apellido,pass,e_mail,sexo,fecha_creacion,status_user,edad,pais_origen
,ocupacion_user,estado_civil_user,ip,comentario_user,intereses_user,foto);
    EXCEPTION
        WHEN unique_violation then
            return 0;
    END;
    RETURN idusr;
END;
$body$
LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;
--- End of my functions ---

When I try to execute that function I get the following error:

ERROR:  function public.sp_insert_users_new("unknown", "unknown", "unknown",
"unknown", "unknown", "unknown", integer, "unknown", "unknown", "unknown",
"unknown", "unknown", "unknown", "unknown", "unknown") does not exist

My table structure is as following:

--- Begin table structure ---
CREATE TABLE "public"."users" (
  "iduser" SERIAL,
  "firstname" VARCHAR(50) DEFAULT ''::character varying NOT NULL,
  "lastname" VARCHAR(50) DEFAULT ''::character varying NOT NULL,
  "password" VARCHAR(50) DEFAULT ''::character varying NOT NULL,
  "email" VARCHAR(80) DEFAULT ''::character varying NOT NULL,
  "datecreate" DATE DEFAULT '1970-01-01'::date NOT NULL,
  "status" SMALLINT DEFAULT (0)::smallint NOT NULL,
  "age" SMALLINT DEFAULT (0)::smallint NOT NULL,
  "lastlogin" DATE DEFAULT '1970-01-01'::date NOT NULL,
  "pais" VARCHAR(100) DEFAULT ''::character varying NOT NULL,
  "ciudad" VARCHAR(100),
  "car" CHAR(2),
  "where_inet" VARCHAR(50),
  "empleados" VARCHAR(50),
  "inet" VARCHAR(50),
  "pay" VARCHAR(50),
  "cada_cuanto" VARCHAR(50),
  "ocupacion" VARCHAR(150),
  "estado_civil" VARCHAR(50),
  "paish" VARCHAR(50),
  "remote_ip" VARCHAR(50),
  "zipcode" VARCHAR(50) DEFAULT ''::character varying,
  "votos" BIGINT DEFAULT (0)::bigint NOT NULL,
  "comentario" VARCHAR(4000),
  "puntaje" BIGINT DEFAULT (0)::bigint NOT NULL,
  "sex" SMALLINT DEFAULT 0 NOT NULL,
  "intereses" VARCHAR(150) DEFAULT ''::character varying,
  "paisorigen" VARCHAR(100),
  "fotoext" VARCHAR(10),
  "promedio" REAL DEFAULT 0.00,
  CONSTRAINT "users_email_key" UNIQUE("email"),
  CONSTRAINT "users_iduser_key" UNIQUE("iduser"),
  CONSTRAINT "users_pkey" PRIMARY KEY("iduser", "email")
) WITH OIDS;
--- End table structure ---

What is wrong with my function or parameters? I was just looking around a
lot of places in internet and I could not get any answer, help please!



В списке pgsql-general по дате отправления:

Предыдущее
От: Harald Fuchs
Дата:
Сообщение: Re: Understanding EXPLAIN ANALYZE output
Следующее
От: Alex Turner
Дата:
Сообщение: Re: Python Driver