Re: [pgadmin-hackers] Final pgAdmin III - v1.22.2 Released

2016-11-25 Thread Erwin Brandstetter
So long an thanks for all the fish! How does the final release of pgadmin III v1.22.2 compare to the BigSQL release "pgAdmin3 LTS 1.23.0a" A later version number, released earlier? https://bigsql.com/components.jsp https://bigsql.org/pgadmin3/index.jsp Which one would you recommend as final vers

[pgadmin-hackers] Display of DEFAULT PRIVILEGES incorrect

2013-11-19 Thread Erwin Brandstetter
Hi developers! The owner / target_role is missing from the SQL script for ALTER DEFAULT PRIVILEGES. I created an issue in Redmine under my Postgres account (brsa) with all the details, steps to reproduce et al. https://redmine.postgresql.org/issues/694 I haven't posted for so long I am not

Re: [pgadmin-hackers] Re: Missing REVOKE in SQL for functions with SECURITY DEFINER (or any function, really)

2013-04-23 Thread Erwin Brandstetter
ave Page wrote: Dhiraj, can you look into this please? Thanks. On Sun, Apr 7, 2013 at 11:02 PM, Erwin Brandstetter wrote: Hi developers! I have been missing in action for a while, so I am not sure whether anybody even uses trac any more. Either way, I just ran into this bug once again and che

[pgadmin-hackers] Re: Missing REVOKE in SQL for functions with SECURITY DEFINER (or any function, really)

2013-04-07 Thread Erwin Brandstetter
the DDL script. To reproduce: CREATE OR REPLACE FUNCTION foo() RETURNS int AS 'SELECT 1' LANGUAGE sql; REVOKE EXECUTE ON FUNCTION foo() FROM public; This is a **potential security hazard** and it has been open for (at least) over a year now. Regards Erwin On 27.02.2012 23:53, Erwin Br

Re: [pgadmin-hackers] Re: Items missing from some context menus in object browser of v1.16 beta4

2012-09-11 Thread Erwin Brandstetter
On 11.09.2012 19:41, Guillaume Lelarge wrote: On Sat, 2012-09-08 at 02:04 +0200, Erwin Brandstetter wrote: On 05.09.2012 23:12, Guillaume Lelarge wrote: On Fri, 2012-08-31 at 23:55 +0200, Guillaume Lelarge wrote: On Mon, 2012-08-27 at 16:57 +0200, Erwin Brandstetter wrote: On 27.08.2012 16

Re: [pgadmin-hackers] Re: Items missing from some context menus in object browser of v1.16 beta4

2012-09-07 Thread Erwin Brandstetter
On 05.09.2012 23:12, Guillaume Lelarge wrote: On Fri, 2012-08-31 at 23:55 +0200, Guillaume Lelarge wrote: On Mon, 2012-08-27 at 16:57 +0200, Erwin Brandstetter wrote: On 27.08.2012 16:37, Erwin Brandstetter wrote: Aloha! I think I ran into this regression with v1.16 beta4 and filed a ticket

[pgadmin-hackers] Re: Items missing from some context menus in object browser of v1.16 beta4

2012-08-27 Thread Erwin Brandstetter
On 27.08.2012 16:37, Erwin Brandstetter wrote: Aloha! I think I ran into this regression with v1.16 beta4 and filed a ticket. So far I have seen this to affect indexes, primary keys and foreign keys But *not* tables, views, function, triggers, sequences or types ... Added two small screenshots

[pgadmin-hackers] Items missing from some context menus in object browser of v1.16 beta4

2012-08-27 Thread Erwin Brandstetter
Aloha! I think I ran into this regression with v1.16 beta4 and filed a ticket. So far I have seen this to affect indexes, primary keys and foreign keys But *not* tables, views, function, triggers, sequences or types ... Added two small screenshots to the ticket to compare 1.4 and 1.16b4 http

[pgadmin-hackers] Bug in SQL script for indexes

2012-08-27 Thread Erwin Brandstetter
Aloha! The SQL script for indexes incorrectly prepends the index name with the table name of the involved table - instead of the schema name where the index lives. Demo to reproduce: I say: CREATE TABLE x(name text); CREATE INDEX name_idx ON x (name); pgAdmin says: -- Index: x.na

Re: [pgadmin-hackers] Should we keep using trac?

2012-06-18 Thread Erwin Brandstetter
On Jun 18, 10:35 am, dp...@pgadmin.org (Dave Page) wrote: > On Mon, Jun 18, 2012 at 9:30 AM, Guillaume Lelarge > > wrote: > > On Sun, 2012-06-17 at 12:15 -0300, Dickson S. Guedes wrote: > >> 2012/6/17 Guillaume Lelarge : > >> > Quick question: is trac the right tool? > > >> Which problems we are t

[pgadmin-hackers] Re: Missing REVOKE in SQL for functions with SECURITY DEFINER (or any function, really)

2012-02-27 Thread Erwin Brandstetter
On 27.02.2012 23:38, Erwin Brandstetter wrote: Hi developers! Congratulations on the many bug fixes in the latest release! I think I found another serious problem. Testing with pgAdmin 1.14.2 on Windows XP. Server is PostgreSQL 9.1 on Devian Squeeze. There is a security hazard lingering in

[pgadmin-hackers] Missing REVOKE in SQL for functions with SECURITY DEFINER (or any function, really)

2012-02-27 Thread Erwin Brandstetter
Hi developers! Congratulations on the many bug fixes in the latest release! I think I found another serious problem. Testing with pgAdmin 1.14.2 on Windows XP. Server is PostgreSQL 9.1 on Devian Squeeze. There is a security hazard lingering in the reverse engineered SQL of the latest version

Re: [pgadmin-hackers] Re: pgAdmin III commit: Fix constraints handling on the table properties di

2012-02-27 Thread Erwin Brandstetter
On 19.12.2011 14:07, Guillaume Lelarge wrote: On Mon, 2011-12-19 at 03:42 -0800, Erwin Brandstetter wrote: On Dec 10, 11:46 am, guilla...@lelarge.info (Guillaume Lelarge) wrote: Fix constraints handling on the table properties dialog The wxListCtrl control doesn't handle strings or more

[pgadmin-hackers] Re: pgAdmin III commit: Fix constraints handling on the table properties di

2011-12-19 Thread Erwin Brandstetter
On Dec 19, 12:42 pm, Erwin Brandstetter wrote: > On Dec 10, 11:46 am, guilla...@lelarge.info (Guillaume Lelarge) wrote: > > > > > > > > > > > Fix constraints handling on the table properties dialog > > > The wxListCtrl control doesn't handle stri

[pgadmin-hackers] Re: pgAdmin III commit: Fix constraints handling on the table properties di

2011-12-19 Thread Erwin Brandstetter
On Dec 10, 11:46 am, guilla...@lelarge.info (Guillaume Lelarge) wrote: > Fix constraints handling on the table properties dialog > > The wxListCtrl control doesn't handle strings or more than 512 characters on > Windows. So we need to put the definition of constraints in a wxArrayString so > that w

Re: [pgadmin-hackers] v1.14 beta1: Ctrl-C does not copy selected text inside a textbox in the edit grid

2011-08-30 Thread Erwin Brandstetter
Aloha! On 30.04.2011 09:43, Erwin Brandstetter wrote: On 30.04.2011 09:23, Guillaume Lelarge wrote: Le 29/04/2011 16:55, Erwin Brandstetter a écrit : [...] Testing pgAdmin v1.14 beta1 on Win XP Home Concerning .. 2010-08-30 GL 1.14.0 Allow the use of Ctrl-V inside a textbox of frmEditGrid

[pgadmin-hackers] www: dead link far 1.14 docs

2011-08-19 Thread Erwin Brandstetter
Aloha! Here is a dead link http://pgadmin.org/docs/ to http://pgadmin.org/docs/1.14/index.html Tested 2011-08-20 01:00 UTC Regards Erwin -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pg

Re: [pgadmin-hackers] Changed default ordering in tables

2011-08-08 Thread Erwin Brandstetter
Thanks to both of you! Looking forward to the next release! -- Erwin Brandstetter On 06.08.2011 14:49, Guillaume Lelarge wrote: On Fri, 2011-07-29 at 10:33 +0100, Dave Page wrote: On Fri, Jul 29, 2011 at 9:14 AM, Erwin Brandstetter wrote: So, that's two distinct issue: - "Las

Re: [pgadmin-hackers] Changed default ordering in tables

2011-07-29 Thread Erwin Brandstetter
On 29.07.2011 07:10, Erwin Brandstetter wrote: On 29.07.2011 04:57, Erwin Brandstetter wrote: On 26.07.2011 23:20, Dave Page wrote: On Tue, Jul 26, 2011 at 9:53 PM, Erwin Brandstetter wrote: That may be the key here. When I open the simple test table from above in v1.14 I get descending

Re: [pgadmin-hackers] Changed default ordering in tables

2011-07-28 Thread Erwin Brandstetter
On 29.07.2011 04:57, Erwin Brandstetter wrote: On 26.07.2011 23:20, Dave Page wrote: On Tue, Jul 26, 2011 at 9:53 PM, Erwin Brandstetter wrote: That may be the key here. When I open the simple test table from above in v1.14 I get descending order. On opening the Sort/Filter dialog it see an

Re: [pgadmin-hackers] Changed default ordering in tables

2011-07-28 Thread Erwin Brandstetter
On 26.07.2011 23:20, Dave Page wrote: On Tue, Jul 26, 2011 at 9:53 PM, Erwin Brandstetter wrote: That may be the key here. When I open the simple test table from above in v1.14 I get descending order. On opening the Sort/Filter dialog it see an explicit ORDER BY test_id DESCENDING - which I

Re: [pgadmin-hackers] Changed default ordering in tables

2011-07-26 Thread Erwin Brandstetter
On 26.07.2011 22:29, Dave Page wrote: On Tue, Jul 26, 2011 at 7:13 PM, Erwin Brandstetter wrote: On 26.07.2011 18:12, Dave Page wrote: Hi Erwin On Tue, Jul 26, 2011 at 4:47 PM, Erwin Brandstetter wrote: Aloha! In v1.14 tables are opened with ORDER BY $pkey DESC. I wonder if

Re: [pgadmin-hackers] Changed default ordering in tables

2011-07-26 Thread Erwin Brandstetter
On 26.07.2011 18:12, Dave Page wrote: Hi Erwin On Tue, Jul 26, 2011 at 4:47 PM, Erwin Brandstetter wrote: Aloha! In v1.14 tables are opened with ORDER BY $pkey DESC. I wonder if descending order ist intended. It used to be the other way round and, as far as I am concerned, that was just

[pgadmin-hackers] Changed default ordering in tables

2011-07-26 Thread Erwin Brandstetter
. No need to change the default behavior? -- Erwin Brandstetter -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers

Re: [pgadmin-hackers] Idea: check SQL before copying to SQL dialogue.

2011-07-21 Thread Erwin Brandstetter
On 20.07.2011 22:45, Guillaume Lelarge wrote: On Wed, 2011-07-20 at 21:41 +0200, Erwin Brandstetter wrote: On 20.07.2011 20:26, Guillaume Lelarge wrote: On Wed, 2011-07-20 at 19:05 +0100, Dave Page wrote: On Wed, Jul 20, 2011 at 6:05 PM, Erwin Brandstetter wrote: Aloha! A lot of work has

Re: [pgadmin-hackers] Idea: check SQL before copying to SQL dialogue.

2011-07-20 Thread Erwin Brandstetter
On 20.07.2011 20:26, Guillaume Lelarge wrote: On Wed, 2011-07-20 at 19:05 +0100, Dave Page wrote: On Wed, Jul 20, 2011 at 6:05 PM, Erwin Brandstetter wrote: Aloha! A lot of work has been put into when and where to refresh the browser window. From my experience it is often a _good_ thing

[pgadmin-hackers] Idea: check SQL before copying to SQL dialogue.

2011-07-20 Thread Erwin Brandstetter
Aloha! A lot of work has been put into when and where to refresh the browser window. From my experience it is often a _good_ thing, that changes via SQL are not reflected in the browser window immediately. Serves me well as a poor man's undo-tool. On the other hand, one tends to forget about re

Re: [pgadmin-hackers] Wrong statistics for overloaded functions

2011-07-07 Thread Erwin Brandstetter
On 07.07.2011 08:52, Guillaume Lelarge wrote: On Wed, 2011-07-06 at 21:22 +0200, Erwin Brandstetter wrote: Aloha! I have been observing irregularities in the function statistics for some time. Now I have investigated and believe to have found the cause. Everything is here, including a

[pgadmin-hackers] Wrong statistics for overloaded functions

2011-07-06 Thread Erwin Brandstetter
Aloha! I have been observing irregularities in the function statistics for some time. Now I have investigated and believe to have found the cause. Everything is here, including a proposed fix: http://code.pgadmin.org/trac/ticket/325 Regards Erwin -- Sent via pgadmin-hackers mailing list (

Re: [pgadmin-hackers] Branch 1.14?

2011-06-19 Thread Erwin Brandstetter
On Jun 15, 11:57 am, dp...@pgadmin.org (Dave Page) wrote: > On Wed, Jun 15, 2011 at 10:09 AM, Guillaume Lelarge > > wrote: > > We don't have both. We currently have a pgAdmin which supports > > everything back to 7.3. > > No we don't. We have a pgAdmin, which it says on the website supports > back

Re: [pgadmin-hackers] Database bar

2011-06-13 Thread Erwin Brandstetter
On 13.06.2011 14:56, Guillaume Lelarge wrote: On Mon, 2011-06-13 at 00:36 +0200, Erwin Brandstetter wrote: On 12.06.2011 08:59, Guillaume Lelarge wrote: On Sat, 2011-06-11 at 22:24 +0200, Erwin Brandstetter wrote: (...) After closing pgAdmin a new entry "perspective-8316" lan

Re: [pgadmin-hackers] Database bar

2011-06-12 Thread Erwin Brandstetter
On 12.06.2011 08:59, Guillaume Lelarge wrote: On Sat, 2011-06-11 at 22:24 +0200, Erwin Brandstetter wrote: On 11.06.2011 18:16, Guillaume Lelarge wrote: On Sat, 2011-06-11 at 18:13 +0200, Erwin Brandstetter wrote: On 11.06.2011 17:17, Guillaume Lelarge wrote: On Sat, 2011-06-11 at 16:02

Re: [pgadmin-hackers] Database bar

2011-06-11 Thread Erwin Brandstetter
On 11.06.2011 18:16, Guillaume Lelarge wrote: On Sat, 2011-06-11 at 18:13 +0200, Erwin Brandstetter wrote: On 11.06.2011 17:17, Guillaume Lelarge wrote: On Sat, 2011-06-11 at 16:02 +0200, Erwin Brandstetter wrote: On 28.05.2011 15:56, Guillaume Lelarge wrote: (...) So, I finally did some

Re: [pgadmin-hackers] Database bar

2011-06-11 Thread Erwin Brandstetter
On 28.05.2011 15:56, Guillaume Lelarge wrote: On 05/09/2011 07:17 PM, Erwin Brandstetter wrote: On 06.05.2011 23:40, Guillaume Lelarge wrote: On 05/06/2011 04:27 PM, Erwin Brandstetter wrote: Hi Guillaume! On 05.05.2011 22:50, Guillaume Lelarge wrote: On 05/05/2011 05:25 PM, Erwin

Re: [pgadmin-hackers] Database bar

2011-05-09 Thread Erwin Brandstetter
On 06.05.2011 23:40, Guillaume Lelarge wrote: On 05/06/2011 04:27 PM, Erwin Brandstetter wrote: Hi Guillaume! On 05.05.2011 22:50, Guillaume Lelarge wrote: On 05/05/2011 05:25 PM, Erwin Brandstetter wrote: (...) Changing to another connection and changing back does not change the situation

Re: [pgadmin-hackers] v1.14 SQL editor collapsing feature

2011-05-06 Thread Erwin Brandstetter
On 06.05.2011 21:52, Dave Page wrote: On Friday, May 6, 2011, Erwin Brandstetter wrote: About the new feature the SQL editor: collapsing / expanding logical parts of the code .. (Do we have a name for it?) Other features like this have an entry in the "View" menu with which to

[pgadmin-hackers] v1.14 SQL editor collapsing feature

2011-05-06 Thread Erwin Brandstetter
About the new feature the SQL editor: collapsing / expanding logical parts of the code .. (Do we have a name for it?) Other features like this have an entry in the "View" menu with which to activate / deactivate it. Indent guides Line ends White space ... I had half expected to

Re: [pgadmin-hackers] Database bar

2011-05-06 Thread Erwin Brandstetter
Hi Guillaume! On 05.05.2011 22:50, Guillaume Lelarge wrote: On 05/05/2011 05:25 PM, Erwin Brandstetter wrote: (...) - What if someone issues one of the following commands? RESET role; SET ROLE TO my_other_role; See for yourself: SELECT current_user, session_user; The display in

[pgadmin-hackers] Database bar

2011-05-05 Thread Erwin Brandstetter
Aloha! I have had a closer look at the status of the "database bar" or "database selector" in the sql editor in v1.12.3 and v1.14beta1. Testing on Win XP Pro with pg 8.4 on Debian Lenny. Sorry for nagging, but that is my role here ... In 1.12.3: The bug I reported previously is still there. The

Re: [pgadmin-hackers] pgAdmin 1.14 Visual Tour

2011-05-01 Thread Erwin Brandstetter
Hi Guillaume! I find the visual tour very useful! One thing: > We allowed the use of the mousewheel to display the text bigger or smaller. This has already been there in 1.12.2 or earlier. And one ammendment to Adam's suggestions: On May 1, 12:57 am, adam.c.sc...@gmail.com (Adam Scott) wrote: (.

Re: [pgadmin-hackers] v1.14 beta1: Ctrl-C does not copy selected text inside a textbox in the edit grid

2011-04-30 Thread Erwin Brandstetter
On 30.04.2011 09:23, Guillaume Lelarge wrote: Le 29/04/2011 16:55, Erwin Brandstetter a écrit : [...] Testing pgAdmin v1.14 beta1 on Win XP Home Concerning .. 2010-08-30 GL 1.14.0 Allow the use of Ctrl-V inside a textbox of frmEditGrid. Patch from Steffen Kuhn. Ctrl-V now works fine to

Re: [pgadmin-hackers] v1.14 beta1: Ctrl-C does not copy selected text inside a textbox in the edit grid

2011-04-30 Thread Erwin Brandstetter
On 30.04.2011 09:23, Guillaume Lelarge wrote: Le 29/04/2011 16:55, Erwin Brandstetter a écrit : [...] Testing pgAdmin v1.14 beta1 on Win XP Home Concerning .. 2010-08-30 GL 1.14.0 Allow the use of Ctrl-V inside a textbox of frmEditGrid. Patch from Steffen Kuhn. Ctrl-V now works fine to

[pgadmin-hackers] v1.14 beta1: Ctrl-C does not copy selected text inside a textbox in the edit grid

2011-04-29 Thread Erwin Brandstetter
Aloha! Testing pgAdmin v1.14 beta1 on Win XP Home Concerning .. > 2010-08-30 GL 1.14.0 Allow the use of Ctrl-V inside a textbox of frmEditGrid. Patch from Steffen Kuhn. Ctrl-V now works fine to paste text. If I select part of the text (in edit mode) and use "Copy" from the context menu, the

Re: [pgadmin-hackers] 1.12.3 built

2011-04-27 Thread Erwin Brandstetter
On 27.04.2011 17:33, Dave Page wrote: On Wed, Apr 27, 2011 at 4:30 PM, Erwin Brandstetter wrote: On 27.04.2011 17:00, Dave Page wrote: On Wed, Apr 27, 2011 at 2:49 PM, Erwin Brandstetter wrote: On Apr 14, 11:00 pm, dp...@pgadmin.org (Dave Page) wrote: Source, windows and osx builds athttp

Re: [pgadmin-hackers] 1.12.3 built

2011-04-27 Thread Erwin Brandstetter
On 27.04.2011 17:00, Dave Page wrote: On Wed, Apr 27, 2011 at 2:49 PM, Erwin Brandstetter wrote: On Apr 14, 11:00 pm, dp...@pgadmin.org (Dave Page) wrote: Source, windows and osx builds athttp://developer.pgadmin.org/ftp/release/v1.12.3/ Please give them a sanity check! After working with

Re: [pgadmin-hackers] 1.12.3 built

2011-04-27 Thread Erwin Brandstetter
On Apr 14, 11:00 pm, dp...@pgadmin.org (Dave Page) wrote: > Source, windows and osx builds > athttp://developer.pgadmin.org/ftp/release/v1.12.3/ > > Please give them a sanity check! After working with it for a couple of days, something stands out. I have had 4 crashes when applying a filter in th

Re: [pgadmin-hackers] Server status button

2011-04-22 Thread Erwin Brandstetter
On Apr 21, 8:31 pm, dp...@pgadmin.org (Dave Page) wrote: > Hi, > > I wonder if we should replace the "View filtered data" button on the > main tool bar with one for opening the the server status monitor? We > already have a View Data button, and the server status tool is pretty > comprehensive now,

[pgadmin-hackers] Properties dialogue: REVOKE goes wrong in certain cases.

2011-04-21 Thread Erwin Brandstetter
Hi developers! While testing the new release I verified that a bug is still there. So I created a ticket accordingly: http://code.pgadmin.org/trac/ticket/315 Description and testcase included. Priority major, because it includes data loss and security risk in rare cases. Regards Erwin --

Re: [pgadmin-hackers] 1.12.3 built

2011-04-21 Thread Erwin Brandstetter
On 20.04.2011 21:19, Dave Page wrote: On Wed, Apr 20, 2011 at 7:28 PM, Erwin Brandstetter wrote: (...) I noticed a couple of small issues on the server status window: - Menu-Help-Help does not do anything. Do you mean "Help -> Help Contents"? It works for me, on a clean VM.

Re: [pgadmin-hackers] 1.12.3 built

2011-04-21 Thread Erwin Brandstetter
On 20.04.2011 21:41, Guillaume Lelarge wrote: Le 20/04/2011 21:19, Dave Page a écrit : On Wed, Apr 20, 2011 at 7:28 PM, Erwin Brandstetter wrote: (...) - Colors in Acrivity pane are not explained anywhere (I think that has been discussed already.) If you want me to, I will open tickets for

Re: [pgadmin-hackers] 1.12.3 built

2011-04-20 Thread Erwin Brandstetter
Aloha! I have been working with 1.12.3 on Win XP for a day now. Databases are pg 8.4.7 on Debian Lenny - so, not the latest stuff. Except from the problem with upgrading from 1.12.2 the overall impression is very good. The new version seems generally more responsive. Especially the small fixes

Re: [pgadmin-hackers] 1.12.3 built

2011-04-19 Thread Erwin Brandstetter
On 19.04.2011 13:56, Dave Page wrote: On Tue, Apr 19, 2011 at 12:16 PM, Erwin Brandstetter wrote: On 18.04.2011 18:52, Dave Page wrote: On Mon, Apr 18, 2011 at 5:06 PM, Erwin Brandstetter wrote: On Apr 14, 11:00 pm,dp...@pgadmin.org (Dave Page) wrote: Source, windows and osx builds

Re: [pgadmin-hackers] 1.12.3 built

2011-04-19 Thread Erwin Brandstetter
On 18.04.2011 18:52, Dave Page wrote: On Mon, Apr 18, 2011 at 5:06 PM, Erwin Brandstetter wrote: On Apr 14, 11:00 pm,dp...@pgadmin.org (Dave Page) wrote: Source, windows and osx builds athttp://developer.pgadmin.org/ftp/release/v1.12.3/ Please give them a sanity check! I downloaded the

Re: [pgadmin-hackers] 1.12.3 built

2011-04-18 Thread Erwin Brandstetter
On Apr 14, 11:00 pm, dp...@pgadmin.org (Dave Page) wrote: > Source, windows and osx builds > athttp://developer.pgadmin.org/ftp/release/v1.12.3/ > > Please give them a sanity check! I downloaded the Windows build and tried upgrading from pgAdmin 1.12.2 on a PC with Win XP Pro. upgrade.bat did not

Re: [pgadmin-hackers] Source reindenting

2011-01-04 Thread Erwin Brandstetter
On Thursday, December 30, 2010 6:33:14 PM UTC+1, Guillaume Lelarge wrote: > Le 30/12/2010 11:24, Magnus Hagander a �crit : > > On Thu, Dec 30, 2010 at 11:13, Guillaume Lelarge > > wrote: > >> Le 30/12/2010 09:52, Magnus Hagander a �crit : (...) > >>> Do you also prefer tabs in the end, and

[pgadmin-hackers] Uncalled CREATE OR REPLACE VIEW in privileges dialog

2011-01-04 Thread Erwin Brandstetter
Hi developers! My best wishes for 2011 to the pgAdmin team! :) Testing v.1.12.2 (Dec 13 2010) on Windows XP Pro, Server PostgreSQL 8.4.5 on Debian Lenny. I found some weirdness in the privileges dialog for VIEWs. On changing any privileges via dialog, the VIEW itself gets CREATE OR REPLACEd

Re: [pgadmin-hackers] 1.12.2 builds

2010-12-23 Thread Erwin Brandstetter
On Thursday, December 16, 2010 3:56:54 PM UTC+1, pgSnake wrote: > To update the runtimes I expect. Probably. But it should work without a system restart. And it actually did, when I installed on another machine now with a freshly installed Win XP Pro. As the upgrade worked in any case, I don't t

Re: [pgadmin-hackers] 1.12.2 builds

2010-12-16 Thread Erwin Brandstetter
I upgraded from 1.12.1 to 1.12.2 on two different Win XP machines without a problem. Upgrade requires to restart Windows afterwards. I wonder why that is necessary? Regards Erwin -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http

[pgadmin-hackers] Logfile name is hard to adjust

2010-11-18 Thread Erwin Brandstetter
Aloha! Testing pgAdmin v1.12.1 on Windows XP Pro. New PC, I installed from scratch, so I revisited a couple of steps I hadn't touched in quite a while. Under File ->Options ->Logging .. It is not possible to change the logfile name to a filename that does not exist yet. Changes typed in by han

Re: [pgadmin-hackers] [pgAdmin III] #232: Smart defaults for new connection in query tool

2010-09-14 Thread Erwin Brandstetter
On Sep 9, 11:34 pm, t...@code.pgadmin.org ("pgAdmin Trac") wrote: > #232: Smart defaults for new connection in query tool (...) > Comment(by gleu): > >  Patch at >  http://github.com/gleu/pgadmin3/commit/8c358a7ead668bc7b2f7c845ab83b4... I am not fluent in C, but from what I see, that should do th

Re: [pgadmin-hackers] Problem with insert - 1.12.0 RC1

2010-09-01 Thread Erwin Brandstetter
On 02.09.2010 01:14, Guillaume Lelarge wrote: Le 02/09/2010 00:41, Erwin Brandstetter a écrit : On Aug 31, 7:19 pm,sid.the.technic...@gmail.com (Sid) wrote: Hi, ~~~ Local installation: Windows 7 / Polish PgAdmin III: V. 1.12.0 RC1 PostgreSQL: 8.4.4

Re: [pgadmin-hackers] Problem with insert - 1.12.0 RC1

2010-09-01 Thread Erwin Brandstetter
On Aug 31, 7:19 pm, sid.the.technic...@gmail.com (Sid) wrote: > Hi, > > ~~~ > Local installation: > Windows 7 / Polish > PgAdmin III: V. 1.12.0 RC1 > PostgreSQL: 8.4.4 > ~~~ > > Table should have some constraints (not null for instance) . > Open table to edit

Re: [pgadmin-hackers] 1.12.0 beta 3 uploaded

2010-07-13 Thread Erwin Brandstetter
On 12.07.2010 09:59, Guillaume Lelarge wrote: Le 12/07/2010 03:31, Erwin Brandstetter a écrit : (...) I will not be able to do a lot of testing, as I am away from July 15th to August, 20th - which is a good thing otherwise. :) Thailand and Cambodia. More than a month, lucky guy

Re: [pgadmin-hackers] [pgAdmin III] #210: Wrong Server selected after changing "Group"

2010-07-11 Thread Erwin Brandstetter
On Jul 12, 3:23 am, t...@code.pgadmin.org ("pgAdmin Trac") wrote: > #210: Wrong Server selected after changing "Group" BTW: it would be nice, if one could just rename a server "Group" instead of changing the attribute of every single contained server. But this is not an important feature, as it is

Re: [pgadmin-hackers] 1.12.0 beta 3 uploaded

2010-07-11 Thread Erwin Brandstetter
I am testing beta3. So far, I have found a few bugs and created / reopened tickets accordingly. I will not be able to do a lot of testing, as I am away from July 15th to August, 20th - which is a good thing otherwise. :) Thailand and Cambodia. Regards Erwin -- Sent via pgadmin-hackers mailing l

[pgadmin-hackers] Re: Create Table Dialog: Change Column after creation/Reorder Columns

2010-06-26 Thread Erwin Brandstetter
On Jun 22, 5:36 pm, onur.ogu...@gmail.com (Onur GUZEL) wrote: > Dave Page wrote: > > Please don't. This would take far more work than it is worth, and > > there are a ton of ways it can go wrong. The likelihood of me > > accepting a patch for post-creation rearrangement of columns is > > extremely

Re: [pgadmin-hackers] 60 GB of error log.

2010-05-20 Thread Erwin Brandstetter
On 20.05.2010 05:21, dp...@pgadmin.org wrote: 2010/5/19 Erwin Brandstetter: Aloha! I encountered a serious problem involving pgAdmin3 1.10.3 today. But I am not entirely sure, what is to blame. Maybe one of you can make anything of it? I gave a application-developer access to one of our

[pgadmin-hackers] 60 GB of error log.

2010-05-19 Thread Erwin Brandstetter
Aloha! I encountered a serious problem involving pgAdmin3 1.10.3 today. But I am not entirely sure, what is to blame. Maybe one of you can make anything of it? I gave a application-developer access to one of our databases (postgres 8.4.3 on Debian Lenny) so we could discuss the design of a n

[pgadmin-hackers] Reverse engineering of functions ..

2010-05-19 Thread Erwin Brandstetter
Aloha! Found another hitch with functions returning TABLE(). #191 says it all. On a side note, the SQL example demonstrates another small issue: ... LANGUAGE sql is transformed to ... LANGUAGE 'sql' -- note the quotes. "langname" is a name, not a text. For backward compatibility th

Re: [pgadmin-hackers] Bug in 1.10.3: Properties dialog for functions returning TABLE(..) is broken.

2010-05-14 Thread Erwin Brandstetter
On 14.05.2010 22:54, brsaw...@gmail.com wrote: On 14.05.2010 22:24, guilla...@lelarge.info wrote: Le 14/05/2010 13:42, Dave Page a écrit : On Fri, May 14, 2010 at 12:32 PM, Erwin Brandstetter wrote: On 14.05.2010 08:49, guilla...@lelarge.info wrote: Hi Erwin, Le 14/05/2010 04:35, Erwin

Re: [pgadmin-hackers] Bug in 1.10.3: Properties dialog for functions returning TABLE(..) is broken.

2010-05-14 Thread Erwin Brandstetter
On 14.05.2010 22:24, guilla...@lelarge.info wrote: Le 14/05/2010 13:42, Dave Page a écrit : On Fri, May 14, 2010 at 12:32 PM, Erwin Brandstetter wrote: On 14.05.2010 08:49, guilla...@lelarge.info wrote: Hi Erwin, Le 14/05/2010 04:35, Erwin Brandstetter a écrit

Re: [pgadmin-hackers] Re: SVN Commit by dpage: r8369 - in trunk/pgadmin3: . docs pgadmin pkg/win32

2010-05-14 Thread Erwin Brandstetter
On 14.05.2010 10:06, Dave Page wrote: On Thu, May 13, 2010 at 5:57 PM, Erwin Brandstetter wrote: Might fix #152, too? (need to install MS VC++ 2005 Redistributable Package first on certain XP Home PCs) I still don't understand how you get that problem - we ship the redistribu

Re: [pgadmin-hackers] Bug in 1.10.3: Properties dialog for functions returning TABLE(..) is broken.

2010-05-14 Thread Erwin Brandstetter
On 14.05.2010 08:49, guilla...@lelarge.info wrote: Hi Erwin, Le 14/05/2010 04:35, Erwin Brandstetter a écrit : [...] On further testing 1.10.3 beta on Win XP Pro I found a bug that might be a show-stopper. See ticket #188. Can you give us the real statement to create that function

[pgadmin-hackers] Bug in 1.10.3: Properties dialog for functions returning TABLE(..) is broken.

2010-05-13 Thread Erwin Brandstetter
Aloha! On further testing 1.10.3 beta on Win XP Pro I found a bug that might be a show-stopper. See ticket #188. Regards Erwin -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers

[pgadmin-hackers] Re: SVN Commit by dpage: r8369 - in trunk/pgadmin3: . docs pgadmin pkg/win32

2010-05-13 Thread Erwin Brandstetter
On May 13, 6:25 pm, dp...@pgadmin.org (Dave Page) wrote: > On Thu, May 13, 2010 at 5:06 PM, Guillaume Lelarge > > > > wrote: > > Le 13/05/2010 17:56, s...@pgadmin.org a écrit : > >> Author: dpage > > >> Date: 2010-05-13 16:56:01 +0100 (Thu, 13 May 2010) > > >> New Revision: 8369 > > >> Revision >

Re: [pgadmin-hackers] 1.10.3 Uploaded

2010-05-13 Thread Erwin Brandstetter
On May 13, 12:03 pm, dp...@pgadmin.org (Dave Page) wrote: (...) > Please take a minute to check for any show-stopper issues! I have been testing Guillaume's pgadmin3.exe from 2010-04-29 in a 1.10.2 environment extensively over the last two weeks. On Win XP Pro and Win XP Home . Aside from the cras

Re: [pgadmin-hackers] "Compact" and "complete" SQL

2010-05-10 Thread Erwin Brandstetter
On 10.05.2010 21:16, dp...@pgadmin.org wrote: On Mon, May 10, 2010 at 3:20 PM, Erwin Brandstetter wrote: On 07.05.2010 21:21, dp...@pgadmin.org wrote: Sorry - missed that. I generally prefer to only include SQL DDL for things that are non-default. I generally agree. I see

Re: [pgadmin-hackers] "Compact" and "complete" SQL

2010-05-10 Thread Erwin Brandstetter
On 07.05.2010 21:21, dp...@pgadmin.org wrote: Sorry - missed that. I generally prefer to only include SQL DDL for things that are non-default. I generally agree. I see the "complete" variant as an option. The "compact" (non-default SQL DDL) version is what would make my work easier. However, a

"Compact" and "complete" SQL (was: Re: [pgadmin-hackers] Redundant statements)

2010-05-07 Thread Erwin Brandstetter
Hi Dave! I send a reply on the thread to you, Dave. Guillaume seems to like the idea somewhat. I wonder what you think about it. On 29.04.2010 17:50, guilla...@lelarge.info wrote: Le 29/04/2010 17:28, Erwin Brandstetter a écrit : On 29.04.2010 15:21, guilla...@lelarge.info wrote

Re: [pgadmin-hackers] pgAdmin 1.12 Visual Tour

2010-05-07 Thread Erwin Brandstetter
Aloha! The tour is a great introduction to the new features. Told me a lot about what's been going on while I was away last year. :) I would advise every new user of v1.12 to have a look. Regards Erwin -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to

Re: [pgadmin-hackers] GSoC Student

2010-05-06 Thread Erwin Brandstetter
On May 6, 3:28 pm, ak1...@gmail.com (adeel khan) wrote: (...) > In the end, i would say its just a beginning and its a long road and i would > be surely looking forward for you suggestions, comments or else and > obviously help. Hi Adeel! Welcome and good luck with your project! I am not into cod

Re: [pgadmin-hackers] Redundant statements

2010-04-29 Thread Erwin Brandstetter
On 30.04.2010 00:40, guilla...@lelarge.info wrote: Le 30/04/2010 00:35, Erwin Brandstetter a écrit : On 29.04.2010 18:48, guilla...@lelarge.info wrote: Le 29/04/2010 17:50, Guillaume Lelarge a écrit : Le 29/04/2010 17:28, Erwin Brandstetter a écrit : On

Re: [pgadmin-hackers] Redundant statements

2010-04-29 Thread Erwin Brandstetter
On 29.04.2010 18:48, guilla...@lelarge.info wrote: Le 29/04/2010 17:50, Guillaume Lelarge a écrit : Le 29/04/2010 17:28, Erwin Brandstetter a écrit : On 29.04.2010 15:21, guilla...@lelarge.info wrote: [...] What do you think of it? Should I create a ticket

Re: [pgadmin-hackers] Redundant statements

2010-04-29 Thread Erwin Brandstetter
On 29.04.2010 15:21, guilla...@lelarge.info wrote: Sorry for not answering sooner. No problem, the thread is old, but I just posted that yesterday. :) Le 29/04/2010 14:15, Erwin Brandstetter a écrit : On 28.04.2010 19:16, brandstet...@falter.at wrote: Aloha! I am testing

Re: [pgadmin-hackers] Redundant statements

2010-04-29 Thread Erwin Brandstetter
On 28.04.2010 19:16, brandstet...@falter.at wrote: Aloha! I am testing Guillaume's version of pgadmin3.exe from Apr. 17. The fix below is included and it seems to fix the problem just fine. However, as a side effect (?) there is now a redundant statement for each and every column: ALTER

Redundant statements (was: Re: [pgadmin-hackers] column STATISTICS lost)

2010-04-28 Thread Erwin Brandstetter
Aloha! I am testing Guillaume's version of pgadmin3.exe from Apr. 17. The fix below is included and it seems to fix the problem just fine. However, as a side effect (?) there is now a redundant statement for each and every column: ALTER TABLE foo ALTER COLUMN bar SET STORAGE PLAIN; or

Re: [pgadmin-hackers] pgadmin 1.10.2 crashes on start

2010-04-23 Thread Erwin Brandstetter
On 22.04.2010 21:37, guilla...@lelarge.info wrote: Le 22/04/2010 14:28, Erwin Brandstetter a écrit : On 19.04.2010 23:46, guilla...@lelarge.info wrote: Le 19/04/2010 19:24, Erwin Brandstetter a écrit : On 17.04.2010 08:02, guilla...@lelarge.info wrote

Re: [pgadmin-hackers] pgadmin 1.10.2 crashes on start

2010-04-22 Thread Erwin Brandstetter
On 19.04.2010 23:46, guilla...@lelarge.info wrote: Le 19/04/2010 19:24, Erwin Brandstetter a écrit : On 17.04.2010 08:02, guilla...@lelarge.info wrote: (...) I really don't understand. From your pgadmin3.log, it's quite obvious that the program crash before startup. I'

Re: [pgadmin-hackers] pgadmin 1.10.2 crashes on start

2010-04-19 Thread Erwin Brandstetter
On 17.04.2010 08:02, guilla...@lelarge.info wrote: Le 17/04/2010 01:02, Erwin Brandstetter a écrit : On 17.04.2010 00:16, guilla...@lelarge.info wrote: Le 09/04/2010 16:33, Guillaume Lelarge a écrit : (...) Sorry for making you wait so long. Here is the pgAdmin

[pgadmin-hackers] SET search_path = value

2010-04-19 Thread Erwin Brandstetter
Hi developers! Just created a ticket concerning a minor error in the reverse engineered SQL code for roles Besides the example ... ALTER ROLE SET search_path = test, public; --> ALTER DATABASE test SET search_path='test, public';-- quotes are wrong ... there are at least two more occ

Re: [pgadmin-hackers] pgadmin 1.10.2 crashes on start

2010-04-16 Thread Erwin Brandstetter
On 17.04.2010 00:16, guilla...@lelarge.info wrote: Le 09/04/2010 16:33, Guillaume Lelarge a écrit : (...) Sorry for making you wait so long. Here is the pgAdmin binary. It's compiled from the 1.10 branch, so a 1.10.2 + 15 bug fixes. Tell me if you still have trouble with it I unpacked th

Re: [pgadmin-hackers] pgadmin 1.10.2 crashes on start

2010-04-09 Thread Erwin Brandstetter
On 02.04.2010 17:24, guilla...@lelarge.info wrote: Le 02/04/2010 16:26, Erwin Brandstetter a écrit : Hi Guillaume! On 27.03.2010 02:57, guilla...@lelarge.info wrote: Hi Erwin, Le 26/03/2010 16:07, Erwin Brandstetter a écrit : (...) Hi Guillaume! I re-installed v1.10.2 on

Re: [pgadmin-hackers] Missing RULEs from VIEWs and their format

2010-04-09 Thread Erwin Brandstetter
On 08.04.2010 22:38, guilla...@lelarge.info wrote: Le 07/04/2010 19:47, Erwin Brandstetter a écrit : [...] I have just filed ticket #167 concerning missing RULEs with VIEWs. On a related but less important note: the formatting of rules might be improved if was done like triggers are

[pgadmin-hackers] Missing RULEs from VIEWs and their format

2010-04-07 Thread Erwin Brandstetter
Hi developers! I have just filed ticket #167 concerning missing RULEs with VIEWs. On a related but less important note: the formatting of rules might be improved if was done like triggers are: -- status quo CREATE OR REPLACE RULE on_delete AS ON DELETE TO test DO INSTEAD DELETE FROM test2

Re: [pgadmin-hackers] Missing non-login roles in properties dialog

2010-04-04 Thread Erwin Brandstetter
On 04.04.2010 22:10, guilla...@lelarge.info wrote: Le 04/04/2010 21:39, Erwin Brandstetter a écrit : Hi developers! Seeing as Guillaume is on a roll, fixing bugs faster than I can open new tickets, I have found one more, in a feeble attempt to keep up. Thanks :) Group roles

[pgadmin-hackers] Missing non-login roles in properties dialog

2010-04-04 Thread Erwin Brandstetter
Hi developers! Seeing as Guillaume is on a roll, fixing bugs faster than I can open new tickets, I have found one more, in a feeble attempt to keep up. Group roles are missing for the "Owner" field of properties dialogs. Ticket #164 has the details. Regards Erwin -- Sent via pgadmin-hackers

Re: [pgadmin-hackers] pgadmin 1.10.2 crashes on start

2010-04-02 Thread Erwin Brandstetter
Hi Guillaume! On 27.03.2010 02:57, guilla...@lelarge.info wrote: Hi Erwin, Le 26/03/2010 16:07, Erwin Brandstetter a écrit : (...) Hi Guillaume! I re-installed v1.10.2 on the same machine and tried as advised. I get identical error msg. every time. Even "pgadmin3 \h" has the s

Re: [pgadmin-hackers] column STATISTICS lost

2010-03-26 Thread Erwin Brandstetter
On 26.03.2010 20:47, guilla...@lelarge.info wrote: Le 26/03/2010 17:10, Erwin Brandstetter a écrit : [...] Column statistcs are lost in the re-engineered SQL in the SQL pane in pgAdmin 1.10.2. I have just filed ticket #160 in trac describing the problem. Not sure this really is a

[pgadmin-hackers] column STATISTICS lost

2010-03-26 Thread Erwin Brandstetter
Hi developers! Column statistcs are lost in the re-engineered SQL in the SQL pane in pgAdmin 1.10.2. I have just filed ticket #160 in trac describing the problem. Regards Erwin -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: htt

[pgadmin-hackers] Bug with create function ... RETURNS TABLE

2010-03-26 Thread Erwin Brandstetter
Hi developers! A bug in pgAdmin 1.10.2 renders the re-engineered SQL for functions returning TABLE () useless. I have just filed a ticket in trac describing the problem. Regards Erwin -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscriptio

  1   2   >