[BUGS] BUG #3879: OS X Start Script should not `cd /Users/postgres`

2008-01-16 Thread David Wheeler 

The following bug has been logged online:

Bug reference:  3879
Logged by:  David Wheeler
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.3RC1
Operating system:   Mac OS X 10.5.1
Description:OS X Start Script should not `cd /Users/postgres`
Details: 

The Mac OS X start script (contrib/start-scripts/osx/PostgreSQL) should not
have the recently-added lines `cd /Users/postgres` for the following
reasons:

 * Not all systems use that username.
 * Even those that use the "postgres" username may not have a home
directory.
 * changing to the home directory appears to have no effect whatsoever.

Here is the patch:

--- contrib/start-scripts/osx/PostgreSQL.orig   2008-01-15 16:24:54.0
-0800
+++ contrib/start-scripts/osx/PostgreSQL2008-01-15 16:25:11.0
-0800
@@ -84,7 +84,6 @@
 StartService () {
 if [ "${POSTGRESQL:=-NO-}" = "-YES-" ]; then
 ConsoleMessage "Starting PostgreSQL database server"
-cd /Users/postgres
 if [ "${ROTATELOGS}" = "1" ]; then
 sudo -u $PGUSER sh -c "${DAEMON} -D '${PGDATA}' 2>&1 |
${LOGUTIL} '${PGLOG}' ${ROTATESEC} &"
 else
@@ -95,7 +94,6 @@
 
 StopService () {
 ConsoleMessage "Stopping PostgreSQL database server"
-cd /Users/postgres
 sudo -u $PGUSER $PGCTL stop -D "$PGDATA" -s -m fast
 }
 
@@ -103,7 +101,6 @@
 if [ "${POSTGRESQL:=-NO-}" = "-YES-" ]; then
 ConsoleMessage "Restarting PostgreSQL database server"
# should match StopService:
-cd /Users/postgres
sudo -u $PGUSER $PGCTL stop -D "$PGDATA" -s -m fast
# should match StartService:
 if [ "${ROTATELOGS}" = "1" ]; then

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

[BUGS] BUG #3872: backslash_quote = off doesn't work any more

2008-01-16 Thread David Gradwell 

The following bug has been logged online:

Bug reference:  3872
Logged by:  David Gradwell
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.3-beta3
Operating system:   Windows Server 2003
Description:backslash_quote = off doesn't work any more
Details: 

set backslash_quote = off in postgresql.conf


create table a (a1 varchar(100))

insert into a(a1)   values ( '\602')

gives ERROR: invalid byte sequence for encoding "UTF8": 0x82'

It worked fine in 8.2 !!

In fact to meet the sql standard we shouldn't have to change the conf file. 
The default should be SQL compliance !!

I can email the current and 8.2 conf files if helpful.

Thanks

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Re: [BUGS] BUG #3872: backslash_quote = off doesn't work any more

2008-01-16 Thread Tomasz Ostrowski 
On Mon, 14 Jan 2008, David Gradwell wrote:

> Description:backslash_quote = off doesn't work any more

I think you need to
set standard_conforming_strings=on;
instead.

Then:
select '\''012'::text;
 text  
---
 \'012
(1 row)

 select '\012'::text;
 text 
--
 \012
(1 row)

I think this backslash_quote is ignored when
standard_conforming_strings is on.

Regards
Tometzky
-- 
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
  Winnie the Pooh

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

Re: [BUGS] BUG #3872: backslash_quote = off doesn't work any more

2008-01-16 Thread Tom Lane 
"David Gradwell" <[EMAIL PROTECTED]> writes:
> set backslash_quote = off in postgresql.conf

> create table a (a1 varchar(100))
> insert into a(a1)   values ( '\602')
> gives ERROR: invalid byte sequence for encoding "UTF8": 0x82'

backslash_quote has got zero to do with that case.

regards, tom lane

---(end of broadcast)---
TIP 6: explain analyze is your friend

[BUGS] BUG #3880: pgAdmin III dialog size

2008-01-16 Thread rf 

The following bug has been logged online:

Bug reference:  3880
Logged by:  rf
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.2.6-1
Operating system:   WinXp Pro
Description:pgAdmin III dialog size
Details: 

When viewing the SQL tab in the New Table dialog, a scroll bar appears at
the bottom .. I am unable to resize the dialog to allow me to view more
data.

Dialogs in pgAdmin should be resizeable, allowing the user to control the
interface.  Constraining window size in a world full of large widescreen
displays is frustrating for the user.  Scrolling around in a small window is
also inefficient; it's like looking at the world thru a telescope.

If the dialog doesn't look good when sized larger, then the user won't do
it; but let them decide this.

Respectfully submitted,

-rf

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

Re: [BUGS] BUG #3879: OS X Start Script should not `cd /Users/postgres`

2008-01-16 Thread Tom Lane 
"David Wheeler" <[EMAIL PROTECTED]> writes:
> The Mac OS X start script (contrib/start-scripts/osx/PostgreSQL) should not
> have the recently-added lines `cd /Users/postgres` for the following
> reasons:

I agree.  Removed, thanks for the report.

regards, tom lane

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org