Re: [pgadmin-support] [ADMIN] Can't access tables.

2010-10-06 Thread Tom Lane
g, maybe vacuuming the system catalogs would help. regards, tom lane -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] [NOVICE] Where is PostgreSQL root directory?

2009-04-08 Thread Tom Lane
t; I should use the --with-pgsql=DIR command. You'd only run configure if you were trying to install pgAdmin from source; and I suppose what it wants is the root of the Postgres source tree, which you haven't got because you didn't install Postgres from source. I'd suggest findi

Re: [pgadmin-support] [BUGS] BUG #3829: Wrong index reporting from pgAdmin III (v1.8.0 rev 6766-6767)

2007-12-20 Thread Tom Lane
Dave Page <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Just out of curiosity, why is pgAdmin doing it this way at all? >> Seems it would be a lot easier to use the all-columns form of >> pg_get_indexdef than to cons up the display from fetches of each >> column

Re: [pgadmin-support] [BUGS] BUG #3829: Wrong index reporting from pgAdmin III (v1.8.0 rev 6766-6767)

2007-12-19 Thread Tom Lane
Dave Page <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Hm, there is a definitional issue here. Should pg_get_indexdef print >> this stuff at all when colno is nonzero? >> ... >> Dave, I think we put in this variant of the function for pgAdmin --- >> wh

Re: [pgadmin-support] [BUGS] BUG #3829: Wrong index reporting from pgAdmin III (v1.8.0 rev 6766-6767)

2007-12-19 Thread Tom Lane
e put in this variant of the function for pgAdmin --- what does pgAdmin need? regards, tom lane ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

Re: [ADMIN] [pgadmin-support] Overloading functions that are used by operators.

2003-07-12 Thread Tom Lane
xtcat'. I see no such error here ... regression=# create function pg_catalog.textcat(varchar,text) regression-# returns text as 'textcat' language 'internal'; CREATE FUNCTION regards, tom lane ---(end of broadcast)---

Re: [ADMIN] [pgadmin-support] Overloading functions that are used by operators.

2003-07-11 Thread Tom Lane
or comes when the planner tries to convert that string back to OID form. We fixed this in 7.4 by modifying the way that pg_statistic stores data values, so that no conversion needs to occur. regards, tom lane ---(end of broadcast)-