Re: [BUGS] locale and german umlauts

2001-08-07 Thread Nishad Prakash
On Wed, 1 Aug 2001, Wolfgang Winkler wrote: > export LC_CTYPE=de_DE.ISO8859-1 > export LC_COLLATE=de_DE.ISO8859-1 > > and make a database with > > createdb test. > > Is there something obvious I'm doing wrong? > Two things that could help: 1) Make sure the locale has been set before starting the

[BUGS] v7.0.2: can't use 'EXTRACT(EPOCH FROM'

2001-08-07 Thread Trevin Chow
I'm running postgres 7.0.3 on one machine and 7.1.2 on another. I tried running the exact SQL sample from the user manual for date time functions: SELECT EXTRACT(EPOCH FROM TIMESTAMP '2001-02-16 20:38:40'); This example won't run on the v7.0.3 and I get teh following error: ERROR: parser: par

Re: Odpověď: Re: [BUGS] backend don't use index when querying by indexed column

2001-08-07 Thread Tom Lane
<[EMAIL PROTECTED]> writes: > first of all thank You for Your response. But here is the > reality. Table formula have about 45 rows at this time. > The id_formula column is int4 defined as not null primary key. It is eh? Have you done a VACUUM ANALYZE on this table lately? 4500 rows (1%) wou