Re: [BUGS] COPY FROM/TO losing a single byte of a multibyte UTF-8 sequence

2010-08-20 Thread Tom Lane
Steven Schlansker writes: > On Aug 19, 2010, at 3:24 PM, Tom Lane wrote: >> We generally assume that in server-safe encodings, the ctype.h functions >> will behave sanely on any single-byte value. You can argue the wisdom >> of that, but deciding to change that policy would be a rather massive >>

Re: [BUGS] COPY FROM/TO losing a single byte of a multibyte UTF-8 sequence

2010-08-20 Thread Tom Lane
Tatsuo Ishii writes: >> We generally assume that in server-safe encodings, the ctype.h functions >> will behave sanely on any single-byte value. > I think this "wisedom" is only true for C locale. I'm not surprised > all that it does not work with non C locales. > From array_funcs.c: >

Re: [BUGS] BUG #5626: Parallel pg_restore fails with "tuple concurrently updated"

2010-08-20 Thread Tom Lane
Stephen Frost writes: > * Tom Lane (t...@sss.pgh.pa.us) wrote: >> We should probably try to make pg_restore smarter about this case, > Yes, definitely. I don't have an immediate solution though, I just posted some further analysis to pgsql-hackers. Please follow up there.

Re: [BUGS] BUG #5626: Parallel pg_restore fails with "tuple concurrently updated"

2010-08-20 Thread Stephen Frost
* Tom Lane (t...@sss.pgh.pa.us) wrote: > Mph ... removing the public schema from the restore list is problematic, > because you've got a lot of stuff *in* the public schema, and of course > all that stuff depends on the public schema entry. Normally this > doesn't bother pg_restore because it just

Re: [BUGS] BUG #5626: Parallel pg_restore fails with "tuple concurrently updated"

2010-08-20 Thread Tom Lane
Albert Ullrich writes: > We run essentially the following commands to create the table of contents in > order to prevent pg_restore from failing: > pg_restore -l database.dump | \ > eval fgrep -v -e "' SCHEMA - public '" \ > -e "' COMMENT - SCHEMA public '" \ > -e "' PROCEDURAL LANGUA

Re: [BUGS] BUG #5305: Postgres service stops when closing Windows session

2010-08-20 Thread Soporte @ Teksol SA
>From my side, i have no choice to get the stack trace from production servers where i found the issue. I have another several servers with almost the same config to development purposes and no crashes there. I don't have any code into the database, there is no compiled functions, just sql queries

Re: [BUGS] libpq: system-wide root.crt

2010-08-20 Thread Martin Pitt
Magnus Hagander [2010-08-20 15:07 +0200]: > Please add this to > https://commitfest.postgresql.org/action/commitfest_view/open Done, thanks! https://commitfest.postgresql.org/action/patch_view?id=364 Martin -- Martin Pitt| http://www.piware.de Ubuntu Developer (www.ubun

Re: [BUGS] libpq: system-wide root.crt

2010-08-20 Thread Magnus Hagander
On Thu, Aug 19, 2010 at 23:11, Martin Pitt wrote: > Hello PostgreSQL developers, > > Martin Pitt [2010-08-17  6:49 +0200]: >> I received a request to support system-wide root certificates in >> libpq. Right now it only looks in ~/.postgresql/root.crt, but since >> such certificates are usually set