[pgadmin-support] Error craches pgAdmin

[Paolo Saudin]

Hi,

I found a different pgAdmin behavior  if  I use it against Postgres 8.1.15
or 8.2.0. Here to try it out

 

I have a table filled with dates :

CREATE TABLE _master_h24  (

  fulldate timestamp without time zone NOT NULL,

  CONSTRAINT _master_h24_pkey PRIMARY KEY (fulldate)

)  WITHOUT OIDS;

 

I have a function to fulfill it with dates :

CREATE OR REPLACE FUNCTION fillmastertable_h24()

  RETURNS timestamp without time zone AS

$BODY$

declare

    dt_now timestamp;

    dt_last timestamp;

    max_loops INTEGER;

    v INTEGER;

BEGIN

    -- gets the last update

    SELECT fulldate INTO dt_last FROM _master_h24 ORDER BY fulldate DESC
LIMIT 1;

    --RAISE NOTICE 'last : % ', dt_last;

 

    -- gets the gmt - 1 hour date time

    dt_now := to_timestamp(TIMEZONE('WAT',CURRENT_TIMESTAMP), 'YYYY-MM-DD');

    --RAISE NOTICE 'dt_now : % ', dt_now;

    max_loops := 100;

    v := 0;

    WHILE dt_last < dt_now AND v < max_loops loop

      v := v + 1;

      dt_last := dt_last + '24 HOUR'::INTERVAL;

 

      /* execute query */

      BEGIN

        RAISE NOTICE 'Dt : % ', dt_last;

 

        insert into _master_24 (fulldate) VALUES (dt_last);
/*  ß <- HERE IS THE TABLE MISSPELLING (_master_24 ) */

 

      /* errors check */

      EXCEPTION

      /* in case of any error */

        WHEN OTHERS THEN RAISE NOTICE 'ERROR in fillmastertable_h24';

      END;

 

    END loop;

    return dt_last;

END;

$BODY$

  LANGUAGE 'plpgsql' VOLATILE;

ALTER FUNCTION fillmastertable_h24() OWNER TO postgres;

 

I then insert the first date to begin with :

insert into _master_h24 (fulldate) VALUES ('2006-12-01'); -> OK

 

I run the script  :

SELECT fillmastertable_h24();

 

And on Postgres 8.1.15 I get back ‘ERROR: “relation _master_24” does not
exist -> OK

While on Postgres 8.2.0 I get back only “:” and pgAdmin craches loosing the
connection to the server. If I click on the server node I get the following
message box : 

An error has occurred:

Server closed the connection unexpectedly

This probably means the server terminated abnormally before or while
processing the request

 

I don’t know if depends on pgAdmin or the server itself.

 

Thanks,

Paolo Saudin