Re: [HACKERS] Store data in pg_toast for custom type fails (bug?)

2014-04-22 Thread Honza
On 03/28/2014 07:02 PM, Tom Lane wrote: > I wrote: >> Honza writes: >>> after a months I've found a time to make test-case for this bug, probably: > >> Confirmed that this reproduces a problem on HEAD. Will look into it, >> thanks! > > I believe I u

[HACKERS] Store data in pg_toast for custom type fails (bug?)

2014-03-28 Thread Honza
Hi, after a months I've found a time to make test-case for this bug, probably: I've got my custom type and a table stores historical data of the main table. The problem occurs at our production servers, version 9.2.6. We've found it after our backups wasn't complete because of selection from "c

[HACKERS] PostgreSQL hackfest @ Developer Conference 2013, Brno, CZ

2013-01-09 Thread Honza Horak
don't forget your laptop. See the links for details: G+ hackfest event: https://plus.google.com/u/0/events/cqb5364p4377vd8lp6gvmqqtk6c DevConf web: http://www.devconf.cz/ DevConf schedule: http://developerconference2013.sched.org/ Contact person: Honza Horak (hho...@redhat.com) Feel fre

Re: [HACKERS] Ability to listen on two unix sockets

2012-07-11 Thread Honza Horak
On 07/02/2012 09:45 PM, Tom Lane wrote: Honza Horak writes: On 06/15/2012 05:40 PM, Honza Horak wrote: I realized the patch has some difficulties -- namely the socket path in the data dir lock file, which currently uses one port for socket and the same for interface. So to allow users to

Re: [HACKERS] Ability to listen on two unix sockets

2012-06-20 Thread Honza Horak
On 06/15/2012 05:40 PM, Honza Horak wrote: I realized the patch has some difficulties -- namely the socket path in the data dir lock file, which currently uses one port for socket and the same for interface. So to allow users to use arbitrary port for all unix sockets, we'd need t

Re: [HACKERS] Ability to listen on two unix sockets

2012-06-15 Thread Honza Horak
> On 06/13/2012 03:25 PM, Honza Horak wrote: > A draft patch is attached. It renames unix_socket_directory to > unix_socket_directories and allows to use directory:port to be able > to > create more sockets in one directory with different port number in > the > socket name.

Re: [HACKERS] Ability to listen on two unix sockets

2012-06-15 Thread Honza Horak
On 06/13/2012 03:25 PM, Honza Horak wrote: Going through the thread, I'd like to sum it up choosing approach with less potential issues and would like to find a consensus if possible. It seems unix_socket_directory could be turned into list and probably renamed to unix_socket_directories,

Re: [HACKERS] Ability to listen on two unix sockets

2012-06-13 Thread Honza Horak
configuration option, so it seems better to add a new configuration option to distinguish the primary listening port from additional ports. Regards, Honza -- 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] Ability to listen on two unix sockets

2012-06-13 Thread Honza Horak
ted with simply patching pg_config_manual.h, same as Debian does it already? For example, is there any piece of software, that simply rely on /tmp location of the socket and doesn't use libpg for the communication? Regards, Honza -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresq

Re: [HACKERS] Ability to listen on two unix sockets

2012-06-12 Thread Honza Horak
kets of various postmasters in the same directory. In that scenario every client should know which port to connect and also which one is primary. Regards, Honza -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] Ability to listen on two unix sockets

2012-06-07 Thread Honza Horak
Going back to the original problem (inaccessible /tmp directory), it is the case (2) -- a client uses the default path. So any additional client-side socket option won't probably help here, but we would probably need a second hard-coded path e.g. at /var/run/postgresql. Regards, Honza

Re: [HACKERS] Ability to listen on two unix sockets

2012-06-06 Thread Honza Horak
On 06/06/2012 04:50 PM, Andres Freund wrote: On Wednesday, June 06, 2012 04:38:42 PM Tom Lane wrote: Florian Pflug writes: If we're going to have this at all, we should go all the way and support an arbitrary number of sockets. Well, that's what I wanted to discuss before Ho

[HACKERS] Ability to listen on two unix sockets

2012-06-06 Thread Honza Horak
it's enough to have the location hard-coded? What are your opinions? Regards, Honza -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] ORDER BY different locales for 8.0

2005-04-19 Thread Honza Pazdziora
ED]> ftp://ftp2.zf.jcu.cz/users/zakkr/pg/ -- ---- Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/ .project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ... Only self-confident people can be si

Re: [HACKERS] Does psql use nested transactions?

2004-08-17 Thread Honza Pazdziora
exception you get, _continuing_ with your transaction. This way, large part of the application logic is shifted to the server and to the database schema. The client just tries if the command will run OK. -- ---- Honza Pazdziora |

Re: [HACKERS] Does psql use nested transactions?

2004-08-17 Thread Honza Pazdziora
, do update of the existing record It should be upto the application to decide if the failed insert should lead to abortion of the transaction, or if it should be silently ignored and based on the return value of the insert proceed with update. -- ---

Re: [HACKERS] Nested Transaction TODO list

2004-07-07 Thread Honza Pazdziora
or OTHERS. -- ---- Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/ .project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ... Only self-confident people can be simple. ---(end of

Re: [HACKERS] Adding VERSION to startup log output

2004-07-07 Thread Honza Pazdziora
mpt. Will the version information in log break anything? -- ---- Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/ .project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ...

Re: [HACKERS] Improving postgresql.conf

2004-06-09 Thread Honza Pazdziora
pecifying datadirectory in the configuration file, or even defaulting to the same directory where the .conf file is stored when no datadirectory option is used. -- ---- Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/

Re: [HACKERS] Improving postgresql.conf

2004-06-09 Thread Honza Pazdziora
ewhere else and in it the location of the data directory is specified. It does not mandate there will only be one cluster and it does not mean that each cluster cannot have completely different configuration file. -- ---- Honza

Re: [HACKERS] Refined LC_COLLATE or multiple database clusters?

2004-06-09 Thread Honza Pazdziora
ion instructions can be found at http://www.fi.muni.cz/~adelton/l10n/ -- ---- Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/ .project: Perl, mod_perl, DBI, Oracle, large Web s

Re: [HACKERS] PostgreSQL configuration

2004-04-09 Thread Honza Pazdziora
each and every setting in :-) I never used that "feature" so was never bitten by it. Anyway, Apache HTTP server seems to do it the right way, doesn't it? -- ---- Honza Pazdziora | [EMAIL PROTECTED] | http://w

Re: [HACKERS] PostgreSQL configuration

2004-04-08 Thread Honza Pazdziora
f configuration, or separate them in any way. -- ---- Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/ .project: Perl, mod_perl, DBI, Oracle, large Web systems, XML/XSL, ... Only self-confident people can be simple. ---(end of

Re: [HACKERS] locale

2004-04-08 Thread Honza Pazdziora
shouldn't it make elementary checks (upon startup, perhaps) that the current locale settings and the current locale version produces results compatible with the existing indexes? And if it does not, reindex? -- ---- Honza P

[HACKERS] Arbitrary collation support for PostgreSQL

2004-02-28 Thread Honza Pazdziora
distribution. I'd appreciate comments about the viability of the goal, name, and / or solution presented. Yours, -- ---- Honza Pazdziora | [EMAIL PROTECTED] | http://www.fi.muni.cz/~adelton/ .project: Perl, mod_perl, DBI,