claus wrote:

Hello again,

Another thing .... on this table:

-- Table: public.log

-- DROP TABLE public.log;

CREATE TABLE public.log
(
 userid varchar(10) NOT NULL,
 log_time timestamptz NOT NULL,
 type varchar(10),
 message varchar(200),
 ip_addr varchar(15),
 CONSTRAINT log_pkey PRIMARY KEY (userid, log_time)
) WITH OIDS;
REVOKE ALL ON TABLE public.log FROM public;
GRANT ALL ON TABLE public.log TO postgres;
GRANT ALL ON TABLE public.log TO "ETAD";

I get a hanging window when opening "View Data".

This works for me using the DDL above on Linux with a 7.4 backend (and no data), what client do you use?
Please activate full debugging and send the log.


Regards,
Andreas



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to