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, l
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
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
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
--
I use XP Pro latest hot fix.
Azttached the logfile ... hope this helps ...
Regards,
Claus2003-09-19 08:44:08 INFO :
##
2003-09-19 08:44:08 INFO : # pgAdmin III Version 0.9.2 BETA 2 Startup
2003-09-19 08:44:08 INFO :
##
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 (u
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, l