[HACKERS] FailedAssertion

2011-05-12 Thread Yves Weißig
Hi together, I'm currently debugging my developed AM and are running into this problem: TRAP: FailedAssertion("!(((bool) (((void*)(tid) != ((void *)0)) && ((tid)->ip_posid != 0", File: "indexam.c", Line: 488) Can anybody explain what it means? I'm having difficulties to understand what went

Re: [HACKERS] could not write block & xlog flush request 3FD/0 is not satisfied

2011-05-09 Thread Yves Weißig
-hackers@postgresql.org Subject: Re: [HACKERS] could not write block & xlog flush request 3FD/0 is not satisfied On Sun, May 8, 2011 at 4:18 PM, Yves Weißig wrote: > ERROR:  xlog flush request 3FD/0 is not satisfied --- flushed only to > 0/20E2DC4 > That's a pretty big differenc

Re: [HACKERS] could not write block & xlog flush request 3FD/0 is not satisfied

2011-05-08 Thread Yves Weißig
Am 08.05.2011 17:38, schrieb Kevin Grittner: > Yves Weißig wrote: > >> my experimental index which I am developing still has some >> problems. Perhaps the list has some advices or hints where this >> error might occur: >> >> WARNING: could not write blo

[HACKERS] could not write block & xlog flush request 3FD/0 is not satisfied

2011-05-08 Thread Yves Weißig
Hi again pgsql-hackers, my experimental index which I am developing still has some problems. Perhaps the list has some advices or hints where this error might occur: WARNING: could not write block 6 of base/459204/483963 DETAIL: Multiple failures --- write error might be permanent. directly fo

Re: [HACKERS] Best way to construct Datum out of a string?

2011-04-28 Thread Yves Weißig
Am 28.04.2011 05:52, schrieb Tom Lane: > =?ISO-8859-15?Q?Yves_Wei=DFig?= > writes: >> Am 27.04.2011 16:11, schrieb Heikki Linnakangas: >>> What kind of a Datum do you want it to be? What data type? See >>> CStringGetDatum, or perhaps CStringGetTextDatum(). Or perhaps you want >>> to call the inpu

[HACKERS] new AM, best way to obtain new block at end of index?

2011-04-28 Thread Yves Weißig
Hi list, currently I am obtaining a new block at the end of an index with: buf = ReadBuffer(rel, P_NEW); but it throws: ERROR: unexpected data beyond EOF in block 0 of relation base/11874/156053 HINT: This has been seen to occur with buggy kernels; consider updating your system. system is up

[HACKERS] new AM, build returns error

2011-04-27 Thread Yves Weißig
Hi, my new AM starts working..., calling something like CREATE INDEX idx ON films USING ebi (did) returns now: ERROR: unexpected EBI relation size: 3, should be 4294967295 The second argument looks for me like max uint32... there might be somehting wrong here I think? Is there somehting wrong

Re: [HACKERS] Best way to construct Datum out of a string?

2011-04-27 Thread Yves Weißig
Am 27.04.2011 16:11, schrieb Heikki Linnakangas: > On 27.04.2011 17:06, Yves Weißig wrote: >> Hi, >> >> sadly, so far my search in the source code wasn't very successfull on >> this topic. >> So, how can I construct a Datum out of a string? > > What kin

[HACKERS] Best way to construct Datum out of a string?

2011-04-27 Thread Yves Weißig
Hi, sadly, so far my search in the source code wasn't very successfull on this topic. So, how can I construct a Datum out of a string? Greetz, Yves -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsq

Re: [HACKERS] new AM, catalog entries

2011-04-27 Thread Yves Weißig
Am 26.04.2011 17:07, schrieb Alvaro Herrera: > Excerpts from Yves Weißig's message of mar abr 26 11:32:31 -0300 2011: > >> I keep getting: ERROR: there is no built-in function named "ebibuild" >> This error message somehow leads me to fmgr.c where the contents of an >> array are inspected (in lin

Re: [HACKERS] operator classes for index?

2011-04-27 Thread Yves Weißig
Am 26.04.2011 17:37, schrieb Tom Lane: > =?ISO-8859-1?Q?Yves_Wei=DFig?= > writes: >> Am 26.04.2011 14:28, schrieb Robert Haas: >>> On Tue, Apr 26, 2011 at 5:18 AM, Yves Weißig >>> wrote: >>>> CREATE OPERATOR CLASS abstime_ops >>>> DE

[HACKERS] new AM, catalog entries

2011-04-26 Thread Yves Weißig
Hi list, I really have problems with the catalog entries for my AM. In the doc (http://developer.postgresql.org/pgdocs/postgres/index-catalog.html) it says "anyone able to write a new access method is expected to be competent to insert an appropriate row for themselves." :-) This is true so far fo

Re: [HACKERS] operator classes for index?

2011-04-26 Thread Yves Weißig
Am 26.04.2011 14:28, schrieb Robert Haas: > On Tue, Apr 26, 2011 at 5:18 AM, Yves Weißig > wrote: >> CREATE OPERATOR CLASS abstime_ops >> DEFAULT FOR TYPE abstime USING ebi FAMILY abstime_ops AS >> OPERATOR 1 = (abstime,abstime), >> FUNCTION 1 hashint4(abstime,ab

Re: [HACKERS] operator classes for index?

2011-04-26 Thread Yves Weißig
Am 26.04.2011 01:15, schrieb Tom Lane: > =?ISO-8859-15?Q?Yves_Wei=DFig?= > writes: >> But anyway I am having trouble creating an operator class: > >> CREATE OPERATOR CLASS abstime_ops >> DEFAULT FOR TYPE abstime USING ebi FAMILY abstime_ops AS >> OPERATOR 1 = , >> FUNCTION 1 abstimeeq(abstime

Re: [HACKERS] operator classes for index?

2011-04-25 Thread Yves Weißig
Am 24.04.2011 23:33, schrieb Tom Lane: > =?ISO-8859-15?Q?Yves_Wei=DFig?= > writes: >> again index access methods, can somebody shed some light into operator >> classes for indexes? The documentation is an entry point, but after >> reading I still don't have a clue how exactly they are used and cr

[HACKERS] operator classes for index?

2011-04-24 Thread Yves Weißig
Hi, again index access methods, can somebody shed some light into operator classes for indexes? The documentation is an entry point, but after reading I still don't have a clue how exactly they are used and created? Perhaps somebody with great knowledge can supply an 101 on opeartor classes? Becau

Re: [HACKERS] best way to test new index?

2011-04-23 Thread Yves Weißig
ults can be compared to a master file or whatsoever. On low level I tend to go your way and debug with elog, I just thought somebody might have a different approach on debugging such code. Yves Am 22.04.2011 18:30, schrieb Kevin Grittner: > Yves Weißig wrote: > >> Ok, but I thou

Re: [HACKERS] What Index Access Method Functions are really needed?

2011-04-23 Thread Yves Weißig
That is exactly the point, Kevin, I read the documentation and found out that "amgettuple" and "amgetbitmap" are optional. I just wondered if there is more information about this topic? Additionally, I can not find "amcostestimate" in hash.h or anywhere, or am I missing something? So "All of them"

[HACKERS] What Index Access Method Functions are really needed?

2011-04-22 Thread Yves Weißig
Hi, another question regarding indexes. Sadly I can't find enough info in the documentation. Which of the functions are needed in order for a index to work? I am developing a prototype so it would be great if not all of the functions have to be implemented. E.g. are amcostestimate or amoptions nee

Re: [HACKERS] best way to test new index?

2011-04-22 Thread Yves Weißig
Ok, but I thought more like an automated test, or a test which checks if the interface is correctly implemented. By the way, tho broaden the topic, what would be the best way to debug in pg? elog? asserts? Am 22.04.2011 01:26, schrieb Josh Berkus: > On 4/21/11 1:28 PM, Kevin Grittner wrote: >> Tha

Re: [HACKERS] best way to test new index?

2011-04-21 Thread Yves Weißig
Yes I do! Am 21.04.2011 20:56, schrieb Kevin Grittner: > Yves Weißig wrote: > >> what is the best way to test a new developed index structure? > > Are you talking about a new AM (like btree, hash, GiST, or GIN)? > > -Kevin > -- Sent via pgsql-hackers

[HACKERS] best way to test new index?

2011-04-21 Thread Yves Weißig
Hello pgsql-hackers, what is the best way to test a new developed index structure? Greets, Yves -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers