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 robertmh...@gmail.com wrote: On Sun, Feb 28, 2010 at 8:43 AM, Ivan Sergio Borgonovo m...@webthatworks.it 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

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

2010-02-28 Thread Ivan Sergio Borgonovo
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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

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

2010-02-10 Thread Ivan Sergio Borgonovo
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 mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

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

2010-02-04 Thread Ivan Sergio Borgonovo
'::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 pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

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

2010-02-04 Thread Ivan Sergio Borgonovo
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. Any good receipt in Moscow? ;) thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql

Re: [HACKERS] development setup and libdir

2010-02-01 Thread Ivan Sergio Borgonovo
On Sun, 31 Jan 2010 22:24:40 + Mark Cave-Ayland mark.cave-ayl...@siriusit.co.uk 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

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 eu...@timbira.com 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 something wrong in our

[HACKERS] development setup and libdir

2010-01-30 Thread Ivan Sergio Borgonovo
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] [1] OK I know I can parse the Makefile with sed... ;) thanks -- Ivan Sergio Borgonovo http

Re: [HACKERS] development setup and libdir

2010-01-30 Thread Ivan Sergio Borgonovo
On Sat, 30 Jan 2010 11:06:02 -0500 Tom Lane t...@sss.pgh.pa.us wrote: Ivan Sergio Borgonovo m...@webthatworks.it 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 $libdir

Re: [HACKERS] development setup and libdir

2010-01-30 Thread Ivan Sergio Borgonovo
On Sat, 30 Jan 2010 11:06:02 -0500 Tom Lane t...@sss.pgh.pa.us wrote: Ivan Sergio Borgonovo m...@webthatworks.it 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 $libdir

Re: [HACKERS] development setup and libdir

2010-01-30 Thread Ivan Sergio Borgonovo
On Sat, 30 Jan 2010 16:51:44 -0500 Andrew Dunstan and...@dunslane.net 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 definitively it would be hard

Re: [HACKERS] development setup and libdir

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

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 eu...@timbira.com 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 two command lines [1]. Consider I'm

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

2010-01-29 Thread Ivan Sergio Borgonovo
of Datum - looping over the C array - assign to each Datum element the converted C value - construct_array the Postgres array That's a pain. Any other way? macro? 2 Seems the easiest 3 ??? Is there any function in postgres that let you append elements to an ArrayType? thanks -- Ivan Sergio

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

2010-01-28 Thread Ivan Sergio Borgonovo
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@postgresql.org) To make changes to your subscription

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 kevin.gritt...@wicourts.gov wrote: Ivan Sergio Borgonovo m...@webthatworks.it 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

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 klep...@svana.org 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 to be careful

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

2010-01-27 Thread Ivan Sergio Borgonovo
in the process on my web site and if someone find them worth for a better place I'll release them with a suitable license. -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

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

2010-01-27 Thread Ivan Sergio Borgonovo
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-hackers@postgresql.org) To make changes to your

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

2010-01-27 Thread Ivan Sergio Borgonovo
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
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
On Wed, 27 Jan 2010 22:06:43 +0200 Heikki Linnakangas heikki.linnakan...@enterprisedb.com 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 save

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

2010-01-25 Thread Ivan Sergio Borgonovo
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

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

2010-01-23 Thread Ivan Sergio Borgonovo
int32 typmod, int attdim) */ /* ??? */ funcctx-tuple_desc = BlessTupleDesc(tupdesc); funcctx-attinmeta = TupleDescGetAttInMetadata(tupdesc); -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

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 gsst...@mit.edu wrote: On Sat, Jan 23, 2010 at 12:56 PM, Ivan Sergio Borgonovo m...@webthatworks.it 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 I'd use