Re: [BUGS] Bug #837: Unable to use LATIN9 (=ISO-8859-15) encoding

[Steve Haslam]

On Fri, Dec 06, 2002 at 12:20:54AM +0100, Peter Eisentraut wrote:
> > >From PSQL, if I perform:
> > \encoding LATIN9
> > insert into i18ntest(id, data) values('Euro symbol', '¤');
> >
> > then I would expect this to insert a euro symbol into the data column
> 
> '¤' means '¤', not anything else.  Maybe you want to try '\244'
> (octal).

That was a literal character 164 that the browser seems to have munged when
uploading the form (the script is also available in raw form using the URI
at the top, http://araqnid.ddts.net/~steve/i18ntest.sql)

SRH
-- 
Steve Haslam  Reading, UK   [EMAIL PROTECTED]
Debian GNU/Linux Maintainer   [EMAIL PROTECTED]
 Currently for sale: http://www.arise.demon.co.uk/my_cv/
almost called it today, turned to face the void, numb with the suffering
and the question- "Why am I?"  [queensrÿche]



msg05482/pgp0.pgp
Description: PGP signature

[BUGS] BUG #6082: server segfault - pg_stat_reset_shared(null)

[Steve Haslam]

The following bug has been logged online:

Bug reference:  6082
Logged by:  Steve Haslam
Email address:  araq...@googlemail.com
PostgreSQL version: 9.0.4
Operating system:   Debian GNU/Linux (amd64)
Description:server segfault - pg_stat_reset_shared(null)
Details: 

=> select pg_stat_reset_shared(null)
*server segfault*

Also occurs with a 9.1b2 build.

To be fair, it *does* reset all the shared statistics.

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] BUG #6083: psql script line numbers incorrectly count \copy data

[Steve Haslam]

The following bug has been logged online:

Bug reference:  6083
Logged by:  Steve Haslam
Email address:  araq...@googlemail.com
PostgreSQL version: 9.0.4
Operating system:   Debian GNU/Linux (amd64)
Description:psql script line numbers incorrectly count \copy data
Details: 

test_linenumbers.dat:
1
1
2
3
5
8

test_linenumbers.sql:
DO $$ BEGIN  RAISE INFO 'Before copy';  END; $$; -- line 1
CREATE TEMP TABLE test_linenumbers_data(value int);
\copy test_linenumbers_data from test_linenumbers.dat
DO $$ BEGIN  RAISE INFO 'After copy';  END; $$; -- line 4


Performing "psql -f test_linenumbers.sql" produces:


psql:test_linenumbers.sql:1: INFO:  Before copy
DO
CREATE TABLE
psql:test_linenumbers.sql:11: INFO:  After copy
DO


However, it seems to me that the second INFO should be reported against
test_linenumbers.sql:4 rather than :11. Apparently, the data read from \copy
is incrementing the script line number counter?

Also occurs with 9.1b2 and a recent 9.2devel.

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs