[GENERAL] ODBC and Kerberos authtentication

2017-05-25 Thread Jorge García
Hello everyone, I'm new to the list, greetings from MX! I'm currently working on a small project with PostgreSQL 9.6. This project involves Kerberos for authentication, my question is: The ODBC driver support this? What are the flags/options you have to use on the odbc.ini file? I cant find t

Re: [GENERAL] Libpq Asynchronous Command Processing

2010-05-31 Thread Alonso García , Bruno Elier
>So PQexec works fine for you on both 7.4 and 8.3, producing a quick >result no matter which server you run it against? Yes. If I use PQexec, both 7.4 and 8.3 produce a quick result but I if I use asynchronous command processing 8.3 produce a slow result whereas 7.4 works fine. >Consider using

Re: [GENERAL] Libpq Asynchronous Command Processing

2010-05-31 Thread Alonso García , Bruno Elier
>> With that analysis, I'd be betting against it being a client problem. >> (If you wanted, you might confirm that by pointing an old client at >> the new server.) >> >> I'd look into how the data was loaded into the new server and how >> the database is configured: number of buffers, indexes, and

[GENERAL] Libpq Asynchronous Command Processing

2010-05-31 Thread Alonso García , Bruno Elier
Hello, I am migrating a client/server application from Debian Sarge to Debian 5.0 and I am finding problems with the client application. The facts are the following: ->The client application is an interface to a Postgresql DB so it uses libpq. ->The client application compiles properly in both Deb

Re: [GENERAL] OID in $_TD->{new}/$_TD->{old}

2009-07-29 Thread Antonio José García Lagar
tributes. Not sure if this would be worth changing. > > regards, tom lane And is there any other way to access to the row OID from the trigger? Thanks -- Antonio José García Lagar Compact Software International SA http://www.c17.net -- Sent via pgsql-general mailing lis

[GENERAL] OID in $_TD->{new}/$_TD->{old}

2009-07-29 Thread Antonio José García Lagar
It is posible to access to the row OID of the row which fired a pl/perl trigger? If I try to access to $_TD->{new}{oid} or $_TD->{old}{oid} I have no result. Thanks in advance! -- Antonio José García Lagar Compact Software International SA http://www.c17.net -- Sent via pgsql-g

[GENERAL] Problema al cargar polígonos

2008-01-08 Thread Pedro Briones García
gracias de antemano. Un saludo. Pedro Briones García TRAGSATEC Área de SIG y Consultoría Departamento de Cartografía C/ Julián Camarillo 6, Edificio 6B - 2ª Pl. Sector B 28037 Madrid mailto:[EMAIL PROTECTED] Tfno.: +34 91 322 6489/+34 679 09 0001

[GENERAL] Can I catch sentences in SQL using triggers?

2005-06-01 Thread Manuel García
Hello Everybody, somebody knows if its possible to catch one sentences in full SQL using the triggers, or maybe somebody have any idea about to how do it? I am using postgreSQL 7.3 on fedora core 1   Thanks in advancedManuel

[GENERAL] Postgresql and Delphi for windows

2005-02-21 Thread García
!Hi list¡: Does anybody have information about the use of delphi and Postgresql? I have installed the version 8.0 of Postgresql and Delphi 7 entreprise. And, do you have information about MySQL an Postgresql (a comparision)?. THANK YOU. __ Do Yo

[GENERAL] How to read sql commans from file resolved

2005-01-27 Thread García
Hi list: Thank you all of you who friendly help me. The bug was mine. Im working in windows and the editor appended a txt extension so that was the problem. Instead of CreateTableWeather.sql, i've got CreateTableWeather.sql.txt. But by the way, i have a question (at some extent)related: By defaul

[GENERAL] how to read do the psq \i command

2005-01-27 Thread García
Hi list: Recently I installed postgresql 8.0, marvellous; and I've been studying the tutorial. I got stuck in chapter 2 "The SQL languaje". There, it says that in order to read sql commands stored in a file you can type: mydb=> \i basics.sql So I create a file named CreateTable_weather.sql but

[GENERAL] Full text search question (select...match...against).

2001-02-01 Thread Alberto Otero García
ments vector space model | 0 | +--+---++ Does anyone know how to do this in PostgreSQL? Thank you in advance for your answer. -- Alberto Otero García e-mail: [EMAIL PROTECTED] Cometa Technologies, S.L. URL: http://www.cometatech.com

[GENERAL] mysqldump export and pg_dump import

2000-11-01 Thread Alberto Otero García
to the mailing list. Thank you very much in advance for your help. -- Alberto Otero García e-mail: [EMAIL PROTECTED] Cometa Technologies, S.L. URL: http://www.cometatech.com