clayton cottingham wrote:
Brett Schwarz wrote:
I couldn't resist, so I went ahead and did all of them. I might be using
these in a future app anyways. Again these are Tcl procs, but you may be
able to transfer the logical to another language, if you want.
if you need this in perl
Brett Schwarz wrote:
I couldn't resist, so I went ahead and did all of them. I might be using
these in a future app anyways. Again these are Tcl procs, but you may be
able to transfer the logical to another language, if you want.
if you need this in perl i think Data::Manip might hep:
Stephan Szabo wrote:
On Mon, 10 Sep 2001, Jeff Barrett wrote:
How can I call a shell script from within a pl/pgsql function that is called
as from a trigger. I do not want to interact with the script I just want it
to run. I do want the trigger to wait for the script it called to
Chris Ruprecht wrote:
Hi guys,
There are a number of features, I would love to see implemented in a future
release of PostGreSQL, more specific, into PL/PGSQL. Is there a central
place somewhere, where we (the PostGreSQL user community, I guess that is),
is able to see what is planned
Time Co-Ordinate Tue, 05 Jun 2001 19:45:55 -0400, The Organism labeled Tom Lane
said:
clayton cottingham [EMAIL PROTECTED] writes:
how does one execute an sql statement from inside a plperl function?
At the moment, one doesn't.
This is one of a number of features that have
is there a list of all possible returns for all procedural language types?
aka
perl can return these types
c can return these
..
thanks!
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Jack wrote:
Is that possible to execute a client application from server site by
PL/Pgsql, such as pg_dump? Because my client sites are running Windows OS,
or is there any Windows version of all Client Applications come from
PostGreSQL V7.1?
Jack
---(end of
did you get this error when you tried to :
createlang plperl template1?
me too!
then i did this
find /usr -name libperl.so
/usr/lib/perl5/5.6.0/i386-linux/CORE/libperl.so
and then added
that dir {/usr/lib/perl5/5.6.0/i386-linux/CORE/}
to the /etc/ld.so.conf
ldconfig
and vroom it all went
Justin Clift wrote:
Hi Clayton,
Was it opening a new connection to the database every time, or did it
open one connection each time and pump multiple queries through it?
It would be a good things to develop your script and benchmark this both
ways. Could become a useful tool for
hello
on the modperl list a good thread was happening called
'fast db access'
find attached scripts used to do this
here are my results:
[drfrog]$ perl fast_db.pl
postgres
16 wallclock secs ( 0.05 usr + 0.00 sys = 0.05 CPU) @ 400.00/s (n=20)
mysql
3 wallclock secs ( 0.07 usr + 0.00 sys
hello:
im try to find out how mysql or postgresql perform
i was wondering if there are any benchmarking scripts out there?
if so please lemme see em try em etc!!
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
hi one of the developers here at work say this should work
insert into detail (det_id,det_mas_id,det_date,det_amt) values
(0,0,now(),'0'), (1,1,now(),'1');
but when i try that in postgres like:
insert into detail (det_id,det_mas_id,det_date,det_amt) values
(0,0,datetime'now','0'),
Peter Mount wrote:
At 10:33 26/03/01 +0200, Mathijs Brands wrote:
Has anybody ever tried calling Java code from a pgsql trigger written
in C? Shouldn't this be possible using JNI?
This was discussed recently.
I'm not exactly a Java expert myself, but this is the way PHP allows
you
Najm Hashmi wrote:
Hi all, I was just wondering if there is way or some sort of utility to
incorporate XML in postgrres.
Thanks in advance.
---(end of
"Brett W. McCoy" wrote:
On Tue, 6 Mar 2001, Josh Berkus wrote:
Just a quick question ... I need to do a regular transfer (daily + on
demand) of data from a MySQL database to a PostgreSQL database and back
again. Can anybody steer me towards a good script for this, or do I
have
Francis Solomon wrote:
Hi Boulat,
stasis=# select (now() + '1 year')::date;
?column?
2002-03-06
(1 row)
Hope this helps
Francis
Hi,
Im a little bit stuck here.
Does anyone know how to get date in format '-MM-DD' of a date one
year from now.
So
just wondering which of these two formats
seems best
pros and cons of each
i know that supposedly
xql is simpler in style than
XML-QL but XML-QL has some nice sql like syntax
the perl modules seem to work nicer too
Hi all:
has anyone heard of XQL?
XQL is xml sql
i just was catching up on
some email and noticed this nugget
http://www.ibiblio.org/xql/
anyways there is a xml::xql perl module so
perl could do it
but the ability to spit it right out of pg would be neato
Frank Joerdens wrote:
On Wed, Dec 13, 2000 at 11:04:13AM -0800, Josh Berkus wrote:
Frank,
Please look in the list archives. About 2 months ago this topic came
up and was discussed extensively (including a creative solution by yours
truly).
Hm, neither my archives nor a
Mathijs Brands wrote:
On Wed, Dec 13, 2000 at 04:49:51PM -0800, Josh Berkus allegedly wrote:
Stuart,
I don't think I'd be comfortable with having the node_level column in the
table structure. First, because you can derive that value using a function,
it's duplicate data. Second,
On Mon, 4 Dec 2000 18:20:29 -0800 (PST), S.F. Lee said:
Thank for your hint, but I have some questions :
1. Do I have to compile the C program into a shared
object (*.so)?
yes
2. Do I have to use SPI (SPI is too complicate to
me)?
My request is very simple. I have a
Mateusz Mazur wrote:
Hello.
I wonder where I can find JDBC driver for Postgresql. I think it should be
class (sorry I am newbie). I would be very greatfull for quick response.
Mateusz.
download the source tarball go into
src/interfaces/jdbc
and follow directions!1
bon appetite!!
Roberto Mello wrote:
Jason wrote:
aolserver is a web/application server. PHP is a server-side scripting
language. Why exactly *should* it have a job scheduler?
Some (such as myself) might also ask why should a web server have a job
scheduler, but that's a thread for a different
On Sat, 18 Nov 2000 01:13:23 +0200, Max Fonin said:
Can give a link ?
can do :
http://freshmeat.net/projects/mysql2pgsql/?highlight=convert+sql
i havent tried their's
did try yours
it was nice to have the transactions!
On Fri, 17 Nov 2000 13:45:37 -0800
clayton cottingham [EMAIL
Max Fonin wrote:
Hi.
I'm writing MySQL-Postgres dump converter. E.g. it will convert only database dumps
produced by mysqldump.
It's almost ready, problems are ENUM and SET types. I have problems with types
emulation.
Maybe someone help me guys ?
Anyway, some half-working version
Joe Conway wrote:
On machines where I've installed PostgreSQL 7.0.2 from RPM, psql allows
use
of the up arrow key for history and the escape/tab key for command
completion, but on my remote web host (webpipe.net) those keys don't
work.
What do I need to do to get these features
On Tue, 21 Nov 2000 00:01:33 +0200, Max Fonin said:
Hi.
MySQL-Postgres dump converter is now available at
http://ziet.zhitomir.ua/~fonin/code/my2pg.pl.
Still beta and bugsome version but working, supports MySQL ENUMs, near the end are
SET emulation.
Please help me to test.
Max
On Wed, 25 Oct 2000 10:44:48 -0700, Jie Liang said:
Hi,
I want send a e-mail when the rows of mytable reaches 100,000, how?
one way is to make a function using perl
and use say mail::sender as the module to send the info
use the code snippet
in perldoc Mail::Sender
another
28 matches
Mail list logo