Nevermind. It was a configuration error. I thought I'd get smart by using /usr/local instead of the default libraries and includes. Once I reverted back to the defaults, all went well. Thanks anyway!Doug
I get the following errors upon running a make check for 8.1.3:
./pg_regress: line 503: 9002 Bus error "$bindir/psql" -
X $psql_options postgres /dev/null
./pg_regress: line 503: 9007 Bus error "$bindir/psql" -
X $psql_options postgres /dev/null
./pg_regress: line
On Jul 13, 2005, at 12:46 PM, Tom Lane wrote:
Doug Hall <[EMAIL PROTECTED]> writes:
delete from citizen where id not in (select citizenid from
citizen_stage);
The explain select tells me that there is a sequential select of
citizen_stage records. (??) There are 75009 citizen recor
Sorry. I realize this is a rather newbie question, but I've got a slow
delete going on here, and I could use some help figuring out why. This
is the classic "get rid of orphans" select.
delete from citizen where id not in (select citizenid from
citizen_stage);
citizen.id and citizen_stage.ci
On Wed, 9 Mar 2005 11:02:10 -0600, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
>... but the fact is there's still a LOT of places
> that are windows shops and a LOT of people who use windows more heavily
> than *nix. More important, the egotism of "If you want to use PostgreSQL
> you better run it on w
I remember reading someone's post recently, that provided directions
for using compiler directives to optimize Postgres for the G5 chip. If
that's you, could you please repost this, or send me a link, if it's on
a web site somewhere.
Thanks,
Doug
---(end of broadcast)---
Sorry for the newbie question, but how do you get PostgreSQL to list
the available databases? I know how to log into a certain database, but
not list all of them. I know this must be possible because the
phppgAdmin web site demonstrates it with their trial server.
Thanks,
Doug Hall
