Re: [HACKERS] Defaulting psql to ON_ERROR_ROLLBACK=interactive

2017-03-16 Thread Andreas 'ads' Scherbaum
further discussion, Peter will propose another solution soon. -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project -- Sent via pgsql-hackers mailing list (pg

Re: [HACKERS] to_date_valid()

2016-09-09 Thread Andreas 'ads' Scherbaum
On 08.09.2016 17:31, Peter Eisentraut wrote: On 8/15/16 7:33 AM, Andreas 'ads' Scherbaum wrote: postgres=# SELECT to_date('2011 12 18', ' MM DD'); to_date 2011-12-08 (1 row) That is from the regression tests, and obviously handles the date transformation wrong. My

Re: [HACKERS] to_date_valid()

2016-08-15 Thread Andreas 'ads' Scherbaum
On 15.08.2016 13:44, Artur Zakirov wrote: On 15.08.2016 14:33, Andreas 'ads' Scherbaum wrote: Is it right and "true" way to validate date by extra transforming and comparison? Maybe validate date by using ValidateDate(). Attached sample patch. This does not solve the probl

Re: [HACKERS] to_date_valid()

2016-08-15 Thread Andreas 'ads' Scherbaum
On 15.08.2016 10:24, Artur Zakirov wrote: On 14.08.2016 01:52, Andreas 'ads' Scherbaum wrote: Attached is a patch to "do the right thing". The verification is in "to_date()" now, the extra function is removed. Regression tests are updated - two or three of them returned

Re: [HACKERS] to_date_valid()

2016-08-13 Thread Andreas 'ads' Scherbaum
e, and still passed. They fail now. Documentation is also updated. Regards, -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project to_date_valid.

Re: [HACKERS] to_date_valid()

2016-07-29 Thread Andreas 'ads' Scherbaum
he checks in to_date. -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] sslmode=require fallback

2016-07-15 Thread Andreas 'ads' Scherbaum
aren't exactly uncommon these days... What expire time would you chose for the certificate? One year? Two years? Which tool is going to re-generate your new cert, once this one expires? You don't want to run initdb again ... Regards, -- Andreas 'ads' Scherbaum Ger

Re: [HACKERS] to_date_valid()

2016-07-05 Thread Andreas 'ads' Scherbaum
On 05.07.2016 04:33, David G. Johnston wrote: On Mon, Jul 4, 2016 at 8:39 PM, Andreas 'ads' Scherbaum <adsm...@wars-nicht.de <mailto:adsm...@wars-nicht.de>>wrote: On 04.07.2016 18:37, Pavel Stehule wrote: I don't know if the name "strict" is best, but the

Re: [HACKERS] to_date_valid()

2016-07-05 Thread Andreas 'ads' Scherbaum
On 05.07.2016 06:05, Pavel Stehule wrote: 2016-07-05 2:39 GMT+02:00 Andreas 'ads' Scherbaum <adsm...@wars-nicht.de <mailto:adsm...@wars-nicht.de>>: On 04.07.2016 18:37, Pavel Stehule wrote: I don't know if the name "strict" is best, but the

Re: [HACKERS] to_date_valid()

2016-07-04 Thread Andreas 'ads' Scherbaum
tes the input format for string parsing, and that the date is in range. But there is not much validation on the date itself. So the name can't be "strict" because of the conflict with "NULL" handling, and you don't like "valid" - what other options do you offer?

Re: [HACKERS] to_date_valid()

2016-07-04 Thread Andreas 'ads' Scherbaum
uly 2016 at 09:32, Euler Taveira <eu...@timbira.com.br <mailto:eu...@timbira.com.br>> wrote: On 02-07-2016 22 <tel:02-07-2016%2022>:04, Andreas 'ads' Scherbaum wrote: > The attached patch adds a new function "to_date_valid()"

Re: [HACKERS] to_date_valid()

2016-07-04 Thread Andreas 'ads' Scherbaum
On 04.07.2016 16:33, Amit Kapila wrote: On Sun, Jul 3, 2016 at 6:34 AM, Andreas 'ads' Scherbaum <adsm...@wars-nicht.de> wrote: Hello, we have customers complaining that to_date() accepts invalid dates, and returns a different date instead. This is a known issue: http://sql-info.de/post

Re: [HACKERS] to_date_valid()

2016-07-03 Thread Andreas 'ads' Scherbaum
On 03.07.2016 07:05, Jaime Casanova wrote: El 2/7/2016 20:33, "Euler Taveira" <eu...@timbira.com.br <mailto:eu...@timbira.com.br>> escribió: > > On 02-07-2016 22:04, Andreas 'ads' Scherbaum wrote: > > The attached patch adds a new function "to_date_val

[HACKERS] to_date_valid()

2016-07-02 Thread Andreas 'ads' Scherbaum
umentation update as well. -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project to_date_valid.patch.gz Description: application/gzip -- Sent via pgs

[HACKERS] TESTING in src/bin/pg_upgrade has incorrect documentation

2016-06-02 Thread Andreas 'ads' Scherbaum
Hi, the TESTING file in src/bin/pg_upgrade talks about a "check.sh script", but this seems to be a binary (check) now. Regards, -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Voluntee

Re: [HACKERS] Bug in intarray bench script

2016-05-24 Thread Andreas 'ads' Scherbaum
The following review has been posted through the commitfest application: make installcheck-world: not tested Implements feature: not tested Spec compliant: not tested Documentation:not tested The patch changes the benchmark tool in a way that the explain output is

[HACKERS] Small typo in a comment in pg_regress.c

2016-04-02 Thread Andreas 'ads' Scherbaum
Hi, stumbled over this while looking into the source. Patch attached. Regards, -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project diff --git a/src

Re: [HACKERS] pl/pgSQL, get diagnostics and big data

2016-02-10 Thread Andreas 'ads' Scherbaum
%zu. I re-ran all the tests, especially the long test with 2^32+x rows, and it produces the same result as before. Regards, -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, German

Re: [HACKERS] pl/pgSQL, get diagnostics and big data

2016-02-01 Thread Andreas 'ads' Scherbaum
On 01.02.2016 21:24, Andreas 'ads' Scherbaum wrote: Attached patch expands the row_count to 64 bit. Remembering an issue we had recently with clear text patches, attached is a gzipped version as well. Regards, -- Andreas 'ads' Scherbaum German PostgreSQL

[HACKERS] pl/pgSQL, get diagnostics and big data

2016-02-01 Thread Andreas 'ads' Scherbaum
_pg - 5 (1 row) Attached patch expands the row_count to 64 bit. diagnostics=# select testfunc_pg((2^32 + 5)::bigint); testfunc_pg - 4295017296 (1 row) I hope, I covered all the places which count the result set. Regards, -- Andreas '

Re: [HACKERS] Small documentation fix in src/interfaces/ecpg/preproc/po/pt_BR.po

2015-10-08 Thread Andreas 'ads' Scherbaum
Hello, On 10/07/2015 05:18 PM, Euler Taveira wrote: On 06-10-2015 19:49, Andreas 'ads' Scherbaum wrote: When working on a script, I stumbled over a mistake in the pt_BR.po translation for ecpg. Patch attached. I've already fixed it in the translation git. It'll be available only in the next

[HACKERS] Small documentation fix in src/bin/initdb/po/zh_CN.po

2015-10-06 Thread Andreas 'ads' Scherbaum
When working on a script, I stumbled over a mistake in the zh_CN.po translation for initdb. Patch attached. Regards, -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact

[HACKERS] Small documentation fix in src/interfaces/ecpg/preproc/po/pt_BR.po

2015-10-06 Thread Andreas 'ads' Scherbaum
When working on a script, I stumbled over a mistake in the pt_BR.po translation for ecpg. Patch attached. Regards, -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany

Re: [HACKERS] documentation update for doc/src/sgml/func.sgml

2014-10-17 Thread Andreas 'ads' Scherbaum
On 09/14/2014 06:32 PM, Peter Eisentraut wrote: On 9/12/14 3:13 PM, Andreas 'ads' Scherbaum wrote: Of course a general rule how to link to WP would be nice ... I think Wikipedia links should be avoided altogether. We can assume that readers are technically proficient to look up general

Re: [HACKERS] documentation update for doc/src/sgml/func.sgml

2014-09-12 Thread Andreas 'ads' Scherbaum
, -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 13c71af..15742f8 100644 --- a/doc/src

Re: [HACKERS] documentation update for doc/src/sgml/func.sgml

2014-08-21 Thread Andreas 'ads' Scherbaum
. There are very few of them, most in acronym.sgml. It would be nice to have a general rule how to handle external links. I would suggest to put relevant tags around functions and types, like: functionround()/ and typeNUMERIC/. Can do. Thanks, -- Andreas 'ads

[HACKERS] documentation update for doc/src/sgml/func.sgml

2014-08-20 Thread Andreas 'ads' Scherbaum
is not always rounded up, as expected from a mathematical point of view. Regards, -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project diff --git a/doc/src/sgml

Re: [HACKERS] Patch: iff - if

2014-04-17 Thread Andreas 'ads' Scherbaum
, -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Patch: iff - if

2014-04-16 Thread Andreas 'ads' Scherbaum
On 04/16/2014 12:19 AM, Andreas 'ads' Scherbaum wrote: stumbled over a number of iff in the source where if is meant - not sure what the real story behind this is, but attached is a patch to fix the about 80 occurrences. Looks like I missed something in my math lessons

Re: [HACKERS] [pgsql-advocacy] GSoC 2014 - mentors, students and admins

2014-02-25 Thread Andreas 'ads' Scherbaum
, -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

[HACKERS] REMINDER: FOSDEM 2012 - PostgreSQL Devroom: Call for Speakers

2011-12-17 Thread Andreas 'ads' Scherbaum
Am 20.11.2011 23:54, schrieb Andreas 'ads' Scherbaum: FOSDEM 2012 - PostgreSQL Devroom: Call for Speakers The PostgreSQL project will have a Devroom at FOSDEM 2012, which takes place on February 4-5 in Brussels, Belgium. The Devroom will mainly cover topics for PostgreSQL users, developers

[HACKERS] REMINDER: Hotel reservation for FOSDEM 2012 - Deadline: December 31th, 2011

2011-12-17 Thread Andreas 'ads' Scherbaum
Am 11.11.2011 16:14, schrieb Andreas 'ads' Scherbaum: like the last years we will have a devroom at FOSDEM 2012. We also look forward to have a booth. We made a group reservation in the Agenda Louise hotel: Hotel Agenda Louise rue de Florence 6 B-1000 Brussels Tel: + 32.2.539.00.31 Fax

[HACKERS] FOSDEM 2012 - PostgreSQL Devroom: Call for Speakers

2011-11-20 Thread Andreas 'ads' Scherbaum
-- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

[HACKERS] Hotel reservation for FOSDEM 2012 - Deadline: December 31th, 2011

2011-11-11 Thread Andreas 'ads' Scherbaum
. If you would like to book a room, please send me an email. Include your name, email address, room type, arrival and leave date. Important: please send me this information until December 31th, 211! Thanks -- Andreas 'ads' Scherbaum German PostgreSQL User Group

[HACKERS] Small documentation enhancement for default_tablespace

2010-11-27 Thread Andreas 'ads' Scherbaum
-- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project *** a/doc/src/sgml/config.sgml --- b/doc/src/sgml/config.sgml *** *** 4357,4362 COPY postgres_log FROM '/full/path

Re: [HACKERS] SHOW TABLES

2010-07-15 Thread Andreas 'ads' Scherbaum
in psql ... same for any interface language, really ... Isn't that what the information_schema catalog is for? Is there a way to query all databases from information_schema? Bye -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User

Re: [HACKERS] SHOW TABLES

2010-07-15 Thread Andreas 'ads' Scherbaum
On Thu, 15 Jul 2010 22:01:34 +0300 Peter Eisentraut wrote: On tor, 2010-07-15 at 19:21 +0200, Andreas 'ads' Scherbaum wrote: Is there a way to query all databases from information_schema? No. This got rejected before, because of not in the standard. In this case: no way to answer SHOW

Re: [HACKERS] Streaming Rep - 2-phase backups and reducing time to full replication

2009-12-24 Thread Andreas 'ads' Scherbaum
+1 for integrating such a feature in a future version. Bye -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Exclusion Constraint vs. Constraint Exclusion

2009-12-07 Thread Andreas 'ads' Scherbaum
be a lot less work. However, partition_exclusion seems to imply that it *only* applies to partitioned tables, which is not the case... It is less coding work - but it will for sure confuse the users. Bye -- Andreas 'ads' Scherbaum German PostgreSQL User Group

Re: [HACKERS] Listen / Notify - what to do when the queue is full

2009-11-19 Thread Andreas 'ads' Scherbaum
of messages in the queue ... Bye -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Listen / Notify - what to do when the queue is full

2009-11-19 Thread Andreas 'ads' Scherbaum
On Thu, 19 Nov 2009 14:23:57 +0100 Joachim Wieland wrote: On Thu, Nov 19, 2009 at 1:51 PM, Andreas 'ads' Scherbaum adsm...@wars-nicht.de wrote: And in addition i don't like the idea of having the sender sitting around until there's room for more messages in the queue, because some very

Re: [HACKERS] EOL for 7.4?

2009-11-12 Thread Andreas 'ads' Scherbaum
for an OSS project page. If this goes well, we could EOL 8.0 after 8.5 comes out, and thus decrease our maintenance burden. +1 -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact

Re: [HACKERS] EOL for 7.4?

2009-11-12 Thread Andreas 'ads' Scherbaum
On Thu, 12 Nov 2009 15:23:06 -0500 Andrew Dunstan wrote: Andreas 'ads' Scherbaum wrote: On Tue, 03 Nov 2009 10:32:17 -0800 Josh Berkus wrote: The same goes for other OSS projects. There's quite a few random OSS apps which were created on PG 7.4 and have never offered their users

[HACKERS] Patch: create or replace language

2009-10-06 Thread Andreas 'ads' Scherbaum
Hello, following this old discussion: http://archives.postgresql.org/pgsql-patches/2008-03/msg00402.php i modifies the patch to use the CREATE [OR REPLACE] LANGUAGE syntax. If the patch is ok, i will add the documentation too. Kind regards -- Andreas 'ads

Re: [HACKERS] Changed error message for blocks by prepared transactions

2009-06-23 Thread Andreas 'ads' Scherbaum
On Mon, 22 Jun 2009 19:24:28 -0400 Tom Lane wrote: Andreas 'ads' Scherbaum adsm...@wars-nicht.de writes: the small attached patch changes the error message for a blocked database in case there are prepared transactions. Isn't this duplicative of the errdetail_busy_db code? And anyway I

[HACKERS] Changed error message for blocks by prepared transactions

2009-06-22 Thread Andreas 'ads' Scherbaum
- Translation still pending, how to add new messages to the .po files? Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project PGDay.eu 2009

[HACKERS] Small patch removing the crypt auth from sample pg_hba.conf

2009-03-31 Thread Andreas 'ads' Scherbaum
Hello, although the crypt auth functionality is removed i 8.4 i found a remnant in the sample pg_hba.conf file. The attached patch removes the keyword from the config file. Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group European

Re: [HACKERS] Validating problem in the isn contrib module

2009-03-06 Thread Andreas 'ads' Scherbaum
On Fri, 06 Mar 2009 00:32:40 +0100 Bernd Helmle wrote: --On Freitag, März 06, 2009 02:26:12 +0100 Andreas 'ads' Scherbaum adsm...@wars-nicht.de wrote: test=# select is_valid('978-3-937514-69-6'::isbn13); ERROR: invalid check digit for ISBN number: 978-3-937514-69-6, should be 7 ROW 1

Re: [HACKERS] Validating problem in the isn contrib module

2009-03-06 Thread Andreas 'ads' Scherbaum
On Fri, 6 Mar 2009 07:14:20 +0100 A. Kretschmer wrote: Nice advertisement for your book... Actually the example is copypaste from the .tex file ;-) Bye -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors

Re: [HACKERS] Validating problem in the isn contrib module

2009-03-06 Thread Andreas 'ads' Scherbaum
On Fri, 06 Mar 2009 10:50:41 + Gregory Stark wrote: Andreas 'ads' Scherbaum adsm...@wars-nicht.de writes: The validator function should use the weak mode for itself to return 'f' in case of invalid input. It cannot be the users job to make sure a validator function is working

Re: [HACKERS] Validating problem in the isn contrib module

2009-03-06 Thread Andreas 'ads' Scherbaum
On Fri, 06 Mar 2009 12:44:31 +0100 Bernd Helmle wrote: --On Freitag, März 06, 2009 11:32:14 +0100 Andreas 'ads' Scherbaum adsm...@wars-nicht.de wrote: I don't see anything that's not already documented. is_valid() checks the presence of the invalid (!) marker only. It looks like

Re: [HACKERS] Validating problem in the isn contrib module

2009-03-06 Thread Andreas 'ads' Scherbaum
invalid_text_representation THEN RETURN false; END; $$ LANGUAGE 'plpgsql'; Bye -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

[HACKERS] Validating problem in the isn contrib module

2009-03-05 Thread Andreas 'ads' Scherbaum
my entire transaction. Is this just a bug or is this intended behaviour. And if it's not a bug, how can i validate an ISBN number in my application - without raising an error? Thank you kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group

Re: [HACKERS] Patch for str_numth() in PG 7.4

2009-01-13 Thread Andreas 'ads' Scherbaum
On Tue, 13 Jan 2009 12:30:09 -0300 Alvaro Herrera wrote: The other cases were already handled, so Andreas' initial patch was enough -- applied. Thank you. Bye -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board

[HACKERS] Patch for str_numth() in PG 7.4

2009-01-12 Thread Andreas 'ads' Scherbaum
to include this patch into the next 7.4 release (i assume there will be at least one release if 7.4 reaches eol). Thanks kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors *** src/bin/psql

Re: [HACKERS] Patch for str_numth() in PG 7.4

2009-01-12 Thread Andreas 'ads' Scherbaum
Hello all, On Mon, 12 Jan 2009 22:55:32 +0100 Andreas 'ads' Scherbaum wrote: I tracked the problem done to the function str_numth() in src/backend/utils/adt/formatting.c. The fix (attached) is easy: i stole the function code from the latest 8.0 version which looks fare more sane in handling

Re: [HACKERS] [patch] Reformat permissions in \l+ (like \z does)

2009-01-01 Thread Andreas 'ads' Scherbaum
On Wed, 31 Dec 2008 13:08:20 -0500 Tom Lane wrote: Andreas 'ads' Scherbaum adsm...@wars-nicht.de writes: On Sun, 28 Dec 2008 18:19:48 -0500 Tom Lane wrote: If we're going to do this, shouldn't it happen uniformly for *all* ACL displays in describe.c? Makes sense, imho. Done. Oh

Re: [HACKERS] [patch] Reformat permissions in \l+ (like \z does)

2008-12-29 Thread Andreas 'ads' Scherbaum
On Sun, 28 Dec 2008 18:19:48 -0500 Tom Lane wrote: Andreas 'ads' Scherbaum adsm...@wars-nicht.de writes: the march 2008 commitfest added a patch[1] with extended information for \l+. The may 2008 commitfest added a patch[2] which reformats the permission output in \z. I like the new output

[HACKERS] [patch] Reformat permissions in \l+ (like \z does)

2008-12-21 Thread Andreas 'ads' Scherbaum
. Kind regards 1: http://archives.postgresql.org/message-id/488c2fe3-a6c7-4cfa-bd3c-f0588da81...@tcpd.net 2: http://archives.postgresql.org/message-id/37ed240d0804170921h7a6b92fev65aeb99f658f8...@mail.gmail.com -- Andreas 'ads' Scherbaum German PostgreSQL User Group

[HACKERS] FOSDEM 2009 Call for Papers - deadline

2008-12-09 Thread Andreas 'ads' Scherbaum
and presentations about new and shiny features. The talk committee consists of Gregory Stark, Koen Martens, Magnus Hagander and Andreas Scherbaum. More information are available at: http://wiki.postgresql.eu/wiki/FOSDEM_2009 Kind regards -- Andreas 'ads' Scherbaum German

Re: [HACKERS] Parsing of pg_hba.conf and authentication inconsistencies

2008-08-14 Thread Andreas 'ads' Scherbaum
which tool is doing the check as long as it's possible to check the config at all. Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] TODO Item: Allow pg_hba.conf to specify host names along with IP addresses

2008-06-15 Thread Andreas 'ads' Scherbaum
. I would also like to see a note that the DNS lookup could seriously slow down the authentication process. Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] Overhauling GUCS

2008-06-06 Thread Andreas 'ads' Scherbaum
in place, this should not be much overhead. Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Core team statement on replication in PostgreSQL

2008-06-02 Thread Andreas 'ads' Scherbaum
On Mon, 02 Jun 2008 11:52:05 -0400 Chris Browne wrote: [EMAIL PROTECTED] (Andreas 'ads' Scherbaum) writes: On Thu, 29 May 2008 23:02:56 -0400 Andrew Dunstan wrote: Well, yes, but you do know about archive_timeout, right? No need to wait 2 hours. Then you ship 16 MB binary stuff

Re: [HACKERS] Core team statement on replication in PostgreSQL

2008-05-30 Thread Andreas 'ads' Scherbaum
solution. Not everyone wants to spend the time and the manpower to implement a simple replication. Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] Core team statement on replication in PostgreSQL

2008-05-30 Thread Andreas 'ads' Scherbaum
it on as part of core Postgres. Ack Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Core team statement on replication in PostgreSQL

2008-05-30 Thread Andreas 'ads' Scherbaum
, especially if you ship the logfile over the internet (means: no high-speed connection, maybe even pay-per-traffic) to the slave. Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Core team statement on replication in PostgreSQL

2008-05-30 Thread Andreas 'ads' Scherbaum
On Fri, 30 May 2008 16:22:41 -0400 (EDT) Greg Smith wrote: On Fri, 30 May 2008, Andreas 'ads' Scherbaum wrote: Then you ship 16 MB binary stuff every 30 second or every minute but you only have some kbyte real data in the logfile. Not if you use pg_clearxlogtail ( http://www

Re: [HACKERS] Core team statement on replication in PostgreSQL

2008-05-30 Thread Andreas 'ads' Scherbaum
On Fri, 30 May 2008 17:05:57 -0400 Andrew Dunstan wrote: Andreas 'ads' Scherbaum wrote: On Thu, 29 May 2008 23:02:56 -0400 Andrew Dunstan wrote: Well, yes, but you do know about archive_timeout, right? No need to wait 2 hours. Then you ship 16 MB binary stuff every 30 second or every

Re: [HACKERS] triggers on prepare, commit, rollback... ?

2008-05-21 Thread Andreas 'ads' Scherbaum
(or --follow=name) for just this reason. Not every system is GNU. Not every possible configuration uses the same logfile name for the next logfile. Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Protection from SQL injection

2008-04-29 Thread Andreas 'ads' Scherbaum
a feature against SQL injections which will not be used by literally anyone? Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] get rid of psql welcome message

2008-04-17 Thread Andreas 'ads' Scherbaum
On Thu, 17 Apr 2008 15:58:10 +0200 Peter Eisentraut wrote: Mike Aubury wrote: Am I missing something.. $ psql -q testdb testdb=# This also quiets out a few other unrelated things. Like all \timing messages *grumble* -- Andreas 'ads' Scherbaum German

Re: [HACKERS] get rid of psql welcome message

2008-04-17 Thread Andreas 'ads' Scherbaum
-- Andreas 'ads' Scherbaum German PostgreSQL User Group -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Binary data type with other output method

2007-12-27 Thread Andreas 'ads' Scherbaum
On Wed, 26 Dec 2007 20:20:59 -0500 Andrew Dunstan wrote: Andreas 'ads' Scherbaum wrote: The reason for my question is: PHP (yes *grumble*) does not recognize boolean columns but instead makes a simple string from a PG boolean. So every time you select a boolean column in PHP, you

Re: [HACKERS] Binary data type with other output method

2007-12-27 Thread Andreas 'ads' Scherbaum
On Thu, 27 Dec 2007 08:52:15 -0500 Andrew Dunstan wrote: Andreas 'ads' Scherbaum wrote: On Wed, 26 Dec 2007 20:20:59 -0500 Andrew Dunstan wrote: This PHP driver is in use since years, do you really expect they will fix this bug and make thousands of applications fail? Everyone like

Re: [HACKERS] Binary data type with other output method

2007-12-27 Thread Andreas 'ads' Scherbaum
On Thu, 27 Dec 2007 11:39:29 -0500 Andrew Dunstan wrote: Andreas 'ads' Scherbaum wrote: i considered this one but this would only bring 0/1 as input, not as output values, which is what i want. er, what? This domain would have input and output values of 0/1. Yes, but i

Re: [HACKERS] Binary data type with other output method

2007-12-26 Thread Andreas 'ads' Scherbaum
: if (!$bool) because 't' and 'f' give TRUE in PHP. I was begged many times by our people coding PHP to find a workaround for this problem. Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group ---(end of broadcast

Re: [HACKERS] Binary data type with other output method

2007-12-26 Thread Andreas 'ads' Scherbaum
On Wed, 26 Dec 2007 17:12:33 -0500 Mark Mielke wrote: Andreas 'ads' Scherbaum wrote: The reason for my question is: PHP (yes *grumble*) does not recognize boolean columns but instead makes a simple string from a PG boolean. So every time you select a boolean column in PHP, you cannot use

[HACKERS] Binary data type with other output method

2007-12-25 Thread Andreas 'ads' Scherbaum
AS boolean2) WITHOUT FUNCTION AS ASSIGNMENT; ... and so on. Can i have this in an easier way? Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group ---(end of broadcast)--- TIP 7: You

Re: [HACKERS] Binary data type with other output method

2007-12-25 Thread Andreas 'ads' Scherbaum
Hello, On Tue, 25 Dec 2007 11:10:25 -0500 Andrew Dunstan wrote: Andreas 'ads' Scherbaum wrote: i'm in the need to create a boolean datatype which returns an integer instead of the usual 't'/'f'. Before anyone starts to point me at casts: it's a lot overhead to cast some hundred

Re: [HACKERS] Binary data type with other output method

2007-12-25 Thread Andreas 'ads' Scherbaum
Hello, On Tue, 25 Dec 2007 22:12:23 +0500 imad wrote: Why dont you provide a cast, I dont see an overhead in typbyval datatypes. I already have a cast from my type to PGs internal boolean ... or what do you mean? Kind regards -- Andreas 'ads' Scherbaum

Re: [HACKERS] Status report on 8.3 release

2007-11-29 Thread Andreas 'ads' Scherbaum
another Beta, if we do something about this problem: http://archives.postgresql.org/pgsql-hackers/2007-11/msg00960.php Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group ---(end of broadcast)--- TIP

Re: [HACKERS] Status report on 8.3 release

2007-11-29 Thread Andreas 'ads' Scherbaum
On Fri, 30 Nov 2007 11:26:35 +1100 Brendan Jurd wrote: On Nov 30, 2007 11:10 AM, Andreas 'ads' Scherbaum [EMAIL PROTECTED] wrote: i would also like to test another Beta, if we do something about this problem: http://archives.postgresql.org/pgsql-hackers/2007-11/msg00960.php Hi Andreas

Re: [HACKERS] PG 7.3 is five years old today

2007-11-28 Thread Andreas 'ads' Scherbaum
On Tue, 27 Nov 2007 15:37:04 -0500 Tom Lane wrote: Andreas 'ads' Scherbaum [EMAIL PROTECTED] writes: On Tue, 27 Nov 2007 11:08:58 -0800 Joshua D. Drake wrote: Release 7.3.21 with and EOL addendum :). E.g; this is the last release of 7.3 and 7.3 is now considered unsupported. I know

Re: [HACKERS] PG 7.3 is five years old today

2007-11-28 Thread Andreas 'ads' Scherbaum
(and given the lack of back patches, should be too much of a burden in that time either) +1 for that. Kind regards -- Andreas 'ads' Scherbaum Failure is not an option. It comes bundled with your Microsoft product. (Ferenc Mantfeld) ---(end

Re: [HACKERS] PG 7.3 is five years old today

2007-11-27 Thread Andreas 'ads' Scherbaum
should not be the next and final release some days after the notice ;-) Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

Re: [HACKERS] quote_literal(integer) does not exist

2007-11-25 Thread Andreas 'ads' Scherbaum
On Sat, 24 Nov 2007 21:17:39 -0500 Tom Lane wrote: Andreas 'ads' Scherbaum [EMAIL PROTECTED] writes: we have some plpgsql functions which use quote_literal() regardless of the data type. With Beta 3 this does not work anymore[1]. If you're unwilling to fix your application, you can hack

Re: [HACKERS] quote_literal(integer) does not exist

2007-11-25 Thread Andreas 'ads' Scherbaum
with beta software so it needs an reinstall anyway after the release. Kind regards -- Andreas 'ads' Scherbaum PostgreSQL User Group Germany ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

[HACKERS] quote_literal(integer) does not exist

2007-11-24 Thread Andreas 'ads' Scherbaum
regards 1: http://archives.postgresql.org/pgsql-hackers/2007-08/msg00697.php -- Andreas 'ads' Scherbaum PostgreSQL User Group Germany ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ

Re: [HACKERS] New feature request: FlashBack Query

2007-02-19 Thread Andreas 'ads' Scherbaum
-- Andreas 'ads' Scherbaum German PostgreSQL Usergroup: http://www.pgug.de ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Problem with windows installer

2007-01-04 Thread Andreas 'ads' Scherbaum
-- Andreas 'ads' Scherbaum Failure is not an option. It comes bundled with your Microsoft product. (Ferenc Mantfeld) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail

[HACKERS] Problem with windows installer

2007-01-03 Thread Andreas 'ads' Scherbaum
a windows superuser - testing the same package/version on two different systems, one XP Home and one XP Pro, works without errors - and yes, some reboots Thanks in advance for your help -- Andreas 'ads' Scherbaum Failure is not an option. It comes bundled with your

Re: [HACKERS] Catch the commit

2005-07-04 Thread Andreas 'ads' Scherbaum
On Thu, 30 Jun 2005 00:06:42 +0200 Andreas 'ads' Scherbaum [EMAIL PROTECTED] wrote: is it possible in a module to receive an event, get a trigger fired, get a function called or something like this when the current transaction is about to be committed? Background: In a module (tablelog) i

[HACKERS] Catch the commit

2005-06-29 Thread Andreas 'ads' Scherbaum
-- Andreas 'ads' Scherbaum Failure is not an option. It comes bundled with your Microsoft product. (Ferenc Mantfeld) ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command