Re: [HACKERS] DBI-LINK not support special support?

2011-09-14 Thread Robert Haas
On Wed, Sep 14, 2011 at 9:15 AM, paulo matadr wrote: > Any ideia for help You are much more likely to get help if you ask on the right mailing list, instead of here. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing li

Re: [HACKERS] foreign table: WARNING: problem in alloc set ExecutorState detected write past chunk end in block ...

2011-09-14 Thread Josh Kupershmidt
On Tue, Sep 13, 2011 at 7:38 PM, Tom Lane wrote: > Hmm.  I tried on 64-bit Lion (10.7.1) and had no luck. > > Please try setting a gdb breakpoint on the warning elog (it's in aset.c) > and looking to see what's the contents of the complained-of chunk.  That > might give us a hint anyway ... D'oh.

[HACKERS] memory barriers (was: Yes, WaitLatch is vulnerable to weak-memory-ordering bugs)

2011-09-14 Thread Robert Haas
On Mon, Aug 8, 2011 at 7:47 AM, Robert Haas wrote: > I've been thinking about this too and actually went so far as to do > some research and put together something that I hope covers most of > the interesting cases.  The attached patch is pretty much entirely > untested, but reflects my present be

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] DBI-LINK not support special support?

2011-09-14 Thread paulo matadr
Environment has been applied [postgres@gcomdesenv oracle]$ export declare -x HOME="/usr/local/pgsql/data" declare -x INPUTRC="/etc/inputrc" declare -x JAVA_HOME="/usr/java/jdk1.6.0_26" declare -x LANG="en_US.UTF-8" declare -x LANGUAGE="en_US.UTF-8" declare -x LC_ALL="en_US" declare -x LC_CTYPE="UT

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] Sponsored development

2011-09-14 Thread David Fetter
On Tue, Sep 13, 2011 at 08:24:15AM +0300, Heikki Linnakangas wrote: > On 13.09.2011 00:33, Dermot wrote: > >I have seen this feature on the todo list: > >http://wiki.postgresql.org/wiki/Todo#Referential_Integrity > > > >It's my understanding that this will allow FK constraints on array > >elements,

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] WIP: Fast GiST index build

2011-09-14 Thread Robert Haas
On Tue, Sep 13, 2011 at 5:00 PM, Stefan Keller wrote: > 2011/9/6 Alexander Korotkov : >> GiST use serial numbers of operations for concurrency. In current >> implementation xlog record ids are used in capacity of that numbers. In >> unlogged table no xlog records are produced. So, we haven't seria

Re: [HACKERS] augmenting MultiXacts to improve foreign keys

2011-09-14 Thread Robert Haas
On Tue, Sep 13, 2011 at 9:27 AM, Alvaro Herrera wrote: >> I wonder if it's a mistake to be thinking about solving this problem >> by extending the MultiXact mechanism.  Pushing xmax out-of-line so >> that we have room to store tuple information seems expensive, >> especially because there's no con

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] Inserting heap tuples in bulk in COPY

2011-09-14 Thread Heikki Linnakangas
On 13.08.2011 17:33, Tom Lane wrote: Heikki Linnakangas writes: The patch is WIP, mainly because I didn't write the WAL replay routines yet, but please let me know if you see any issues. Why do you need new WAL replay routines? Can't you just use the existing XLOG_HEAP_NEWPAGE support? By a

Re: [HACKERS] unite recovery.conf and postgresql.conf

2011-09-14 Thread Peter Eisentraut
On tis, 2011-09-13 at 17:10 +0100, Simon Riggs wrote: > So treat postgresql.conf as if it has an automatic "include > recovery.conf" in it. The file format is the same. Sounds good. That would also have the merit that you could use, say, different memory settings during recovery. -- Sent via

[HACKERS] [REVIEW] pg_last_xact_insert_timestamp

2011-09-14 Thread Kyotaro HORIGUCHI
Hi, This is a review for pg_last_xact_insert_timestamp patch. (https://commitfest.postgresql.org/action/patch_view?id=634) Summary There's one question and two comments. Q1: The shmem entry for timestamp is not initialized on allocating. Is this OK? (I don't know that for OS

Re: [HACKERS] DBI-LINK not support special support?

2011-09-14 Thread Albe Laurenz
paulo matadr wrote: > I use dbi-link to connect for oracle db 10g and 11g, and > big problem give to me: > example: > select * from table(oracle) > çavân > When dbi-link call information from oracle his show > ?cv?an > > In pure perl script no have problems too. > > Any ideas for help me? This is