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
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
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.
-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
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
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
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 |
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
-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
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:
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
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
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
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
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
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)
16 matches
Mail list logo