Re: [GENERAL] ERROR: Failed to build any 5-way joins

Steve Atkins wrote: On Apr 21, 2007, at 3:41 PM, Tom Lane wrote: "Raymond O'Donnell" <[EMAIL PROTECTED]> writes: I've just run into the above error (with the additional message "SQL state XX000"). Funny thing is, when I change the join (between the views) either to an INNER JOIN or a RIGHT JO

Re: [GENERAL] ERROR: Failed to build any 5-way joins

On Apr 21, 2007, at 3:41 PM, Tom Lane wrote: "Raymond O'Donnell" <[EMAIL PROTECTED]> writes: I've just run into the above error (with the additional message "SQL state XX000"). Funny thing is, when I change the join (between the views) either to an INNER JOIN or a RIGHT JOIN, the query works

Re: [GENERAL] PostgreSQL configuration

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/21/07 15:06, Leticia wrote: > Hi Community, > > I have a server with Linux Fedora Core 6 and PostgreSQL 8.2.3. > The server has 4 G of RAM > > I want to configure 1.2 G de RAM only for PostgreSQL. Which could > be a good setting? > > When I tr

Re: [GENERAL] large table problem

On Fri, 20 Apr 2007, Jason Nerothin wrote: I'm trying to work my way around a large query problem. Not too unexpectedly, the app server (EJB3/JPA) is choking on the queries which are "unnamed native queries" in Java parliance. Work-around attempt 1 was to call directly to the JDBC driver, but

Re: [GENERAL] ERROR: Failed to build any 5-way joins

"Raymond O'Donnell" <[EMAIL PROTECTED]> writes: > I've just run into the above error (with the additional message "SQL > state XX000"). > Funny thing is, when I change the join (between the views) either to an > INNER JOIN or a RIGHT JOIN, the query works - it only goes belly-up when > I try a L

[GENERAL] ERROR: Failed to build any 5-way joins

Hi all, I've just run into the above error (with the additional message "SQL state XX000"). I see from the following thread from 2003 - http://archives.postgresql.org/pgsql-sql/2003-12/msg00111.php - that at the time it was considered a bug. I'm wondering if it was fixed, or am I doing som

Re: [GENERAL] Problem compiling PostgreSQL 8.2.3 on RedHat Enterprise Server 2.1?

On Sat, 21 Apr 2007 12:01:46 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > =?UTF-8?Q?Bj=C3=B8rn?= T Johansen <[EMAIL PROTECTED]> writes: > > When I try to compile I get the following error...: > > /usr/bin/ld:exports.list:1: parse error in VERSION script > > collect2: ld returned 1 exit status > > m

[GENERAL] permissions

I am not sure how the permissions work anymore. What I want to do is create a database and have a user create all the tables and rules. I created the database from user postgres. I then set the owner of the database to my userid my userid created a number of tables and rules. I then tried to

[GENERAL] PostgreSQL configuration

Hi Community, I have a server with Linux Fedora Core 6 and PostgreSQL 8.2.3. The server has 4 G of RAM I want to configure 1.2 G de RAM only for PostgreSQL. Which could be a good setting? When I try to run a join of three tables, PostgreSQL seems to b

Re: [GENERAL] Regular Expression Data Type

On Apr 21, 2007, at 11:01 , Richard Doust wrote: select price from shipping_prices where shipFromZip = '23773' and shipToZip ~ '87927' because shipToZip is defined as a regular expression, I'd match a row where shipToZip held the value '879[0-9]{2,2}' or '87[0-9]*'. Wouldn't that be cool

Re: [GENERAL] Regular Expression Data Type

Richard Doust <[EMAIL PROTECTED]> writes: > What I'd like to be able to do is to define a field in the database > as a regular expression so that when I select, i.e., > select price from shipping_prices where shipFromZip = '23773' and > shipToZip ~ '87927' > because shipToZip is defined as a

Re: [GENERAL] Problem compiling PostgreSQL 8.2.3 on RedHat Enterprise Server 2.1?

=?UTF-8?Q?Bj=C3=B8rn?= T Johansen <[EMAIL PROTECTED]> writes: > When I try to compile I get the following error...: > /usr/bin/ld:exports.list:1: parse error in VERSION script > collect2: ld returned 1 exit status > make[3]: *** [libpq.so.5.0] Error 1 That ancient version of ld doesn't understand

[GENERAL] Regular Expression Data Type

Hi. I appreciate that I can query the database and find records that match a regular expression. What I'd like to be able to do is to define a field in the database as a regular expression so that when I select, i.e., select price from shipping_prices where shipFromZip = '23773' and shipTo

Re: [GENERAL] [HACKERS] functions to obtain query plan

On Apr 21, 2007, at 4:46 , sharath kumar wrote: For a particular query, are there any functions which can give me the start-up cost, total run-cost, number of rows and width? -hackers is a list for discussion of development of PostgreSQL itself. Your question would probably be more appropr

Re: [GENERAL] Modify existing index

am Sat, dem 21.04.2007, um 0:20:45 -0700 mailte RPK folgendes: > > How to see the details of indexes being used by a table? If I want to drop an Within psql, type '\d '. > index, how can I do that? DROP , perhaps with option CASCADE. Please read our documentation... Andreas -- Andreas Kr

[GENERAL] Problem compiling PostgreSQL 8.2.3 on RedHat Enterprise Server 2.1?

When I try to compile I get the following error...: gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -fno-strict-aliasing -fpic -DFRONTEND -I. -I../../../src/include -D_GNU_SOURCE -I../../../src/port -c -o pgstrcasecmp.o pgstrcasecmp.c rm -f thread.c && ln -s ../../../src/port/thre

Re: [GENERAL] Modify existing index

How to see the details of indexes being used by a table? If I want to drop an index, how can I do that? >The choice of what your primary key is should arise from the schema >design, not the frequency of queries. If you are querying columns >other than the primary key, just add another index.