Thanks for all of the replies. I recompiled my DB with plperlu and am using perl's sleep function.
I agree that a basic function (non-CPU intensive sleep) like this should be built in.
Thanks again.
-Don
On 8/21/05, John DeSoi <[EMAIL PROTECTED]> wrote:
On Aug 21, 2005, at 5:09 PM, Guido Barosi
On Mon, Aug 22, 2005 at 08:34:29AM -0500, Don Drake wrote:
> I agree that a basic function (non-CPU intensive sleep) like this should be
> built in.
It's being discussed in pgsql-hackers:
http://archives.postgresql.org/pgsql-hackers/2005-08/msg00633.php
Do you have any use cases in addition to
Michael Fuhr wrote:
> On Mon, Aug 22, 2005 at 08:34:29AM -0500, Don Drake wrote:
> > I agree that a basic function (non-CPU intensive sleep) like this should be
> > built in.
>
> It's being discussed in pgsql-hackers:
>
> http://archives.postgresql.org/pgsql-hackers/2005-08/msg00633.php
>
> Do
Hello,
I am using postgresql 7.4.5, and was having some trouble with the
initcap() function. The problem was the following:
initcap('aéeou') = AéEou,
and I need
initcap('aéeou') = Aéeou,
I found in the documentation that to correct this behaviour, I must
run initdb --locale=SOMETHING.
Well, I di
On Mon, Aug 22, 2005 at 11:10:54AM -0300, Maxi Combina wrote:
[must run initdb to switch locale]
>
> Is there any shorter way to change the locales? I didnot found any
> `recreate' or `regenerate' command.
No, initdb is the only option.
--
Alvaro Herrera ()
"El número de instalaciones de UNIX
Sean Chittenden <[EMAIL PROTECTED]> writes:
> Today I was charged with fixing a DB, and upon looking into it, I
> discovered that there was gigs upon gigs of the errors from below.
> Has anyone seen this or, more interesting to me, recovered from this
> kind of a failure mode?
> Here's a bit of ba
Tom Lane wrote:
> Bruce Momjian writes:
> > Michael Fuhr wrote:
> >> Do you have any use cases in addition to what's already been
> >> mentioned? Sleeping isn't really a database operation, so there
> >> needs to be some justification for making it a standard function.
>
> > Well, we needed it f
Bruce Momjian writes:
> Michael Fuhr wrote:
>> Do you have any use cases in addition to what's already been
>> mentioned? Sleeping isn't really a database operation, so there
>> needs to be some justification for making it a standard function.
> Well, we needed it for our own regression tests, s
Hi,
I would like to know how to connect to postgres from
shell scripts using a password protected user.
Is there a way to embed the password in psql login.
It keeps prompting for the passwords.
Any hint is appreciated.
Thanks
Priya
Hi all,
I have the following question.
Is there anyway for me to know how much space on disk will ocupy an
index, created in a determined row or rows of a table?, anything like
a rule, formula, calculation? that allow me to know in advance how
much space will the index use before actually created
> They run with fsync off AND they like to toggle the power switch at
> random? I'd suggest finding other employment --- they couldn't
> possibly be paying you enough to justify cleaning up after stupidity
> as gross as that.
Colo-by-windows. If there weren't DBAs with Win32 admin tendencies,
I'
Take a look at the .pgpass file, some info at:
http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.html
Doing that, your password is still as secure as your .pgpass file,
which hopefully is more secure than your script.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 22 Aug 2005, Hemapriya wrote:
I would like to know how to connect to postgres from
shell scripts using a password protected user.
Is there a way to embed the password in psql login.
It keeps prompting for the passwords.
psql checks f
Bruce,
Agree that pausing or sleeping is not really a database
function, more of a programming function. But Oracle and I understand
though I can't find it at the moment SQL*Server do offer this
functionality within their DB's just because people do store functions
and procedures that are
Devrim GUNDUZ <[EMAIL PROTECTED]> writes:
> psql checks for PGUSER, PGPASSWORD, PGHOST, PGPORT, PGDATABASE and some
> other environmental variables. Export relevant values to the parameters.
PGPASSWORD is deprecated because it is insecure on some platforms
(to wit, those where other users can see
On Fri, 2005-08-12 at 22:37, wisan watcharinporn wrote:
> i have database with critical data (such patient information)
> how can i protect my database from root access
> because this host in company can access with root from many person
> (person who manage some service application on host but mus
On Fri, 2005-08-12 at 17:48, [EMAIL PROTECTED] wrote:
> Hello,
>
> I followed this advice for picking a good effective_cache_size value
> (below) from Scott Marlowe, and run into a bit of trouble:
>
> I looked at the `top' output and saw "721380k cached".
> So I calculated the effective cache siz
On Sun, Aug 21, 2005 at 06:35:22AM +0100, Aldor wrote:
> if you want to insert biiig data volumes try either using COPY instead
> of INSERT - it will run much much faster
And if for some reason you have to stick with inserts, group them into
transactions; it will perform much better than individu
Hi sandhya,
I really wonder if the function name is pg_field_type (res, col_no).
The
function name which returns the field type of a particular column is PQftype
(res, col_no).
This
returns the field type as oid.The oid of the built-in data types can be found
in src/incl
19 matches
Mail list logo
