Hi.
I used one function where in we can read the contents of the file from the
database.
Whenever there is a request for the specified file it should take the
contents from the database.
I have exported all my files to databaseand in webserver when ever there
is a request fro the file i am
Hi there,
How can i send mail form postgresql.
any suggestion.
thanx & regards
aftab
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Hi list!
My issue is as follows :
I have to do some calculations based on *exact* number of rows in 2
tables (with a filter) meaning:
SELECT count(*) FROM a WHERE a.row1 in (1,2,3,4);
SELECT count(*) FROM b WHERE b.row1 in (1,2,3,4);
However i couldn't use the count(*) since it is too slow bea
Title: How to run a posgresql function/procedure thro crontab in Linux ES 4.0
Hello,
If anybody tried, please let me know how to run a postgresQL function/procedure thro crontab in Linux ES 4.0
Thanks and regards,
G.Murugan,
Sr. Software Engineer.
Extn. 1658
==
Title: Procedure in PostgresQL
Hello,
Is there any way to create procedure in postgresQL.
Thanks and regards,
G.Murugan,
Sr. Software Engineer.
Extn. 1658
===
Sobha Renaissance Information Technol
On Dec 27 2005, Murugan G wrote:
Hello,
Is there any way to create procedure in postgresQL.
Yes, look at the docs on PL/pgSQL and the other PL's:
http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-CONDITIONALS
http://www.postgresql.org/docs/current/static/p
Murugan G wrote:
Hello,
If anybody tried, please let me know how to run a postgresQL
function/procedure thro crontab in Linux ES 4.0
$ psql --help
This is psql 8.1.0, the PostgreSQL interactive terminal.
..
-c COMMAND run only single command (SQL or internal) and exit
..
S
On Tue, Dec 27, 2005 at 02:44:32PM +0530, Aftab Alam wrote:
> How can i send mail form postgresql.
You could write a function in a language like plperlu, pltclu, or
plpython, but a problem with functions that have effects outside
the database is that those effects can't be undone if the transactio
On Thu, Dec 22, 2005 at 07:30:56AM -0800, Alain Rodriguez Arias wrote:
> Ok I'm using the EMS PostgreSQL Manager Pro utility to export my data into a
> XML, the thing is that when I got a bytea field, which i use to save files,
> when i tried to import the XML I have just create the file is corrupt
Bummer, it looks like there isn't any good solution for the case of
identical user and group names. You might want to search through the
archives to see if this scenario was discussed when roles were being
designed, but it looks like your best bet is to rename either the user
or the group before du
On Fri, Dec 23, 2005 at 04:50:32PM +1100, Dan Austin wrote:
> > [...]
> > Right, the file is fully written under a temp name, and then
> > rename()'d
>
> This makes sense and is almost certainly not the cause of the problem.
> Although there is a lot more data being written to that file than I
>
From http://docs.sun.com/source/817-1836-10/perfplat.html
High File System Page-in Rate
If you are seeing high file system page-in rates on Solaris 8 or 9, you
may benefit from increasing the value of segmap_percent. This parameter
is set by adding the following line to the /etc/system file:
There's also a non-percent-based control as well. My understanding is
that segmap_percent doesn't work on some versions or architectures,
notably OpenSolaris.
On Tue, Dec 27, 2005 at 01:15:39PM -0800, Tom Arthurs wrote:
> From http://docs.sun.com/source/817-1836-10/perfplat.html
>
> High File Sys
On Thu, Dec 22, 2005 at 11:47:13AM -0500, Tom Lane wrote:
> Martijn van Oosterhout writes:
> > On Wed, Dec 21, 2005 at 11:30:15PM -0800, Benjamin Arai wrote:
> >> Somebody said running "sync ; sync; sync" from the console. This seems
>
> > The reason is partly historical. On some OSes running sy
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> How would syncsync differ from sync;sync? The second
> case will wait for the first command to return, or is there a race
> condition that's reduced by typing by hand?
The actual runtime of the "sync" program is epsilon, because it doesn't
wait for all
Hi Michael,
thanks for your reply.
you have mention that i can use plperlu, pltclu, or
plpython for sending mail, i am using windows version of postgres(7.3.1),
I have found that no dll in the postgres lib. for above mention language.
kindly suggest, form where i can find those language lib, &
Title: Standby database & RAC concept in PostgresQL
Hello,
Can I know whether Oracle's Standby database & RAC concepts available in PostgresQL
Thanks and regards,
G.Murugan,
Sr. Software Engineer.
Extn. 1658
=
17 matches
Mail list logo
