Re: [HACKERS] dedebugging and a functions that just don't work on debian flavour

2010-03-02 Thread Ivan Sergio Borgonovo
On Sun, 28 Feb 2010 23:02:39 -0500 Robert Haas wrote: > On Sun, Feb 28, 2010 at 8:43 AM, Ivan Sergio Borgonovo > wrote: > > I've no idea what to do next other than asking if someone can > > give a look to the code and check my comprehension of what a > > tsquery sho

[HACKERS] dedebugging and a functions that just don't work on debian flavour

2010-02-28 Thread Ivan Sergio Borgonovo
and no error. I've no idea what to do next other than asking if someone can give a look to the code and check my comprehension of what a tsquery should be in memory. http://www.webthatworks.it/d1/files/ts_utilities.tar.bz2 thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it --

[HACKERS] I still didn't get how tsquery is internally

2010-02-10 Thread Ivan Sergio Borgonovo
a small problem. The op is always char = 0x08 (even on a much simpler function that just retrieve op and return it as a masked int64. It seems that char op = PG_GETARG_CHAR(1); is not really what I thought it to be. -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-hackers m

Re: [HACKERS] building tsquery directly in memory (avoid makepol)

2010-02-04 Thread Ivan Sergio Borgonovo
#x27;, '&', 'ACD' ); should be turned into pizza:A & risotto:C & risotto:D & barolo:A & barolo:C I noticed you actually loop over the tsvector in tsvectorout to allocate the memory for the string buffer and I was wondering if it is really worth for my case as well

[HACKERS] building tsquery directly in memory (avoid makepol)

2010-02-04 Thread Ivan Sergio Borgonovo
g to be preferred during a scan between 'java:1A,2B '::tsvector @@ to_tsquery('java:A | java:B'); vs. 'java:1A,2B '::tsvector @@ to_tsquery('java:AB') ? they look equivalent. Are they? thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgs

Re: [HACKERS] development setup and libdir

2010-02-01 Thread Ivan Sergio Borgonovo
On Sun, 31 Jan 2010 22:24:40 + Mark Cave-Ayland wrote: > Ivan Sergio Borgonovo wrote: > > > Of course I can write a script that can workaround this. > > It seems that the only thing missing is that pgxs 8.3 used to > > prefix .so with lib and then rename them at in

Re: [HACKERS] development setup and libdir

2010-01-31 Thread Ivan Sergio Borgonovo
On Sun, 31 Jan 2010 02:44:13 -0200 Euler Taveira de Oliveira wrote: > Ivan Sergio Borgonovo escreveu: > > I'm pretty sure that what you're pointing at is not going to work > > unless you specify a bunch of other parameters. > Ugh? Are you saying there is some

Re: [HACKERS] development setup and libdir

2010-01-30 Thread Ivan Sergio Borgonovo
On Sat, 30 Jan 2010 22:25:32 -0200 Euler Taveira de Oliveira wrote: > Ivan Sergio Borgonovo escreveu: > > That's pretty expensive. > > > Ugh? > > > I mean... I just would like my .so end up with the expected name > > somewhere else. > It's just t

Re: [HACKERS] development setup and libdir

2010-01-30 Thread Ivan Sergio Borgonovo
On Sat, 30 Jan 2010 18:32:58 -0500 Robert Haas wrote: > On Sat, Jan 30, 2010 at 5:36 PM, Ivan Sergio Borgonovo > wrote: > >> For development purposes you would be far better off building a > >> private version of postgres (with configure --prefix=/path) and > >>

Re: [HACKERS] development setup and libdir

2010-01-30 Thread Ivan Sergio Borgonovo
On Sat, 30 Jan 2010 16:51:44 -0500 Andrew Dunstan wrote: > Ivan Sergio Borgonovo wrote: > > It is becoming a more serious issue than what I thought... > > Debian install everything in > > /usr/lib/postgresql/8.3/lib/ > > -rw-r--r-- 1 root root > > so defin

Re: [HACKERS] development setup and libdir

2010-01-30 Thread Ivan Sergio Borgonovo
On Sat, 30 Jan 2010 11:06:02 -0500 Tom Lane wrote: > Ivan Sergio Borgonovo writes: > > ... I can't make install (provided it works as expected, I > > didn't try yet) since I sincerely hope that my user doesn't have > > write right on whatever is pointed by

Re: [HACKERS] development setup and libdir

2010-01-30 Thread Ivan Sergio Borgonovo
On Sat, 30 Jan 2010 11:06:02 -0500 Tom Lane wrote: > Ivan Sergio Borgonovo writes: > > ... I can't make install (provided it works as expected, I > > didn't try yet) since I sincerely hope that my user doesn't have > > write right on whatever is pointed by

[HACKERS] development setup and libdir

2010-01-30 Thread Ivan Sergio Borgonovo
l.sql - sed -e 's/\$libdir/'`pwd`'/g' uninstall_module.sql > uninstall_module.l.sql - psql < sometestcode.sql Not that bad... but if that "someunknownparam" existed it would be nicer and avoid hard coding the module name in 2 places (Makefile and bash script)[1]

[HACKERS] helpers to convert C types to postgres types (Array)

2010-01-29 Thread Ivan Sergio Borgonovo
tion in postgres that let you append elements to an ArrayType? thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] returning array in a field together with other types

2010-01-28 Thread Ivan Sergio Borgonovo
atic values to construct_array since they are "basic type" array so the size etc... should be known at compile time, inspite of having to call get_typlenbyvalalign? thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] C function accepting/returning cstring vs. text

2010-01-27 Thread Ivan Sergio Borgonovo
On Wed, 27 Jan 2010 22:06:43 +0200 Heikki Linnakangas wrote: > Ivan Sergio Borgonovo wrote: > > But then... why do we have all that logic to save the function > > context if anyway it is more convenient to process everything in > > one run? > > It's a pain to

Re: [HACKERS] C function accepting/returning cstring vs. text

2010-01-27 Thread Ivan Sergio Borgonovo
it the first time I wasn't in a condition to take advantage of it. Now it looks more useful. -- Ivan Sergio Borgonovo http://www.webthatworks.it -- 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] C function accepting/returning cstring vs. text

2010-01-27 Thread Ivan Sergio Borgonovo
ialized mode? Is there a rule of thumb to chose between one mode or the other? thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it -- 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] C function accepting/returning cstring vs. text

2010-01-27 Thread Ivan Sergio Borgonovo
; Probably, but I didn't check. Does this nearly translate to: "nothing you should care about right now and anyway just functions that won't return results to SQL"? thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-hackers mailing list (pgsql-hac

Re: [HACKERS] C function accepting/returning cstring vs. text

2010-01-27 Thread Ivan Sergio Borgonovo
t; or the like. Right now I've not enough knowledge to hope my notes get into the source code. Once I've a working piece of code I'll put the information I gathered in the process on my web site and if someone find them worth for a better place I'll release them with a su

Re: [HACKERS] C function accepting/returning cstring vs. text

2010-01-27 Thread Ivan Sergio Borgonovo
On Wed, 27 Jan 2010 14:44:02 +0100 Martijn van Oosterhout wrote: > On Wed, Jan 27, 2010 at 02:14:36PM +0100, Ivan Sergio Borgonovo > wrote: > > I haven't been able to understand the difference between function > > returning cstring and text and if there is any need

Re: [HACKERS] C function accepting/returning cstring vs. text

2010-01-27 Thread Ivan Sergio Borgonovo
On Mon, 25 Jan 2010 16:36:46 -0600 "Kevin Grittner" wrote: > Ivan Sergio Borgonovo wrote: > > The README files might be a good place to start, then browse code. Is there a book? The more I read the source and the few info about it, the more I have questions that should ha

[HACKERS] C function accepting/returning cstring vs. text

2010-01-25 Thread Ivan Sergio Borgonovo
reference and knowledge of the code base it's pretty hard even to find prototype/sample code. thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it -- 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] Re: Cstring vs. Datum values ( BuildTupleFromCStrings vs. BlessTupleDesc)

2010-01-23 Thread Ivan Sergio Borgonovo
On Sat, 23 Jan 2010 15:54:04 + Greg Stark wrote: > On Sat, Jan 23, 2010 at 12:56 PM, Ivan Sergio Borgonovo > wrote: > > And if I can... how, why and when... because I didn't find any > > clear example in the source tree that gives me a clue about when > >

[HACKERS] Cstring vs. Datum values ( BuildTupleFromCStrings vs. BlessTupleDesc)

2010-01-23 Thread Ivan Sergio Borgonovo
TEXTOID, -1, 0); /* ?? Oid oidtypeid, // where can I get a list of OID int32 typmod, int attdim) */ /* ??? */ funcctx->tuple_desc = BlessTupleDesc(tupdesc); funcctx->attinmeta = TupleDescGetAttInMetadata(tupdesc); -- Ivan Sergio Borgonovo http://ww