I have a bunch of data in Sybase and some of it is in image fields. We
use bcp on this data transparently all the time without major issues in
character mode. Is there a fundamental technical reason that BLOBs
can't be COPY'd in postgresql or is it just that nobody has ever wanted
to before?
If I'm not mistaken you have an infinit recursion because you are always
pulling the same id (whatever _id starts at) throughout each function call.
Postgres is most likely killing the functions when it's hits some stack
or memory limit.
Mark Cave-Ayland wrote:
Hi everyone,
I'm trying to write
"Mark Cave-Ayland" <[EMAIL PROTECTED]> writes:
> I'm trying to write a recursive plpgsql function in PostgreSQL 7.4.2
> that given a tree node id (ictid) will return all the nodes below it in
> the tree, one row per node. When I try and execute the function I get
> the following error message:
You
Hi everyone,
I'm trying to write a recursive plpgsql function in PostgreSQL 7.4.2
that given a tree node id (ictid) will return all the nodes below it in
the tree, one row per node. When I try and execute the function I get
the following error message:
CONTEXT: PL/pgSQL function "findsubcategori
On Tue, 2004-08-03 at 05:57, Kay-Uwe Genz wrote:
>
> But pg_user is a view and cant referenced. So I try to use pg_shadow,
> but PG say that this is an System table and I cant use it.
so you real question is probably:
how can i modify the structure of system tables ?
you do not say what your ult
Interesting, IBM is saying that the code is worth 85M dollars!
On Wed, 2004-08-04 at 00:19, Scott Ribe wrote:
> > I could be reading it incorrectly, but the paragraph was outside any
> > attributed quote:
>
> You are correct that the specific comment about pg not thriving was outside
> any quotes
Hi,
I am adding image and large object support in my Cocoa
postgresql browser.
Are there going to be any enhanced bytea support functions
coming along?
It seems sorta silly to have to write customized C code
to import a file into a bytea field.
Maybe something like
CREATE TABLE image (
name
On Wed, 2004-08-04 at 03:28, Jay wrote:
> hi people,
> i am using mysql and i am having the following problem
> I know this is not the correct to ask this problem.
Surely a MySQL mailing list could have answered this? I thought they
had good community support.
> but i am need of
> help urg
I have given the requested info below, but read this first:
1) Check the permissions on the backup file, ensure that the user permissions are
such that the
system user you are trying to restore with has permission to read the file
2) Look at the actual backup file, ensure that there is a backup
I am trying to get an hourly backup of postgres. I tried using the
script below
but when I try to restore off the dumped file it throws an error that
says it
cannot read the data [-1]. If I just type in pg_dump -Fc --file=***
username= database
it restores fine. So something is going on wi
> sort_mem = 5
That is way, way too large. Try more like 5000 or lower.
> num_poste | numeric(9,0)| not null
For starters numerics are really, really slow compared to integers. Why
aren't you using an integer for this field since youhave '0' decimal
places.
> sche
>Content-class: urn:content-classes:message
>MIME-Version: 1.0
>Subject: RE: [PERFORM] Tuning queries on large database
>X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0
>Date: Wed, 4 Aug 2004 09:06:54 -0400
>X-MS-Has-Attach:
>X-MS-TNEF-Correlator:
>Thread-Topic: [PERFORM] Tuning queries on
>
> The result is that for "short queries" (Q1 and Q2) it runs in a few
> seconds on both Oracle and PG. The difference becomes important with
> Q3 : 8 seconds with oracle
> 80 sec with PG
> and too much with Q4 : 28s with oracle
>17m20s with PG !
>
> Of course when I
Hi,
I have some problem of performance on a PG database, and I don't
know how to improve. I Have two questions : one about the storage
of data, one about tuning queries. If possible !
My job is to compare Oracle and Postgres. All our operational databases
have been running under Oracle for about
Hello,
my web application grows slower and slower over time. After some
profiling I came to the conclusion that my SQL queries are the biggest
time spenders (25 seconds). Obviously I need to optimise my queries and
maybe introduce some new indexes.
The problem is, that my application uses dynam
The problem is that postgres has failed to thrive as a web based back end database.
Ever heard of
the LAMP soluton? Linux + Apache + Mysql + Php. Its unfortunate, but real. Its easy
to find
hosting with Mysql db, its not as easy (although getting more common I think) to find
hosting with
Pos
Gunasekaran Balakrishnan wrote:
> Hi,
>
> I see that one of the bug fixes in 7.4.3 is:
>
> "Fix temporary memory leak when using non-hashed aggregates (Tom)"
>
> I am still using 7.4.2, and want to find out if I need to upgrade to 7.4.3.
>
> I did not quite understand the bug, or find a wa
--On Dienstag, August 03, 2004 20:51:45 -0600 Scott Marlowe
<[EMAIL PROTECTED]> wrote:
On Tue, 2004-08-03 at 13:05, CSN wrote:
Just wondering, is updateable views slated for a
future version of Postgresql? In addition to using
rules that is.
It's on the todo list. Of course, the just means someo
Hi,
I see that one of the bug fixes in 7.4.3 is:
"Fix temporary memory leak when using non-hashed aggregates (Tom)"
I am still using 7.4.2, and want to find out if I need to upgrade to 7.4.3.
I did not quite understand the bug, or find a way to re-produce this in the
mailist archives.
19 matches
Mail list logo
