From: | "Paolo Saudin" <paolo(at)ecometer(dot)it> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | Error craches pgAdmin |
Date: | 2006-12-11 19:11:39 |
Message-ID: | 005f01c71d58$32943610$97bca230$@it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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 dont know if depends on pgAdmin or the server itself.
Thanks,
Paolo Saudin
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2006-12-12 00:21:34 | Re: Backup dialog window: bad size |
Previous Message | Alex Terrazas | 2006-12-11 17:01:52 | installing on mandriva 7 |