Re: [GENERAL] using Postgres to store many small files

2004-03-04 Thread Richard Huxton
On Thursday 04 March 2004 01:03, Matthew Hixson wrote: [snip] I recently discovered the Hibernate project and was pleasantly surprised how simple it was to store an image in Postgres as a bytea using Hibernate's BLOB support. I'm wondering if Postgres would have any problem handling all of

[GENERAL] Are Postgres 7.4.1 RPMs available for SuSE 9.0 ?

2004-03-04 Thread Gellert, Andre
Hi everybody, currenty we use Suse Linux 9 and the rpms with 7.4.0 downloaded from ftp://ftp.gmd.de/mirrors2/suse/ftp.suse.com/people/max/postgresql-7.4/ . I don't know how to contact the person who build this rpms , and i cannot find other resources on the web, so does anyone know a place to

Réf. : Re: [GENERAL] SPI memory managment issue

2004-03-04 Thread bsimon
after investigation, I have to reformulate : The actual memory is freed after each call of spi_finish, which is cool. However the global amount of virtual memory used by the process does not decrease until the last spi_finish. I get : ERROR: out of memory DETAIL: Failed on request of size 10.

[GENERAL] META: Filtering viruses/worms

2004-03-04 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 X-Virus-Scanned: by amavisd-new at postgresql.org Since amavisd does not appear to be catching the latest worm, how about filtering on size? Anything, say, over 20K will be held for approval. Here are the top posts by size to this list

Re: [GENERAL] Moving from MySQL to PGSQL....some questions (multilevel

2004-03-04 Thread Michael Chaney
On Thu, Mar 04, 2004 at 10:50:50AM -0500, Tom Lane wrote: If I understood the requirements correctly, it might be sufficient to put a unique index on (id1,id2). If two transactions simultaneously try to insert for the same id1, one would get a duplicate-index-entry failure, and it would have

Re: [GENERAL] ERROR: function round(double precision, integer) does

2004-03-04 Thread Glen Parker
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joshua D. Drake oms=# select round(1.25::decimal, 2); round --- 1.25 (1 row) BUT. DB=# select round(1.25::float, 2); select round(1.25::numeric, 2); Yeah I know, but in the interest

Re: [GENERAL] ERROR: function round(double precision, integer) does not exist - WTF?

2004-03-04 Thread Tom Lane
Glen Parker [EMAIL PROTECTED] writes: DB=# select round(1.25::float, 2); ERROR: function round(double precision, integer) does not exist What the heck? This can't be right... Can it? regression=# \df round List of functions Result data type | Schema | Name |

Re: [GENERAL] REFERENCES error message complaint, suggestion

2004-03-04 Thread Karl O. Pinc
On 2004.03.04 17:19 Greg Stark wrote: Greg Stark [EMAIL PROTECTED] writes: It's great to know which constraint was violated but that doesn't really help you figure out *why* it was violated. On further thought it would never be feasible to do what the other poster is really looking for. At

Re: [GENERAL] ERROR: function round(double precision, integer) does not exist - WTF?

2004-03-04 Thread Dann Corbit
-Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Thursday, March 04, 2004 6:18 PM To: Glen Parker Cc: Pg-General Subject: Re: [GENERAL] ERROR: function round(double precision, integer) does not exist - WTF? Glen Parker [EMAIL PROTECTED] writes: DB=# select

Re: [GENERAL] ERROR: function round(double precision, integer) does

2004-03-04 Thread Tom Lane
Glen Parker [EMAIL PROTECTED] writes: This popped up because we're doing dev work against a 7.4 server but deploying against a 7.2 server. To make matters worse, here's one of the errors we get on 7.2 after doing the casts and re-deploying: DB=# select 1234::numeric 1234::float; ERROR:

Re: [GENERAL] ERROR: function round(double precision, integer) does not exist - WTF?

2004-03-04 Thread Tom Lane
Glen Parker [EMAIL PROTECTED] writes: When I say it's broken though, I'm talking more specifically about trying to use round(float, int); is there some reason that this function overload should not exist in the absence of an implicit float-numeric cast? Send a patch ... I don't recall anyone

[GENERAL] Tom Lane heads up

2004-03-04 Thread DeJuan Jackson
Just dropping a quick not for Tom Lane. I sent a personal message today, but I wasn't sure if you'd get it after I remembered all of the spam filters you've got set up. Sorry for the off topic post. ---(end of broadcast)--- TIP 5: Have you

Re: [GENERAL] Setting up Postgresql on Linux

2004-03-04 Thread scott.marlowe
On Thu, 4 Mar 2004, phil campaigne wrote: Hello, when I login to linux and check the env's I see: PATH=/usr/local/pgsql/bin:/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin:/home/postgres/bin:/opt/IBMJava2-14/bin:/opt/IBMJava2-14/jre/bin:/usr/local/pgsql/bin

[GENERAL] building 7.4.1 (on linux) with --disable-shared

2004-03-04 Thread David Garamond
Does it currently work? src/backend/utils/mb/conversion_procs/*/ is not building anything, and 'make install' fails because it tries to copy *.so files. -- dave ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] building 7.4.1 (on linux) with --disable-shared

2004-03-04 Thread Tom Lane
David Garamond [EMAIL PROTECTED] writes: Does it currently work? src/backend/utils/mb/conversion_procs/*/ is not building anything, and 'make install' fails because it tries to copy *.so files. For sufficiently small values of current, it builds. You do realize you won't have any PL

[GENERAL] performance problems: join conditions

2004-03-04 Thread Joseph Shraibman
I have a query like this: SELECT ... FROM u, d WHERE d.ukey = u.ukey AND restrictions on u AND (d.status = 3 OR (u.status = 3 AND d.status IN(2,5))); explain shows: - Aggregate (cost=126787.04..126787.04 rows=1 width=4) - Hash Join (cost=39244.00..126786.07 rows=387 width=4)