Re: [pgadmin-hackers] What we still have to do for 1.12

2010-03-21 Thread Dave Page 
On Sat, Mar 20, 2010 at 4:49 PM, Guillaume Lelarge
 wrote:
> Hi,
>
> As Bruce wrote the release notes for 9.0, I read it to check if we still
> have a lot of things to do to fully support 9.0. We're not that far but
> we still have two major missing features.
>
> Here is the list of the work *I think* we still have to do before a 1.12
> beta 1 release:
>
>  * Support for 9.0:
>   * exclusion constraint (#118)
>   * default ACL (#99)
>   * deferrable unique constraint
>   * typed table (#135) ...     patch available, awaiting comments
>   * autonamed index (#158) ... patch available, awaiting comments

We also have an internal TODO item to update support for synonyms in
EDB, which have changed. Ashesh - any idea how long that might take?
It's ticket number FB9247.

>  * Support for 8.4:
>   * sql/med objects (#142)

Why? They don't do anything useful yet do they?

>  * To be fixed:
>   * frmQuery connection combobox layout
>   * frmOptions dialog layout

I was looking at the backup/restore dialogues the other day. I think
we should put the tabs back up at the top agin, as they look awful at
the bottom on the Mac. Thoughts?

> I tried many times to include the exclusion constraint support and the
> default ACL support, but couldn't get anything done. I also tried to
> work on the sql/med objects, but that too didn't work out. Maybe I'm
> just tired :/

Yeah, I know that feeling.

> I think I'm gonna work on the to-be-fixed issues and on the remaining
> bugs. I'll also apply the patches awaiting comments monday evening if
> no-one objects to it.

Go ahead.

> I don't know when we want to release beta 1. If we want that before 9.0
> beta 1 or really next to it, I'm gonna ask for help :)

We can probably push out an alpha for PG beta 1. We always get bags of
time once PG goes to beta.


-- 
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
PG East Conference: http://www.enterprisedb.com/community/nav-pg-east-2010.do

-- 
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] Ticket 158: allow an index to be autonamed

2010-03-21 Thread Dave Page 
On Sat, Mar 20, 2010 at 4:46 PM, Guillaume Lelarge
 wrote:
> Hi,
>
> This is a quite simple patch. It simply allows a user to create an index
> without giving it a name.

:-)

-- 
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
PG East Conference: http://www.enterprisedb.com/community/nav-pg-east-2010.do

-- 
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] Donation of 3 FEITIAN PKI smart cards to the pgAdmin community

2010-03-21 Thread Jean-Michel Pouré - GOOZE 
Le mercredi 17 mars 2010 à 19:19 +0100, Magnus Hagander a écrit :
> In principle this sonuds very intesting. But I take it it requires a
> card reader, which is not included, to be actually useful? 

As noone registered the offer at PostgreSQL, I will also include a free
card reader. Just register on Gooze.eu and mention during checkout:
"pgAdmin developer, please include a free reader".

Please note that I am aware of PostgreSQL core hackers and I will only
ship to well-known people like Dave, Magnus, Guillaume, etc ...

My stock is going low quickly, so I can only recommend to ask for free
PKI+readers quickly. When my stock of free cards is down, I will post a
new message indicating out of stock.

To request a free card + reader:
http://www.gooze.eu/feitian-pki-free-software-developer-card

Kind regards,
Jean-Michel
-- 
  GOOZE - http://www.gooze.eu
   High quality cryptographic tools 
  for GNU/Linux, Mac OS X and Windows
 including the FEITIAN PKI card
31 avenue Lucien René Duchesne - Bât. 11
  78170 LA CELLE-SAINT-CLOUD - FRANCE


-- 
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] SVN Commit by guillaume: r8239 - in trunk/pgadmin3: . pgadmin/dlg

2010-03-21 Thread svn 
Author: guillaume

Date: 2010-03-21 16:26:25 + (Sun, 21 Mar 2010)

New Revision: 8239

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=8239&view=rev

Log:
Allow an index to be autonamed.


Modified:
   trunk/pgadmin3/CHANGELOG
   trunk/pgadmin3/pgadmin/dlg/dlgIndex.cpp

-- 
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] [pgAdmin III] #158: Allow an index to be autonamed

2010-03-21 Thread pgAdmin Trac 
#158: Allow an index to be autonamed
--+-
  Reporter:  gleu |   Owner:  gleu 
  Type:  feature  |  Status:  closed   
  Priority:  minor|   Milestone:  1.12 
 Component:  pgadmin  | Version:  trunk
Resolution:  fixed|Keywords:  index 9.0
  Platform:  all  |  
--+-
Changes (by gleu):

  * status:  assigned => closed
  * resolution:  => fixed
  * milestone:  => 1.12


Comment:

 Done in r8239.

-- 
Ticket URL: 
pgAdmin III 
pgAdmin III

-- 
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] SVN Commit by guillaume: r8240 - in trunk/pgadmin3: . pgadmin/dlg pgadmin/include/dlg pgadmin/include/schema pgadmin/schema pgadmin/ui

2010-03-21 Thread svn 
Author: guillaume

Date: 2010-03-21 16:29:07 + (Sun, 21 Mar 2010)

New Revision: 8240

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=8240&view=rev

Log:
Add new TYPE syntax of CREATE TABLE.


Modified:
   trunk/pgadmin3/CHANGELOG
   trunk/pgadmin3/pgadmin/dlg/dlgColumn.cpp
   trunk/pgadmin3/pgadmin/dlg/dlgTable.cpp
   trunk/pgadmin3/pgadmin/include/dlg/dlgTable.h
   trunk/pgadmin3/pgadmin/include/schema/pgTable.h
   trunk/pgadmin3/pgadmin/schema/pgColumn.cpp
   trunk/pgadmin3/pgadmin/schema/pgTable.cpp
   trunk/pgadmin3/pgadmin/ui/dlgColumn.xrc
   trunk/pgadmin3/pgadmin/ui/dlgTable.xrc

-- 
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] [pgAdmin III] #135: New CREATE TABLE syntax

2010-03-21 Thread pgAdmin Trac 
#135: New CREATE TABLE syntax
--+-
  Reporter:  gleu |   Owner:  gleu 
  Type:  feature  |  Status:  closed   
  Priority:  minor|   Milestone:  1.12 
 Component:  pgadmin  | Version:  trunk
Resolution:  fixed|Keywords:  table 9.0
  Platform:  all  |  
--+-
Changes (by gleu):

  * status:  assigned => closed
  * resolution:  => fixed
  * milestone:  => 1.12


Comment:

 Done in r8240.

-- 
Ticket URL: 
pgAdmin III 
pgAdmin III

-- 
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] [pgAdmin III] #3: Grouping servers

2010-03-21 Thread pgAdmin Trac 
#3: Grouping servers
-+--
 Reporter:  gleu |   Owner:  gleu
 Type:  feature  |  Status:  assigned
 Priority:  minor|   Milestone:  
Component:  pgadmin  | Version:  trunk   
 Keywords:   |Platform:  
-+--
Changes (by gleu):

  * milestone:  1.12 =>


-- 
Ticket URL: 
pgAdmin III 
pgAdmin III

-- 
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] [pgAdmin III] #4: i18n enhancements

2010-03-21 Thread pgAdmin Trac 
#4: i18n enhancements
-+--
 Reporter:  gleu |   Owner:  gleu
 Type:  feature  |  Status:  assigned
 Priority:  minor|   Milestone:  
Component:  pgadmin  | Version:  trunk   
 Keywords:   |Platform:  
-+--
Changes (by gleu):

  * milestone:  1.12 =>


-- 
Ticket URL: 
pgAdmin III 
pgAdmin III

-- 
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] [pgAdmin III] #5: Modifying an object's schema via the UI

2010-03-21 Thread pgAdmin Trac 
#5: Modifying an object's schema via the UI
-+--
 Reporter:  gleu |   Owner:  gleu
 Type:  feature  |  Status:  assigned
 Priority:  minor|   Milestone:  
Component:  pgadmin  | Version:  trunk   
 Keywords:   |Platform:  
-+--
Changes (by gleu):

  * milestone:  1.12 =>


-- 
Ticket URL: 
pgAdmin III 
pgAdmin III

-- 
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: [pgAdmin III] #7: Better display of the logfile in the server status window

2010-03-21 Thread pgAdmin Trac 
#7: Better display of the logfile in the server status window
-+--
 Reporter:  gleu |   Owner:  gleu
 Type:  feature  |  Status:  assigned
 Priority:  minor|   Milestone:  
Component:  pgadmin  | Version:  trunk   
 Keywords:   |Platform:  
-+--
Changes (by gleu):

  * milestone:  1.12 =>


-- 
Ticket URL: 
pgAdmin III 
pgAdmin III

-- 
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: [pgAdmin III] #10: Display the locks in a logical tree rather than a list (in the server status window)

2010-03-21 Thread pgAdmin Trac 
#10: Display the locks in a logical tree rather than a list (in the server
status window)
-+--
 Reporter:  gleu |   Owner:  gleu
 Type:  feature  |  Status:  assigned
 Priority:  minor|   Milestone:  
Component:  pgadmin  | Version:  trunk   
 Keywords:   |Platform:  
-+--
Changes (by gleu):

  * milestone:  1.12 =>


-- 
Ticket URL: 
pgAdmin III 
pgAdmin III

-- 
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] [pgAdmin III] #11: Config editor: sort and filter

2010-03-21 Thread pgAdmin Trac 
#11: Config editor: sort and filter
-+--
 Reporter:  gleu |   Owner:  gleu
 Type:  feature  |  Status:  assigned
 Priority:  minor|   Milestone:  
Component:  pgadmin  | Version:  trunk   
 Keywords:   |Platform:  
-+--
Changes (by gleu):

  * milestone:  1.12 =>


-- 
Ticket URL: 
pgAdmin III 
pgAdmin III

-- 
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] [pgAdmin III] #118: Operator Exclusion Constraints

2010-03-21 Thread pgAdmin Trac 
#118: Operator Exclusion Constraints
---+
 Reporter:  gleu   |   Owner:  dpage
 Type:  feature|  Status:  new  
 Priority:  minor  |   Milestone:  1.12 
Component:  pgadmin| Version:  trunk
 Keywords:  table 9.0  |Platform:  all  
---+
Changes (by gleu):

  * milestone:  => 1.12


-- 
Ticket URL: 
pgAdmin III 
pgAdmin III

-- 
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] [pgAdmin III] #99: Default ACLs

2010-03-21 Thread pgAdmin Trac 
#99: Default ACLs
--+-
 Reporter:  gleu  |   Owner:  gleu
 Type:  feature   |  Status:  assigned
 Priority:  minor |   Milestone:  1.12
Component:  pgadmin   | Version:  trunk   
 Keywords:  role 9.0  |Platform:  all 
--+-
Changes (by gleu):

  * milestone:  => 1.12


-- 
Ticket URL: 
pgAdmin III 
pgAdmin III

-- 
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] [pgAdmin III] #142: Support for SQL/Med objects

2010-03-21 Thread pgAdmin Trac 
#142: Support for SQL/Med objects
-+--
 Reporter:  gleu |   Owner:  gleu
 Type:  feature  |  Status:  assigned
 Priority:  minor|   Milestone:  1.12
Component:  pgadmin  | Version:  1.10
 Keywords:  browser  |Platform:  all 
-+--
Changes (by gleu):

  * milestone:  => 1.12


-- 
Ticket URL: 
pgAdmin III 
pgAdmin III

-- 
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] [pgAdmin III] #148: Miscellaneous requests for the query tool

2010-03-21 Thread Dickson S. Guedes 
2010/3/20 Guillaume Lelarge :
> Applies and compiles with no issue.

Good!

> Anyways there are a few things that I don't like.

I'm already wainting for. :-)

> When the combobox contains the maximum number of queries, it should
> delete the older one and record the new one whereas now it simply
> doesn't do anything.

Yes, i was in doubt whether I delete the oldest query or not, but your
review answers my doubt.

> What happens when pgAdmin loads a queries file with more than the
> maximum number of queries in it? AFAICT, it loads everything. I think it
> shouldn't. It should only load the X last one (X being the maximum
> number of queries).

I agree.

> I don't think the default maximum query size is sane. 100 characters are
> really not enough. At least 1024 (much like track_activity_query_size).
> By the way, I also don't think we should talk in bytes. It's a number of
> characters.

Sounds better for me, too.

> I think that's all for me. Can you send us an updated patch?

Yes, I can.

> Thanks a lot.

Thank you too.

[]s
Dickson S. Guedes
mail/xmpp: gue...@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br

-- 
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] What we still have to do for 1.12

2010-03-21 Thread Ashesh Vashi 
On Sun, Mar 21, 2010 at 3:27 PM, Dave Page  wrote:

> On Sat, Mar 20, 2010 at 4:49 PM, Guillaume Lelarge
>  wrote:
> > Hi,
> >
> > As Bruce wrote the release notes for 9.0, I read it to check if we still
> > have a lot of things to do to fully support 9.0. We're not that far but
> > we still have two major missing features.
> >
> > Here is the list of the work *I think* we still have to do before a 1.12
> > beta 1 release:
> >
> >  * Support for 9.0:
> >   * exclusion constraint (#118)
> >   * default ACL (#99)
> >   * deferrable unique constraint
> >   * typed table (#135) ... patch available, awaiting comments
> >   * autonamed index (#158) ... patch available, awaiting comments
>
> We also have an internal TODO item to update support for synonyms in
> EDB, which have changed. Ashesh - any idea how long that might take?
> It's ticket number FB9247.


I have just started working on it.
I will update you soon about - how long it may take.

--
Ashesh Vashi
EnterpriseDB INDIA: www.enterprisedb.com