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 no

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. > > > > >

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, but not here Here's my preliminary list: Could you expand your idea about this here? I

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 (pgs

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 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 have the s

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 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 forgot it since then

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

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 with

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, > > but not here >> Here's my preliminary list: > Could you expand your idea about this here? It was something suggested to me on IR

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 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 Gonzalez 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 th

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 a

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, 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 your su

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, an

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 subsc

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 Alexander Korotkov
On Mon, Sep 12, 2011 at 8:21 AM, David E. Wheeler wrote: > 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 gin/gist/spgist. * Signature ind

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

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/ -K

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 Gonzalez 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 t

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 Tom Lane
Rodrigo Gonzalez 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 eventually be possible,

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 has

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 wrote: > > 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 s

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 ju

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 across

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

2011-09-13 Thread Thom Brown
On 12 September 2011 05:21, 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 out th

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

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 organizati

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 unde

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

2011-09-12 Thread Magnus Hagander
On Sep 13, 2011 2:37 AM, "Stephen Frost" 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 love to see done

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 com

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

2011-09-12 Thread David E . Wheeler
On Sep 12, 2011, at 6:01, Peter Eisentraut 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 your subscripti

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

2011-09-12 Thread Dimitri Fontaine
Hi, "David E. Wheeler" 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 projects of that sc

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: http://www.postgresql.org