Re: [HACKERS] What Would You Like To Do?

2011-09-24 Thread Bruce Momjian
Joshua D. Drake wrote: On 09/13/2011 11:51 AM, Michael Nolan wrote: The ability to restore a table from a backup file to a different table name in the same database and schema. This can be done but agreed it is not intuitive. Can you elaborate

Re: [HACKERS] What Would You Like To Do?

2011-09-24 Thread Andrew Dunstan
On 09/24/2011 09:51 AM, Bruce Momjian wrote: Joshua D. Drake wrote: On 09/13/2011 11:51 AM, Michael Nolan wrote: The ability to restore a table from a backup file to a different table name in the same database and schema. This can be done but agreed it is

Re: [HACKERS] What Would You Like To Do?

2011-09-15 Thread Kaare Rasmussen
On 2011-09-14 17:27, David E. Wheeler wrote: On Sep 14, 2011, at 5:49 AM, Kaare Rasmussen wrote: [brief]: http://postgresopen.org/2011/schedule/presentations/83/ You list Job scheduling as one item here, snip but not here Here's my preliminary list: Could you expand your idea about this

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Kaare Rasmussen
Hi [brief]: http://postgresopen.org/2011/schedule/presentations/83/ You list Job scheduling as one item here, snip but not here Here's my preliminary list: Could you expand your idea about this here? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Hannu Krosing
On Tue, 2011-09-13 at 10:26 -0700, Joshua D. Drake wrote: Complete isolation at the user level, allowing an ISP to support multiple independent customers on a server without having to fiddle with multiple back ends each running on a separate port, a feature that MySQL has had for as far

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Hannu Krosing
On Tue, 2011-09-13 at 17:02 -0300, Rodrigo Gonzalez wrote: On 09/13/2011 04:52 PM, Tom Lane wrote: Rodrigo Gonzalezrjgonz...@estrads.com.ar writes: In a perfect world, it would be nice if one could do combined queries linking a PostgreSQL database with an Oracle one, or a MySQL one,

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Joshua D. Drake
On 09/14/2011 05:12 AM, Hannu Krosing wrote: On Tue, 2011-09-13 at 10:26 -0700, Joshua D. Drake wrote: Complete isolation at the user level, allowing an ISP to support multiple independent customers on a server without having to fiddle with multiple back ends each running on a separate port,

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread David E. Wheeler
On Sep 14, 2011, at 5:49 AM, Kaare Rasmussen wrote: [brief]: http://postgresopen.org/2011/schedule/presentations/83/ You list Job scheduling as one item here, snip but not here Here's my preliminary list: Could you expand your idea about this here? It was something suggested to me on IRC a

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Hannu Krosing
On Wed, 2011-09-14 at 07:14 -0700, Joshua D. Drake wrote: On 09/14/2011 05:12 AM, Hannu Krosing wrote: On Tue, 2011-09-13 at 10:26 -0700, Joshua D. Drake wrote: Complete isolation at the user level, allowing an ISP to support multiple independent customers on a server without having to

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Jaime Casanova
On Wed, Sep 14, 2011 at 9:14 AM, Joshua D. Drake j...@commandprompt.com wrote: On 09/14/2011 05:12 AM, Hannu Krosing wrote: On Tue, 2011-09-13 at 10:26 -0700, Joshua D. Drake wrote: Complete isolation at the user level, allowing an ISP to support multiple independent customers on a server

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Aidan Van Dyk
On Wed, Sep 14, 2011 at 12:09 PM, Jaime Casanova ja...@2ndquadrant.com wrote: last time i tried it (last year), it seems broken because i couldn't log in with any user anymore... but it could be that i did something wrong so i didn't report until i could confirm but i hadn't the time and i

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Jaime Casanova
On Wed, Sep 14, 2011 at 11:49 AM, Aidan Van Dyk ai...@highrise.ca wrote: But I found it useful when needing to hand out seperate usernames for different apps because they all needed to have their own search_path and other settings set before login (yes, dumb apps, mostly odbc), and be able to

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Josh Berkus
DW, All: - Update newsysviews and bundle it as an extension, and maintain it for each new version - Add median() and quartile() windowing aggregates, or similar equivalents. - work on pgTune -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-hackers mailing list

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread Hannu Krosing
On Sun, 2011-09-11 at 21:21 -0700, David E. Wheeler wrote: Hackers, Later this week I'm giving a [brief][] for an audience of what I hope will be corporate PostgreSQL users that covers how to get a feature developed for PostgreSQL. The idea here is that there are a lot of organizations

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread David E. Wheeler
On Sep 13, 2011, at 9:43 AM, Hannu Krosing wrote: Hannu Krosing / 2ndQuadrant * more enhancements to pl/python - use real function arguments, store modules in database, direct support for postgresql types, operators and functions, automatic startup command, automatic ORM from table

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread Thom Brown
On 12 September 2011 05:21, David E. Wheeler da...@kineticode.com wrote: Hackers, Later this week I'm giving a [brief][] for an audience of what I hope will be corporate PostgreSQL users that covers how to get a feature developed for PostgreSQL. The idea here is that there are a lot of

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread Michael Nolan
The lists all seem to be focusing on the things that the developers would like to add to PostgreSQL, what about some things that users or ISPs might like to have, and thus perhaps something that companies might actually see as worth funding? For example: A fully integrated ability to query

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread Joshua D. Drake
On 09/13/2011 10:13 AM, Michael Nolan wrote: The lists all seem to be focusing on the things that the developers would like to add to PostgreSQL, what about some things that users or ISPs might like to have, and thus perhaps something that companies might actually see as worth funding? Well

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread Michael Nolan
On Tue, Sep 13, 2011 at 12:26 PM, Joshua D. Drake j...@commandprompt.comwrote: On 09/13/2011 10:13 AM, Michael Nolan wrote: The lists all seem to be focusing on the things that the developers would like to add to PostgreSQL, what about some things that users or ISPs might like to have, and

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread Rodrigo Gonzalez
On 09/13/2011 03:51 PM, Michael Nolan wrote: For example: A fully integrated ability to query across multiple databases,possibly on multiple servers, something Oracle has had for nearly two decades. That isn't the approach to take. The fact that Oracle

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread Tom Lane
Rodrigo Gonzalez rjgonz...@estrads.com.ar writes: In a perfect world, it would be nice if one could do combined queries linking a PostgreSQL database with an Oracle one, or a MySQL one, Can't you do that with FDW that is present in 9.1? FDW provides the structure within which that will

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread Joshua D. Drake
On 09/13/2011 11:51 AM, Michael Nolan wrote: The ability to restore a table from a backup file to a different table name in the same database and schema. This can be done but agreed it is not intuitive. Can you elaborate on tha a bit, please? The only way I've

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread Rodrigo Gonzalez
On 09/13/2011 04:52 PM, Tom Lane wrote: Rodrigo Gonzalezrjgonz...@estrads.com.ar writes: In a perfect world, it would be nice if one could do combined queries linking a PostgreSQL database with an Oracle one, or a MySQL one, Can't you do that with FDW that is present in 9.1? FDW provides the

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread Kevin Grittner
Rodrigo Gonzalez wrote: On 09/13/2011 04:52 PM, Tom Lane wrote: FDW provides the structure within which that will eventually be possible, but there's no Oracle or MySQL wrapper today ... They are both listed at wiki And here: http://www.pgxn.org/tag/foreign%20data%20wrapper/ -Kevin

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread Michael Nolan
On Tue, Sep 13, 2011 at 2:55 PM, Joshua D. Drake j...@commandprompt.comwrote: On 09/13/2011 11:51 AM, Michael Nolan wrote: The ability to restore a table from a backup file to a different table name in the same database and schema. This can be done but agreed it

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread Alexander Korotkov
On Mon, Sep 12, 2011 at 8:21 AM, David E. Wheeler da...@kineticode.comwrote: So, what do you want to work on? Let me know, I'll do as much match-making at the conference as I can. Here is my list: * Additional approximate string matching functions and index access for them using

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread Dann Corbit
From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Michael Nolan Sent: Tuesday, September 13, 2011 11:51 AM To: Joshua D. Drake Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] What Would You Like To Do? On Tue, Sep 13, 2011 at 12:26 PM

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread David E. Wheeler
On Sep 13, 2011, at 3:12 PM, Kevin Grittner wrote: And here: http://www.pgxn.org/tag/foreign%20data%20wrapper/ A shorter URL with more results: http://www.pgxn.org/tag/fdw Best, David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread David E . Wheeler
On Sep 12, 2011, at 9:50 AM, Dimitri Fontaine wrote: Thanks to Greg Smith for adding a few bonus ideas I hadn't thought of. What else have you got? I don't think we necessarily have to limit ourselves to core features, BTW: projects like PostGIS and pgAdmin are also clearly popular, and new

Re: [HACKERS] What Would You Like To Do?

2011-09-12 Thread Peter Eisentraut
On sön, 2011-09-11 at 21:21 -0700, David E. Wheeler wrote: * Column-leve collation support: Peter/Enterprise DB Column-level collation support already exists. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] What Would You Like To Do?

2011-09-12 Thread Dimitri Fontaine
Hi, David E. Wheeler da...@kineticode.com writes: Thanks to Greg Smith for adding a few bonus ideas I hadn't thought of. What else have you got? I don't think we necessarily have to limit ourselves to core features, BTW: projects like PostGIS and pgAdmin are also clearly popular, and new

Re: [HACKERS] What Would You Like To Do?

2011-09-12 Thread David E . Wheeler
On Sep 12, 2011, at 6:01, Peter Eisentraut pete...@gmx.net wrote: Column-level collation support already exists. Yeah, just realized that. I mention to say table or column-level encoding. Best, David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to

Re: [HACKERS] What Would You Like To Do?

2011-09-12 Thread Stephen Frost
* David E. Wheeler (da...@kineticode.com) wrote: Toward the end of the presentation, I'd like to make some suggestions and offer to do some match-making. I'm thinking primarily of listing some of the stuff the community would love to see done, along with the names of the folks and/or

Re: [HACKERS] What Would You Like To Do?

2011-09-12 Thread Magnus Hagander
On Sep 13, 2011 2:37 AM, Stephen Frost sfr...@snowman.net wrote: * David E. Wheeler (da...@kineticode.com) wrote: Toward the end of the presentation, I'd like to make some suggestions and offer to do some match-making. I'm thinking primarily of listing some of the stuff the community would

Re: [HACKERS] What Would You Like To Do?

2011-09-12 Thread David E. Wheeler
On Sep 12, 2011, at 9:41 PM, Magnus Hagander wrote: I'm not looking for funding (probably couldn't take it if I was offered it, heh), so I'm not sure if it should be included, but I'm still planning to dig into revamping the logging system (if I can ever manage to get out from under my