[SQL] sum query

2004-12-03 Thread Keith Worthington
Hi All, I am trying to join three tables and sum the quantities. The first table contains all of the possible items. The second table contains orders and the third table contains the items on each order. For all items found in tbl_item I need the total quantity on open orders. If an item is no

Re: [SQL] grouping a many to many relation set

2004-12-03 Thread Johan Henselmans
On 2-dec-04, at 3:45, Michael Fuhr wrote: On Wed, Dec 01, 2004 at 06:57:54AM +0100, Johan Henselmans wrote: Richard Huxton wrote: I think what's missing here is the explicit statement of which group these belong in. Without a value to sort/group by, there's nothing for your queries to "get a grip

Re: [SQL] Failed system call was shmget(key=1, size=1155072, 03600).

2004-12-03 Thread Andrew Sullivan
On Fri, Dec 03, 2004 at 09:00:53AM +, Andrew M wrote: > DETAIL: Failed system call was shmget(key=1, size=1155072, 03600). > HINT: This error usually means that PostgreSQL's request for a shared > memory segment exceeded available memory or swap space. To reduce the > request size (currentl

Re: [SQL] Failed system call was shmget(key=1, size=1155072, 03600).

2004-12-03 Thread Achilleus Mantzios
O Andrew M έγραψε στις Dec 3, 2004 : > Hi, > when building postgreSQL 8 I get the following error message: > > DETAIL: Failed system call was shmget(key=1, size=1155072, 03600). > HINT: This error usually means that PostgreSQL's request for a shared > memory segment exceeded available memory o

[SQL] Failed system call was shmget(key=1, size=1155072, 03600).

2004-12-03 Thread Andrew M
Hi, when building postgreSQL 8 I get the following error message: DETAIL: Failed system call was shmget(key=1, size=1155072, 03600). HINT: This error usually means that PostgreSQL's request for a shared memory segment exceeded available memory or swap space. To reduce the request size (currentl