Re: [GENERAL] Is there anyway to...

On 11/2/06, louis gonzales <[EMAIL PROTECTED]> wrote: Hey Brian, Yeah I had considered this, using cron, I just feel like that is too dirty. Actually I didn't see Andreas' post, can someone forward that? I'm running this application on Solaris 9. Ultimately what I want to know is, is there som

Re: [GENERAL] Is there anyway to...

I suppose I'll just concede now :) Thanks for putting up with my sarcasm and humoring my other ideas. I really wanted to see if there were any other methods out there and do appreciate everyone's ideas. Thanks again, CRON it is. Glen Parker wrote: Wes Sheldahl wrote: if you did have a cr

Re: [GENERAL] Is there anyway to...

Wes Sheldahl wrote: if you did have a cron job run to check, you would probably just have it set a boolean field on expired records or something of that sort, and run it a little after midnight, at the start of each day, assuming durations were always being measured in days. Exactly. You fl

Re: [GENERAL] Is there anyway to...

Wes, Thanks. That is fair. Wes Sheldahl wrote: On 11/2/06, *AgentM* <[EMAIL PROTECTED] > wrote: On Nov 2, 2006, at 14:02 , Glen Parker wrote: > louis gonzales wrote: >> Hey Brian, >> Yeah I had considered this, using cron, I just feel like that is

Re: [GENERAL] Is there anyway to...

On 11/2/06, AgentM <[EMAIL PROTECTED]> wrote: On Nov 2, 2006, at 14:02 , Glen Parker wrote:> louis gonzales wrote:>> Hey Brian,>> Yeah I had considered this, using cron, I just feel like that is>> too dirty.>> Actually I didn't see Andreas' post, can someone forward that? >> I'm running this applic

Re: [GENERAL] Is there anyway to...

Glen, Two things: 1) The instructor should only get a flag when the date conflict occurs, once they create this student profile account, they shouldn't have to manually check, I want the program to do, what programs should do, automate as much as possible! So the suggestion about 'generating a

Re: [GENERAL] Is there anyway to...

A. Kretschmer wrote: am Thu, dem 02.11.2006, um 14:24:20 -0500 mailte louis gonzales folgendes: visit the student profile it will only show/flag the status if the time has elapsed. Is there like a sleep() function that postgresql has? That could be part of the plan. So sleep(24hours) -

Re: [GENERAL] Is there anyway to...

Ron Johnson <[EMAIL PROTECTED]> schrieb: > >> Take a look at http://pgfoundry.org/projects/pgjob/ > > I did. > > > Latest File Releases > > Package Version DateNotes / Monitor Download > > This Project Has Not Released Any Files OMG. Sorry. Andreas -- Really, I'm not out to de

Re: [GENERAL] Is there anyway to...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/02/06 13:24, louis gonzales wrote: [snip] >>> I'm running this application on Solaris 9. Ultimately what I want to >>> know is, is there something that is internal to postgresql that can >>> be used that doesn't need external action, to make it

Re: [GENERAL] Is there anyway to...

On Nov 2, 2006, at 15:00 , Richard Troy wrote: On Thu, 2 Nov 2006, AgentM wrote: Just some commentary... This is exactly the sort of thing cron is for. Duplicating that functionality in the RDBMS would be silly IMO. I don't see why you could consider cron to be "dirty" for this applicati

Re: [GENERAL] Is there anyway to...

On Thu, 2 Nov 2006, AgentM wrote: > > > > Just some commentary... This is exactly the sort of thing cron is > > for. Duplicating that functionality in the RDBMS would be silly > > IMO. I don't see why you could consider cron to be "dirty" for > > this application... > > I actually tried to com

Re: [SQL] [GENERAL] Is there anyway to...

imad wrote: Or you can probably use a PostgreSQL administration tool for scheduled jobs. I know a number of such tools which provide this feature and EnterpriseDB Management Server is one of them. As is pgAdmin's pgAgent. Regards, Dave ---(end of broadcast)

Re: [GENERAL] Is there anyway to...

louis gonzales wrote: Fine so let's say when the instructor creates the user profile, this can trigger the creation of a sequence, say, but IF the instructor doesn't visit that student's profile for a month, I want something that, independent of any other action, will be either incrementing or

Re: [GENERAL] Is there anyway to...

am Thu, dem 02.11.2006, um 14:24:20 -0500 mailte louis gonzales folgendes: > visit the student profile it will only show/flag the status if the time > has elapsed. Is there like a sleep() function that postgresql has? > That could be part of the plan. So sleep(24hours) - pseudo code - wake

Re: [GENERAL] Is there anyway to...

Apparently this isn't the first time someone else thought a sleep or timer mechanism, independent of user action would be of great value and didn't want to use external programs to accomplish it. http://developer.*postgresql*.org/pgdocs/postgres/release-8-2.html * Add a server-side *sleep* *fun

Re: [GENERAL] Is there anyway to...

On Nov 2, 2006, at 14:02 , Glen Parker wrote: louis gonzales wrote: Hey Brian, Yeah I had considered this, using cron, I just feel like that is too dirty. Actually I didn't see Andreas' post, can someone forward that? I'm running this application on Solaris 9. Ultimately what I want to k

Re: [GENERAL] Is there anyway to...

To all who replied, first, thank you! Second, I simply said 'dirty' never said dislike or anything like that. I've used and use cron for different OS related operations and have for years. I LOVE cron itself. What I mean with 'dirty' is that I'm trying to take away as much as possible from

Re: [GENERAL] Is there anyway to...

louis gonzales <[EMAIL PROTECTED]> schrieb: > Hey Brian, > Yeah I had considered this, using cron, I just feel like that is too dirty. Why? > > Actually I didn't see Andreas' post, can someone forward that? Sorry, i posted to the list, and i can see my mail. > > I'm running this applicatio

Re: [SQL] [GENERAL] Is there anyway to...

Or you can probably use a PostgreSQL administration tool for scheduled jobs. I know a number of such tools which provide this feature and EnterpriseDB Management Server is one of them. --Imad www.EnterpriseDB.com On 11/2/06, A. Kretschmer <[EMAIL PROTECTED]> wrote: am Thu, dem 02.11.2006, um

Re: [GENERAL] Is there anyway to...

louis gonzales wrote: Hey Brian, Yeah I had considered this, using cron, I just feel like that is too dirty. Actually I didn't see Andreas' post, can someone forward that? I'm running this application on Solaris 9. Ultimately what I want to know is, is there something that is internal to post

Re: [GENERAL] Is there anyway to...

Hey Brian, Yeah I had considered this, using cron, I just feel like that is too dirty. Actually I didn't see Andreas' post, can someone forward that? I'm running this application on Solaris 9. Ultimately what I want to know is, is there something that is internal to postgresql that can be use

Re: [GENERAL] Is there anyway to...

louis gonzales wrote: Hello all, Is there an existing mechanism is postgresql that can automatically increment/decrement on a daily basis w/out user interaction? The use case I'm considering is where a student is in some type of contract with an instructor of some sort, and that contract puts

Re: [GENERAL] Is there anyway to...

am Thu, dem 02.11.2006, um 13:14:22 -0500 mailte louis gonzales folgendes: > Hello all, > Is there an existing mechanism is postgresql that can automatically > increment/decrement on a daily basis w/out user interaction? The use You can use CRON for such tasks. I hope for, you have a operating

[GENERAL] Is there anyway to...

Hello all, Is there an existing mechanism is postgresql that can automatically increment/decrement on a daily basis w/out user interaction? The use case I'm considering is where a student is in some type of contract with an instructor of some sort, and that contract puts a time limit on the s

Re: [GENERAL] is there anyway to get the backends IP address from the

Steve Crawford wrote: > On Saturday 12 February 2005 4:09 pm, Bruce Momjian wrote: > > Added to TODO: > > > > * Add IP address to pg_stat_activity > > I like it. How about IP and port to differentiate multiple connections > from the same host? Will this support IPV6? Good point, added:

Re: [GENERAL] is there anyway to get the backends IP address from

have some idiotproofing. Is there info on what the check_function_bodies does check? Oisin - Original Message - From: "Bruce Momjian" To: <[EMAIL PROTECTED]> Cc: Sent: Monday, February 21, 2005 10:47 AM Subject: Re: [GENERAL] is there anyway to get the backends IP add

Re: [GENERAL] is there anyway to get the backends IP address from

Tony Caduto wrote: > Bruce, > On another note, is there plans to improve the type checking of stored > functions during the save/compile? > Currently I can pretty much make tons of mistakes (on purpose of course > :-) and they are not flagged as errors until runtime. > The biggest complaint I see

Re: [GENERAL] is there anyway to get the backends IP address from

Bruce, On another note, is there plans to improve the type checking of stored functions during the save/compile? Currently I can pretty much make tons of mistakes (on purpose of course :-) and they are not flagged as errors until runtime. The biggest complaint I see from other DBAs (MS SQL, Oracl

Re: [GENERAL] is there anyway to get the backends IP address from the

On Saturday 12 February 2005 4:09 pm, Bruce Momjian wrote: > Added to TODO: > > * Add IP address to pg_stat_activity I like it. How about IP and port to differentiate multiple connections from the same host? Will this support IPV6? Cheers, Steve ---(end of broadca

Re: [GENERAL] is there anyway to get the backends IP address from

Berend Tober wrote: > > Tony Caduto wrote: > >> Hi, > >> Does anyone know if there is a way to get the backends IP address from > >> the PID? > >> I am using the view pg_stat_activity and it would be nice if it would > >> also display the IP address along with the PID. > >> > >> I can see the IP ad

Re: [GENERAL] is there anyway to get the backends IP address from

> Tony Caduto wrote: >> Hi, >> Does anyone know if there is a way to get the backends IP address from >> the PID? >> I am using the view pg_stat_activity and it would be nice if it would >> also display the IP address along with the PID. >> >> I can see the IP address when I do a ps -ef but it woul

Re: [GENERAL] is there anyway to get the backends IP address from the

Tony Caduto wrote: > Hi, > Does anyone know if there is a way to get the backends IP address from > the PID? > I am using the view pg_stat_activity and it would be nice if it would > also display the IP address along with the PID. > > I can see the IP address when I do a ps -ef but it would be n

Re: [GENERAL] is there anyway to get the backends IP address from the PID?

On Fri, Jan 14, 2005 at 02:29:47PM -0600, Tony Caduto wrote: > Does anyone know if there is a way to get the backends IP address from > the PID? Do you mean the IP address of the backend (the server) or the address of the client that's using that backend? PostgreSQL 8.0 will have inet_client_ad

[GENERAL] is there anyway to get the backends IP address from the PID?

Hi, Does anyone know if there is a way to get the backends IP address from the PID? I am using the view pg_stat_activity and it would be nice if it would also display the IP address along with the PID. I can see the IP address when I do a ps -ef but it would be nice to be able to get it via a s