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 2/dev/null
./pg_regress: line 503: 9007 Bus error $bindir/psql -
X $psql_options postgres /dev/null 2/dev/null
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
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
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 records and 14778
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 what we
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
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