[EMAIL PROTECTED] wrote:
> Error connecting to the server: FATAL: no pg_hba.conf entry
> for host "138.250.104.229", user "globus", database
> "rftDatabase", SSL off
>
> 138.250.104.229 is the IP for the local server, 138.250.104.232
> is the IP of the remote server, but is not showing it in the
>
>I'm testing the Beta 2 of PG-Admin 1.8 and I have the
>Problem that I >cannot see my aggregate functions.
>In the 1.6.3 I could see them direct
>under the public schema, but in the 1.8 I don't
>have that section.
Check that they're made visible, under File -> Options -> Display tab (this
is new
rly as big of a performance gain by splitting
your index up.
Take a look at partial indexes (with the WHERE clause).
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=sql-createindex.html
--
Rod Taylor <[EMAIL PROTECTED]>
PGP Key: http://www.rbt.ca/rbtpub.asc
signatu
> Hi Karim,
>
> Currently there is no way to do this other than enter the SQL yourself
> with a 'LIMIT nnn' on the end of the query. It might be handy though, so
> I'll add it to the todo list.
MSAccess does this decently. They use a cursor, pull out 100 entries by
default, then when you scrol
This would cost an extra query for every query, but you could let the DB
manage it with:
select quote_ident('user');
Just pile on all of the identifiers into a list and use the results for
the real query. This way it'll work across all versions of Postgresql
as well as future ones without any
arbitrary text file against a database connection. This would
preserve most of the functionality and should be straight forward to
implement. The only catch is it shouldn't have the select queries in
it which the PGAdmin uses to determine structure.
--
Rod
- Original Message -
From:
to confirm it can be
applied after editing.
As a side note, I still need to be able to cut & paste the SQL
generated for the purposes of a change control report.
Currently this can almost be done with the logging when you grep out
all of the selects (99.9% of the time it's pgAdmin doing it&
When clicking on a table with a comment (definition pane shows how to
create the item), data within ' ' will be highlighted as well if it
matches (see below). The word 'by' will be green.
COMMENT ON TABLE "action" IS 'Actions in queue to be services by th
