It's time for the 6 monthly discussion of the failure of  the horology
tests during DST changeover.
I'd like to find a way to avoid this, so we don't get spurious buildfarm
failures for 2 or 3 days every six months. ISTM the first thing is to

Question: is there any way to use environment variables (or something
similar) in my saved SQL code, and have them expanded at runtime?
I can't see a way to do this in the manuals, and a colleague tells me
it can't be done, but I wanted to check, because if this _can_ be done

Kind people,
Here's something I came up with, having accidentally discovered the
ARRAY() constructor (BTW, I think at least some pointer to it should
be in the array section of functions & operators).

In 7.4.6 there is only plpgsql  under pl where as 7.4.5
includes it in the main distribution
can anyone tell from where plperl for 7.4.6
can be got?

I know it is possible to time isolated queries through the settting of the
\timing option in psql. This makes PgSQL report the time it took to
perform one operation.
I would like to know how one can get a time summary of many operations, if

The Linux fsync man page says:
"It does not necessarily ensure that the entry in the directory
containing the file has also reached disk. For that an explicit fsync on
the file descriptor of the directory is also needed."

I am setting up a postgres server on Redhat Fedora Core 2, and am
unable to connect via tcpip.
I have enabled tcpip_socket in postgresql.conf.
For testing prposes, I'm using trust for local and host 127.0.0.1 in

[ PostgreSQL 7.4.5, Linux (Debian sarge) ]
The date_trunc function is making some off-by-one errors when working at
a DST border.
=> select date_trunc('minute', '2004-10-31 01:00:00-05'::timestamptz);

CREATE RULE "new_rule2" AS ON DELETE TO "public"."klients_view"
DO INSTEAD (
DELETE
FROM klients

pgsql running on port 5480, connect to template1 as non-superuser "phppgadmin"
who does not have createdb privileges. attempt to run a script that creates a
database "phppgadmin" and then do a \connect to that database.   this fails
(as it should) but when it does, it loses the ...

I have a long term plan to implement charset support in pg and now when I
have dropped the work on the timestamps, I've been looking into this
subject.
Today we store the max length of a string in the typmod field, but that

just wondering:
test=> select version();
                                        version
------------------------------------------------------------------------------------------

I did not notice in the Install instructions that a
dump restore  needed to be done...
This is what I got when I upgrade the v8b3 to the v8b4
FATAL:  database files are incompatible with server

Perhaps this is simple, but it has me stumped.  What is the data type to
use for returning a value from count?
Example:
CREATE FUNCTION ev3(int4) RETURNS int4

It seems partial indexes with not null condition do not work:
I did some testings with pgbench database and I observe:
1) statistics information is slghtly incorrect
2) partial index is not used