Re: [BUGS] BUG #8291: postgres_fdw does not re-read USER MAPING after change.

2013-07-10 Thread Bernd Helmle
, reusing it for any subsequent foreign table access. The second error that I found is in the documentation of ALTER USER MAPPING. It incorrectly says how to update a users password. It could be misread, i agree. Attached is a small doc patch to address this against HEAD. -- T

Re: [BUGS] BUG #7562: could not read block 0 in file "base/16385/16585": read only 0 of 8192 bytes

2012-09-21 Thread Bernd Helmle
ERROR: could not read block 251 in file "base/6447890/7843708": read only 0 of 8192 bytes So, not block 0. How many blocks does the new index contain? 255 blocks according to its current size. -- Thanks Bernd -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.or

Re: [BUGS] BUG #7562: could not read block 0 in file "base/16385/16585": read only 0 of 8192 bytes

2012-09-21 Thread Bernd Helmle
ic table. The kernel didn't show any errors. -- Thanks Bernd -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] Warm Standby startup process unconditionally hangs

2011-08-01 Thread Bernd Helmle
ut either i've missed one or this is still open? If not, sorry for bothering you... Our customers reports that with the patches applied they didn't had any further hangs on the standby instances anymore for the last couple of months now. -- Thanks Bernd -- Sent via pgsql-bugs

Re: [BUGS] BUG #6113: SET DATESTYLE='European' does not set datestyle output correctly

2011-07-12 Thread Bernd Helmle
ot; setting. SET datestyle TO 'European'; SHOW datestyle; DateStyle --- ISO, DMY (1 row) SELECT '27.12.2011'::date; date 2011-12-27 (1 row) -- Thanks Bernd -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #6066: Bad string in German translation causes segfault (user-triggerable)

2011-06-17 Thread Bernd Helmle
9.0, 9.1 and current -HEAD, too. -- Thanks Bernd -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #6024: pg_dump won't dump ALTERed inherited fields

2011-05-12 Thread Bernd Helmle
submit for 9.2, it's on my radar again. -- Thanks Bernd -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] Warm Standby startup process unconditionally hangs

2011-04-07 Thread Bernd Helmle
hangs occured in the past. We'll see wether we get further hangs there. Bernd -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] Warm Standby startup process unconditionally hangs

2011-03-21 Thread Bernd Helmle
already performed at 20/6BEB2EB0 After this, the startup process just "hangs", with the symptoms shown above. I need to restart the standby now, because the customer wants to have it back as soon as possible, but if you need more infos, please let me know. -- Thanks Bernd -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] Psql malloc error on Git master

2011-01-21 Thread Bernd Helmle
--without-readline What I've done is to switch to MacPorts[1] and use their packaging. I'm building PostgreSQL then with: --with-libraries=/opt/local/lib --with-includes=/opt/local/include which for example links psql/libreadline with: % otool -L $PGSQL_HOME/bin/psql /Users/bernd/pg

Re: [BUGS] BUG #5555: ALTER TABLE ONLY ... SET NOT NULL on parent prevent prior inherited tables from being restored

2010-07-15 Thread Bernd Helmle
hough. There's a TODO item for it: see "Move NOT NULL constraint information to pg_constraint" FYI, i'm currently working on it, see <https://commitfest.postgresql.org/action/patch_view?id=312> Bernd -- Sent via pgsql-bugs mailing list (pgsql-bugs@pos

Re: [BUGS] BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading

2010-06-04 Thread Bernd Helmle
releases? (think of diff's against schema-only dumps and so on). Bernd -- 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 #3255: Proper escaping missing

2007-04-27 Thread Bernd Fuhrmann
The following bug has been logged online: Bug reference: 3255 Logged by: Bernd Fuhrmann Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Windows XP SP2 Description:Proper escaping missing Details: I just tried to use pgAdmin to create a

Re: [BUGS] BUG #2850: Cannot select from information_schema.schemat

2006-12-21 Thread Bernd Helmle
stem catalog. -- Thanks Bernd ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

[BUGS] BUG #2297: plpgsql function causes disconnect sometimes

2006-03-04 Thread bernd
The following bug has been logged online: Bug reference: 2297 Logged by: bernd Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Linux Fedora Core 3 Description:plpgsql function causes disconnect sometimes Details: I'm trying to make

Re: [BUGS] Postgre connection management

2003-08-22 Thread Bernd vd Brincken
Please call this site: http://www.google.com and type "postgres connection pooling" in the text field, next press the "Google search" button - and choose one or another of the 2000 URLs that you receive. regards // Bernd vdB

Re: [BUGS] Make install error

2003-07-02 Thread Bernd von den Brincken
Hello, Segree, Gareth wrote: Whenever I do a make install I get the following error: /usr/lib/postgresql/ascii_msc.so does not exist. Obvious, you have to install the ascii library before you can use postgres on your Nokia mobile phone. Regards // Bernd vdB ---(end of

Re: [BUGS] commands

2003-06-17 Thread Bernd von den Brincken
ally aim for. For the moment the only advice can be to read the docs. // Bernd vdB ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [BUGS] 'query was cancelled' - depending on search pattern

2003-04-03 Thread Bernd von den Brincken
Hello Tom, At 04.04.2003 00:22, you wrote: Bernd von den Brincken <[EMAIL PROTECTED]> writes: > a query ... produces an error 'Query was cancelled' - > sometimes, depending on the search words. That's really, really hard to believe. I suspect you've mis-analyz

[BUGS] 'query was cancelled' - depending on search pattern

2003-04-03 Thread Bernd von den Brincken
some postgresql.conf parameters, without effect, and failed in finding anything on 'query was cancelled' in the docs or in google. Any hints are welcome (and an update to the docs about error messages would make sense anyway). // Bernd vdB ---(end of broadcast)---