Re: [pgadmin-support] enable/disable rules

2009-02-27 Thread Andreas Neumann
Perfect! Thanks for checking. Looking forward to 1.10 beta. Andreas On Fri, February 27, 2009 2:34 pm, Guillaume Lelarge wrote: > Andreas Neumann a écrit : >> hm - I have Postgres 8.3.3 - so if it is already in Pgadmin3 1.8.4 - how >> can I find this method? >> > > It seems I was wrong. I don't

Re: [pgadmin-support] enable/disable rules

2009-02-27 Thread Guillaume Lelarge
Andreas Neumann a écrit : > hm - I have Postgres 8.3.3 - so if it is already in Pgadmin3 1.8.4 - how > can I find this method? > It seems I was wrong. I don't find it in 1.8.4, but I find it in 1.9. So you need to wait for 1.10 beta, which is expected next week. > Should I find it in the context

Re: [pgadmin-support] enable/disable rules

2009-02-27 Thread Guillaume Lelarge
Andreas Neumann a écrit : > [...] > It would be cool if one could interactively enabe/disable rules on > individual tables (either all rules or selected rules), e.g. by > right-clicking on the rule (context menu). I saw that there is a patch for > this purpose > (http://ww

[pgadmin-support] enable/disable rules

2009-02-27 Thread Andreas Neumann
Hi, It would be cool if one could interactively enabe/disable rules on individual tables (either all rules or selected rules), e.g. by right-clicking on the rule (context menu). I saw that there is a patch for this purpose (http://www.mail-archive.com/pgadmin-hack...@postgresql.org/msg10671.html

Re: [pgadmin-support] Backup of rules

2006-12-06 Thread Dave Page
Ezequias Rodrigues da Rocha wrote: Hi list, It is possible to make a backup with an option to backup roles ? Mo - that requires pg_dumpall, which pgAdmin doesn't have an interface to yet. Regards, Dave. ---(end of broadcast)--- TIP 6: explai

[pgadmin-support] Backup of rules

2006-12-06 Thread Ezequias Rodrigues da Rocha
Hi list, It is possible to make a backup with an option to backup roles ? Regards ... -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Re: [pgadmin-support] Treatment of views with associated rules -

2006-11-28 Thread Dave Page
Ben Trewern wrote: All, I've just been trying to setup some updateable views using standard views and associated rules. Is there any possibility of when you open a view in the SQL editor the SQL for the associated rules also show up. It would seem to make sense. When a view is droppe

[pgadmin-support] Treatment of views with associated rules - Feature Request

2006-11-27 Thread Ben Trewern
All, I've just been trying to setup some updateable views using standard views and associated rules. Is there any possibility of when you open a view in the SQL editor the SQL for the associated rules also show up. It would seem to make sense. When a view is dropped the rules are sil

Re: [pgadmin-support] pgAdmin III Reverse Engineered SQL for RULES

2003-08-15 Thread Andreas Pflug
Dave Page wrote: -Original Message- *From:* Donald Fraser [mailto:[EMAIL PROTECTED] *Sent:* 15 August 2003 00:51 *To:* [pgADMIN] *Subject:* [pgadmin-support] pgAdmin III Reverse Engineered SQL for RULES Haven't checked the latest version. Ru

Re: [pgadmin-support] pgAdmin III Reverse Engineered SQL for RULES

2003-08-15 Thread Andreas Pflug
Gosh, didn't commit successfully, now it's conflicting. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [pgadmin-support] pgAdmin III Reverse Engineered SQL for RULES

2003-08-15 Thread Dave Page
> -Original Message- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 15 August 2003 11:49 > To: Dave Page > Cc: [pgADMIN] > Subject: Re: [pgadmin-support] pgAdmin III Reverse Engineered > SQL for RULES > > > Um, > did you notice that I alre

Re: [pgadmin-support] pgAdmin III Reverse Engineered SQL for RULES

2003-08-15 Thread Andreas Pflug
Donald Fraser wrote: Haven't checked the latest version. Running pgAdmin III 0.8.0 devel 3rd Aug. Feature requests: 1) The reverse engineered SQL code for RULES does not include the *normal* commented out -- DROP RULE ... Which I find very handy in most of the other reverse engineere

Re: [pgadmin-support] pgAdmin III Reverse Engineered SQL for RULES

2003-08-15 Thread Dave Page
Title: Message   -Original Message-From: Donald Fraser [mailto:[EMAIL PROTECTED] Sent: 15 August 2003 00:51To: [pgADMIN]Subject: [pgadmin-support] pgAdmin III Reverse Engineered SQL for RULES   Haven't checked the latest version. Running pgAdmin III 0.8.0 deve

[pgadmin-support] pgAdmin III Reverse Engineered SQL for RULES

2003-08-14 Thread Donald Fraser
  Haven't checked the latest version. Running pgAdmin III 0.8.0 devel 3rd Aug.   Feature requests: 1) The reverse engineered SQL code for RULES does not include the *normal* commented out -- DROP RULE ... Which I find very handy in most of the other reverse engineered SQL code.   2)

Re: [pgadmin-support] Bug for view with rules

2002-12-23 Thread Dave Page
Dave. -Original Message-From: Donald Fraser [mailto:[EMAIL PROTECTED]] Sent: 23 December 2002 14:22To: [EMAIL PROTECTED]Subject: [pgadmin-support] Bug for view with rules Hi Dave, thanks for the latest fix.   Have spent all morning creating the situation for a

Re: [pgadmin-support] Bug for view with rules

2002-12-23 Thread Dave Page
g for view with rules Hi Dave, thanks for the latest fix.   Have spent all morning creating the situation for a view that causes a crash - here it is...   First create a simple table such as:   CREATE TABLE public.tbl_catchbug ( id int4, s_sometext text ) WITHOUT

[pgadmin-support] Bug for view with rules

2002-12-23 Thread Donald Fraser
public.vu_tbl_catchbug TO postgres;   Next create a function in PL/SQL such as:   CREATE FUNCTION raise_exception1(text) RETURNS int4 AS ' DECLARE s_message ALIAS FOR $1; BEGIN     RAISE EXCEPTION s_message;     RETURN -1; END; ' LANGUAGE 'plpgsql';   Next create the followin

Re: [pgadmin-support] Can't delete rules

2002-11-29 Thread Dave Page
: Donald Fraser [mailto:[EMAIL PROTECTED]] Sent: 29 November 2002 10:13To: [EMAIL PROTECTED]Subject: [pgadmin-support] Can't delete rules pgAdmin Version 1.4.2   1) The syntax for the DROP RULE statement generated by pgAdmin is incorrect. If you try to drop a rule you ge

Re: [pgadmin-support] Can't delete rules

2002-11-29 Thread Dave Page
Title: Message Hi Donald, -Original Message-From: Donald Fraser [mailto:[EMAIL PROTECTED]] Sent: 29 November 2002 10:13To: [EMAIL PROTECTED]Subject: [pgadmin-support] Can't delete rules pgAdmin Version 1.4.2   1) The syntax for the DROP RULE stat

[pgadmin-support] Can't delete rules

2002-11-29 Thread Donald Fraser
52002-11-28 13:58:47 - DBMS Version: 07.02.0004 PostgreSQL 7.2.3 on i686-pc-linux-gnu, compiled by GCC 2.96   2) Not a bug, more of a lacking feature: You can't create rules for views, this is a pain as the only way you can update, insert or delete on views is to create rules for them.   Regards Donald

Re: RULES

2001-11-10 Thread Dave Page
  -Original Message-From: Edward Grabczewski [mailto:[EMAIL PROTECTED]] Sent: 10 November 2001 11:03To: [EMAIL PROTECTED]: [pgadmin-support] RULES Are or will RULES be supported in AdminII?   Currently pgAdmin II supports Rules on tables only. Rules (and

RULES

2001-11-10 Thread Edward Grabczewski
Are or will RULES be supported in AdminII? Eddy Grabczewskimailto:[EMAIL PROTECTED]";>[EMAIL PROTECTED]

RULES

2001-11-10 Thread Edward Grabczewski
Are or will RULES be supported in AdminII?   Eddy Grabczewskimailto:[EMAIL PROTECTED]";>[EMAIL PROTECTED]