"Lim Berger" <straightfwd007@xxxxxxxxx> writes: > Here's the table definition: > > Table "public.cachedstats" > Column | Type | Modifiers > -----------------------+-----------------------+------------------------------ > id | bigint | not null > prof_name | character varying(20) | not null > notes | text | not null > inform_prof_on_change | character(1) | not null default 'N'::bpchar > > Indexes: > "cachedstats_pkey" PRIMARY KEY, btree (id) > "idx_cachedstats_unique_prof_name" UNIQUE, btree (alias) What's "alias"? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend