[BUGS] Wrong formated date on the first day of the Daylight Saving time.

2001-03-27 Thread pgsql-bugs
Laurent Faillie ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Wrong formated date on the first day of the Daylight Saving time. Long Description Hi every body, I find this problem using the following configuration: $ uname -

Re: [BUGS] Wrong formated date on the first day of the Daylight Saving time.

2001-03-27 Thread Karel Zak
On Tue, Mar 27, 2001 at 04:35:11AM -0500, [EMAIL PROTECTED] wrote: > Short Description > Wrong formated date on the first day of the Daylight Saving time. It's common problem with this time in 7.0.x - already fixed in 7.1. > scheduling=# select to_char( jour, 'DayDD Mon '), jour from >back

[BUGS] Please help On Alternative Database Location

2001-03-27 Thread Francesco Protano
it's sure that this email should to be write to anywhere but here, but the various requests to help done in some mailings lists about postgresqk are failed.So i write you, in the hope to receive an response. Briefly the question. I work under Linux platform, Mandrake 7.2 distribution, and i need t

Re: [BUGS] Please help On Alternative Database Location

2001-03-27 Thread Tom Lane
Francesco Protano <[EMAIL PROTECTED]> writes: > I work under Linux platform, Mandrake 7.2 > distribution, and i need to create a postgres > database, for example called "mydb", in alternative > location, for example "/home/username". In the > official documentation this is very simple to do, but >

Re: [BUGS] Please help On Alternative Database Location

2001-03-27 Thread Peter Eisentraut
Francesco Protano writes: > 1) su - username > 2) set PGDATA2 = "/home/username" (but i tried > relatives path too) > 3) initlocation $PGDATA2 > 4) createdb -D $PGDATA2 mydb initlocation PGDATA2 createdb -D PGDATA2 mydb -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/

[BUGS] Bug about 'Foreign Key'

2001-03-27 Thread Cid R Andrade
PostgreSQL Developers,   I have a PostgreSQL 7.0.2 running at Conectiva Linux, with kernel 2.2.14, with 56 Mb of data.   I'd created a table: Create Table Andamento (     Etiqueta integer not null,     CodTecnico integer not null,     DtInicio timestamp not null,     DtLiberacao timestamp n

Re: [BUGS] Local Host Security? All users should have passwordsoptionally...

2001-03-27 Thread Peter Eisentraut
> Iván Baldo ([EMAIL PROTECTED]) reports a bug with a severity of 2 > I wanted to add passwords to all the users on the database, including > the postgres user, etc. Then everything is authenticated using "crypt" > method, so it asks passwords EVERYTIME. The problem I found is that I > cannot do

Re: [BUGS] Bug about 'Foreign Key'

2001-03-27 Thread Stephan Szabo
This should be fixed for 7.1, it now checks that the referencing columns exist on the fk table and that the referenced columns are part of a unique index [our unique/pkey] on the referenced table. On Tue, 27 Mar 2001, Cid R Andrade wrote: > PostgreSQL Developers, > > I have a PostgreSQL 7.0.2

[BUGS] pg v7.1RC1: jdbc1 fails to compile

2001-03-27 Thread pgsql-bugs
Michael Fischer v. Mollard ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description pg v7.1RC1: jdbc1 fails to compile Long Description When I was compiling postgresql-7.1RC1 (on a debian 2.2 with a jdk118_v3 from blackdown.org) I got