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
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 g
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 recent
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 ha
> 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 kno
"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 l
> -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:
> I think in 7.2 such conversions were allowed silently, but we
> have reduced the number of implicit type coercions.
I'm sensing some brain damage going on here...
DB=# select round(100::int, 2);
round
100.00
(1 row)
And...
DB=# create temp table test2(field1 float, field2 decima
"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;
> E
"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 a
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 checke
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
> LD_LIBRARY_PATH=/usr/lo
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 l
I have a query like this:
SELECT ... FROM u, d WHERE d.ukey = u.ukey AND 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)
17 matches
Mail list logo
