> "Hunter, Ray" wrote:
>
> Does Postgres in anyway support replication? Will I be able to have
> load-balancing between two postgres databases?
>
> RAY HUNTER
> Automated Test Group
> Software Support Engineer
>
> ENTERASYS NETWORKS
>
> Internal: 53888
> Phone: 801 887-9888
> Fax:
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
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
Kristopher Yates wrote:
>PERL SNIPPET:
>
># build arrays from file (OMITTED)
>
>use Pg;
>$dbhost='127.0.0.1';
>$dbname='mpact';
>#$connstr="dbname=$dbname";
>$connstr="host=$dbhost dbname=$dbname";
>$conn = Pg::connectdb($connstr);
>
>#more code related to date omitted
>
>$result=$conn->exec(
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 plan
hello:
i thought id find out what people think about this:
http://www.zdnet.com/zdnn/stories/news/0,4586,2778706,00.html?chkpt=zdnn_rt_latest
which basically points out that redhat will be making their own database
based off of postgres7.1
my main concern is that this could cause some sort of s
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
consider this function:
CREATE FUNCTION "test" (integer) RETURNS text AS 'return "select * from testt
limit $_[o];";' LANGUAGE 'plperl';
how would i get it to just run the query instead of just return it as text
using plperl?
---(end of broadcast)
hello:
how does one execute an sql statement from inside a plperl function?
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
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
>
> ---(e
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 t
thought id fool around
can't seem to get it to replicate properly
ive followed the instructions impicitly to no avail
manuall it dont work
if anyone has any helpful suggestiuoons etc id love to hear from yah!!
using the tk interface i get a tk error
invalid command name "ConnInfoCmd"
wh
Thomas Good wrote:
>
> On 18 Apr 2001, Clayton Cottingham aka drfrog wrote:
>
> > i will recomp both the newest postgresql and mysql
> > not using any optimizing techs at all i'll post the
> > config scripts i use
>
> Hiya Clayton,
>
> Try it with
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. Co
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 =
Lonnie Cumberland wrote:
> Hello All,
>
> I have been using the 7.0.2 version of PostgreSQL which came with my Mandrake
> Linux and now want to do a fresh install of the 7.1 version because I think
> that there are many things fixed since then.
>
> Do anyone know where the 7.1 RPM's are so that
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'), (1,1,date
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
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 al
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 broadcast)--
Najm Hashmi wrote:
>
> Hi all, I just want to know how to put quotes around a string. Is there a
> function to do so?
> If not how can I escape a single quote.
> Thank you in advance.
>
>
>
> ---
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
>
"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
Markus Wagner wrote:
>
> Hi,
>
> I would like my C source code to compile under unix and windows. I am
> currently using the pg libs to access my database. Under Windows I'd like
> to use odbc.
>
> What's the most platform (and db) independend way to access the database?
> Since odbc comes from
"Jeff S." wrote:
>
> I want to build my tables by placing all the sql
> statements in a file. What is the correct way to use
> this file with psql?
>
> Example: My text file has this in it:
>
> CREATE TABLE table1 (
>table1_id serial,
>field1 char(5),
>PRIMARY KEY (table1_id)
> );
Boulat Khakimov wrote:
>
> David Olbersen wrote:
> >
> > On Sun, 4 Mar 2001, Boulat Khakimov wrote:
> >
> > ->How do I encrypt/decrypt something in PG?
> >
> > Perhaps it'd be better to one-way encrypt something? Granted I don't know the
> > details of your project, but allowing a way to "decrypt
heya:
just wondering if anyone has any comments on this
onlamp is o'rielly's new ideal
that ,really, has been in use for quite a while
its anacronym stands for
linux apache mysql and {php/perl/python}
more info here:
http://www.onlamp.com/
heya
there are a couple of good example on how to do this in the perl
cookbook
the trim function in chapter one might help
the source code from the book is avail at ora.com
Mike D'Agosta wrote:
>
> Hi,
>
>I have a number of empty tables and I want to get the column names and
> data types with an SQL statement. I want to do this procedurally, not
> interactively (so I can't use \d in psql). Postgres doesn't
> support DESCRIBE... is there any other way to do thi
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
Najm Hashmi wrote:
>
> Hi all,
> It is a very simple but I am not able to recall how to do it I
> just need to find out the current value of a seq. It is very simple
> select statement but I can't recall it... Help me please before I get
> myself get fired -:).
> Regards, Najm
select nex
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 d
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 archiv
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!!
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 h
take a look at the contrib sections fti or fulltext index example
it takes you through it all
"S.F. Lee" wrote:
>
> Hi,
>
>I am using Red Hat 6.1 + PostgreSQL 7.0.3. All of
> my
> applications are developed by C and ECPG. I would
> like to know how to execute a C program by Trigger,for
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
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 the
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 v
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
> c
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.
>
hi all,
lately at work there has been a debate over
mysql versus postgres
im just looking for independent benchmarks
i personally love postgres
at work they like mysql
currently we are investigating other possible db solutions
and they are looking at oracle, i think we could save a lot of d
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
anot
46 matches
Mail list logo
