> You already got an answer to the first part of your question, but I
> thought you might be interested in the second as well. Here's what I
> did:
Thanks. That's very helpful, to see a good example of using the built-in
catalog data.
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(
Steps taken that work:
1. Take a low-level (tar) backup on the live server
2. Restore the files on a second server (identical OS and PG versions)
3. Copy the archived WAL files to the backup server
4. Restore the archived WAL files on the backup server
However, why don't steps 5 through 8 wo
=?ISO-8859-1?Q?Greg_Jan=E9e?= <[EMAIL PROTECTED]> writes:
> db=> explain analyze SELECT * FROM scene A WHERE A.footprint && box
> '((-120.1, 34.3), (-119.7, 34.4))' ;
> QUERY PLAN
> --
4 maj 2007 kl. 18:09 skrev Tom Lane:
Henrik Zagerholm <[EMAIL PROTECTED]> writes:
I have a SELECT query that uses Seq scans instead of index scan
despite that the index scan is faster.
Try 8.2, it's a bit smarter about the costs of repeated indexscans
on the inside of a nestloop.
Ahh sorr
I tried to set that policy to all available settings [activate, not
activate, not set] but the result does not change, the installer stops with
the same error.
Here below elevated privileges set for Windows installer
I then tried the same things on a true Windows XP Professional SP
On Sat, May 05, 2007 at 03:01:36PM +1200, Glen Eustace wrote:
> Is there some way that one can determine whether a table has changed
> i.e. an insert, delete, update, without having to resort to setting a
> flag in another table using a triger or rule.
You can NOTIFY a LISTENing client which doe
