Hi,
Command Prompt will set up an escrow account online at www.escrow.com.
When the Escrow account totals 2000.00 and is released, Command Prompt
will dedicate a programmer for one month to debugging, documenting,
reviewing, digging, crying, screaming, begging and bleeding with the
code. At
Thanks to Alvaro H. and Joshua D. for pointing me to pg_proc.
The function I was looking for is an overloaded one, so in my query of
pg_proc I had to specify the signature of the one that I wanted.
My favorite page, for today:
http://www.postgresql.org/docs/7.3/static/catalogs.html
-David
hi,
you are right: I wrote it in wrong way. psql is a client program, but he
wants to get the file not from the place where psql runs.
He says:
but i want to execute this script from the client and so my blob-data
is on the client and lo_import fails (the server doesn't have this file).
That's
In the last exciting episode, [EMAIL PROTECTED] (David Link) wrote:
Why does adding SUM and GROUP BY destroy performance?
When you use SUM (or other aggregates), there are no short cuts to
walking through each and every tuple specified by the WHERE clause.
On some systems there are statistics
Sounds good to me. I can throw in $500 to start.
On Wednesday, September 17, 2003, at 12:06 PM, Joshua D. Drake wrote:
Hello,
O.k. here are my thoughts on how this could work:
Command Prompt will set up an escrow account online at www.escrow.com.
When the Escrow account totals 2000.00 and
Yes thats it.
Ok - one last question.
My Script looks like this and actually i can run it only on the server (so i have to
copy all my data to the server each time i want to update my blobs):
INSERT INTO tablexy (BLOBFIELD) VALUES (lo_import('BLOBFILE')).
Now we know if I want to upload a
Yes thats it. Thanks.
Am Mi, 2003-09-17 um 22.42 schrieb Doug McNaught:
Daniel Schuchardt [EMAIL PROTECTED] writes:
Hi @ all,
i'm sure there was a psql-function to transfere my Blob-Data to the
server but I can't remember.
The psql function to use is \lo_import--this reads the file
Ron Johnson wrote:
On Thu, 2003-09-18 at 03:23, Gaetano Mendola wrote:
Ron Johnson wrote:
PostgreSQL does not do horizontal scaling at all, since the postmaster
can only run on 1 CPU, but it's good at vertical scaling, since it
can make use of all of the CPUs in a box. (Well, there's sure to
be
Hi,
hi have a table with 2.5 million records which i try do delete. i have
several constraints on it too.
i tried to delete the records using delete but it does not seem to work.
the delete runs forever. hrs...
i cannot truncate it as it complains about foreign keys.
What is the problem ?
Not sure about 2.5 million records but try running VACUUM ANALYSE
before the delete and during (every now and then).
Had the same problem with 100,000 records and it did the trick nicely.
Hi,
hi have a table with 2.5 million records which i try do delete. i have
several constraints on it too.
Daniel Schuchardt [EMAIL PROTECTED] writes:
So I have to do 2 steps manually in psql:
\lo_import(ClientFile) - Returns OID
INSERT INTO tablexy (BLOBFIELD) VALUES (Returned OID)
Is there a way to do this automatically?
See psql's :LASTOID (I think that's the name) variable.
Alex [EMAIL PROTECTED] writes:
hi have a table with 2.5 million records which i try do delete. i have
several constraints on it too.
i tried to delete the records using delete but it does not seem to work.
the delete runs forever. hrs...
i cannot truncate it as it complains about foreign
Marc G. Fournier wrote:
And that has nothing to do with user need as a whole, since the care
level I mentioned is predicated by the developer interest level.
While I know, Marc, how the whole project got started (I have read the
first posts), and I appreciate that you, Bruce, Thomas, and Vadim
On Thu, 18 Sep 2003, Lamar Owen wrote:
Huh? I have no disagreement that upgrading is a key feature that we are
lacking ... but, if there are any *on disk* changes between releases, how
do you propose 'in place upgrades'?
RTA. It's been hashed, rehashed, and hashed again. I've asked
On Thursday, September 18, 2003, at 12:11 PM, Lamar Owen wrote:
RTA. It's been hashed, rehashed, and hashed again. I've asked twice
if eRserver can replicate a 7.3 database onto a 7.4 server (or a 7.2
onto a 7.3); that question has yet to be answered. If it can do this,
then I would be a
Thanks Ron, Thanks Christopher for your excellent feedback.
I guess it's back to the drawing board. This is a very late hour
business requirement change. And we need quick real-time results.
Two things are being considered:
1. loading the non aggregate query entirely into memory (using
Andrew Rawnsley wrote:
eRserver should be able to migrate the data. If you make heavy use of
sequences, schemas and other such things it won't help you for those.
snip
Using eRserver may help you work around the problem, given certain
conditions. It doesn't solve it. I think if we can get Mr.
- Original Message -
From: Daniel Schuchardt [EMAIL PROTECTED]
To: Doug McNaught [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 4:44 PM
Subject: Re: [GENERAL] psql and blob
Yes thats it.
Ok - one last question.
My Script looks like this and actually i can
If bugfixes were consistently backported, and support was provided for
older versions running on newer OS's, then this wouldn't be as much of
a problem. But we orphan our code afte one version cycle; 7.0.x is
completely unsupported, for instance, while even 7.2.x is virtually
unsupported.
Restrictions in the Mac OS X implementation of shmget limit Postgres to 2MB
of shared buffers. This could be a problem for large databases and/or heavy
activity.
http://www.postgresql.org/docs/7.3/interactive/kernel-resources.html
These directions are sufficient to increase shared buffers
We are looking for information regarding any capabilities of PostgreSQL in regards to
scalability. Ideally we want to be able to scale in both directions. What sort of
solutions are out there for either or both directions of scalability? Specifically,
open-source solutions would be most in
Joshua D. Drake [EMAIL PROTECTED] writes:
If you want to have continued support for an older rev, purchase a
commercial version. I am not trying to push my product here, but frankly
I think your argument is weak. There is zero reason for the community to
support previous version of code.
Hi!
I have a trigger using a update but this doestn work into trigger but if I
execute the update from pgadmin this works perfectely.
This is the code
select into registro * from t_pagos_comisiones where f_wholetipoagnivel =
who and f_fecha = $4 for update;
IF FOUND THEN
IF ($5 0) THEN
Hello list,
That's the question, what is the equivalent data type of the msSQL image
data type ?
TIA,
--
Josué Maldonado.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
Hello,
I think the below just about says it all:
http://www.commandprompt.com/images/mammoth_versus_dolphin_500.jpg
Sincerely,
Joshua Drake
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
Joshua D. Drake wrote:
Hello,
I think the below just about says it all:
http://www.commandprompt.com/images/mammoth_versus_dolphin_500.jpg
Sincerely,
Joshua Drake
Too bad the symbol of Oracle Corp. isn't a peanut...
Mike Mascari
[EMAIL PROTECTED]
Josué Maldonado wrote:
Hello list,
That's the question, what is the equivalent data type of the msSQL image
data type ?
You can use 'bytea' for binary data. You can use 'text' and base64
encode the image before insertion. You can, of course, create your own
'image' type using CREATE TYPE.
On Thu, 18 Sep 2003, Duffey, Kevin wrote:
We are looking for information regarding any capabilities of PostgreSQL
in regards to scalability. Ideally we want to be able to scale in both
directions. What sort of solutions are out there for either or both
directions of scalability?
I think the below just about says it all:
http://www.commandprompt.com/images/mammoth_versus_dolphin_500.jpg
Hey Josh, what about some t-shirts with this on the back and some
snappy verbiage above/below the image? Just a thought, but maybe
that's something the advocacy team could run with
Andrew Rawnsley [EMAIL PROTECTED] writes:
Sequence information is stored in their individual 1-row tables, with
an entry is pg_class of relkind 'S'. So you can't
really get a list of sequences with last_value in a single query
Nope, you can't ... and I surely hope you weren't expecting that
On Thu, Sep 18, 2003 at 20:59:53 -0700,
expect [EMAIL PROTECTED] wrote:
I had no idea that my address was being broadcast to the world via
comp.databases.postgresql.general I have no problem with having messages sent
to the list go to the group. I do have a problem with my address out
scott.marlowe [EMAIL PROTECTED] writes:
... Being honest and fair will win
hearts and minds, and when they need the Saturn 4 instead of the Estes
rocket, they'll remember who to come to.
I like this analogy, though maybe you've overstretched. Perhaps:
MySQL = Estes. Put in InnoDB, and you
Oh, its a sticky problem, to be sure. Have to get something working at
some point, though...
You're point about approximate solutions is well taken.
On Friday, September 19, 2003, at 01:11 AM, Tom Lane wrote:
Andrew Rawnsley [EMAIL PROTECTED] writes:
On Friday, September 19, 2003, at 12:21 AM,
On Friday, September 19, 2003, at 12:21 AM, Tom Lane wrote:
Andrew Rawnsley [EMAIL PROTECTED] writes:
Sequence information is stored in their individual 1-row tables, with
an entry is pg_class of relkind 'S'. So you can't
really get a list of sequences with last_value in a single query
Nope, you
34 matches
Mail list logo