[BUGS] BUG #2692: psql sends natively-localized strings to database without setting client_encoding first

2006-10-13 Thread Sergiy Vyshnevetskiy
The following bug has been logged online: Bug reference: 2692 Logged by: Sergiy Vyshnevetskiy Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: FreeBSD-6 stable Description:psql sends natively-localized strings to database without setting cl

Re: [BUGS] BUG #2692: psql sends natively-localized strings to database without setting client_encoding first

2006-10-13 Thread Tom Lane
"Sergiy Vyshnevetskiy" <[EMAIL PROTECTED]> writes: > psql mixes natively-localized string in SQL commands without setting > client_encoding first. Looks like we _really_ need some code in configure > script to find acceptable native names for our database charsets. Actually, psql has no business

[BUGS] BUG #2688: Building from source with PL/Python fails ("distutils not found")

2006-10-13 Thread Anastasios Hatzis
My yesterday bug-report #2688 is solved. The solution was that I would have need to set the path environment to the shared libraries after I built Python with the --enable-shared option. A Linux newbie error. I will ask the Python doc team to add a notice on the appropriate place. Sorry for th

[BUGS] BUG #2691: Server did not start. Error: Could not create log file.

2006-10-13 Thread Ille vieljans
The following bug has been logged online: Bug reference: 2691 Logged by: Ille vieljans Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: debian Description:Server did not start. Error: Could not create log file. Details: Stopping PostgreSQL

[BUGS] BUG #2690: GRANT does not allow periods in database or schema names

2006-10-13 Thread Nick Johnson
The following bug has been logged online: Bug reference: 2690 Logged by: Nick Johnson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.1 Operating system: FreeBSD 6.1 Description:GRANT does not allow periods in database or schema names Details: Though you ca

Re: [BUGS] BUG #2690: GRANT does not allow periods in database or schema names

2006-10-13 Thread Alvaro Herrera
Nick Johnson wrote: > > The following bug has been logged online: > > Bug reference: 2690 > Logged by: Nick Johnson > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.1 > Operating system: FreeBSD 6.1 > Description:GRANT does not allow periods in database or

Re: [BUGS] BUG #2690: GRANT does not allow periods in database or schema names

2006-10-13 Thread Peter Eisentraut
Nick Johnson wrote: > Though you can create a database with a period in the name (e.g., > "example.com"), you cannot issue a GRANT on that database name from > the command line. > > pgsql=# GRANT ALL ON DATABASE example.com TO someuser; > ERROR: syntax error at or near "." at character 30 You are

Re: [BUGS] BUG #2690: GRANT does not allow periods in database or schema names

2006-10-13 Thread Tom Lane
"Nick Johnson" <[EMAIL PROTECTED]> writes: > Though you can create a database with a period in the name (e.g., > "example.com"), you cannot issue a GRANT on that database name from the > command line. You need some double quotes: http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX

Re: [BUGS] BUG #2691: Server did not start. Error: Could not create log file.

2006-10-13 Thread Tom Lane
"Ille vieljans" <[EMAIL PROTECTED]> writes: > Stopping PostgreSQL 8.1 database server: main. > hostname:/etc/init.d# ./postgresql-8.1 start > Starting PostgreSQL 8.1 database server: main* Use of uninitialized value in > pattern match (m//) at /usr/share/postgresql-common/PgCommon.pm line 433. >