Re: [SQL] how to download linux 7.3 image

2007-07-23 Thread Aarni Ruuhimäki
On Monday 23 July 2007 01:03, Jean-David Beyer wrote: Mohd Ghalib Akhtar wrote: how to download linux 7.3 image file(means os) ? If you want a Red Hat looking product, you should consider running the latest version of Fedora. You might also want to try CentOs, 'an Enterprise-class Linux

Re: [SQL] Database Synchronization

2007-07-23 Thread Jyoti Seth
Hello, When I am installing slony-I from rpm's available at the following url:http://main.slony.info/downloads/1.2/rpm/ it is giving an error: There are no installable providers of postgresql-slony1-engine. In our system postgresql has been installed through YAST. So when we try to install and

Re: [SQL] The nested view from hell - Restricting a subquerry

2007-07-23 Thread Gregory Stark
Nis Jørgensen [EMAIL PROTECTED] writes: Well, the query can be satisfied by looking only at the rows with an order_id matching the invoice_id given. The condition that this is the largest invoice in the group then needs to be checked afterwards. I certainly did not expect the query planner

Re: [SQL] The nested view from hell - Restricting a subquerry

2007-07-23 Thread Nis Jørgensen
Gregory Stark skrev: 1. Look up all order_ids for which (order_id,my_invoice_id) appear in eg_orders 2. Find all rows (in both branches of the UNION) with these id_s 3. Group the rows, and calculate max(invoice_id) 4. Filter the result rows on max(invoice_id) = my_invoice_id. So here's

Re: [SQL] The nested view from hell - Restricting a subquerry

2007-07-23 Thread Gregory Stark
Gregory Stark [EMAIL PROTECTED] writes: Nis Jørgensen [EMAIL PROTECTED] writes: 1. Look up all order_ids for which (order_id,my_invoice_id) appear in eg_orders 2. Find all rows (in both branches of the UNION) with these id_s Oh, did you mean look up the order_ids for which there was at

Re: [SQL] Database Synchronization

2007-07-23 Thread Andrew Sullivan
On Mon, Jul 23, 2007 at 02:55:21PM +0530, Jyoti Seth wrote: In our system postgresql has been installed through YAST. So when we try to install and configure slony-I through source, it gives the message please make sure tp build and install postgresql from the sources first. You _might_ be