Thread: View Data hangs

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".
On the left lower corner it says "aborting" but the window stays
white. It can be closed using the X in the upper right corner.

The table contains
Rows (estimated) 586
Rows (counted) 599

OID: 6475655
Primary key: userid, log_time

When using the Query tool everything displays fine.

I got this rehgardless with 7.3.3 and 7.3.4. pgadmin III is still Beta 2.

Any ideas? Any additional info that could be useful for you?

Thanx and regards,
Claus

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

I use XP Pro latest hot fix.
Azttached the logfile ... hope this helps ...

Regards,
Claus

claus wrote:

>I use XP Pro latest hot fix.
>Azttached the logfile ... hope this helps ...
>
>
>
>2003-09-19 08:44:28 INFO   : Running query SELECT Oid, * FROM public.log ORDER BY "userid, log_time"
>
>
This was fixed post-Beta2, it is a bad multi-column key quoting.

Regards,
Andreas

Great.

> This was fixed post-Beta2, it is a bad multi-column key quoting.
So I wait for the next release.

Thanx a lot,
Claus