[SQL] help with rule and notification

2003-10-03 Thread Theodore Petrosky
I don't know if this is the correct forum for this question but I will start here... I have a job tracking system that I am developing with postgresql and mac os x. I have all the pieces in place (mostly) but i am having a problem with notify.. I am trying to set up things so that two (or more) p

Re: [SQL] help with rule and notification

2003-10-02 Thread Theodore Petrosky
ok if the only info I can pass is that the notify happened and then I need to go look at the notifying table is it possible to create a rule that on update of jobstable insert into notifytable the jobnumber has there been any real discussion about adding this to the todo list? I was really pretty

Re: [SQL] help with rule and notification

2003-10-01 Thread Tom Lane
Theodore Petrosky <[EMAIL PROTECTED]> writes: > create rule r1 as on update to table1 do (update > table2 set jobno = table1.jobno; notify table2;) > so anyone listening for notifications on table2 can > ask table2 for the jobno that was updated. then if > they were viewing that jobno, update thei

Re: [SQL] help with rule and notification

2003-10-01 Thread CN
> so anyone listening for notifications on table2 can > ask table2 for the jobno that was updated. then if > they were viewing that jobno, update their display. if > not just ignore the notify. Pardon me if I make your focus blur! I believe the implementation for such requirement in an application

[SQL] help with rule and notification

2003-10-01 Thread Theodore Petrosky
I don't know if this is the correct forum for this question but I will start here... I have a job tracking system that I am developing with postgresql and mac os x. I have all the pieces in place (mostly) but i am having a problem with notify.. I am trying to set up things so that two (or more) p