Re: [BUGS] 8.0: Absolute path required for INITDB?

2004-08-09 Thread Josh Berkus
Tom, > It might be worth absolut-izing this path in initdb before it's > passed down, but I can't get exceedingly excited about it. Well, once again let me check the docs to make sure people are warned about this -- Josh Berkus Aglio Database Solutions San Francisco -

Re: [BUGS] 8.0: Absolute path required for INITDB?

2004-08-09 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: >> It might be worth absolut-izing this path in initdb before it's >> passed down, but I can't get exceedingly excited about it. > Well, once again let me check the docs to make sure people are warned about > this Why would it matter? I don't think I

Re: [BUGS] 8.0: Absolute path required for INITDB?

2004-08-09 Thread Josh Berkus
Tom, > Why would it matter? I don't think I've ever once had occasion to use > the -L switch in initdb, because it figures it out just fine for itself. > People who are using it should be wizardly enough to know about the > chdir. Oh. Then I have a different bug to report, because INITDB for Su

Re: [BUGS] 8.0: Absolute path required for INITDB?

2004-08-09 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: > Oh. Then I have a different bug to report, because INITDB for Sunday's CVS > would not run without the -L option. Well, that does deserve investigation. But I've been initdb'ing frequently and not noticed any problems. What configure switches did you u

Re: [BUGS] 8.0: Absolute path required for INITDB?

2004-08-09 Thread Josh Berkus
Tom, > Well, that does deserve investigation. But I've been initdb'ing > frequently and not noticed any problems. What configure switches > did you use exactly? Did you try to move the installation tree > after configure? My only configure switch was --prefix=/usr/local/pg80b I did not move t

Re: [BUGS] 8.0: Absolute path required for INITDB?

2004-08-09 Thread Josh Berkus
Tom, > Well, that does deserve investigation. But I've been initdb'ing > frequently and not noticed any problems. What configure switches > did you use exactly? Did you try to move the installation tree > after configure? Here's the issue: if you start initdb from a directory other than PGBASE

Re: [BUGS] 8.0: Absolute path required for INITDB?

2004-08-09 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: > Here's the issue: if you start initdb from a directory other than PGBASE, you > can run into trouble: > [EMAIL PROTECTED]:/usr/local/pg80b/bin> ./initdb -D ../data > initdb: file "/usr/local/pg80b/bin/share/postgresql/postgres.bki" does not > exist Actua

Re: [BUGS] 8.0: Absolute path required for INITDB?

2004-08-09 Thread Bruce Momjian
Why don't we just throw an error if it isn't an abolute path name, rather than failing in a weird way? --- Josh Berkus wrote: > Tom, > > > Well, that does deserve investigation. But I've been initdb'ing > > frequently and

[BUGS] Bug: century/millenium still broken

2004-08-09 Thread Tom Lane
After all that about numbering centuries and millenia correctly, why does CVS tip still give me regression=# select extract(century from now()); date_part --- 20 (1 row) [ ... looks in code ... ] Apparently it's because you fixed only timestamp_part, and not timestamptz_part.

[BUGS] beta - win32, restore from pg_dump not possible

2004-08-09 Thread Mike G
Hello, Testing out beta version of 8.0 on XP Pro. I am trying to use psql to restore a dump of my database (prod. version runs under cygwin). Whenever I execute psql the password prompt is displayed and skipped right over which results in the command failing. psql.exe mydb < c:\mybackup file