Re: [GENERAL] auto insert data every one minute

2009-01-17 Thread Joshua D. Drake
On Sat, 2009-01-17 at 22:40 -0800, searchelite wrote: > > > Tino Wildenhain wrote: > > > > > > I wonder what is you complete problem? It seems all the advices given > > so far are shots-in-the-dark. Could you perhaps expand a bit? > > > > Also for sophisticated solution, if you stick to window

Re: [GENERAL] auto insert data every one minute

2009-01-17 Thread searchelite
Tino Wildenhain wrote: > > > I wonder what is you complete problem? It seems all the advices given > so far are shots-in-the-dark. Could you perhaps expand a bit? > > Also for sophisticated solution, if you stick to windows you might > want to consider something different then just pure CMD,

Re: [GENERAL] Autovacuum daemon terminated by signal 11

2009-01-17 Thread Tom Lane
"Justin Pasher" writes: >> From: Tom Lane [mailto:t...@sss.pgh.pa.us] >> Anyway, it happens consistently on my HP box. I find that your proposed >> patch fixes it, but makes the "normal" path crash :-( --- the loop in >> do_autovacuum has to be executed in AutovacMemCxt, because it creates an >>

Re: [GENERAL] Autovacuum daemon terminated by signal 11

2009-01-17 Thread Justin Pasher
> -Original Message- > From: Tom Lane [mailto:t...@sss.pgh.pa.us] > Sent: Saturday, January 17, 2009 9:50 AM > To: Alvaro Herrera > Cc: Justin Pasher; pgsql-general@postgresql.org > Subject: Re: [GENERAL] Autovacuum daemon terminated by signal 11 > > Alvaro Herrera writes: > > Hmm, in ret

Re: [GENERAL] Trigger to clone across databases?

2009-01-17 Thread Grzegorz Jaƛkiewicz
this not only can be done , but is done - for instance slony does (also) that. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Trigger to clone across databases?

2009-01-17 Thread Jasen Betts
On 2009-01-17, Darren Govoni wrote: > Hi, > I'm looking for a trigger (any language) that can clone the inserted > row and insert it in another postgres server elsewhere. Is this > possible? Practical? Thoughts? > > I know there are some replication systems out there, but I'm hoping a > simple t

Re: [GENERAL] array_agg for 8.3

2009-01-17 Thread Jeff Davis
On Sat, 2009-01-17 at 02:09 -0500, Faheem Mitha wrote: > Hi, > > Can anyone comment on the practicality of using the code for array_agg > from the dev repos, file src/backend/utils/adt/array_userfuncs.c in 8.3 as > a user defined function? It looks like this code was recently added, Nov > 13th/

Re: [GENERAL] executing a sql script

2009-01-17 Thread Joshua D. Drake
On Fri, 2009-01-16 at 22:09 -0800, johnf wrote: > I'm using python and can execute standard "select,update,delete,functions". > What I'd like to do is execute a sql script (a text file). But I don't know > how? You need to open the text file and pass it as an argument: try: file = "%s/%

Re: [GENERAL] Autovacuum daemon terminated by signal 11

2009-01-17 Thread Tom Lane
Alvaro Herrera writes: > Hmm, in retrospect this is pretty obviously buggy. I can't say that > it's that easy for me to reproduce it though; I definitely can't make it > crash. Maybe by sheer luck, the new TopTransactionContext pointer > points to the same memory area that the old was stored in.

Re: [GENERAL] executing a sql script

2009-01-17 Thread johnf
On Saturday 17 January 2009 07:14:06 am Adrian Klaver wrote: > On Friday 16 January 2009 10:09:06 pm johnf wrote: > > I'm using python and can execute standard > > "select,update,delete,functions". What I'd like to do is execute a sql > > script (a text file). But I don't know how? > > Some thing

Re: [GENERAL] executing a sql script

2009-01-17 Thread Adrian Klaver
On Friday 16 January 2009 10:09:06 pm johnf wrote: > I'm using python and can execute standard "select,update,delete,functions". > What I'd like to do is execute a sql script (a text file). But I don't > know how? > Some thing like: > import psycopg2 > import psycopg2.extensions > conn =

Re: [GENERAL] Autovacuum daemon terminated by signal 11

2009-01-17 Thread Martijn van Oosterhout
On Fri, Jan 16, 2009 at 05:13:17PM -0600, Justin Pasher wrote: > Dang it. I wonder why the --enable-debug option doesn't seem to actually > be enabling debug. :( For reference, here is the configure command that > the package uses according to the config.log (in case you spot anything > wrong).

Re: [GENERAL] Trigger to clone across databases?

2009-01-17 Thread Scott Marlowe
On Fri, Jan 16, 2009 at 6:31 PM, Darren Govoni wrote: > Hi, > I'm looking for a trigger (any language) that can clone the inserted > row and insert it in another postgres server elsewhere. Is this > possible? Practical? Thoughts? > > I know there are some replication systems out there, but I'm ho