Skip site navigation (1) Skip section navigation (2)

Strange bug...

From: "Donald Fraser" <demolish(at)cwgsy(dot)net>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Strange bug...
Date: 2003-01-17 20:05:25
Message-ID: 000a01c2be63$c9168050$1664a8c0@DEMOLITION (view raw or flat)
Thread:
Lists: pgadmin-support
OS W2K SP2
pgAdmin II 1.4.12 
PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96

Another strange bug...

I create the following table using an SQL statement:

CREATE TABLE "tbl_usertype" (
"id" int4 NOT NULL, 
"s_desc" varchar(60) NOT NULL, 
CONSTRAINT "tbl_usertype_s_desc_key" UNIQUE ("s_desc"), 
CONSTRAINT "tbl_usertype_pkey" PRIMARY KEY ("id")
) WITHOUT OIDS;
GRANT SELECT ON "tbl_usertype" TO PUBLIC;

pgAdmin then reports the following as the SQL statements:

-- Table: public.tbl_usertype
CREATE TABLE public.tbl_usertype (
id int4 NOT NULL, 
s_desc varchar(60) NOT NULL, 
CONSTRAINT tbl_usertype_s_desc_key UNIQUE (s_desc), 
CONSTRAINT tbl_usertype_pkey PRIMARY KEY (id)
) WITHOUT OIDS;
GRANT SELECT ON TABLE public.tbl_usertype TO PUBLIC;
GRANT ALL ON TABLE public.tbl_usertype TO postgres;

Now one would expect to see under pgAdmin one Index named "tbl_usertype_s_desc_key".
pgAdmin reports zero Indexes....?
Again I checked the output from pg_dumpall and it definitely exists.
pg_dump displays the following lines.
-- Name: tbl_usertype_s_desc_key; Type: INDEX; Schema: public; Owner: postgres
CREATE UNIQUE INDEX tbl_usertype_s_desc_key ON tbl_usertype USING btree (s_desc);

Regards
Donald Fraser.

pgadmin-support by date

Next:From: John WellsDate: 2003-01-18 00:37:49
Subject: Re: Data Migration Wizard and rollbacks
Previous:From: John WellsDate: 2003-01-17 14:58:35
Subject: Re: Data Migration Wizard and rollbacks

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group