Re: [HACKERS] Issue on C function that reads int2[] (using "int2vector")

2015-11-30 0:39 GMT-02:00 Tom Lane: > Rodrigo Hjort writes: > > I created a custom C function with this signature: > > > CREATE FUNCTION calculate_hash(numbers int2[]) > > RETURNS int8 > > AS 'MODULE_PATHNAME', 'pg_calculate_hash' > >

[HACKERS] Help on creating C function that reads int2[] (using "int2vector")

The whole project is on GitHub: https://github.com/hjort/mega-sena/tree/master/src Best regards, -- Rodrigo Hjort www.hjort.co

[HACKERS] Issue on C function that reads int2[] (using "int2vector")

The whole project is on GitHub: https://github.com/hjort/mega-sena/tree/master/src Best regards, -- Rodrigo Hjort www.hjort.co

Re: [HACKERS] Strange behavior on to_tsquery()

//git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e3e3087d8717c26cd1c4581ba29274ac214eb816 > >regards, tom lane > I modified my code by calling *palloc0()* instead and that issue no longer appears. :D Thanks, Tom Lane! -- Rodrigo Hjort www.hjort.co

[HACKERS] Strange behavior on to_tsquery()

the same. 1) Do you have any clue on what could be happening and how to solve this issue, please? 2) Sometimes the value returned by *to_tsquery()* has a ":*" suffix. What does that mean? Thanks in advance. Best Regards, -- Rodrigo Hjort www.hjort.co

[HACKERS] DBLink's default user: postgres

()') rot-> AS (usr name, db name); usr| db --+ postgres | escola (1 registro) This way, I fear DBLink functions should become a vulnerability issue on my database. Is there any way to protect or override this setting? Or it should be done on pg_hba.conf only

[HACKERS] Deferred Constraints

Dear Hackers, Could you point me the first version PostgreSQL started to support Deferred Constraints (ie: DEFERRABLE keyword on foreign keys creation)? I guess it is earlier than 7.0, right? -- Regards, Rodrigo Hjort http://icewall.org/~hjort ---(end of broadcast

[HACKERS] Ontology on PostgreSQL - is there something?

know-how on the backend internals, how difficult is it to develop this (3 operators + 1 index type)? -- Best regards, Rodrigo Hjort http://icewall.org/~hjort CELEPAR - Cia de Informática do Paraná - Brasil http://www.pr.gov.br

Re: [HACKERS] Connection Broken with Custom Dicts for TSearch2

How about those "pg_ts*" tables, which are specific for a database? Will they serve to the whole cluster?2006/6/7, Teodor Sigaev <[EMAIL PROTECTED] >:OpenFTS never, but tsearch2 is possible. But it requires enough work to do, so I    have doubt that it will be done in 8.2...-- Rodrigo Hjorthttp://i

Re: [HACKERS] Connection Broken with Custom Dicts for TSearch2

Oleg, Actually I got PG 8.1.4 compiled from source on a Debian GNU/Linux 2.6.16-k7-2. My locale is pt_BR, but I configured TSearch2 to use rules from the 'simple'. Then I just followed the instructions from the link. The fact is that it only works at the first time. Regards, Rodrigo

[HACKERS] Connection Broken with Custom Dicts for TSearch2

Sorry, but I thought it that was the most appropriate list for the issue.I was following these instructions:http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/custom-dict.html And what happens is that the function works just once. Perhaps a malloc/free issue?$ psql fuzzyfuzzy=# select to_t

Re: [HACKERS] LIKE, leading percent, bind parameters and indexes

* from table where field like 'THE NAME%'; -- index scanselect * from table where field like '%THE NAME%'; -- seq scanselect * from table where field like :bind_param; -- seq scan (always)Regards, Rodrigo Hjort http://icewall.org/~hjort

Re: [HACKERS] LIKE, leading percent, bind parameters and indexes

%' on static text or bound paremeter, makes the planner always do a sequential scan. Is that the scenario?-- Rodrigo Hjorthttp://icewall.org/~hjort 2006/5/23, Tom Lane <[EMAIL PROTECTED]>: "Rodrigo Hjort" <[EMAIL PROTECTED]> writes:> What happens is that only the "004

[HACKERS] LIKE, leading percent, bind parameters and indexes

PG-Hackers,I got the following picture:detran=# \d sa_dut.tb_usuario    Table "sa_dut.tb_usuario" Column  |    Type | Modifiers-+-+---  numprocesso | bigint   

Re: [HACKERS] Issue on Varchar Ordering

Thanks all. I'm gonna try other locales and encodings.2006/3/29, Tom Lane <[EMAIL PROTECTED]>: "Rodrigo Hjort" <[EMAIL PROTECTED]> writes:> The fact is that I can't raise PostgreSQL with C encoding, as special> characters are used on most tables. You're c

Re: [HACKERS] Issue on Varchar Ordering

Yeah, I think there's a problem on Linux locales.Using the C locale, it works as expected:[EMAIL PROTECTED]:~$ export LC_ALL=C && cat test.txt | sortGABRIEL ALCIDES KLIM PERONDIGABRIEL ALEXANDRE DA SILVA MANICA GABRIELA HELEDA DE SOUZAGABRIELA JACOBY NOSGABRIELA LETICIA BATISTA NUNESBut when using

[HACKERS] Issue on Varchar Ordering

Pg-Hackers,I'm having the following issue:create table aluno (id serial, nome varchar(60));rodrigo=# select * from aluno order by nome offset 35 limit 5; id |   nome+---  36 | GABRIELA HELEDA DE SOUZA 37 | GABRIELA JACOBY NOS 38 | GABRIEL ALCIDES KLIM

Re: [HACKERS] Restoring a Full Cluster on a Different Architecture (32 x 64)

Well, actually we're ain't gonna do this procedure regularly, but just in case of failure - if it ever happens.For the moment, I did the dump/restore and it worked, but took almost 1 hour, due to tsearch2 indexes on a table. Yeah, I thought 64-bit data could be stored on other files than pg_control

[HACKERS] Restoring a Full Cluster on a Different Architecture (32 x 64)

Dear PostgreSQL Hackers,We got a PG 8.1 on a Debian 64 bits, which does a full backup (PITR) daily.Then we installed a Debian 32 bits (actually, it's on VMWare) and wanted to restore the previous PG cluster on it. As there are a lot of indexes, specially GiST, "pg_dump" and "pg_restore" are not via

[HACKERS] Server Programming in C: palloc() and pfree()

I'm having some problems when using "pfree()" on functions in C.Calling it on "psql" gives the exception below on both versions of function "insert()" [1,2] if "pfree()" is enabled: server closed the connection unexpectedly    This probably means the server terminated abnormally    before o