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

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 f

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

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 SSL

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

On Mon, Apr 9, 2012 at 1:14 PM, Bruce Momjian 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 good and bad po

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

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

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

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

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

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 transf

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

On Wed, Mar 21, 2012 at 10:51 PM, Atri Sharma 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 pgsql-hackers mailing l

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

-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

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

c: Heikki Linnakangas; 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 wrote: >>> >>> >>> --

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

Pg Hackers > Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 > > On Tue, Mar 20, 2012 at 11:57 AM, Atri Sharma wrote: >> >> >> -Original Message- >> From: Merlin Moncure [mailto:mmonc...@gmail.com] >> Sent: 20 March 2012 20:

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

-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

Pg Hackers > Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 > > On Tue, Mar 20, 2012 at 6:58 AM, Atri Sharma wrote: >> -Original Message- >> From: Merlin Moncure [mailto:mmonc...@gmail.com] >> Sent: 20 March 2012 03:15 >> To: Heik

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

-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

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 > 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 things in that > list are

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

On Mon, Mar 19, 2012 at 12:29 PM, 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

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

kers > Subject: Re: [HACKERS] Regarding column reordering project for GSoc 2012 > > On Mon, Mar 19, 2012 at 2:49 PM, Heikki Linnakangas > wrote: >> On 19.03.2012 21:29, Alvaro Herrera wrote: >>> >>> >>> Excerpts from Atri Sharma's message of lun mar 19 16

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

-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

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 jo

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

-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

-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

On Mon, Mar 19, 2012 at 2:49 PM, Heikki Linnakangas 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 PL/Java project.Please let

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

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

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 P

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

On Tue, Mar 20, 2012 at 12:08 AM, Atri Sharma wrote: > On Mon, Mar 19, 2012 at 11:51 PM, Alvaro Herrera > 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 ide

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

On Mon, Mar 19, 2012 at 11:51 PM, Alvaro Herrera 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 on the indivi

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

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 ma

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

-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

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

-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

On Sat, Mar 17, 2012 at 1:48 PM, Andrew Dunstan 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 > it MUST be done

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

On 03/17/2012 04:42 PM, Dave Page wrote: On Saturday, March 17, 2012, Atri Sharma > 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 point as far as

[HACKERS] Regarding column reordering project for GSoc 2012

On Saturday, March 17, 2012, Atri Sharma 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 point as far as I can see - I was objecting to your suggestion that the "middle layer" that tra

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

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 mean,if

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

On Sat, Mar 17, 2012 at 2:16 PM, Atri Sharma 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         www.2ndQuadrant.com P

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

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 pr

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

On Saturday, March 17, 2012, 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). >

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

[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

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 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 The PostgreSQL

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

: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 da

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 have worked with > MySql,Oracle and other database systems.I have designed databases for > various pro

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

time. Please let me know your 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/20

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

n 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

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 interested

[HACKERS] Regarding column reordering project for GSoc 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 as well. I would be interested in developing the column reordering project by