Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-04-09 Thread Bruce Momjian
On Tue, Mar 20, 2012 at 01:25:15PM +0100, Claes Jakobsson wrote: On 20 mar 2012, at 13.08, Heikki Linnakangas wrote: On 20.03.2012 11:10, Claes Jakobsson wrote: Personally I'd love a type 2 JDBC driver for PostgreSQL. Why? listen/notify over SSL for example unless that's been

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-04-09 Thread Merlin Moncure
On Mon, Apr 9, 2012 at 1:14 PM, Bruce Momjian br...@momjian.us wrote: Well, I assume they reimplemented libpq so that java would not rely on a platform-specific library like libpq. yes, that is correct. jdbc for postgres is a complete implementation of the client side protocol. this has some

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-04-09 Thread Andrew Dunstan
On 04/09/2012 02:14 PM, Bruce Momjian wrote: On Tue, Mar 20, 2012 at 01:25:15PM +0100, Claes Jakobsson wrote: On 20 mar 2012, at 13.08, Heikki Linnakangas wrote: On 20.03.2012 11:10, Claes Jakobsson wrote: Personally I'd love a type 2 JDBC driver for PostgreSQL. Why? listen/notify over

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-04-09 Thread Bruce Momjian
On Mon, Apr 09, 2012 at 01:29:46PM -0500, Merlin Moncure wrote: but generally speaking jdbc is displacing odbc as the 'go to' library for connection between different kinds of database systems, especially on non-windows environments. jdbc is to java as fdw is to postgres basically. so a fdw

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-25 Thread Claes Jakobsson
On 19 mar 2012, at 22.45, Merlin Moncure wrote: one pl/java based project that IMO is just screaming to be done is a pl/java based FDW (wrapping JDBC) that would approximately reproduce dblink...maybe with some extra features geared towards ETL type jobs like a row based callback for

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-25 Thread Claes Jakobsson
On 20 mar 2012, at 13.08, Heikki Linnakangas wrote: On 20.03.2012 11:10, Claes Jakobsson wrote: Personally I'd love a type 2 JDBC driver for PostgreSQL. Why? listen/notify over SSL for example unless that's been fixed in the JDBC driver recently. And I'm sure there are other things in

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-23 Thread Merlin Moncure
On Wed, Mar 21, 2012 at 10:51 PM, Atri Sharma atri.j...@gmail.com wrote: Please let me know how to proceed further. Waiting for your reply, sure -- let's take this discussion off line. send me a private mail and we'll discuss if/how we can get this off the ground. merlin -- Sent via

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-21 Thread Atri Sharma
-Original Message- From: Atri Sharma [mailto:atri.j...@gmail.com] Sent: 22 March 2012 09:20 To: 'Atri Sharma' Subject: RE: [HACKERS] Regarding column reordering project for GSoc 2012 -Original Message- From: Atri Sharma [mailto:atri.j...@gmail.com] Sent: 20 March 2012 23:05

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-20 Thread Atri Sharma
-Original Message- From: Claes Jakobsson [mailto:cl...@versed.se] Sent: 20 March 2012 14:40 To: Merlin Moncure Cc: Heikki Linnakangas; Alvaro Herrera; Atri Sharma; Daniel Farina; Andrew Dunstan; Dave Page; Pg Hackers Subject: Re: [HACKERS] Regarding column reordering project for GSoc

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-20 Thread Atri Sharma
-Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: 20 March 2012 03:15 To: Heikki Linnakangas Cc: Alvaro Herrera; Atri Sharma; Daniel Farina; Andrew Dunstan; Dave Page; Pg Hackers Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 On Mon, Mar

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-20 Thread Heikki Linnakangas
On 20.03.2012 11:10, Claes Jakobsson wrote: On 19 mar 2012, at 22.45, Merlin Moncure wrote: one pl/java based project that IMO is just screaming to be done is a pl/java based FDW (wrapping JDBC) that would approximately reproduce dblink...maybe with some extra features geared towards ETL type

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-20 Thread Atri Sharma
-Original Message- From: Heikki Linnakangas [mailto:heikki.linnakan...@enterprisedb.com] Sent: 20 March 2012 17:39 To: Claes Jakobsson Cc: Merlin Moncure; Alvaro Herrera; Atri Sharma; Daniel Farina; Andrew Dunstan; Dave Page; Pg Hackers Subject: Re: [HACKERS] Regarding column reordering

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-20 Thread Merlin Moncure
: Re: [HACKERS] Regarding column reordering project for GSoc 2012 On Mon, Mar 19, 2012 at 2:49 PM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 19.03.2012 21:29, Alvaro Herrera wrote: Excerpts from Atri Sharma's message of lun mar 19 16:20:09 -0300 2012: I was just going

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-20 Thread Jeff Janes
On Mon, Mar 19, 2012 at 12:29 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Excerpts from Atri Sharma's message of lun mar 19 16:20:09 -0300 2012: I was just going through PGfoundry and I think I will be able to work on the PL/Java project.Please let me know If I can proceed further on

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-20 Thread Alvaro Herrera
Excerpts from Jeff Janes's message of mar mar 20 12:54:55 -0300 2012: On Mon, Mar 19, 2012 at 12:29 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Did you have a look at the TODO list? http://wiki.postgresql.org/wiki/Todo However, the new user should be aware that many of the

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-20 Thread Atri Sharma
-Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: 20 March 2012 20:52 To: Atri Sharma Cc: Heikki Linnakangas; Alvaro Herrera; Daniel Farina; Andrew Dunstan; Dave Page; Pg Hackers Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 On Tue

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-20 Thread Merlin Moncure
Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 On Tue, Mar 20, 2012 at 6:58 AM, Atri Sharma atri.j...@gmail.com wrote: -Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: 20 March 2012 03:15 To: Heikki Linnakangas Cc: Alvaro Herrera; Atri

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-20 Thread Atri Sharma
-Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: 20 March 2012 22:50 To: Atri Sharma Cc: Heikki Linnakangas; Alvaro Herrera; Daniel Farina; Andrew Dunstan; Dave Page; Pg Hackers Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 On Tue

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-20 Thread Merlin Moncure
Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 On Tue, Mar 20, 2012 at 11:57 AM, Atri Sharma atri.j...@gmail.com wrote: -Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: 20 March 2012 20:52 To: Atri Sharma Cc: Heikki Linnakangas; Alvaro

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-20 Thread Atri Sharma
; Alvaro Herrera; Daniel Farina; Andrew Dunstan; Dave Page; Pg Hackers Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 On Tue, Mar 20, 2012 at 11:57 AM, Atri Sharma atri.j...@gmail.com wrote: -Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-19 Thread Alvaro Herrera
Excerpts from Atri Sharma's message of dom mar 18 01:05:23 -0300 2012: I am understanding the scenario now. I will take a little of your time to modify my original idea: The middle layer still exists, but NOT on the individual client side , rather , on the server side. That is, we maintain

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-19 Thread Atri Sharma
On Mon, Mar 19, 2012 at 11:51 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Excerpts from Atri Sharma's message of dom mar 18 01:05:23 -0300 2012: I am understanding the scenario now. I will take a little of your time to modify my original idea: The middle layer still exists, but NOT

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-19 Thread Atri Sharma
On Tue, Mar 20, 2012 at 12:08 AM, Atri Sharma atri.j...@gmail.com wrote: On Mon, Mar 19, 2012 at 11:51 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Excerpts from Atri Sharma's message of dom mar 18 01:05:23 -0300 2012: I am understanding the scenario now. I will take a little of your

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-19 Thread Alvaro Herrera
Excerpts from Atri Sharma's message of lun mar 19 16:20:09 -0300 2012: I was just going through PGfoundry and I think I will be able to work on the PL/Java project.Please let me know If I can proceed further on ot for GSOC and also,if currently there is any work that needs to be done on

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-19 Thread Heikki Linnakangas
On 19.03.2012 21:29, Alvaro Herrera wrote: Excerpts from Atri Sharma's message of lun mar 19 16:20:09 -0300 2012: I was just going through PGfoundry and I think I will be able to work on the PL/Java project.Please let me know If I can proceed further on ot for GSOC and also,if currently there

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-19 Thread Merlin Moncure
On Mon, Mar 19, 2012 at 2:49 PM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 19.03.2012 21:29, Alvaro Herrera wrote: Excerpts from Atri Sharma's message of lun mar 19 16:20:09 -0300 2012: I was just going through PGfoundry and I think I will be able to work on the

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Andrew Dunstan
On 03/17/2012 04:39 AM, Atri Sharma wrote: Hi All, I am Atri Sharma.I am a C developer with experience in database designing and database management systems.I have worked with MySql,Oracle and other database systems.I have designed databases for various projects as well. I would be

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Atri Sharma
. Atri -Original Message- From: Andrew Dunstan [mailto:and...@dunslane.net] Sent: 17 March 2012 21:30 To: Atri Sharma Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 On 03/17/2012 04:39 AM, Atri Sharma wrote: Hi All, I am Atri

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Atri Sharma
feedback on the idea. Atri -Original Message- From: Andrew Dunstan [mailto:and...@dunslane.net] Sent: 17 March 2012 21:30 To: Atri Sharma Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 On 03/17/2012 04:39 AM, Atri Sharma wrote: Hi

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Alvaro Herrera
Excerpts from Atri Sharma's message of sáb mar 17 05:39:10 -0300 2012: Hi All, I am Atri Sharma.I am a C developer with experience in database designing and database management systems.I have worked with MySql,Oracle and other database systems.I have designed databases for various projects

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Atri Sharma
:17 To: Atri Sharma Cc: Pg Hackers Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 Excerpts from Atri Sharma's message of sáb mar 17 05:39:10 -0300 2012: Hi All, I am Atri Sharma.I am a C developer with experience in database designing and database management systems.I

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Alvaro Herrera
Excerpts from Atri Sharma's message of sáb mar 17 15:48:13 -0300 2012: HI Alvaro, I did send a complete description to the mailing list, based on your past discussions. I don’t know if you got it. I read it, but I don't see how is the client involved. -- Álvaro Herrera

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Atri Sharma
[mailto:alvhe...@commandprompt.com] Sent: 18 March 2012 00:34 To: Atri Sharma Cc: Pg Hackers Subject: RE: [HACKERS] Regarding column reordering project for GSoc 2012 Excerpts from Atri Sharma's message of sáb mar 17 15:48:13 -0300 2012: HI Alvaro, I did send a complete description to the mailing

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Dave Page
On Saturday, March 17, 2012, Atri Sharma atri.j...@gmail.com wrote: Hi Alvaro, Thanks for going through my description. I was going through the posts,when I realised that if we give each client the flexibility of defining his/her own order with complete control,that would be probably the

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Atri Sharma
Hi Dave, I believe,with the ALTER command,we plan to give the user power to modify ordering . Don't we? Atri From: Dave Page [mailto:dp...@pgadmin.org] Sent: 18 March 2012 00:46 To: Atri Sharma Cc: Alvaro Herrera; Pg Hackers Subject: Re: [HACKERS] Regarding column reordering project

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Jaime Casanova
On Sat, Mar 17, 2012 at 2:16 PM, Atri Sharma atri.j...@gmail.com wrote: Hi Dave, I believe,with the ALTER command,we plan to give the user power to modify ordering . Don’t we? And how is that different from a view that orders the columns as the user wishes? -- Jaime Casanova        

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Andrew Dunstan
On 03/17/2012 03:07 PM, Atri Sharma wrote: Hi Alvaro, Thanks for going through my description. I was going through the posts,when I realised that if we give each client the flexibility of defining his/her own order with complete control,that would be probably the right way(IMHO). I

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Andrew Dunstan
On 03/17/2012 04:42 PM, Dave Page wrote: On Saturday, March 17, 2012, Atri Sharma atri.j...@gmail.com mailto:atri.j...@gmail.com wrote: Hi Dave, I believe,with the ALTER command,we plan to give the user power to modify ordering . Don’t we? Probably, but that's not relevant to my

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Daniel Farina
On Sat, Mar 17, 2012 at 1:48 PM, Andrew Dunstan and...@dunslane.net wrote: Mine too. We don't want a column ordering that's different for everyone. That's a recipe for mass confusion. We want to be able to mutate the ordering for everyone, and for everyone to see the same ordering. That means

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Atri Sharma
-Original Message- From: Daniel Farina [mailto:dan...@heroku.com] Sent: 18 March 2012 06:30 To: Andrew Dunstan Cc: Dave Page; Atri Sharma; Alvaro Herrera; Pg Hackers Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 On Sat, Mar 17, 2012 at 1:48 PM, Andrew Dunstan

Re: [HACKERS] Regarding column reordering project for GSoc 2012

2012-03-17 Thread Atri Sharma
-Original Message- From: jcasa...@systemguards.com.ec [mailto:jcasa...@systemguards.com.ec] On Behalf Of Jaime Casanova Sent: 18 March 2012 01:04 To: Atri Sharma Cc: Dave Page; Alvaro Herrera; Pg Hackers Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 On Sat