...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Cédric Villemain
Sent: Saturday, December 04, 2010 3:12 PM
To: ma...@manfbraun.de
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Looking for auto starting procedures
2010/12/2 :
> Hello !
>
> And than
2010/12/2 :
> Hello !
>
> And thanks to all, for answers.
>
> Naturally, cron does not operate on DB tables and if I add/remove/change
> a line in a control table dynamically, cron would not notice that ;-)
> So I had to write a daemon, which acts on that table. This might happen
> about ~5 - 20 s
Le 03/12/2010 21:22, manfred.braun a écrit :
> [...]
> Yes, thanks, I am just trying to lern the difference.
> I am comin from Sql Server, but I am not a experienced
> db developer. But in Sql Server, you may hack your tests
> just in a direct statement and if it runs, wrap/put
> it in the function
!
br++mabra
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alvaro Herrera
Sent: Friday, December 03, 2010 1:22 AM
To: mabra
Cc: pgsql-general
Subject: Re: [GENERAL] Looking for auto starting procedures
Excerpts from
Excerpts from mabra's message of jue dic 02 20:04:36 -0300 2010:
> I've just not understood, when I have to write a function to test sql code
> and when I can do it interactively.
In Postgres, PL/pgSQL and SQL are two different languages. There are
things in PL/pgSQL that you cannot do in pure S
11:22 PM
To: ma...@manfbraun.demabra@manfbraun.de
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Looking for auto starting procedures
On Dec 2, 2010, at 1:27 PM, wrote:
>
> I have not understand, where I can issue direct sql statements
> and it looks like, the RAISE is not pos
On Dec 2, 2010, at 1:27 PM, wrote:
>
> I have not understand, where I can issue direct sql statements
> and it looks like, the RAISE is not possible with plSql:
Right, it's not actually SQL, so you can't use it in plain SQL. It is part of
the plpgsql procedural language.
So you could easily c
al-ow...@postgresql.org] On Behalf Of Adrian Klaver
Sent: Thursday, December 02, 2010 9:35 PM
To: ma...@manfbraun.de
Cc: @manfbraun.dema...@manfbraun.de'; "
Subject: Re: [GENERAL] Looking for auto starting procedures
On 12/02/2010 12:27 PM, ma...@manfbraun.de wrote:
> Hello !
>
> a)
>
On 12/02/2010 12:27 PM, ma...@manfbraun.de wrote:
Hello !
a)
The idea with to test a RAISE statement with an prefix, could
be good. But I am just that new, I could not make it working.
I have not understand, where I can issue direct sql statements
and it looks like, the RAISE is not possible wi
ow...@postgresql.org] On Behalf Of Scott Ribe
Sent: Thursday, December 02, 2010 8:16 PM
To: ma...@manfbraun.demabra@manfbraun.de
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Looking for auto starting procedures
On Dec 2, 2010, at 11:32 AM,
wrote:
>
> The usual notification from
On Dec 2, 2010, at 11:32 AM, wrote:
>
> The usual notification from postgreSQL does not allow to write
> an [own, better to evaluate] identifier in the syslog. This is
> not a matter of the syslog daemon, its on the program which logs.
> May be, I have just not found this.
Am I missing somethin
] On Behalf Of Robert Gravsjö
Sent: Thursday, December 02, 2010 1:24 PM
To: ma...@manfbraun.de
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Looking for auto starting procedures
On 2010-12-01 16.16, ma...@manfbraun.de wrote:
> Hello !
>
> I am coming from Sql Server right now an
On 2010-12-01 16.16, ma...@manfbraun.de wrote:
Hello !
I am coming from Sql Server right now and have to learn about the
infrastructure.
What I missed first, is, to execute procedures regularly/repeatedly
on a given time. I want to prevent my to write a lot external
programs und use cron :-(
On 12/01/2010 11:16 PM, ma...@manfbraun.de wrote:
The othing thing is, that I need some internally running procedures, which
do some work. On Sql Server, I can use "auto-start stored procedures".
Is there anything like this in postgresql, or what can I do?
There is no built-in scheduler at pre
Hello !
I am coming from Sql Server right now and have to learn about the
infrastructure.
What I missed first, is, to execute procedures regularly/repeatedly
on a given time. I want to prevent my to write a lot external
programs und use cron :-(
The othing thing is, that I need some internally r
15 matches
Mail list logo
