Blog: Pavel Stehule

208 blogs updated: 75 min. ago
New version of PLpgSQL_check
Hi I released new version of plpgsql_check. Some bugs are fixed. There are new extra warnings related to function arguments and PostgreSQL 1...
31-05-2017 10:00:29 Pavel Stehule PostgreSQL
Orafce and plpgsql_check are ready for PostgreSQL 10
Small note: All regress tests of and passed on PostgreSQL 10.
10-04-2017 21:10:19 Pavel Stehule PostgreSQL
How to find unindexed foreign keys
Often performance issue is missing index on foreign keys. With few queries is very simple to find foreign keys without index: Create a demo:...
09-04-2017 08:18:20 Pavel Stehule PostgreSQL
new command line tool pgimportdoc
More, more times I had to import some XML documents to Postgres. How do it simply? More, some XML documents are not in UTF8 encoding, so som...
20-02-2017 09:31:52 Pavel Stehule PostgreSQL
OpenERP configuration
I had a customer with strange issues of OpenERP - the main problem was long life of OpenERP/PostgreSQL sessions. The fix was not hard - usin...
23-12-2016 21:25:07 Pavel Stehule PostgreSQL
Orafce package for PostgreSQL 9.3, 9.4, 9.5, 9.6 for WIN32, WIN64 is available
Please, download from link.
27-08-2016 08:40:49 Pavel Stehule PostgreSQL
XMLTABLE implementation is done
I finished the patch for XMLTABLE in PostgreSQL. It is working well. Examples what I found on net works: postgres=# SELECT, x.* FROM em...
21-08-2016 10:50:12 Pavel Stehule PostgreSQL
Prototype of XMLTABLE function is done
The parsing of XML is not simple in Postgres. For more complex data I prefer external procedures in PLPerlu or PLPythonu based on usage of X...
07-08-2016 12:32:31 Pavel Stehule PostgreSQL

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.