Re: FW: [GENERAL] GRANT question

2005-11-27 Thread Freemail
Dear Michael, certainly I tried and seems to be ok. Maybe I fogot to copy it into my letter? -- csaba -Original Message- From: Michael Fuhr [mailto:[EMAIL PROTECTED] Sent: Sunday, November 27, 2005 4:50 PM To: Együd Csaba (Freemail) Cc: 'Tom Lane'; pgsql-general@postgresql.o

Re: FW: [GENERAL] GRANT question

2005-11-26 Thread Freemail
Regards, -- Csaba Együd -Original Message- From: Michael Fuhr [mailto:[EMAIL PROTECTED] Sent: Saturday, November 26, 2005 10:16 PM To: Együd Csaba (Freemail) Cc: pgsql-general@postgresql.org Subject: Re: FW: [GENERAL] GRANT question On Sat, Nov 26, 2005 at 09:37:00PM +0100, Egyd Csaba (Freemail) w

FW: [GENERAL] GRANT question

2005-11-26 Thread Freemail
-Original Message- From: Együd Csaba (Freemail) [mailto:[EMAIL PROTECTED] Sent: Saturday, November 26, 2005 9:36 PM To: 'Michael Fuhr' Subject: RE: [GENERAL] GRANT question OK, here you are. --- moson.gdb=> SELECT oid::regprocedure FROM pg_proc

Re: [GENERAL] Syntax Error in COPY - worked around

2005-11-26 Thread Freemail
Hi, it seems to be some kind of windows/pgadmin error (?), because running the dump on the linux server it was ok. I was able to work around the problem, but... Thank you Jaime. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jaime Casanova Sent: Frida

Re: [GENERAL] Making the DB secure

2005-06-22 Thread Freemail
Hi All, I am really sorry for upsetting the list. You are absolutelly right, I do have applied a network specialist, who stated that the VPN is a must, and we started to configure and test the server together (using OpenVPN). Actually this application is going to operate in a test phase for month

Re: [GENERAL] Best practices: Handling Daylight-saving time

2005-03-17 Thread Együd Csaba (Freemail)
After a few days of working on the problem I can state that - IMHO - this is the best way: Using UTC (or any other timezone) with NO DST (this is the most important) is the only reliable way to store continous data. On the client we can convert the server time easily to local time. Even if the s

Re: [GENERAL] PostgreSQL 8.0.0 Released

2005-01-19 Thread Együd Csaba (Freemail)
Great! Thank you guys. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc G. Fournier Sent: Wednesday, January 19, 2005 2:03 PM To: pgsql-announce@postgresql.org Cc: pgsql-general@postgresql.org Subject: [GENERAL] PostgreSQL 8.0.0 Released After more t

Re: [GENERAL] Any function for calculating inersect of intervals?

2005-01-17 Thread Együd Csaba (Freemail)
Thak you Alban, Tom's solution (OVERLAPS) is the best for me. bye, -- Csaba -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alban Hertroys Sent: Monday, January 17, 2005 5:49 PM To: Együd Csaba Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Any fu

Re: [GENERAL] Very slow stored proc

2004-12-23 Thread Együd Csaba (Freemail)
-Original Message- From: Alvaro Herrera [mailto:[EMAIL PROTECTED] Sent: Thursday, December 23, 2004 11:12 PM To: Együd Csaba (Freemail) Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Very slow stored proc On Thu, Dec 23, 2004 at 09:48:56PM +0100, Együd Csaba (Freemail) wrote: Hi

Re: [GENERAL] Very slow stored proc

2004-12-23 Thread Együd Csaba (Freemail)
Dear Alvarao, would you please so kind explaining me your opinion in details. thanks, -- Csaba -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alvaro Herrera Sent: Thursday, December 23, 2004 3:58 PM To: Együd Csaba (Freemail) Cc: pgsql-general

Re: [GENERAL] Very slow stored proc

2004-12-23 Thread Együd Csaba (Freemail)
Hi, I've got it. Not the date handling is slow but the string handling. Eliminating the huge string buffer and running all the inserts row by row, the overall running time is 12 sec. So as a conclusion never use large strings in plpgsql functions. Bye, -- Csaba -Original Message- From:

Re: [GENERAL] Strange Index behavior

2004-12-22 Thread Együd Csaba (Freemail)
r way... -- Csaba -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 6:34 PM To: Együd Csaba (Freemail) Cc: 'Együd Csaba'; pgsql-general@postgresql.org Subject: Re: [GENERAL] Strange Index behavior =?iso-8859-2?Q?Egy=FCd_Csaba

Re: [GENERAL] Strange Index behavior

2004-12-22 Thread Együd Csaba (Freemail)
Hi Tom, may be it was misunderstandable... I meant that there is no rows with tstamp='2004.12.22 00:00'. Certainly there are rows matching the range (00:00 - 23:59); from 13:00 to 23:00, but not before 13:00. The only difference betwen the two queries is this value. If the begining of the rang

Re: [GENERAL] PG8 final when

2004-12-20 Thread Együd Csaba (Freemail)
OK, now I am well informed. Thank you. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christopher Browne Sent: Monday, December 20, 2004 3:06 PM To: [EMAIL PROTECTED] Subject: Re: [GENERAL] PG8 final when The world rejoiced as [EMAIL PROTECTED] (Együd

Re: [GENERAL] PG8 final when

2004-12-20 Thread Együd Csaba (Freemail)
You must be right and I must remeber wrong. Sorry. Despite of this I'm very happy with the new estimated deadline. :) Bye, -- Csaba -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Russ Brown Sent: Monday, December 20, 2004 2:33 PM To: [EMAIL PROTECTED]

Re: [GENERAL] Insufficient memory for this operation.

2004-12-14 Thread Együd Csaba (Freemail)
Sent: Tuesday, December 14, 2004 6:25 PM To: [EMAIL PROTECTED] Subject: Re: [GENERAL] Insufficient memory for this operation. Együd Csaba (Freemail) <[EMAIL PROTECTED]> writes: > shared_buffers = 2 # min 16, at least max_connections*2, 8KB each You can lower this to 10,000

Re: [GENERAL] Insufficient memory for this operation.

2004-12-13 Thread Együd Csaba (Freemail)
Hi, it wasn't that! :) That brrr.,*.:$;,^%^%roaaggh BDE :{ on the client side... that was the problem. There were stuck in connections in the BDE stack. After closing all BDE client, the problem went away. Sorry for disturbing ... I discover again and again that Postgres is really GOOD. If you

Re: [GENERAL] Sheduler in Postgres

2004-12-10 Thread Együd Csaba (Freemail)
OK, thank you. Yes we have a more native tool - the "at" service on NT/2K. I wanted to boundle it into the application because I don't like to place parts of the application outside the application. I wrote a scheduler service sepcialy for the applications tasks. It works fine, but I thought this

Re: [GENERAL] Error restoring bytea from dump

2004-10-27 Thread Együd Csaba (Freemail)
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Fuhr Sent: Tuesday, October 26, 2004 10:05 PM To: Egy?d Csaba (Freemail) Cc: '[EMAIL PROTECTED]' Subject: Re: [GENERAL] Error restoring bytea from dump On Tue, Oct 26, 2004 at 08:51:31PM +0200, Együd Csaba wrot

Re: [GENERAL] Error restoring bytea from dump

2004-10-26 Thread Együd Csaba (Freemail)
nes). Bye, -- Csaba Együd -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Fuhr Sent: Tuesday, October 26, 2004 10:05 PM To: Egy?d Csaba (Freemail) Cc: '[EMAIL PROTECTED]' Subject: Re: [GENERAL] Error restoring bytea from dump On Tue, Oct 26

Re: [GENERAL] Error restoring bytea from dump

2004-10-26 Thread Együd Csaba (Freemail)
Hi there, isn't there any idea? :((( -- Csaba Együd -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Együd Csaba Sent: Monday, October 25, 2004 10:44 PM To: '[EMAIL PROTECTED]' Subject: [GENERAL] Error restoring bytea from dump Hi, the restoration of a

Re: [GENERAL] Modifying users password in pg_shadow from php

2004-09-25 Thread Együd Csaba (Freemail)
ohh thanks. what a stupid i am. :))) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Fuhr Sent: Saturday, September 25, 2004 5:56 PM To: Egy?d Csaba Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] Modifying users password in pg_shadow from