Re: [PATCHES] [PATCH] fix for pg_stat_database (numbackends is always

Petr Jelinek wrote: This patch fixes pg_stat_database which is broken since this commit: http://archives.postgresql.org/pgsql-committers/2005-05/msg00126.php Neilc forgot to add new db entry inicialization to pgstat_recv_bestart() when he removed it from pgstat_add_backend() function

[PATCHES] per user/database connections limit again

. -- Regards Petr Jelinek (PJMODOS) diff -Nacr my-cvs/src/backend/commands/dbcommands.c my-aproach2/src/backend/commands/dbcommands.c *** my-cvs/src/backend/commands/dbcommands.cSun Jun 26 00:47:30 2005 --- my-aproach2/src/backend/commands/dbcommands.c Tue Jun 28 11:26:08 2005

Re: [PATCHES] per user/database connections limit again

with roles is attached (diffed against cvs), everything else is mostly same. I also had to readd roleid to flatfiles because I need it in InitProcess() function. -- Regards Petr Jelinek (PJMODOS) Index: src/backend/commands/dbcommands.c

Re: [PATCHES] per user/database connections limit again

verification) -- Regards Petr Jelinek (PJMODOS) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [PATCHES] per user/database connections limit again

depends partly on roles doc so it will prolly have to wait. I also added limit to pg_roles and pg_shadow views when I was patching pg_dump so you can get it from them. -- Regards Petr Jelinek (PJMODOS) Index: src/backend/catalog/system_views.sql

Re: [PATCHES] per user/database connections limit again

? Yeah I have no problem with LIMIT CONNECTIONS, will you change it or should I do it ? btw where has new keyword to be added to not be added at a fairly unreserved level ? (MAX is also added to keywords.c in that patch) -- Regards Petr Jelinek (PJMODOS) ---(end

Re: [PATCHES] per user/database connections limit again

. -- Regards Petr Jelinek (PJMODOS) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [PATCHES] per user/database connections limit again

Here is promised documentation. Be warned that both my writing skills and my english are far from good :) -- Regards Petr Jelinek (PJMODOS) Index: doc/src/sgml/catalogs.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml

Re: [PATCHES] per user/database connections limit again

Peter Eisentraut wrote: GUC supports per-user/per-db values. We already had discussion here about GUC for this and we agreed that catalog change is better than new GUC variable in this case. -- Regards Petr Jelinek (PJMODOS) ---(end of broadcast

Re: [PATCHES] [HACKERS] Proposed patch to getaddrinfo.c to support

Dave Page wrote: It, or some related patch appears to have broken the build on buildfarm member snake. I haven't had time to investigate. /D Atached patch fixes it and also adds proper gai_strerror for windows. (It's patch against CVS *after* Chucks patch was aplied) -- Regards Petr

Re: [PATCHES] [HACKERS] Proposed patch to getaddrinfo.c to support

not familiar with build system so somebody else will have to do it (I am not familiar with whole configure thingy at all). With those changes it should finally work. -- Regards Petr Jelinek (PJMODOS) ---(end of broadcast)--- TIP 4: Have you searched our list

Re: [PATCHES] [HACKERS] Proposed patch to getaddrinfo.c to support

Looks ok, i don't know what IPv4 has to do with all of this though. -- Regards Petr Jelinek (PJMODOS) ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [PATCHES] [HACKERS] Proposed patch to getaddrinfo.c to support

and HAVE_STRUCT_ADDRINFO always defined under windows because I am not familiar with configure and thats why I haven't sent patch). -- Regards Petr Jelinek (PJMODOS) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http

Re: [PATCHES] [HACKERS] Proposed patch to getaddrinfo.c to support

locale because with initdb --no-locale it passes without prob). So I hope IPv6 episode is finally over :) -- Regards Petr Jelinek (PJMODOS) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http

Re: [PATCHES] force C locale for temp regression installations

with --no-locale Output from make cheks are at http://pjmodos.parba.cz/pgsql/locale/ and http://pjmodos.parba.cz/pgsql/no-locale/ (it's same as loris, I posted it just as evidence that --no-locale fixes all failures) -- Regards Petr Jelinek (PJMODOS) ---(end of broadcast

[PATCHES] Add chklocale.c to msvc build

Hi, attached patch adds chklocale.c to pgportfiles in Mkvcbuild perl module (not really worth the .diff :)) This fixes MSVC build (see buildfarm errors with unresolved reference for _pg_get_encoding_from_locale). -- Regards Petr Jelinek (PJMODOS) Index: Mkvcbuild.pm

[PATCHES] ALTER TYPE RENAME

for this but not in AlterTypeNamespace so I don't know). -- Regards Petr Jelinek (PJMODOS) Index: doc/src/sgml/ref/alter_type.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/alter_type.sgml,v retrieving revision 1.4 diff -c -r1.4 alter_type.sgml

Re: [PATCHES] ALTER TYPE RENAME

wouldn't want to forbid it. But if we provide ALTER TYPE RENAME then consistency would suggest requiring people to use that for composite types. I assume ALTER TYPE RENAME should rename associated relation too, then. -- Regards Petr Jelinek (PJMODOS) ---(end of broadcast

Re: [PATCHES] ALTER TYPE RENAME

a little cleanup in those functions (removed unused code and changed some hardcoded relkind types to globaly predefined constants) - RenameType now calls RenameRelationInternal for composite types (which calls RenameTypeInternal automatically) Any other comments ? -- Regards Petr Jelinek (PJMODOS