Re: [pgadmin-hackers] [pgAdmin4][PATCH] SlickGrid column resize triggers column select

2017-05-05 Thread Murtuza Zabuawala
> expect(column.toRow).toBe(9); > }) > }); > > > > Since we are finishing up this feature anyway, if this bug can wait > another week, we can take it into our backlog and address it and submit the > fix with our next patch. > > > Thanks! > Matt & Sara

Re: [pgadmin-hackers] [pgAdmin4][PATCH] SlickGrid column resize triggers column select

2017-05-05 Thread Sarah McAlear
May 5, 2017 at 5:54 AM, Murtuza Zabuawala < [email protected]> wrote: > Hi, > > PFA patch to fix the issue where in SlickGrid column resize also triggers > 'onHeaderClick' event and triggers column selection, In this > scenario before drag event which colu

[pgadmin-hackers] [pgAdmin4][PATCH] SlickGrid column resize triggers column select

2017-05-05 Thread Murtuza Zabuawala
Hi, PFA patch to fix the issue where in SlickGrid column resize also triggers 'onHeaderClick' event and triggers column selection, In this scenario before drag event which column is under mouse gets selected, So to fix the issue we will check if header checkbox is clicked. RM#2348 Ple

[pgadmin-hackers] pgAdmin 4 commit: Add newly created triggers to the treeview. Fixes #17

2016-11-18 Thread Dave Page
Add newly created triggers to the treeview. Fixes #1747 Branch -- master Details --- http://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=6e5126d571ca9497f90b25aa34f5f318a54b5089 Author: Murtuza Zabuawala Modified Files -- .../databases/schemas/tables/indexes

[pgadmin-hackers] pgAdmin 4 commit: Properly format arguments passed by triggers to funct

2016-11-09 Thread Dave Page
Properly format arguments passed by triggers to functions. Fixes #1912 Branch -- master Details --- http://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=c345adaa528571583a9e4df9c62785dfcbb5316d Author: Murtuza Zabuawala Modified Files -- .../templates/trigger/sql

[pgadmin-hackers] Review: Views, Mat. Views, Vaccum controls, Columns, Indexes, Rules, Triggers

2016-04-14 Thread Dave Page
tions. - Variables should be on their own tab, not the Security tab. - There's no blank line before COMMENT ON in the Create script, or before GRANT... Triggers: - The Definition tab on the Create dialogue needs to be split up. No scrolling should be required! - The Code tab should be hidde

Re: [pgadmin-hackers] [pgAdmin4] PATCH: Added Utility functions for triggers node and rules node

2016-04-05 Thread Dave Page
Thanks - committed. On Wed, Mar 23, 2016 at 3:43 PM, Surinder Kumar wrote: > Hi, > > Trigger and Rules nodes have functions which are also used by view node. > View node use them while generating reverse engineering SQL for respective > nodes. > so they are moved into schema/utils.py > > > Please

[pgadmin-hackers] [pgAdmin4] PATCH: Added Utility functions for triggers node and rules node

2016-03-23 Thread Surinder Kumar
Hi, Trigger and Rules nodes have functions which are also used by view node. View node use them while generating reverse engineering SQL for respective nodes. so they are moved into schema/utils.py Please review the patch. Thanks, Surinder Kumar utility_functions_for_trigger_and_rule_node.pa

[pgadmin-hackers] pgAdmin 4 commit: Default owner for new event triggers.

2016-03-11 Thread Dave Page
Default owner for new event triggers. Branch -- master Details --- http://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=fd05dec29c2e169ba9cb369902511fda8023b402 Modified Files -- .../templates/event_triggers/js/event_trigger.js| 13 + 1 file

[pgadmin-hackers] pgAdmin 4 commit: Add support for Event Triggers.

2016-03-10 Thread Dave Page
Add support for Event Triggers. Branch -- master Details --- http://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=986375d60e45f2e73c625342cc1a0fd024dece3e Author: Harshal Dhumal Modified Files -- .../servers/databases/event_triggers/__init__.py | 664

[pgadmin-hackers] pgAdmin III commit: Fix support for triggers with inline code on PPAS

2014-09-19 Thread Dave Page
Fix support for triggers with inline code on PPAS Branch -- master Details --- http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=97e21c673d762c583b06dd4194952a999b23983e Author: Sanket Mehta Modified Files -- CHANGELOG|2 ++ pgadmin

[pgadmin-hackers] Re: Event Triggers are not listed in the browser view options on the Settings dialogue

2013-09-26 Thread Dave Page
Thanks, applied for 1.18.1+. On Tue, Sep 24, 2013 at 10:39 AM, Dhiraj Chawla wrote: > Hi Dave, > > Please find the updated patch. I have moved the Event Triggers node before > the Extensions node in the treeview. I have also re-arranged the the display > options list to the best

[pgadmin-hackers] Re: Event Triggers are not listed in the browser view options on the Settings dialogue

2013-09-26 Thread Dhiraj Chawla
> wrote: > > Hi Dave, > > > > Please find the updated patch. I have moved the Event Triggers node > before > > the Extensions node in the treeview. I have also re-arranged the the > display > > options list to the best of my knowledge. Please review the patch

[pgadmin-hackers] Re: Event Triggers are not listed in the browser view options on the Settings dialogue

2013-09-24 Thread Dhiraj Chawla
Hi Dave, Please find the updated patch. I have moved the Event Triggers node before the Extensions node in the treeview. I have also re-arranged the the display options list to the best of my knowledge. Please review the patch and let me know your thoughts on the same. regards, *Dhiraj Chawla

[pgadmin-hackers] Re: Event Triggers are not listed in the browser view options on the Settings dialogue

2013-09-23 Thread Dave Page
Hi On Fri, Sep 20, 2013 at 1:13 PM, Dhiraj Chawla wrote: > Hi Dave, > > The Event Triggers options is not listed in the browser view options on the > Settings dialog of pgAdmin, which would allow a user the hide/show the Event > Triggers collection node. Attached is the patch

[pgadmin-hackers] Event Triggers are not listed in the browser view options on the Settings dialogue

2013-09-20 Thread Dhiraj Chawla
Hi Dave, The Event Triggers options is not listed in the browser view options on the Settings dialog of pgAdmin, which would allow a user the hide/show the Event Triggers collection node. Attached is the patch that fixes this issue. Let me know your view on the same. regards, *Dhiraj Chawla

[pgadmin-hackers] pgAdmin III commit: Add support for event triggers in 9.3+.

2013-07-26 Thread Dave Page
Add support for event triggers in 9.3+. Branch -- master Details --- http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=a71985564790c5dc3cbeb397d76c61f84a4ebc9a Author: Dinesh Kumar Modified Files -- CHANGELOG |1 + pgadmin/dlg

[pgadmin-hackers] pgAdmin III commit: Fix constraint triggers SQL

2012-04-30 Thread Guillaume Lelarge
Fix constraint triggers SQL Per a report from Michael Brux. Branch -- REL-1_14_0_PATCHES Details --- http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=0a77a3eeced2b7ced397fca82bf7d1e8646cfbea Modified Files -- CHANGELOG|1 + pgadmin

[pgadmin-hackers] pgAdmin III commit: Fix constraint triggers SQL

2012-04-30 Thread Guillaume Lelarge
Fix constraint triggers SQL Per a report from Michael Brux. Branch -- master Details --- http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=f9f1ae618462af01de0cd38163a97101bc9ac485 Modified Files -- CHANGELOG|1 + pgadmin/schema

[pgadmin-hackers] pgAdmin III commit: Fix the SQL for existing triggers

2012-02-21 Thread Guillaume Lelarge
Fix the SQL for existing triggers Columns weren't quoted. Per report from Bartosz Dmytrak. Branch -- REL-1_14_0_PATCHES Details --- http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=a62f04610bac5c9de8fffe6a478daabc90ad1b9e Modified Files -- CHAN

[pgadmin-hackers] pgAdmin III commit: Fix the SQL for existing triggers

2012-02-21 Thread Guillaume Lelarge
Fix the SQL for existing triggers Columns weren't quoted. Per report from Bartosz Dmytrak. Branch -- master Details --- http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=086314a92c1a2a65c43d4c68f0c6539a932a1d07 Modified Files -- CHAN

Re: [pgadmin-hackers] Enabling/disabling triggers and rules

2011-07-09 Thread Guillaume Lelarge
On Sat, 2011-07-09 at 10:18 +0100, Dave Page wrote: > On Sat, Jul 9, 2011 at 10:12 AM, Guillaume Lelarge > wrote: > > Hi, > > > > Right now, the enabled/disabled state of a trigger and a rule is not > > displayed in the SQL pane of the browser. I can understand we don't > > display its state if th

[pgadmin-hackers] pgAdmin III commit: Fix SQL query for enabled/disabled triggers and rul

2011-07-09 Thread Guillaume Lelarge
Fix SQL query for enabled/disabled triggers and rules When a user enables/disables a trigger, the icon changes, and the properties are updated. But the SQL query in the query pane of the browser wasn't. Same happens to enabled/disabled rules. This patch fixes both. Branch -- master De

[pgadmin-hackers] pgAdmin III commit: Fix SQL query for enabled/disabled triggers and rul

2011-07-09 Thread Guillaume Lelarge
Fix SQL query for enabled/disabled triggers and rules When a user enables/disables a trigger, the icon changes, and the properties are updated. But the SQL query in the query pane of the browser wasn't. Same happens to enabled/disabled rules. This patch fixes both. Branch -

Re: [pgadmin-hackers] Enabling/disabling triggers and rules

2011-07-09 Thread Dave Page
On Sat, Jul 9, 2011 at 10:12 AM, Guillaume Lelarge wrote: > Hi, > > Right now, the enabled/disabled state of a trigger and a rule is not > displayed in the SQL pane of the browser. I can understand we don't > display its state if the object is enabled, but shouldn't we display > that the object is

[pgadmin-hackers] Enabling/disabling triggers and rules

2011-07-09 Thread Guillaume Lelarge
Hi, Right now, the enabled/disabled state of a trigger and a rule is not displayed in the SQL pane of the browser. I can understand we don't display its state if the object is enabled, but shouldn't we display that the object is disabled in the SQL pane if it is? Just like we show a FK is invalid

Re: [pgadmin-hackers] Feature: visual feedback of disabled triggers

2011-03-07 Thread Guillaume Lelarge
gt;>>>>> I would like to suggest you a simple feature : is it possible to add, >>>>>>>> in >>>>>>>> the left panel of pgAdmin (objects browser), a visual feedback of >>>>>>>> disabled triggers (like a red cross,

Re: [pgadmin-hackers] [pgAdmin III] #306: Visual feedback of disabled triggers

2011-03-07 Thread pgAdmin Trac
#306: Visual feedback of disabled triggers --+- Reporter: Erika| Owner: gleu Type: feature | Status: closed Priority: minor| Milestone: 1.14 Component: pgadmin

[pgadmin-hackers] pgAdmin III commit: Disabled triggers are displayed with another icon

2011-03-07 Thread Guillaume Lelarge
Disabled triggers are displayed with another icon The "other" icon is the old one with a red cross on it. It helps to know which triggers are enabled and which aren't. Idea from Erika. Branch -- master Details --- http://git.postgresql.org/gitweb?p=pgadmin3.git

Re: [pgadmin-hackers] Feature: visual feedback of disabled triggers

2011-03-06 Thread Dave Page
: >>>>> On Tue, Feb 8, 2011 at 7:32 AM, Guillaume Lelarge >>>>> wrote: >>>>>> Le 04/02/2011 11:42, R.I.K a écrit : >>>>>>> [...] >>>>>>> I would like to suggest you a simple feature : is it possible to add,

Re: [pgadmin-hackers] Feature: visual feedback of disabled triggers

2011-03-06 Thread Guillaume Lelarge
gt;>> wrote: >>>>> Le 04/02/2011 11:42, R.I.K a écrit : >>>>>> [...] >>>>>> I would like to suggest you a simple feature : is it possible to add, in >>>>>> the left panel of pgAdmin (objects browser), a visual feedback of >&

Re: [pgadmin-hackers] Feature: visual feedback of disabled triggers

2011-03-06 Thread Dave Page
rit : >>>>> [...] >>>>> I would like to suggest you a simple feature : is it possible to add, in >>>>> the left panel of pgAdmin (objects browser), a visual feedback of >>>>> disabled triggers (like a red cross, for example, or a greyed icon)

Re: [pgadmin-hackers] Feature: visual feedback of disabled triggers

2011-03-06 Thread Guillaume Lelarge
t;>>> [...] >>>>> I would like to suggest you a simple feature : is it possible to add, in >>>>> the left panel of pgAdmin (objects browser), a visual feedback of >>>>> disabled triggers (like a red cross, for example, or a greyed icon) ? >&g

Re: [pgadmin-hackers] [pgAdmin III] #306: Visual feedback of disabled triggers

2011-03-06 Thread Guillaume Lelarge
Le 06/03/2011 16:16, Peter Geoghegan a écrit : > This is something we should have had a long time ago. > I guess so. Just needed to know about it and find the time to do it :) -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@

Re: [pgadmin-hackers] Feature: visual feedback of disabled triggers

2011-03-06 Thread Guillaume Lelarge
ple feature : is it possible to add, in >>>> the left panel of pgAdmin (objects browser), a visual feedback of >>>> disabled triggers (like a red cross, for example, or a greyed icon) ? >>>> >>> >>> I think the greyed icon would be best. If we want

Re: [pgadmin-hackers] [pgAdmin III] #306: Visual feedback of disabled triggers

2011-03-06 Thread Peter Geoghegan
This is something we should have had a long time ago. -- Regards, Peter Geoghegan -- Sent via pgadmin-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] [pgAdmin III] #306: Visual feedback of disabled triggers

2011-03-06 Thread pgAdmin Trac
#306: Visual feedback of disabled triggers --+- Reporter: Erika | Owner: gleu Type: feature | Status: assigned Priority: minor | Milestone: Component: pgadmin

Re: [pgadmin-hackers] [pgAdmin III] #306: Visual feedback of disabled triggers

2011-03-06 Thread pgAdmin Trac
#306: Visual feedback of disabled triggers --+- Reporter: Erika | Owner: gleu Type: feature | Status: assigned Priority: minor | Milestone: Component: pgadmin

Re: [pgadmin-hackers] Feature: visual feedback of disabled triggers

2011-02-09 Thread Guillaume Lelarge
in (objects browser), a visual feedback of >>> disabled triggers (like a red cross, for example, or a greyed icon) ? >>> >> >> I think the greyed icon would be best. If we want to do this, we need to >> do this for rules too. > > We use a red cross for disco

[pgadmin-hackers] [pgAdmin III] #306: Visual feedback of disabled triggers

2011-02-09 Thread pgAdmin Trac
#306: Visual feedback of disabled triggers --+- Reporter: Erika | Owner: dpage Type: feature | Status: new Priority: minor | Milestone: Component: pgadmin

Re: [pgadmin-hackers] Feature: visual feedback of disabled triggers

2011-02-07 Thread Dave Page
On Tue, Feb 8, 2011 at 7:32 AM, Guillaume Lelarge wrote: > Le 04/02/2011 11:42, R.I.K a écrit : >> [...] >> I would like to suggest you a simple feature : is it possible to add, in >> the left panel of pgAdmin (objects browser), a visual feedback of >> disabled trig

Re: [pgadmin-hackers] Feature: visual feedback of disabled triggers

2011-02-07 Thread Guillaume Lelarge
Le 04/02/2011 11:42, R.I.K a écrit : > [...] > I would like to suggest you a simple feature : is it possible to add, in > the left panel of pgAdmin (objects browser), a visual feedback of > disabled triggers (like a red cross, for example, or a greyed icon) ? > I think the greye

[pgadmin-hackers] Feature: visual feedback of disabled triggers

2011-02-06 Thread R.I.K
Hi, I would like to suggest you a simple feature : is it possible to add, in the left panel of pgAdmin (objects browser), a visual feedback of disabled triggers (like a red cross, for example, or a greyed icon) ? Thanks in advance, -- Erika -- Sent via pgadmin-hackers mailing list (pgadmin

Re: [pgadmin-hackers] [pgAdmin III] #256: Add triggers on views support

2010-11-07 Thread pgAdmin Trac
#256: Add triggers on views support --+- Reporter: gleu | Owner: gleu Type: feature | Status: closed Priority: minor| Milestone: 1.14 Component: pgadmin | Version

Re: [pgadmin-hackers] Ticket 256: add INSTEAD OF support for triggers

2010-11-07 Thread Guillaume Lelarge
Le 07/11/2010 06:40, Dave Page a écrit : > On Thu, Nov 4, 2010 at 11:19 PM, Guillaume Lelarge > wrote: >> Some patience, yeah, I did use that :) >> >> New patch attached. Works good for me. > > Eyeball review looks OK. > Thanks, commited. -- Guillaume http://www.postgresql.fr http://dalibo

Re: [pgadmin-hackers] Ticket 256: add INSTEAD OF support for triggers

2010-11-06 Thread Dave Page
On Thu, Nov 4, 2010 at 11:19 PM, Guillaume Lelarge wrote: > Some patience, yeah, I did use that :) > > New patch attached. Works good for me. Eyeball review looks OK. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise P

Re: [pgadmin-hackers] Ticket 256: add INSTEAD OF support for triggers

2010-11-04 Thread Guillaume Lelarge
cbFunction->GetValue() == wxString::Format(wxT("<%s>"), _("Inline EDB-SPL"))) sql += wxT("CREATE OR REPLACE TRIGGER ") + qtIdent(name); else sql += wxT("CREATE TRIGGER ") + qtIdent(name); -if (rdbFires->Get

Re: [pgadmin-hackers] [pgAdmin III] #256: Add triggers on views support

2010-10-30 Thread pgAdmin Trac
#256: Add triggers on views support ---+ Reporter: gleu | Owner: gleu Type: feature| Status: assigned Priority: minor | Milestone: Component: pgadmin| Version

Re: [pgadmin-hackers] Ticket 256: add INSTEAD OF support for triggers

2010-10-24 Thread Dave Page
[Ashesh, if you haven't aready, I suggest reviewing this thread. It may shed some light on that Rule weirdness on Solaris] On Sat, Oct 23, 2010 at 11:03 PM, Guillaume Lelarge wrote: >> pgView derives from pgSchemaObject > > Actually, pgView derives from pgRuleObject, which is already weird by > i

Re: [pgadmin-hackers] Ticket 256: add INSTEAD OF support for triggers

2010-10-23 Thread Guillaume Lelarge
Le 23/10/2010 14:03, Dave Page a écrit : > On Sat, Oct 23, 2010 at 3:00 PM, Guillaume Lelarge > wrote: >> Hi, >> >> It was much easier than I previously thought. This patch adds a Triggers >> node in the each view object node if you're connected to a 9.1 >&g

Re: [pgadmin-hackers] Ticket 256: add INSTEAD OF support for triggers

2010-10-23 Thread Dave Page
On Sat, Oct 23, 2010 at 3:00 PM, Guillaume Lelarge wrote: > Hi, > > It was much easier than I previously thought. This patch adds a Triggers > node in the each view object node if you're connected to a 9.1 > PostgreSQL server. You can add and see triggers on views. >

[pgadmin-hackers] Ticket 256: add INSTEAD OF support for triggers

2010-10-23 Thread Guillaume Lelarge
Hi, It was much easier than I previously thought. This patch adds a Triggers node in the each view object node if you're connected to a 9.1 PostgreSQL server. You can add and see triggers on views. It's not ready to be commited. I still have a bug to fix. I tried since two days, and I

[pgadmin-hackers] [pgAdmin III] #256: Add triggers on views support

2010-10-14 Thread pgAdmin Trac
#256: Add triggers on views support ---+ Reporter: gleu | Owner: dpage Type: feature| Status: new Priority: minor | Milestone: Component: pgadmin| Version: trunk

[pgadmin-hackers] pgAdmin III commit: Fix the reverse-engineered query for triggers

2010-09-24 Thread Guillaume Lelarge
Fix the reverse-engineered query for triggers The new "OF column" syntax is only available for UPDATE, and we should check the args only if the number of args is not zero. Set the bytea_output parameter to its old value on 9.0 right after a connection. The tgargs column is of type

[pgadmin-hackers] pgAdmin III commit: Fix the reverse-engineered query for triggers

2010-09-24 Thread Guillaume Lelarge
Fix the reverse-engineered query for triggers The new "OF column" syntax is only available for UPDATE, and we should check the args only if the number of args is not zero. Set the bytea_output parameter to its old value on 9.0 right after a connection. The tgargs column is of type

Re: [pgadmin-hackers] [pgAdmin III] #97: Triggers on columns

2010-01-21 Thread pgAdmin Trac
#97: Triggers on columns --+- Reporter: gleu | Owner: gleu Type: feature | Status: closed Priority: minor| Milestone: 1.12 Component: pgadmin | Version: trunk

Re: [pgadmin-hackers] [pgAdmin III] #97: Triggers on columns

2009-12-07 Thread pgAdmin Trac
#97: Triggers on columns --+- Reporter: gleu | Owner: gleu Type: feature | Status: closed Priority: minor| Milestone: 1.12 Component: pgadmin | Version: trunk

Re: [pgadmin-hackers] [pgAdmin III] #97: Triggers on columns

2009-12-07 Thread pgAdmin Trac
#97: Triggers on columns --+- Reporter: gleu | Owner: gleu Type: feature | Status: closed Priority: minor| Milestone: Component: pgadmin | Version: trunk

Re: [pgadmin-hackers] [pgAdmin III] #97: Triggers on columns

2009-11-24 Thread pgAdmin Trac
#97: Triggers on columns -+-- Reporter: gleu | Owner: gleu Type: feature | Status: assigned Priority: minor| Milestone: Component: pgadmin | Version: trunk

Re: [pgadmin-hackers] [pgAdmin III] #97: Triggers on columns

2009-11-22 Thread pgAdmin Trac
#97: Triggers on columns -+-- Reporter: gleu | Owner: dpage Type: feature | Status: new Priority: minor| Milestone: Component: pgadmin | Version: trunk

[pgadmin-hackers] [pgAdmin III] #97: Triggers on columns

2009-11-22 Thread pgAdmin Trac
#97: Triggers on columns -+-- Reporter: gleu | Owner: dpage Type: feature | Status: new Priority: minor| Milestone: Component: pgadmin | Version: trunk Keywords: trigger

Re: Pseudo alter triggers

2002-03-04 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 04 March 2002 22:24 > To: Dave Page; [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] Pseudo alter triggers > > > Le Lundi 4 Mars 2002 21:33, Dave Page a écrit : > > Bes

Re: Pseudo alter triggers

2002-03-04 Thread Jean-Michel POURE
Le Lundi 4 Mars 2002 21:33, Dave Page a écrit : > Best of both worlds I think, what about you? This seems to be a nice solution my friend. Cheers, Jean-Michel

Re: Pseudo alter triggers

2002-03-04 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 04 March 2002 17:04 > To: [EMAIL PROTECTED] > Subject: [pgadmin-hackers] Pseudo alter triggers > > > Dear all, > > I commited a fix to update display after pseudo-al

Pseudo alter triggers

2002-03-04 Thread Jean-Michel POURE
Dear all, I commited a fix to update display after pseudo-altering triggers. Dave: this might be ready for review... Cheers, Jean-Michel

Re: Triggers

2002-02-22 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 22 February 2002 22:07 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: Triggers > > > Dear Dave, > > I commited a first implementation of pseudo ALTER TRIGGER to

Triggers

2002-02-22 Thread Jean-Michel POURE
Dear Dave, I commited a first implementation of pseudo ALTER TRIGGER to CVS. Could you please advice me on the following points: 1) How can I drop / add the trigger node after ALTER. 2) I don't know how to uncheck checkboxes in frmTrigger form. These are very simple things to do... Have a niv

Re: Pseudo modification of views and triggers (

2002-02-20 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 20 February 2002 09:21 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] Pseudo modification of views > and triggers ( again) > > > Le Mercredi 20 F

Re: Pseudo modification of views and triggers ( again)

2002-02-20 Thread Jean-Michel POURE
ur previous discussions? pgAdmin2 is intended for a large audience, so better if no PL/pgSQL is required. What I see in pgSchema is a powerfull pseudo "CREATE TABLE foo_new AS" clause to copy schema information with selected linked objects (indexes, columns, primary key, triggers, rules, etc

Re: Pseudo modification of views and triggers (

2002-02-20 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 19 February 2002 21:19 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] Pseudo modification of views > and triggers (again) > > > > I've ju

Re: Pseudo modification of views and triggers (again)

2002-02-19 Thread Jean-Michel POURE
t; NOTE: I also noticed that you do not retrieve the new OID. This could be > done along with the definition. Yes, you are right. > Triggers could be implemented exactly as Views. Each property will need to > be handled seperately, though in the future we might look into merging > mul

Re: Pseudo modification of views and triggers (again)

2002-02-19 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 19 February 2002 19:53 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: Pseudo modification of views and triggers (again) > > > Dear Dave, > > 1) Views > View ps

Re: Pseudo modification of views and triggers

2002-02-19 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 19 February 2002 19:28 > To: [EMAIL PROTECTED] > Subject: [pgadmin-hackers] Pseudo modification of views and triggers > > > Dear Dave, > > I implemented pseudo-modi

Pseudo modification of views and triggers (again)

2002-02-19 Thread Jean-Michel POURE
ews, but I may be wrong. We need to rollback views in such a case. Does this means implementing view modification at pgSchema->View level? 2) Triggers It should be possible to change the name of a trigger as well as the underlying function, but not the trigger table itself. Therefore, it

Pseudo modification of views and triggers

2002-02-19 Thread Jean-Michel POURE
Dear Dave, I implemented pseudo-modification of views based on the function example. Pseudo modifiation is carried by a simple DROP /CREATE in both cases. This was pretty easy : I just had to copy and adapt your code... This seems to work fine. I will do the same for triggers and commit

Re: Triggers in PostgreSQL 7.1

2002-01-17 Thread Jean-Michel POURE
OK, please disregard my last message!!!

Triggers in PostgreSQL 7.1

2002-01-17 Thread Jean-Michel POURE
Dear all, I am using pgAdmin II on PostgreSQL 7.1. It seems like triggers are not listed in server objects. Do I miss something? Best regards, Jean-Michel POURE