I never knew running indent was so damn complicated. All three of my
development systems can not manage it without throughing a fault (I've
absolutely no idea why indent in the shell works but doesn't in pgindent on
one).
Anyway, has anyone pgindented the version of tsearch2 that runs with 7.3.4
Hi all,
I want to take backup of our online system on daily basis using
crontab. But actually the pg_hba.conf is configured with password
security.
How I can take the backup without setting password. Or is their any
other
way to take backup.
TIA
regards,
Deepa K
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
"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, an
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
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 ou
expect <[EMAIL PROTECTED]> writes:
> I do have a problem with my address out there in
> the free and clear.
Get a life (or at least a spam-blocker). What other lists can you
name that have the policies you think are "responsible"?
regards, tom lane
-
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 t
> 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 wit
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? Specifi
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 TYP
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]
--
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.
+1-503-222
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 t
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
"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 c
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 need,
>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 sign
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. My
- 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 a
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.
Using eRserver may help you work around the problem, given certain
conditions. It doesn't solve it. I think if we can get Mr. Drak
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 perl
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 muc
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 a
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
star
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 fore
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.
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.
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 ?
Thank
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
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 r
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 clie
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 is
Hello,
Yes that would be expected. I was figuring the first 2k would be the
diagnostics/development
of that plan so that we would have a real idea of what the programmers
think it would take. Thus
the statement of the next 5 months etc..
J
Network Administrator wrote:
That sounds good save t
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'
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 m
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.
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
> Whe
38 matches
Mail list logo
