Scott,
Le mercredi 7 Avril 2004 22:13, scott.marlowe a écrit :
> On Wed, 7 Apr 2004, [iso-8859-15] Hervé Piedvache wrote:
> >
> > I have a database with one table with about 22 millions records.
> > I have a script every day wich insert about 200 000 records ...
> > Sometime my script takes 4 hour
My thoughts in a perfect world for having oracle style jobs in postgresql
would be a very loud yes. In the world called reality I say why waste
precious time on something that can already be accomplished by other means.
This feature at this time would just be icing on an already tasty cake.
T
Bruce Momjian wrote:
Uh, we have EXECUTE, but I don't know if will allow you to set a local
variable. Maybe you can do:
execute doesn't support select into
Mage
---(end of broadcast)---
TIP 7: don't forget to increase your free space ma
Gregory Wood wrote:
Jan Wieck wrote:
Gregory Wood wrote:
The only real advantage I see are for those people in hosting
environments that don't really have access to cron. I suppose it's
also valuable in making your scripts more portable as you wouldn't
need to make further alterations to the sy
Shanmugasundaram Doraisamy <[EMAIL PROTECTED]> writes:
> Thanks for all your support to my previous
> postings. I am currently using Postgresql 7.3.4-2PGDG. The problem I
> am facing is that when I take a dump of the DB using pg_dump and restore
> it using the cat pg_dump_
--- Mage <[EMAIL PROTECTED]> wrote:
> Bruce Momjian wrote:
>
> >
> >Uh, we have EXECUTE, but I don't know if will allow
> you to set a local
> >variable. Maybe you can do:
> >
> >
> execute doesn't support select into
It does, if you use the "for variablename in execute
..." syntax. Which may
Problem:
pg_loopen() unable to open PostgreSQL large object in...
Solution from another mailing list:
My blob oid was very big.
I had to cast to (float) the oid parameter of pg_loopen.
Question:
The oid is a type, isn't it?
I tried to use the oid in a function:
CREATE FUNCTION addfoto(character var
Bruce Momjian wrote:
Mage wrote:
Hello,
is there any variable variable syntax or function in plpgsql? I didn't
find it.
I mean something like: magic(''new.'' || TG_ARGV[0]) = 5;
Uh, we have EXECUTE, but I don't know if will allow you to set a local
variable. Maybe you can do:
EXECUT
On Thursday 08 April 2004 15:21, Sky wrote:
> Problem:
> pg_loopen() unable to open PostgreSQL large object in...
>
> Solution from another mailing list:
> My blob oid was very big.
> I had to cast to (float) the oid parameter of pg_loopen.
Sorry, bigger than what? Why float?
> Question:
> The oi
Marek Lewczuk <[EMAIL PROTECTED]> writes:
> On Apr 5, 2004, at 2:03 PM, Gavin M. Roy wrote:
>
> > I'm one for using base64 encoded text in a text field. It's easy to
> > deal with queries, it's easy to deal with spitting out images, and
> > it's easy to back up. Others do it differently, there
Mike Nolan <[EMAIL PROTECTED]> writes:
> > There's no reason you couldn't write a cron daemon that retrieved its list of
> > jobs from an SQL database. In fact we discussed doing exactly this at my last
> > job. I expect others have thought of the same idea and wouldn't be surprised
> > if it exis
Hi!!
I am trying to store a picture into pg database. I am usig delphi and
ZeosDBO. I convert the picture into base64 text to send to database but when
I do this I get this error trying to do insert :
SQL:Error pqreadData()
Read()--failed: errno=0
No error
I test using Pgexplorer, this use libp
(sorry for the double post if there is one - i sent the mail to the
lisyt from the wrong address)
Hi,
Im passing this in the commmand line to start up the PostgreSQL server:
./pg_ctl start -w -D /Volumes/GROUCH\ 2/Database3
but its always giving me this error:
./postmaster: invalid argument:
Richard Huxton írta:
On Thursday 08 April 2004 15:21, Sky wrote:
Problem:
pg_loopen() unable to open PostgreSQL large object in...
Solution from another mailing list:
My blob oid was very big.
I had to cast to (float) the oid parameter of pg_loopen.
Sorry, bigger than what? Why float?
W
I just ran across a situation where I dropped a table that had a
trigger created on it. The system let me drop the table without
complaining and then I realized/remembered that the trigger also
existed. I tried dropping the trigger, but of course that couldn't be
done because the target relat
Can someone explain why the latter query uses an index scan while the
former uses a sequence scan? I have tried all sorts of casting in the
first case but I cannot get the index scan.
Cheers,
Randall
==
data=> EXPLAIN ANALYZE SELECT acqtimestamp FROM aux_datarecord where
acqtimestamp between (
Greg Stark wrote:
Mike Nolan <[EMAIL PROTECTED]> writes:
> There's no reason you couldn't write a cron daemon that retrieved its list of
> jobs from an SQL database. In fact we discussed doing exactly this at my last
> job. I expect others have thought of the same idea and wouldn't be surprised
>
I just sent this twice before with the wrong email address so it didn't go through, that is why I am sending this so that it will get through. I hope this isn't causing issues.
Hi guys. I certainly hope this is the correct place to email this. I'm having an issue that I have really tried to
Clark Endrizzi said:
> I just sent this twice before with the wrong email address so it didn't
> go through, that is why I am sending this so that it will get through.
> I hope this isn't causing issues.
>
> Hi guys. I certainly hope this is the correct place to email this. I'm
> having an iss
19 matches
Mail list logo
