Re: [ADMIN] [GENERAL] secure connections

2008-09-08 Thread Alejandro D. Burne
2008/9/7 Filip Rembiałkowski <[EMAIL PROTECTED]>: > 2008/9/7 c k <[EMAIL PROTECTED]>: >> Hello, >> I have a question regarding secure connections between pg clients and pg >> server. As per manual for 8.3 we can use openssl for this purpose. does odbc >> driver supports it and how? Is there any oth

Re: [GENERAL] Users functions library

2008-07-13 Thread Alejandro D. Burne
) and to categorize them. I can help to develop it, buy my natural language is spanish and I'm uncomfortable writing in english. Greetings, Alejandro > 2008/7/13 Alejandro D. Burne <[EMAIL PROTECTED]>: >> 2008/7/12 Alejandro D. Burne <[EMAIL PROTECTED]>: >>> Hi,

Re: [GENERAL] Users functions library

2008-07-12 Thread Alejandro D. Burne
2008/7/12 Alejandro D. Burne <[EMAIL PROTECTED]>: > Hi, I need to write a function that gives me a password string, no > just a numbers-characters string; something like people wrote in php, > its based on determined syllables and numbers. > I think it be useful to other peopl

[GENERAL] Users functions library

2008-07-12 Thread Alejandro D. Burne
Hi, I need to write a function that gives me a password string, no just a numbers-characters string; something like people wrote in php, its based on determined syllables and numbers. I think it be useful to other people, is there a site where one can post it and share with other postgres users? A

Re: [GENERAL] Btree indexes, large numbers and <= comparisons

2007-03-29 Thread Alejandro D. Burne
2007/3/29, Toke Høiland-Jørgensen <[EMAIL PROTECTED]>: I have a table with ~5 million rows containing ranges of large (8-digit) numbers. The table has an int4 field for the range start and the range end, and a field which is null if that particular range is expired, and has a value otherwise. I

Re: [GENERAL] [1/2 OFF] Varlena.com inaccessible from .br (Blocked?)

2007-01-18 Thread Alejandro D. Burne
2007/1/18, Alvaro Herrera <[EMAIL PROTECTED]>: Ian Harding wrote: > Brazil has been trying to get its ISPs to block access to a certain > video. I wonder if too wide a net was cast in that effort. > > http://www.slate.com/id/2157399/?nav=navoa FWIW, I'm also blocked out of varlena.com and I'm

Re: [GENERAL] [pgsql-es-ayuda] identificar usuario con registro en una tabla

2006-10-24 Thread Alejandro D. Burne
2006/10/24, Milton Galo Patricio <[EMAIL PROTECTED]>: [EMAIL PROTECTED]:He buscado en la documentación (de forma parcial) y no he podidoencontrar alguna sentencia o comando que me pueda retornar el nombredel usuario que realizo un insert en una determinada tabla (pero de forma historica), me ex

Re: [GENERAL] Visual FoxPro 9 ODBC errors

2006-01-03 Thread Alejandro D. Burne
2006/1/3, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: > 2006/1/3, [EMAIL PROTECTED] < [EMAIL PROTECTED]>: > > >"Alejandro D. Burne" <[EMAIL PROTECTED]> wrote on > 01/01/2006 04:37:10 PM: > > > > 2005/12/30, [EMAIL PROTECTED] < [EMAIL PROT

Re: [GENERAL] Visual FoxPro 9 ODBC errors

2006-01-03 Thread Alejandro D. Burne
2006/1/3, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: >"Alejandro D. Burne" <[EMAIL PROTECTED]> wrote on 01/01/2006 04:37:10 PM: > 2005/12/30, [EMAIL PROTECTED] < [EMAIL PROTECTED]>: > > I am writing an application in Visual Foxpro 9  (running on Windows >

[GENERAL] Release 8.1.1 for Fedora X 64bits

2005-12-14 Thread Alejandro D. Burne
Hi, I'll be watching on ftps without success. There is a release date for 8.1.1?

Re: [GENERAL] pgsql-odbc list problem

2005-08-04 Thread Alejandro D. Burne
pgsql-odbc/2005-07/index.php for my mails (I wrote them on 22/07/2005) without news. Another example, today I wrote 2 mails one arrives the other not (yet?). Thanks, Alejandro. 2005/8/4, Richard Huxton : > Alejandro D. Burne wrote: > > Hi, I'll be posting a lot of messages to [EMAI

[GENERAL] pgsql-odbc list problem

2005-08-04 Thread Alejandro D. Burne
Hi, I'll be posting a lot of messages to [EMAIL PROTECTED] without sucess. I try to unsuscribe/suscribe with the same results. I'll be using this account. Any clues? There is any restriction with gmail accounts? Thanks. Alejandro ---(end of broadcast)---

Re: [GENERAL] Trigger problem

2005-07-22 Thread Alejandro D. Burne
Well, after hours to debug this issue, I found the problem. There is a misspelled word, thanks and sorry for waste your time. Alejandro 2005/7/21, Alejandro D. Burne <[EMAIL PROTECTED]>: > Thanks Michael for your reply, I've attached the db structure and some > data to add, th

[GENERAL] Trigger problem

2005-07-20 Thread Alejandro D. Burne
Hi, I'll be trying to write a my first trigger which fire when an user makes an insert into a table; this insert records in others tables. But when I try to insert a record in trigger's table generate an error: - Syntax error near "into" in char 9. - This is the trigger. CREATE OR REPLACE FUNC

Re: [GENERAL] wrong sort order

2005-07-04 Thread Alejandro D. Burne
ind a locale that include spaces in sort order. Thanks!!!, Alejandro. 2005/7/2, Martijn van Oosterhout : > On Sat, Jul 02, 2005 at 11:28:12AM -0300, Alejandro D. Burne wrote: > > Hi, maybe there is a problem with sorting latin10? Seems to be like > > spaces don't exists just sorti

Re: [GENERAL] wrong sort order

2005-07-02 Thread Alejandro D. Burne
Maybe I'm wrong, but this "feature" I don't see it in any other rdbms ;-) 2005/7/2, Tom Lane <[EMAIL PROTECTED]>: > "Alejandro D. Burne" <[EMAIL PROTECTED]> writes: > > Hi, maybe there is a problem with sorting latin10? Seems to be like >

[GENERAL] wrong sort order

2005-07-02 Thread Alejandro D. Burne
Hi, maybe there is a problem with sorting latin10? Seems to be like spaces don't exists just sorting. Version() ->PostgreSQL 8.0.2 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3) SELECT nombreasociado, codigoasociado FROM Asociados WHERE nombreasociado LIK

[GENERAL] Binary or compiled version?

2005-04-20 Thread Alejandro D. Burne
Hi, I'm installing 8.0.2 on Mandrake and I saw binarys rpms only for RH. Can someone tell me if is better install a rpm version or compile from source in this case? Thanks, Alejandro ---(end of broadcast)--- TIP 6: Have you searched our list archive

[GENERAL] If statements on select

2005-04-15 Thread Alejandro D. Burne
Hi, I'm translating an app made with visual foxpro and mysql as rdbms to postgres. I've got many querys with this sintax: select code1, sum(if(cond1, price,0)), sum(if(cond2,price,0)) from ... may be it's not sql compliant but very usefull there is a way to do this work on postgres? I can't find

Re: [GENERAL] Temporary tables privileges

2005-03-14 Thread Alejandro D. Burne
gt; Alejandro D. Burne wrote: > > Hi, I'm new at pg. > > I'll be using tmp tables in others rdbms. An user can create your own > > tmp tables (grant temporary tables) but can't drop it (I don't want to > > grant drop privileges). > > Other way it

[GENERAL] Temporary tables privileges

2005-03-09 Thread Alejandro D. Burne
Hi, I'm new at pg. I'll be using tmp tables in others rdbms. An user can create your own tmp tables (grant temporary tables) but can't drop it (I don't want to grant drop privileges). Other way it's using on commit; but I can't make this work. Example: CREATE TEMPORARY TABLE tmp ON COMMIT DROP AS

Re: [GENERAL] Fwd: Problem installing Postgresql on MDK10.0

2004-11-17 Thread Alejandro D. Burne
Thanks Ben, libncures5 was installed but libncurses5-devel don't. Problem solved! I must find zlib deps now ;+) On Wed, 17 Nov 2004 09:20:00 +, Ben Trewern <[EMAIL PROTECTED]> wrote: > I think you have to install ncurses. On Mdk 10 its libncurses5-devel I > think. > > Try that and see what

[GENERAL] Fwd: Problem installing Postgresql on MDK10.0

2004-11-16 Thread Alejandro D. Burne
Sorry, but no reply on [EMAIL PROTECTED] -- Forwarded message -- From: Alejandro D. Burne <[EMAIL PROTECTED]> Date: Mon, 15 Nov 2004 15:00:58 +0100 Subject: Problem installing Postgresql on MDK10.0 To: [EMAIL PROTECTED] I'll be trying to install postgres 8.0b1/b4;