public inbox for [email protected]
help / color / mirror / Atom feedExcuse me! Could i to ask a question?
2+ messages / 2 participants
[nested] [flat]
* Excuse me! Could i to ask a question?
@ 2012-12-14 04:05 劉維毅 <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: 劉維毅 @ 2012-12-14 04:05 UTC (permalink / raw)
To: pgsql-docs
Hi!
It's very sorry to disrupted you, but could you help me?
I am a programmer, and i want to use Postgresql 9.2.2 to store my
applications' data. I had to
build a trigger wich based on Database level( When the database startup
, this trigger will fired and
executed.),while i found there are not defined database-level trigger in
postgresql. I read the doc but could
not found methods that could replaced triggers based on database.
Coud you give me a hand? Are there any tables auto update when
postgresql server startup, in this
way i could create a trigger on this table when server startup!
Thanks a lot and best regards!
Edward
mailto:[email protected]
---------------------------------------------------------------------------------------------------
Confidentiality Notice: The information contained in this e-mail and any accompanying attachment(s)
is intended only for the use of the intended recipient and may be confidential and/or privileged of
Neusoft Corporation, its subsidiaries and/or its affiliates. If any reader of this communication is
not the intended recipient, unauthorized use, forwarding, printing, storing, disclosure or copying
is strictly prohibited, and may be unlawful.If you have received this communication in error,please
immediately notify the sender by return e-mail, and delete the original message and all copies from
your system. Thank you.
---------------------------------------------------------------------------------------------------
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Excuse me! Could i to ask a question?
@ 2012-12-17 14:06 Kevin Grittner <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Kevin Grittner @ 2012-12-17 14:06 UTC (permalink / raw)
To: "劉維毅" <[email protected]>; pgsql-docs
[email protected] wrote:
> I am a programmer, and i want to use Postgresql 9.2.2 to store my
> applications' data. I had to
> build a trigger wich based on Database level( When the database startup
> , this trigger will fired and
> executed.),while i found there are not defined database-level trigger in
> postgresql. I read the doc but could
> not found methods that could replaced triggers based on database.
> Coud you give me a hand? Are there any tables auto update when
> postgresql server startup, in this
> way i could create a trigger on this table when server startup!
It's not entirely clear what you want or why. Do you want this to
run when the PostgreSQL cluster (collection of databases running
under the control of a single postmaster process) is available for
connections, when there is the first connection to the cluster
(which creates a backend server process), when there is the first
connection to some particular database in the cluster, or for each
connection? What sorts of things do you need it to do? What is the
problem you are trying to solve?
If you want it once per cluster start, the easiest way would be to
use a custom service script to stop and start the server, which
could run a script. Other timings would need other solutions, but
it would help to know what the problem is that you are trying to
solve.
-Kevin
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-12-17 14:06 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-12-14 04:05 Excuse me! Could i to ask a question? 劉維毅 <[email protected]>
2012-12-17 14:06 Re: Excuse me! Could i to ask a question? Kevin Grittner <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox