Thread: postgresql 8.0b1 observations.

postgresql 8.0b1 observations.

From
mallah@trade-india.com
Date:
Hi Folks,

I installed postgresql8.0b1 a fews days back.
I am listing the issues which i came across
these many be already known issues or may not
be bugs.

1. Automatic convertion to NTFS.

Many NT based windows installation may not
have formatted the drive with NTFS , i think
the installer may assist or at leaset suggest
that converting from fat --> ntfs is a snap.

2. Randomly generated password is too long.

the password for the postgres account contained
non ascii characters in my case and was at least
20-30 chars.


3. History works but not Tab Expansion .
The SQL commands are not expanded on pressing tabs.

4. \s does not work although \? lists it.

psql issue.


5. After something is mistyped and the prompt changes
from "=#" to "-#" pressing ^C quits the psql whereas
in unix/linux ^C brings back to "=#" state where the
person can retype the command.


6. history was not saved .

7. Bundled PgAdminIII still shows documentation of 7.4

Regds
Mallah.

Re: postgresql 8.0b1 Win32 observations

From
Bruce Momjian
Date:
mallah@trade-india.com wrote:
> Hi Folks,
>
> I installed postgresql8.0b1 a fews days back.
> I am listing the issues which i came across
> these many be already known issues or may not
> be bugs.
>
> 1. Automatic convertion to NTFS.
>
> Many NT based windows installation may not
> have formatted the drive with NTFS , i think
> the installer may assist or at leaset suggest
> that converting from fat --> ntfs is a snap.

OK, installer issue?  I don't think we should have the postmaster
complain in its logs, right?

> 2. Randomly generated password is too long.
>
> the password for the postgres account contained
> non ascii characters in my case and was at least
> 20-30 chars.

Same.

> 3. History works but not Tab Expansion .
> The SQL commands are not expanded on pressing tabs.
>
> 4. \s does not work although \? lists it.

The problem is that we don't use readline on Win32.  I am wondering if
we need to prevent display of readline-required psql options.  I have
added that to the open items list.

> psql issue.
>
>
> 5. After something is mistyped and the prompt changes
> from "=#" to "-#" pressing ^C quits the psql whereas
> in unix/linux ^C brings back to "=#" state where the
> person can retype the command.

Yes, that is an open item, control-C on Win32.

> 6. history was not saved .

Needs readline.

> 7. Bundled PgAdminIII still shows documentation of 7.4

OK, pgadmin issue.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: [pgsql-hackers-win32] postgresql 8.0b1 Win32 observations

From
Andrew Dunstan
Date:

Bruce Momjian wrote:

>mallah@trade-india.com wrote:
>
>
>>Hi Folks,
>>
>>I installed postgresql8.0b1 a fews days back.
>>I am listing the issues which i came across
>>these many be already known issues or may not
>>be bugs.
>>
>>1. Automatic convertion to NTFS.
>>
>>Many NT based windows installation may not
>>have formatted the drive with NTFS , i think
>>the installer may assist or at leaset suggest
>>that converting from fat --> ntfs is a snap.
>>
>>
>
>OK, installer issue?  I don't think we should have the postmaster
>complain in its logs, right?
>
>
>
>
>

I've seen contrary opinions, but I don't see how anybody could
contemplate running *any* server on FAT. But then, people use Notepad to
write programs, too.

The installer should complain, but I guess that's it.

cheers

andrew