[pgadmin-support] Postgres question

2006-06-11 Thread OConnell, John
    When we run PgAdmin III, the “connect to server” box pops up with the username already prefilled. This is disabled so we Can not change it, we can only enter our id. How can we change userids? Any help on this would be appreciated, thanks.  Statement of confidentiality: The infor

[pgadmin-support] bpchar_pattern_ops not shown in index command

2006-06-11 Thread Andrus
To reproduce, run: create table foo ( bar char(20)); CREATE UNIQUE INDEX bar_pattern_idx ON foo(LOWER(bar) bpchar_pattern_ops); Observed in pgadmin: CREATE UNIQUE INDEX bar_pattern_idx ON foo USING btree (lower(bar::text)); Expected: bpchar_pattern_ops clause must also be present Plat

[pgadmin-support] Server Instrumentation for Gentoo Portage Install

2006-06-11 Thread Nate . Ingalsbe
I've installed PostgreSQL 8.1.4 on a Gentoo box via the handy dandy Portage tool. (#emerge -av postgresql) I've got the pgAdmin tool on a Windows box that connects to the Gentoo box, and I'd like to get the server instrumentation functions installed on the pg server. I'm not quite sure how to ge