Re: [GENERAL] how to start a procedure after postgresql started.

2011-05-24 Thread jun yang
2011/5/24 Craig Ringer : > On 24/05/11 12:46, jun yang wrote: > >> thanks for the info,i am just not have such deep learn of pg internal, >> i am on user level,not hacker,so the mail is in pgsql-general,not >> hacker list. > > Then you really, really, REALLY don'

Re: [GENERAL] how to start a procedure after postgresql started.

2011-05-24 Thread jun yang
2011/5/24 Rick Genter : > > On May 23, 2011, at 9:46 PM, jun yang wrote: > >> thanks for the info,i am just not have such deep learn of pg internal, >> i am on user level,not hacker,so the mail is in pgsql-general,not >> hacker list. > > What you are asking to do i

Re: [GENERAL] how to start a procedure after postgresql started.

2011-05-23 Thread jun yang
2011/5/23 Craig Ringer : > On 23/05/2011 10:13 AM, jun yang wrote: > >> actually, we will write the procedure in pl/python,then fork a new >> thread or a new process which is easy. > > Yikes. Be careful there - it's not as easy as you think it is. > > Spawni

Fwd: [GENERAL] how to start a procedure after postgresql started.

2011-05-22 Thread jun yang
-- Forwarded message -- From: jun yang Date: 2011/5/23 Subject: Re: [GENERAL] how to start a procedure after postgresql started. To: Craig Ringer 2011/5/23 Craig Ringer : > On 23/05/2011 9:37 AM, jun yang wrote: > >> what we want to do is explore the ability to mov

Re: [GENERAL] how to start a procedure after postgresql started.

2011-05-22 Thread jun yang
2011/5/22 Scott Marlowe : > On Sun, May 22, 2011 at 6:49 AM, jun yang wrote: >> 2011/5/22 Scott Marlowe : >>> On Sat, May 21, 2011 at 10:57 PM, jun yang wrote: >>>> now all the question: >>>> 1.how start a procedure or a script after postgresql start. &g

Re: [GENERAL] how to start a procedure after postgresql started.

2011-05-22 Thread jun yang
2011/5/23 Darren Duncan : > John R Pierce wrote: >> >> On 05/21/11 10:41 PM, Darren Duncan wrote: >>> >>> Well, if you can run a stored procedure automatically when Postgres >>> starts, that looks like a necessary step to being able to implement an >>> entire application inside Postgres. >>> >>> St

Re: [GENERAL] how to start a procedure after postgresql started.

2011-05-22 Thread jun yang
2011/5/22 Scott Marlowe : > On Sat, May 21, 2011 at 10:57 PM, jun yang wrote: >> now all the question: >> 1.how start a procedure or a script after postgresql start. > > Do you need this stored procedure or script to always run at pg > database start?  Or every time

Re: [GENERAL] how to start a procedure after postgresql started.

2011-05-22 Thread jun yang
we don't need se-linux function now ,so it is not the good idea, and se-linux don't available on windows. 2011/5/22 Pavel Stehule : > Hello > > 2011/5/22 jun yang : >> now all the question: >> 1.how start a procedure or a script after postgresql start. >> 2.h

[GENERAL] how to start a procedure after postgresql started.

2011-05-21 Thread jun yang
now all the question: 1.how start a procedure or a script after postgresql start. 2.how to get notify when a table created. 3.how to get notify when a database created. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresq

Re: [GENERAL] Can I add a super table to existing tables?

2009-08-01 Thread Jun Yang
On Sat, Aug 1, 2009 at 9:42 PM, David Fetter wrote: > On Sat, Aug 01, 2009 at 08:10:02PM -0700, Jun Yang wrote: > > On Sat, Aug 1, 2009 at 7:53 PM, David Fetter wrote: > > > On Sat, Aug 01, 2009 at 06:28:54PM -0700, Jun Yang wrote: > > > > Hi all, > > &

Re: [GENERAL] Can I add a super table to existing tables?

2009-08-01 Thread Jun Yang
On Sat, Aug 1, 2009 at 7:53 PM, David Fetter wrote: > On Sat, Aug 01, 2009 at 06:28:54PM -0700, Jun Yang wrote: > > Hi all, > > > > I want to add some common columns to all of my tables. > > Your case may be very special, but offhand, this sounds like a very > bad

[GENERAL] Can I add a super table to existing tables?

2009-08-01 Thread Jun Yang
Hi all, I want to add some common columns to all of my tables. One way I think would be to add a super table that contains the common columns to all tables. But is there a way to add a super table to existing tables for them to inherit from? Thanks! Jun -- Sent via pgsql-general mailing list