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
Hi All,
I'd like to ask your opininon about how to handle DST on an 7/24 system.
Where should it be handled: on the server side or on the client side? And
how could I (at all could I???) make it transparent?
Or we must bow to the fact that twice a year there are two unusable hours?
If it cannot
Hi Michael,
at the first glance it seems to be perfect. In addition it works even for
arrays. Wow! :)
Thank you very much,
-- Csaba
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 10, 2005 8:32 AM
To: Egyd Csaba
Cc: pgsql-general@postgresql.org
Hi,
I use pg8 and ZeosLib 6.5.1. Zeos can't read fields type of array and bit,
so I need to convert these fields to text on the server side.
In case of arrays I can use array_to_string(), but I couldn't find any
functions to convert bit(*) to string (in a format like this: e.g. '10011').
Could
Hi,
how can I determin the number of elements of an array? I saw function
array_dims() which returns a string value representing the dimensions of the
array. Is there a function which returns only the number of elements as an
integer.
-- Csaba
--
No virus found in this outgoing message.
Message-
From: Sven Willenberger [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005 4:27 PM
To: pgsql-general@postgresql.org
Cc: Egyd Csaba
Subject: Re: [GENERAL] Howto determin the number of elemnts of an array
Egyd Csaba wrote:
Hi,
how can I determin the number of elements of an array? I
: Egyd Csaba
Subject: Re: [GENERAL] Howto determin the number of elemnts of an
array
Egyd Csaba wrote:
Hi,
how can I determin the number of elements of an array? I saw function
array_dims() which returns a string value representing the dimensions
of the array. Is there a function which
-
From: PFC [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005 8:48 PM
To: Egyd Csaba; 'Sven Willenberger'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Howto determin the number of elemnts of an array
contrib/intarray
On Mon, 31 Jan 2005 20:00:06 +0100, Egyd Csaba [EMAIL
Hi All,
I'd like to ask some help on finding out which is the best way to
automatically give permissions for users to access database objects.
I try to plan a system where there are users who are sorted into groups
(mirror of the orgaization). The groups should have permissions for
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
Hi,
wondering if exists any functions which aim to calculate intersect of two
intervals.
E.g. I have four dates (D1, D2, D3, D4) and I want to know if (D1,D2)
intersects (D3,D4) or not.
I konw that it can be done by comparing the dates (=,=), but I'm wonder if
I can do it simpler and shorter.
Thank you Tom.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Monday, January 17, 2005 5:37 PM
To: Egyd Csaba
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Any function for calculating inersect of intervals?
=?iso-8859-2?Q?Egy=FCd_Csaba?= [EMAIL PROTECTED
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: Egyd Csaba
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Any
Hi,
I need some information regarding pgsqlODBC driver on Windows2000. We use an
application which inserts records pallely into an SQL database via ODBC.
It estableshes 16 pallel connections and continously inserts data. The
software works well on a test environment with MS Access and MS ODBC
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Egyd Csaba
Sent: Thursday, December 23, 2004 8:01 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Very slow stored proc
Hi,
I have a stored proc which is for filling 2 tables with empty rows in every
minutes. If the server has been
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: Egyd Csaba (Freemail)
Cc: pgsql-general
-Original Message-
From: Alvaro Herrera [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 23, 2004 11:12 PM
To: Egyd Csaba (Freemail)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Very slow stored proc
On Thu, Dec 23, 2004 at 09:48:56PM +0100, Egyd Csaba (Freemail) wrote:
Hi,
Dear
Hi,
Is it a normal behavior that if I give a where clause with an existent index
key, then postgres uses the index, but if I give it a non existent value
than it refuses to use the index.
An example to make it more clear:
CREATE TABLE measured_1
(
tstamp timestamp(0) NOT NULL,
meterid int4
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Wednesday, December 22, 2004 5:47 PM
To: Egyd Csaba
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Strange Index behavior
=?iso-8859-2?Q?Egy=FCd_Csaba?= [EMAIL PROTECTED] writes:
# explain analyze select
...
-- Csaba
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 22, 2004 6:34 PM
To: Egyd Csaba (Freemail)
Cc: 'Egyd Csaba'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Strange Index behavior
=?iso-8859-2?Q?Egy=FCd_Csaba_=28Freemail=29?= [EMAIL
) AND (tstamp = '2004-12-22 23:59:00'::timestamp without time zone))
Total runtime: 200.000 ms
Tom and Martijn,
many thanks.
-- Csaba
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 22, 2004 7:01 PM
To: Egyd Csaba (Freemail)
Cc: 'Egyd Csaba'; pgsql
Hi,
I have a stored proc which is for filling 2 tables with empty rows in every
minutes. If the server has been stopped for more then 3 hours the insertion
takes too much.
I switched off the insert execution, and debugged the proc and realized that
the loop increasing the timestamp takes so long.
Pinto [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 19, 2004 3:24 PM
To: Egyd Csaba; [EMAIL PROTECTED]
Subject: Re: [GENERAL] PG8 final when
--- Egyd Csaba [EMAIL PROTECTED] escreveu:
Dear Developers,
when do you plan to announce the final version of 8.0.0? As far as I
can remember
]
Subject: Re: [GENERAL] PG8 final when
On Mon, 20 Dec 2004 14:13:40 +0100, Egyd Csaba [EMAIL PROTECTED] wrote:
Hi,
as far as I can remember I somewhere read an article - maybe somwhere
on a dbforum or the postgresql.org - which stated that after the RC1
the final version is required
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] (Egyd
Dear Developers,
when do you plan to announce the final version of 8.0.0? As far as I can
remember it was promised by 15. dec.
No hurrying, just would like to know. I should install it on the site and
thougt I wait for the final version.
many thaks,
-- Csaba
---
Outgoing mail is certified Virus
Hi,
one more question: how can I set up vaccum handling in postgres to make it
less agressive? I'm faceing a problem where a batch process (inserting 184
records at once which takes 1 second in normal cases) stops because of a
dead lock. This occures (seemingly) only when a vacuum analyze is
(WinXP, PG8b5, 1GB, 3,2GHz)
Hi,
I regulary get the above error message when I run my applications in
parallel. There are minimum of 5 applications which have to access the
server in parallel, but in the production environment this number will about
30-50 (with the additional clients). Each of
: Tuesday, December 14, 2004 6:25 PM
To: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Insufficient memory for this operation.
Egyd Csaba (Freemail) [EMAIL PROTECTED] writes:
shared_buffers = 2 # min 16, at least max_connections*2, 8KB
each
You can lower this to 10,000 or even lower
. If you have a
problem, you can be sure, that the problem is somewhere else ... Should
avoid using BDE?... Maybe.
Bye,
-- Csaba
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Egyd Csaba
Sent: Tuesday, December 14, 2004 9:50 AM
To: [EMAIL PROTECTED]
Subject
Hi,
I should schedule the execution of several stored procedures. Now I use an
NT service for this, but as far as I know e.g. the Oracle has such a thing.
It would be great if I could fire procedures on a timer basis.
Is there a better solution for this than mine?
Many thanks,
-- Csaba
---
as [EMAIL PROTECTED] (Egyd Csaba) wrote:
Hi, I should schedule the execution of several stored procedures. Now
I use an NT service for this, but as far as I know e.g. the Oracle has
such a thing. It would be great if I could fire procedures on a timer
basis.
Is there a better solution
: Friday, December 10, 2004 11:29 PM
To: Egyd Csaba
Cc: '[EMAIL PROTECTED]'
Subject: Re: [GENERAL] Sheduler in Postgres
cron works pretty well in unix. Scheduled tasks on windows have, in my
experience, been on the flakey side.
On Tue, 7 Dec 2004, [iso-8859-2] Egyd Csaba wrote:
Hi,
I should
Hi,
is it possibile to use an autovacuum feature on the win32 platform?
Or should I write a service application (or use the at service) to run
vacuumdb regularly?
thank you,
-- Csaba Egyd
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Hi,
Before anything I'm very sorry for sending that RTFM style question about
pg_autovacuum. I found it, but I couldn't try it out...
I faced a problem starting the postgres service.
After installation everything had gone well until I started
pg_autovacuum.exe. I do not think that something is
, Egyd Csaba wrote:
the restoration of a dump stops at the line above.
What line above? Are you referring to Error restoring bytea in the
subject header? Is that the *exact* error message?
The dump was created with pgsql 7.3.2 and I need to pump it into a
7.4.3 one. Should anybody tell me
-
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, Egyd Csaba wrote
Hi there,
isn't there any idea? :(((
-- Csaba Egyd
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Egyd Csaba
Sent: Monday, October 25, 2004 10:44 PM
To: '[EMAIL PROTECTED]'
Subject: [GENERAL] Error restoring bytea from dump
Hi,
the restoration
Hi,
the restoration of a dump stops at the line above. The dump was created with
pgsql 7.3.2 and I need to pump it into a 7.4.3 one. Should anybody tell me
what the problem can be and how I can solve it.
(There are double apostophes [''] many times in the string - is it normal???
Besides of the
Hi All,
I'm wonder if there is any possibility to modify a users password by
updating the pg_shadow table.
I'd like to ensure that when the user modifies his/her http password
(htpasswd) than his database password also changes. It is important to have
the same password for both services. I plan
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
Hi,
Generally you want '=' conditions on the leftmost index keys; any
inequality or range constraint should be on the rightmost
keys. You can see this by thinking about the range of index entries that
the scan will have to pass over.
I see. Just like in your earlier example, where you
Hi Tom,
Good, but you're not there yet --- the Sort step shouldn't be there at
all. You've still got some inconsistency between the ORDER BY and the
index. Check my example again.
yes yes I missed that, sorry. Now don't mention the performance because I
couldn' see anything but the result.
The major time sink is clearly here:
- Index Scan using t_stockchanges_fullindex on
t_stockchanges
(cost=0.00..28.74 rows=7 width=46)
(actual time=0.14..9.03 rows=6 loops=1)
Index Cond: ((date = '2004.06.28'::bpchar)
AND (stockid = 1)
AND
Hi Tom,
I did the modifications you suggested on the t_stockchanges_fullindex and
the result tells everthing:
-
explain analyze select date,time from t_stockchanges where stockid='1' and
productid='234' and date='2004.06.29' and changeid=1 order by stockid,
productid, changeid, date, time
the trigger does its task. Thank you
very much.
Best regards,
-- Csaba Egyd
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Stephan Szabo
Sent: 2004. jnius 26. 22:32
To: Egyd Csaba
Cc: [EMAIL PROTECTED] (E-mail)
Subject: Re: [GENERAL] Trigger isn't
] (E-mail)'
Subject: Re: [GENERAL] pg_dump, bytea, dump order questions
Egyd Csaba wrote:
Hi,
answering partially my questions the first problem is
actualy solved. My
text editor inserted a linebreak into the middle of the row
at position
16384. :) Should change my editor
cygwin/7.3.4
The doc contains the option but doesn't work - at least for me.
--Csaba
-Original Message-
From: Karel Zak [mailto:[EMAIL PROTECTED]
Sent: 2004. mjus 7. 13:48
To: Egyd Csaba
Cc: '[EMAIL PROTECTED] (E-mail)'
Subject: Re: [GENERAL] Removing OIDs without recreate
. mjus 7. 14:06
To: Egyd Csaba
Cc: '[EMAIL PROTECTED] (E-mail)'
Subject: Re: [GENERAL] Removing OIDs without recreate
On Fri, May 07, 2004 at 01:59:39PM +0200, Egyd Csaba wrote:
cygwin/7.3.4
The doc contains the option but doesn't work - at least for me.
http://www.postgresql.org/docs/7.3
Hi All,
I use PG 7.3.2 an 7.4.1 on RH 7.1.
I'd like to store small (~ 100x100 px jpeg, or gif) images in a field in
binary format.
I tried to understand the documentation of the large objects but I'm afraid
I coluldn't.
I found some functions to import and export binary files into the db, but
Hi All,
I'm wonder if there is any possibility to kick out automatically stuck in
queries after say 10 minutes or so?
I mean some kind of queries which calls eg. buggy functions with dead loops
or something similar.
Time to time I face such kind of problems which are solved automatically
after
Ahh! Thanks Kris! That works!
-- Csaba
-Original Message-
From: Kris Jurka [mailto:[EMAIL PROTECTED]
Sent: 2004. februr 2. 10:14
To: Egyd Csaba
Cc: [EMAIL PROTECTED] (E-mail)
Subject: Re: [GENERAL] How to kick out automatically stuck in queries
On Mon, 2 Feb 2004, [iso-8859-2
) ...
which means that I need only those rows which has an adate field holding
dates on 2004.01.10 every 30 or 15 minutes at the end. Is it possible to use
some regular expressions or is it worth at all talking about?
thanks,
-- Csaba
Egyd Csaba
[EMAIL PROTECTED
and Deployment
Great Gulf Homes / Ashton Woods Homes
[EMAIL PROTECTED]
Fax: (416) 441-9085
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Egyd Csaba
Sent: Wednesday, January 14, 2004 6:43 AM
To: [EMAIL PROTECTED] (E-mail)
Subject: [GENERAL] Using
Hi Tom,
thank you, I'll upgrade as soon as I can. Anyway I've already planned to do
so for a while.
I'll keep in mind your remarks concerning the DISTINCT clause too.
Bye and Best Regards,
-- Csaba
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Tom Lane
Hi Tom,
Another possibility is that t_stockchanges has child table(s). Your
SELECT would count rows in the child tables, but I don't think that
That's the case. I tried to copy the content of t_stockchanges table into a
temp table.
Being very lazy:) I created the temp table using create
Hi all,
I tried to dump out a single table and just for a verification I counted the
number of 'INERT INTO' rows.
I found that count(*) results less rows than grep.
***
[EMAIL PROTECTED] ~
$ pg_dump -d -t t_stockchanges alumil6 sc.dump
***
alumil6=# select
Hi All,
I run into an error message.
I have the following function where t_stockchanges is one of my tables.
create or replace function get_last_open(int, int) returns setof
t_stockchanges AS '
declare
ProductID alias for $1;
StockID alias for $2;
/var/lib/pgsql/data to eg.
/data/pgsql/data and set $PGDATA to that directory?
Thank you,
-- Egyd Csaba
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do
do this. Aren't
I right?
Tank you in advance.
Best Regards,
-- Egyd Csaba
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.522 / Virus Database: 320 - Release Date: 2003. 09. 29.
---(end of broadcast
cause the error?
Thank you,
-- Csaba
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Egyd Csaba [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 5:41 PM
Subject: Re: [GENERAL] Stored Proc error after modifying field type
=?iso-8859-1?Q?Egy=FCd_Csaba?= [EMAIL
the
Int8 As numeric option before converting my fields.
Anyway, I subscript pgsql-odbc list.
Thank you very much.
-- Csaba
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Egyd Csaba [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 6:23 PM
Subject: Re
Tom,
what do you think about the folowing: I updated the server field of my DSN
to point to the postgres runniong under cygwin on the localhost. The error
does not appear at all.
--
1 06:29:42 SQL Prepare: PostgreSQL - { call addincominginvoice
63 matches
Mail list logo
