Re: [HACKERS] Problem with accesing Oracle from plperlu functionwhen using remote pg client.

Jonah H. Harris escribió: > I first encountered it while working on database links from PG to Oracle at > EnterpriseDB, and the reason Tomasz couldn't find the answer to this online > is because it's such a rare problem that Oracle has no reason to change it. > Really, how many people have parenth

Re: [HACKERS] Problem with accesing Oracle from plperlu functionwhen using remote pg client.

All, Probably somebody should resurrect the Oralink project instead. http://pgfoundry.org/projects/oralink/ --Josh -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Problem with accesing Oracle from plperlu functionwhen using remote pg client.

On Mon, Mar 16, 2009 at 12:36 PM, Alvaro Herrera wrote: > Jonah H. Harris escribió: > > Wow, that's a really idiotic thing for Oracle to do. Well, being able to find out what applications are connected to the database is nice. But, it would also be nice if they stopped parsing the program name

Re: [HACKERS] Problem with accesing Oracle from plperlu functionwhen using remote pg client.

On Mon, Mar 16, 2009 at 12:50 PM, Tomasz Olszak wrote: > Thank you very much, I tried to solve it for about 2 weeks. I know that few > people in the net have the same problem too. No problem :) -- Jonah H. Harris, Senior DBA myYearbook.com

Re: [HACKERS] Problem with accesing Oracle from plperlu functionwhen using remote pg client.

On Mon, Mar 16, 2009 at 1:06 PM, Tom Lane wrote: > We're not going to break a bunch of other applications in order to make > some undocumented, unsupported Oracle thingie work (until they change > it...). Got another solution? Unfortunately, that's the way Oracle has done it since before the e

Re: [HACKERS] Problem with accesing Oracle from plperlu functionwhen using remote pg client.

"Jonah H. Harris" writes: > The solution to this is to change the following line in > src/backend/postmaster/postmaster.c: We're not going to break a bunch of other applications in order to make some undocumented, unsupported Oracle thingie work (until they change it...). Got another solution?

Re: [HACKERS] Problem with accesing Oracle from plperlu functionwhen using remote pg client.

Jonah, you're the man :).  Thank you very much, I tried to solve it for about 2 weeks. I know that few people in the net have the same problem too. I simply chanche that line, recompile postgresql and wait for some better solution. I know that a lot of people uses DBI-LINK. It simply doesn't wo

Re: [HACKERS] Problem with accesing Oracle from plperlu functionwhen using remote pg client.

Jonah H. Harris wrote: > Finally, my low-level Oracle knowledge does benefit Postgres :) :-) > > It's a TNS parsing error due to a combination of Oracle's use of a > Lispish s-expression-like name-value pair format and Postgres' process > listing format for remote connections. > > On connect

Re: [HACKERS] Problem with accesing Oracle from plperlu functionwhen using remote pg client.

Jonah H. Harris escribió: > On connection, the Oracle client sends the current application name to the > Oracle server (which is listed in the V$SESSION view); in the case of > Postgres, the program name is the current backend process name text. > Because Oracle picks up Postgres' backend text, "p

Re: [HACKERS] Problem with accesing Oracle from plperlu functionwhen using remote pg client.

On Mon, Mar 16, 2009 at 11:09 AM, Tomasz Olszak wrote: > So it looks like that plperlu function is executing from remote and local > clients with the same set of environment variable. It has nothing to do with the environment variables. > So I don't have a clue how can I iron out this issue.

Re: [HACKERS] Problem with accesing Oracle from plperlu functionwhen using remote pg client.

Thank you for quick answer. I understand, but when I print from plperlu function notices with result of `env` they're the same in both cases (from remote and local client). So it looks like that plperlu function is executing from remote and local clients with the same set of environment variable.

Re: [HACKERS] Problem with accesing Oracle from plperlu function when using remote pg client.

On Mon, Mar 16, 2009 at 03:16:07PM +0100, Tomasz Olszak wrote: > Greetings to All! > > I've tried to find solution of my problem on other pg mailing lists but > without bigger effect. > > I have a table A in PG. There is also table A in Oracle. > I want to import specific row from oracle to p

[HACKERS] Problem with accesing Oracle from plperlu function when using remote pg client.

Greetings to All! I've tried to find solution of my problem on other pg mailing lists but without bigger effect. I have a table A in PG. There is also table A in Oracle. I want to import specific row from oracle to pg, so i create plperlu function CREATE OR REPLACE FUNCTION import.ora_a_row

Re: [HACKERS] problem inserting in GIN index

Emanuel Calvo Franco escribió: > 2009/3/10 Teodor Sigaev : > >> Apparently there's a crash involved ... > > > > Are other indexes on that table broken? ( Just count(*) with only index scan > > enabled ) > Yes, there are some btree indexes broken. > Alvaro asked him if the option fsync is off. We

Re: [HACKERS] problem inserting in GIN index

2009/3/10 Teodor Sigaev : >> Apparently there's a crash involved ... > > Are other indexes on that table broken? ( Just count(*) with only index scan > enabled ) > -- > Teodor Sigaev                                   E-mail: teo...@sigaev.ru >                                                   WWW:

Re: [HACKERS] problem inserting in GIN index

Apparently there's a crash involved ... Are other indexes on that table broken? ( Just count(*) with only index scan enabled ) -- Teodor Sigaev E-mail: teo...@sigaev.ru WWW: http://www.sigaev.ru/ -- Sent via

Re: [HACKERS] problem inserting in GIN index

A guy just reported on pgsql-es-ayuda that he's getting ERROR: item pointer (543108,2) already exists It will be fine to get test case... Apparently this message only occurs on GIN, in insertItemPointer Reading that routine I can

Re: [HACKERS] problem inserting in GIN index

2009/3/9 Alvaro Herrera : > Tom Lane wrote: >> Alvaro Herrera writes: >> > A guy just reported on pgsql-es-ayuda that he's getting >> > ERROR: item pointer (543108,2) already exists >> Test case? > > Apparently there's a crash involved ... > I asked to Gabriel. The exactly version is 8.3.6. He ju

Re: [HACKERS] problem inserting in GIN index

Tom Lane wrote: > Alvaro Herrera writes: > > A guy just reported on pgsql-es-ayuda that he's getting > > ERROR: item pointer (543108,2) already exists > > > Test case? Apparently there's a crash involved ... -- Alvaro Herrera

Re: [HACKERS] problem inserting in GIN index

Alvaro Herrera writes: > A guy just reported on pgsql-es-ayuda that he's getting > ERROR: item pointer (543108,2) already exists > Test case? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-

[HACKERS] problem inserting in GIN index

Hi, A guy just reported on pgsql-es-ayuda that he's getting ERROR: item pointer (543108,2) already exists Apparently this message only occurs on GIN, in insertItemPointer Reading that routine I cannot help but wonder -- where is g

Re: [HACKERS] problem with archive_command as suggested by documentation

On Mon, Jan 26, 2009 at 04:40:12PM +0100, Albe Laurenz wrote: > Peter Eisentraut wrote: > >> I don't think that particular example is a good one since the > >> whole point of the archive is that it should be off-server. If > >> we're going to be exact about the example then we should give a > >> mo

Re: [HACKERS] problem with archive_command as suggested by documentation

Peter Eisentraut wrote: >> I don't think that particular example is a good one since the whole >> point of the archive is that it should be off-server. If we're going to >> be exact about the example then we should give a more realistic one, >> like using scp. Unfortunately, there is no secure-remo

Re: [HACKERS] problem with archive_command as suggested by documentation

Simon Riggs wrote: I don't think that particular example is a good one since the whole point of the archive is that it should be off-server. If we're going to be exact about the example then we should give a more realistic one, like using scp. Unfortunately, there is no secure-remote-move command

Re: [HACKERS] problem with archive_command as suggested by documentation

"Albe Laurenz" writes: > Heikki Linnakangas wrote: >> Well, the documentation states the reason to do that: >> >> This is an important safety feature to preserve the >> integrity of your archive in case of administrator error >> (such as sending the output of two different servers to the >> sa

Re: [HACKERS] problem with archive_command as suggested by documentation

On Fri, 2009-01-23 at 08:20 +0100, Albe Laurenz wrote: > > Perhaps it should suggest > > something like: > > > > test ! -f .../%f && cp %p .../%f.tmp && mv .../%f.tmp .../%f > > > > ie. copy under a different filename first, and rename the file in place > > after it's completely written, assu

Re: [HACKERS] problem with archive_command as suggested by documentation

Heikki Linnakangas wrote: > > The documentation states > > > > "The archive command should generally be designed to refuse to overwrite > > any pre-existing archive file." > > > > and suggests an archive_command like "test ! -f .../%f && cp %p .../%f". > > > > We ran into (small) problems with

Re: [HACKERS] problem with archive_command as suggested by documentation

On Jan 22, 2009, at 10:18 AM, Albe Laurenz wrote: "The archive command should generally be designed to refuse to overwrite any pre-existing archive file." ... The server received a fast shutdown request while a WAL segment was being archived. The archiver stopped and left behind a half-writt

Re: [HACKERS] problem with archive_command as suggested by documentation

Albe Laurenz wrote: The documentation states in http://www.postgresql.org/docs/current/static/continuous-archiving.html#BACKUP-ARCHIVING-WAL "The archive command should generally be designed to refuse to overwrite any pre-existing archive file." and suggests an archive_command like "test ! -f

[HACKERS] problem with archive_command as suggested by documentation

The documentation states in http://www.postgresql.org/docs/current/static/continuous-archiving.html#BACKUP-ARCHIVING-WAL "The archive command should generally be designed to refuse to overwrite any pre-existing archive file." and suggests an archive_command like "test ! -f .../%f && cp %p .../%f

Re: [HACKERS] problem i get for Patch "blomming filter"

On Sunday 07 December 2008 12:06:44 Unicron wrote: > When i was performancing gmake, i got a error message. The attachment is > the detail, i have no ideas about it. Hope someone' help You probably forgot make distclean before rebuilding. -- Sent via pgsql-hackers mailing list (pgsql-hackers@pos

[HACKERS] problem i get for Patch "blomming filter"

When i was performancing gmake, i got a error message. The attachment is the detail, i have no ideas about it. Hope someone' help                                           Thanks  gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-stric

[HACKERS] Problem in contrib/tablefunc's crosstab()

While fooling with the recent contrib problem http://archives.postgresql.org/pgsql-committers/2008-11/msg00346.php I noticed another way that tablefunc.c is being cavalier about the state when it returns control: the crosstab() function returns with an internal SPI call still active! This is relat

Re: [HACKERS] Problem with Bitmap Heap Scan

I wrote: > Heikki Linnakangas <[EMAIL PROTECTED]> writes: >> Attached is a patch that changes create_bitmap_subplan so that the >> condition put into Recheck condition is never stronger than the >> condition automatically handled by the index. Does that look right to you? > I think this is still

Re: [HACKERS] Problem with Bitmap Heap Scan

Heikki Linnakangas <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Hmm, the ~~ condition should get treated as a "filter" not a "recheck". >> I suppose I broke this somewhere ... > I started to look at this last night. The culprit seems to be this patch: Yeah, it appears that I oversimplified ma

Re: [HACKERS] Problem with Bitmap Heap Scan

Tom Lane wrote: "Rushabh Lathia" <[EMAIL PROTECTED]> writes: Simple select give wrong result when it uses the Bitmap Heap Scan path. It's generally appropriate to mention which PG version you're working with when you report a bug. postgres=# explain select proname from pg_proc where proname

Re: [HACKERS] Problem with Bitmap Heap Scan

Tom Lane wrote: "Rushabh Lathia" <[EMAIL PROTECTED]> writes: Simple select give wrong result when it uses the Bitmap Heap Scan path. It's generally appropriate to mention which PG version you're working with when you report a bug. I was on 8.4 CVS Head, Next time will sure take car

Re: [HACKERS] Problem with Bitmap Heap Scan

"Rushabh Lathia" <[EMAIL PROTECTED]> writes: > Simple select give wrong result when it uses the Bitmap Heap Scan path. It's generally appropriate to mention which PG version you're working with when you report a bug. > postgres=# explain select proname from pg_proc where proname like 'my_pro1'; >

Re: [HACKERS] Problem with Bitmap Heap Scan

Analysis: While debugging bitmap heap scan (BitmapHeapNext function) found that first we perform the underlying index scan and then iterate over bitmap. Now while iterating, we execute ExecQual only if tbmres->recheck is true. And for the query tbmres->recheck is false. But from the que

[HACKERS] Problem with Bitmap Heap Scan

Simple select give wrong result when it uses the Bitmap Heap Scan path. postgres=# CREATE OR REPLACE FUNCTION my_exec_im_test_func(i integer) RETURNS integer AS $$ BEGIN RETURN i + 1; END; $$ LANGUAGE plpgsql; CREATE FUNCTION postgres=# set enable_seqscan=off; SET

Re: [HACKERS] Problem to get the tuple of a table

Zhe He napsal(a): I'm currently implement a new operation in Postgres. If I want to get all tuples of a single attribute table to create an array defined by myself, how can I do that? Look into heapam.c and pgstattuple contrib module is good example. Zdenek -- Zdenek Kotala

[HACKERS] Problem to get the tuple of a table

I'm currently implement a new operation in Postgres. If I want to get all tuples of a single attribute table to create an array defined by myself, how can I do that? -Zhe

Re: [HACKERS] problem with compilation on fedora core 10 64 bit

"Pavel Stehule" <[EMAIL PROTECTED]> writes: > compilation pg8.4 finished with error > In file included from ../../../../src/include/access/xlog.h:20, > from ../../../../src/include/access/hash.h:24, > from catcache.c:19: > ../../../../src/include/utils/timestamp.h

Re: [HACKERS] problem with compilation on fedora core 10 64 bit

I am sorry - It was noise, probably some fedora update issue, after restart all compilation is done. Regards Pavel Stehule 2008/10/8 Markus Wanner <[EMAIL PROTECTED]>: > Hi, > > Pavel Stehule wrote: >> compilation pg8.4 finished with error > > Have you tried 'make distclean'? > > What gcc version

Re: [HACKERS] problem with compilation on fedora core 10 64 bit

Hi, Pavel Stehule wrote: > compilation pg8.4 finished with error Have you tried 'make distclean'? What gcc version is shipped with fc10? I'm building CVS HEAD just fine on debian lenny with gcc 4.3.1. The buildfarm doesn't show any such failure either with various other gcc versions. Regards M

[HACKERS] problem with compilation on fedora core 10 64 bit

Hello compilation pg8.4 finished with error make[4]: Leaving directory `/home/pavel/src/pgsql/src/backend/utils/adt' make -C cache all make[4]: Entering directory `/home/pavel/src/pgsql/src/backend/utils/cache' gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wend

Re: [HACKERS] Problem returning strings with pgsql 8.3.x

On Tue, May 13, 2008 at 8:19 AM, Josh Tolley <[EMAIL PROTECTED]> wrote: > On Tue, May 13, 2008 at 8:01 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > > Martijn van Oosterhout <[EMAIL PROTECTED]> writes: > > > On Mon, May 12, 2008 at 11:23:17PM -0600, Josh Tolley wrote: > > >> SPI_push(); > > >> r

Re: [HACKERS] Problem returning strings with pgsql 8.3.x

On Tue, May 13, 2008 at 8:01 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > Martijn van Oosterhout <[EMAIL PROTECTED]> writes: > > On Mon, May 12, 2008 at 11:23:17PM -0600, Josh Tolley wrote: > >> SPI_push(); > >> retval = > >> InputFunctionCall(&flinfo, lolVarGetString(returnVal, true), > >> resul

Re: [HACKERS] Problem returning strings with pgsql 8.3.x

Martijn van Oosterhout <[EMAIL PROTECTED]> writes: > On Mon, May 12, 2008 at 11:23:17PM -0600, Josh Tolley wrote: >> SPI_push(); >> retval = >> InputFunctionCall(&flinfo, lolVarGetString(returnVal, true), >> resultTypeIOParam, -1); >> SPI_pop(); > Won't this cause the return value to be allocated

Re: [HACKERS] Problem returning strings with pgsql 8.3.x

On Mon, May 12, 2008 at 11:23:17PM -0600, Josh Tolley wrote: > SPI_push(); > retval = > InputFunctionCall(&flinfo, lolVarGetString(returnVal, true), > resultTypeIOParam, -1); > SPI_pop(); Won't

[HACKERS] Problem returning strings with pgsql 8.3.x

Having posted this to -general [1] per -hackers list instructions [2] to try elsewhere first, and waited (not very long, I admit) in vain for a response, I'm posting this to -hackers now. My apologies if my impatience in that regard annoys. While developing PL/LOLCODE, I've found something wrong w

Re: [HACKERS] Problem with server/utils/snapmgr.h

Marko Kreen escribió: > You probably simply need to use ActiveSnapshot there. Heh, ActiveSnapshot as a symbol is also gone in the new code ;-) I changed txid.c to use GetActiveSnapshot() instead. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Comp

Re: [HACKERS] Problem with server/utils/snapmgr.h

On 4/22/08, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Chris Browne wrote: > > > And I was trying to build against CVS HEAD (for both projects ;-)) and > > observed it: > > > > [EMAIL PROTECTED]:CMD/slony1-HEAD/src/backend> make > > gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations

Re: [HACKERS] Problem with server/utils/snapmgr.h

Chris Browne wrote: > And I was trying to build against CVS HEAD (for both projects ;-)) and > observed it: > > [EMAIL PROTECTED]:CMD/slony1-HEAD/src/backend> make > gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../.. -fpic > -I/opt/OXRS/dbs/pgsql84-beta/include/ > -I/opt/OXRS/

Re: [HACKERS] Problem with server/utils/snapmgr.h

[EMAIL PROTECTED] (Alvaro Herrera) writes: > Chris Browne wrote: > >> If I use: >> AC_CHECK_HEADER(utils/snapmgr.h, HAVE_SNAPMGR=1) >> >> this turns out to fail. Apparently autoconf wants to compile the >> #include file to validate that it's an OK #include file. >> >> GCC barfs on it, thus: >

Re: [HACKERS] Problem with server/utils/snapmgr.h

Chris Browne <[EMAIL PROTECTED]> writes: > I tried adding an autoconf rule to Slony-I to check for its existence > (goal then is to do a suitable #define so that we can #ifdef the > #include, so that we #include this only with versions of PostgreSQL > that have the file). The customary way of hand

Re: [HACKERS] Problem with server/utils/snapmgr.h

Chris Browne wrote: > If I use: > AC_CHECK_HEADER(utils/snapmgr.h, HAVE_SNAPMGR=1) > > this turns out to fail. Apparently autoconf wants to compile the > #include file to validate that it's an OK #include file. > > GCC barfs on it, thus: > > [EMAIL PROTECTED]:~/Slony-I/CMD/slony1-HEAD> gcc

[HACKERS] Problem with server/utils/snapmgr.h

There's a new #include file that it turns out we need for Slony-I to reference, namely include/server/utils/snapmgr.h I tried adding an autoconf rule to Slony-I to check for its existence (goal then is to do a suitable #define so that we can #ifdef the #include, so that we #include this only with

Re: [HACKERS] Problem with site doc search

Cédric Villemain wrote: > Le Wednesday 16 April 2008, Magnus Hagander a écrit : > > Cédric Villemain wrote: > > > Notice that : > > > > > > http://search.postgresql.org/search?q=tom+lane&m=1&l=&d=1&s=r > > > and > > > http://search.postgresql.org/search?q=tom+lane&m=1&l=&d=1&s=d > > > > > > do not

Re: [HACKERS] Problem with site doc search

Le Wednesday 16 April 2008, Magnus Hagander a écrit : > Cédric Villemain wrote: > > Notice that : > > > > http://search.postgresql.org/search?q=tom+lane&m=1&l=&d=1&s=r > > and > > http://search.postgresql.org/search?q=tom+lane&m=1&l=&d=1&s=d > > > > do not provide same result (3 results by date, 1

Re: [HACKERS] Problem with site doc search

Cédric Villemain wrote: > Notice that : > > http://search.postgresql.org/search?q=tom+lane&m=1&l=&d=1&s=r > and > http://search.postgresql.org/search?q=tom+lane&m=1&l=&d=1&s=d > > do not provide same result (3 results by date, 1 by rank) even if > only the sorting is changed. Actually, I get 5

Re: [HACKERS] Problem with site doc search

Oleg Bartunov wrote: > On Tue, 15 Apr 2008, Magnus Hagander wrote: > > > I didn't do anything, but possibly it got fixed by a different > > upgrade at some point, and the recrawling of the sites. > > Magnus, we have parser for indexing pgdocs, do you need it ? Yes, please! //Magnus -- Sent vi

Re: [HACKERS] Problem with site doc search

Notice that : http://search.postgresql.org/search?q=tom+lane&m=1&l=&d=1&s=r and http://search.postgresql.org/search?q=tom+lane&m=1&l=&d=1&s=d do not provide same result (3 results by date, 1 by rank) even if only the sorting is changed. -- Cédric Villemain Administrateur de Base de Données Ce

Re: [HACKERS] Problem with site doc search

Oleg Bartunov wrote: Sergey Karpov prepared contrib/extend_parser, which we intend to use for indexing pg-related documents. It handles '_' properly, so if anybody interested, we could post it. Also, it can be useful for playing, since it's standalone contrib module. Does it make sense to back

Re: [HACKERS] Problem with site doc search

Sergey Karpov prepared contrib/extend_parser, which we intend to use for indexing pg-related documents. It handles '_' properly, so if anybody interested, we could post it. Also, it can be useful for playing, since it's standalone contrib module. Oleg On Tue, 15 Apr 2008, Richard Huxton wrote:

Re: [HACKERS] Problem with site doc search

On Tue, 15 Apr 2008, Magnus Hagander wrote: I didn't do anything, but possibly it got fixed by a different upgrade at some point, and the recrawling of the sites. Magnus, we have parser for indexing pgdocs, do you need it ? //Magnus Bruce Momjian wrote: I just searched for pg_standby and

Re: [HACKERS] Problem with site doc search

Magnus Hagander wrote: Did you ever post the code to anybody other than Gevik? If not, please send it to pgsql-www and someone can give it a quick look-over (perhaps Oleg can help us there?) Will do. -- Richard Huxton Archonet Ltd -- Sent via pgsql-hackers mailing list (pgsql-hackers@post

Re: [HACKERS] Problem with site doc search

Richard Huxton wrote: > Bruce Momjian wrote: > > Magnus Hagander wrote: > >> I didn't do anything, but possibly it got fixed by a different > >> upgrade at some point, and the recrawling of the sites. > > > > Oops, maybe it isn't fixed. I tried "pg_standby" and it seemed to > > work but "pg" and "

Re: [HACKERS] Problem with site doc search

Bruce Momjian wrote: Magnus Hagander wrote: I didn't do anything, but possibly it got fixed by a different upgrade at some point, and the recrawling of the sites. Oops, maybe it isn't fixed. I tried "pg_standby" and it seemed to work but "pg" and "standby" returns the same results. Is that co

Re: [HACKERS] Problem with site doc search

Magnus Hagander wrote: > I didn't do anything, but possibly it got fixed by a different upgrade > at some point, and the recrawling of the sites. Oops, maybe it isn't fixed. I tried "pg_standby" and it seemed to work but "pg" and "standby" returns the same results. Is that correct? How do I test

Re: [HACKERS] Problem with site doc search

I didn't do anything, but possibly it got fixed by a different upgrade at some point, and the recrawling of the sites. //Magnus Bruce Momjian wrote: > > I just searched for pg_standby and it looks like it is fixed now. > >

Re: [HACKERS] Problem with site doc search

I just searched for pg_standby and it looks like it is fixed now. --- Gurjeet Singh wrote: > On Tue, Mar 25, 2008 at 3:01 AM, Magnus Hagander <[EMAIL PROTECTED]> > wrote: > > > Gurjeet Singh wrote: > > > On Thu, Mar 6, 2008

Re: [HACKERS] problem with locks on head, backend crash

On 07/04/2008, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Pavel Stehule escribió: > > > > WARNING: problem in alloc set MessageContext: req size > alloc size > > for chunk 0x8b6d1e0 in block 0x8b6bb50 > > WARNING: problem in alloc set MessageContext: req size > alloc size > > for chunk 0x8b6

Re: [HACKERS] problem with locks on head, backend crash

Pavel Stehule escribió: > WARNING: problem in alloc set MessageContext: req size > alloc size > for chunk 0x8b6d1e0 in block 0x8b6bb50 > WARNING: problem in alloc set MessageContext: req size > alloc size > for chunk 0x8b6d1e0 in block 0x8b6bb50 I suggest you make distclean and rebuild the whol

Re: [HACKERS] problem with locks on head, backend crash

On 07/04/2008, Heikki Linnakangas <[EMAIL PROTECTED]> wrote: > Pavel Stehule wrote: > > > when I tested ptop, I found some problems > > > > Which version are you running? I am sorry, HEAD 8.4 today actualized Pavel > > -- > Heikki Linnakangas > EnterpriseDB http://www.enterprisedb.com >

Re: [HACKERS] problem with locks on head, backend crash

Pavel Stehule wrote: when I tested ptop, I found some problems Which version are you running? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.

[HACKERS] problem with locks on head, backend crash

Hello when I tested ptop, I found some problems this pgbench is very slow and when after getting table of locks from ptop I got backend crash. [EMAIL PROTECTED] ~]$ /usr/local/pgsql/bin/pgbench -c80 -t1000 postgres starting vacuum...end. WARNING: you don't own a lock of type ShareLock WARNING:

Re: [HACKERS] Problem with site doc search

On Tue, Mar 25, 2008 at 3:01 AM, Magnus Hagander <[EMAIL PROTECTED]> wrote: > Gurjeet Singh wrote: > > On Thu, Mar 6, 2008 at 5:01 PM, Gevik Babakhani <[EMAIL PROTECTED] > > > wrote: > > > > > No, it's still on the TODO. Gevik has also been looking a bit > > > a

Re: [HACKERS] Problem with site doc search

Gurjeet Singh wrote: On Thu, Mar 6, 2008 at 5:01 PM, Gevik Babakhani <[EMAIL PROTECTED] > wrote: > No, it's still on the TODO. Gevik has also been looking a bit > at it (I think - at least he's indicated that he is), and he > recently got some new parser

Re: [HACKERS] Problem with site doc search

On Thu, Mar 6, 2008 at 5:01 PM, Gevik Babakhani <[EMAIL PROTECTED]> wrote: > > No, it's still on the TODO. Gevik has also been looking a bit > > at it (I think - at least he's indicated that he is), and he > > recently got some new parser code to look at to see if we can > > use to fix it. > > > >

Re: [HACKERS] Problem with site doc search

> No, it's still on the TODO. Gevik has also been looking a bit > at it (I think - at least he's indicated that he is), and he > recently got some new parser code to look at to see if we can > use to fix it. > I have the new parser code. Next week I have some time reserved to look at it. --

Re: [HACKERS] Problem with site doc search

No, it's still on the TODO. Gevik has also been looking a bit at it (I think - at least he's indicated that he is), and he recently got some nwe parser code to look at to see if we can use to fix it. //Magnus On Wed, Mar 05, 2008 at 10:23:28PM -0500, Bruce Momjian wrote: > > Has this been addre

Re: [HACKERS] Problem with site doc search

Has this been addressed? --- Oleg Bartunov wrote: > On Tue, 5 Feb 2008, Magnus Hagander wrote: > > > No. It's on the list, but other things around the release haev priority. > > I just returned from my Europe trip and have

Re: [HACKERS] Problem with site doc search

On Tue, 5 Feb 2008, Magnus Hagander wrote: No. It's on the list, but other things around the release haev priority. I just returned from my Europe trip and have many things to do :) //Magnus On Mon, Feb 04, 2008 at 06:43:09PM -0800, Gurjeet Singh wrote: Hi guys any updates on this? Pi

Re: [HACKERS] Problem with site doc search

No. It's on the list, but other things around the release haev priority. //Magnus On Mon, Feb 04, 2008 at 06:43:09PM -0800, Gurjeet Singh wrote: > Hi guys any updates on this? Pinging you just so that we do not forget > it in the heap of mails in our inboxes. > > Best regards, > > On Feb 3,

Re: [HACKERS] Problem with site doc search

Hi guys any updates on this? Pinging you just so that we do not forget it in the heap of mails in our inboxes. Best regards, On Feb 3, 2008 8:40 AM, Magnus Hagander <[EMAIL PROTECTED]> wrote: > Oleg Bartunov wrote: > > On Sat, 2 Feb 2008, Gurjeet Singh wrote: > > > >> Hi All, > >> > >>I

Re: [HACKERS] Problem with site doc search

Oleg Bartunov wrote: On Sat, 2 Feb 2008, Gurjeet Singh wrote: Hi All, I just noticed a minor bug in our search results. Searching for is_insteadbool in 8.3 docs returns the following page: http://www.postgresql.org/docs/8.3/static/catalog-pg-rewrite.html is_instead is a column, and boo

Re: [HACKERS] Problem with site doc search

On Sat, 2 Feb 2008, Gurjeet Singh wrote: Hi All, I just noticed a minor bug in our search results. Searching for is_insteadbool in 8.3 docs returns the following page: http://www.postgresql.org/docs/8.3/static/catalog-pg-rewrite.html is_instead is a column, and bool is the datatype, bot

[HACKERS] Problem with site doc search

Hi All, I just noticed a minor bug in our search results. Searching for is_insteadbool in 8.3 docs returns the following page: http://www.postgresql.org/docs/8.3/static/catalog-pg-rewrite.html is_instead is a column, and bool is the datatype, both mentioned in different columns. I know i

[HACKERS] Problem with correct compiling and linking server side C function on Windows ,c++ Builder

Hello I tried to find soultion for this problem on -cygwin list , but there they sent me to teh list -win32. But I foun on the site that this is that list (also -hacker-win32),so I came here to -hackers. My problem is as follows , maybe you can help me: I ma working on a server-side funct

Re: [HACKERS] Problem with CVS HEAD's handling of mergejoins

I wrote: > A perhaps less invasive idea is to discard any proposed mergeclauses > that are redundant in this sense. This would still require some > reshuffling of responsibility between select_mergejoin_clauses and > the code in pathkeys.c, since right now select_mergejoin_clauses > takes no accou

Re: [HACKERS] Problem with CVS HEAD's handling of mergejoins

Tom Lane wrote: > I think I can fix this in a day or so, but I now definitely feel that > we'll need an RC2 :-( Understood. :-| -- Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a har

[HACKERS] Problem with CVS HEAD's handling of mergejoins

So I adjusted the patch I was working on as suggested here http://archives.postgresql.org/pgsql-hackers/2008-01/msg00251.php and things started blowing up all over the place --- Assert failures, "too few pathkeys for mergeclauses" errors, etc :-( On investigation, the problem seems to be a bit of

Re: [HACKERS] Problem with PgTcl auditing function on trigger

> > > - Original Message > From: Glyn Astill <[EMAIL PROTECTED]> > To: pgsql-hackers@postgresql.org > Sent: Friday, January 4, 2008 5:23:18 AM > Subject: [HACKERS] Problem with PgTcl auditing function on trigger > > Hi people, > > I've tried

Re: [HACKERS] Problem with PgTcl auditing function on trigger

Glyn Astill wrote: Hi people, I've tried posting on the general list about this, but I never get a reply, so I'm trying here. I think you'll probably have more luck with a TCL list than the PG hackers list. However, I've attached some pltcl functions I put together ages ago to do this s

[HACKERS] Problem with PgTcl auditing function on trigger

Hi people, I've tried posting on the general list about this, but I never get a reply, so I'm trying here. I have a function that is run each time an INSERT, DELETE or UPDATE happens on a row and log into an audit table. It is based on the info here: http://www.alberton.info/postgres

[HACKERS] Problem with PgTcl auditing function on trigger

Hi people, I've tried posting on the general list about this, but I never get a reply, so I'm trying here. I have a function that is run each time an INSERT, DELETE or UPDATE happens on a row and log into an audit table. It is based on the info here: http://www.alberton.info/postgresql_table_au

[HACKERS] Problem

Hello, I am implementing some changes in structure of index from postgresql when run the command initdb gives the following error: Bogus pg_index tuple. What it may come to be? Thanks, -- Pedro Belmino. # Ciência da Computação -

Re: [HACKERS] Problem of a server gettext message.

Hi. Yeah, As a part from which a problem happens, it is your suggestion. This is only the check. http://winpg.jp/~saito/pg83/message_check/gtext2.c Therefore, a message needed is acquirable in the next operation. gtext2 C UTF-8 http://winpg.jp/~saito/pg83/message_check/codeset_utf8_msg.txt gte

Re: [HACKERS] Problem with ControlFileData structure being ABI depe ndent

On Mon, Dec 10, 2007 at 09:56:39AM +, Dave Page wrote: > Dave Page wrote: > > Tom Lane wrote: > >> Dave Page <[EMAIL PROTECTED]> writes: > >>> Gregory Stark wrote: > An alternative is leaving it in the project file but putting > something like > this in c.h: > >> > >> Put it in w

<    1   2   3   4   5   6   7   8   9   10   >