Today I will describe 2 new patches which modify psql:
Continue reading Waiting for 8.4 – psql vs. tabs + wrapped output
Today I will describe 2 new patches which modify psql:
Continue reading Waiting for 8.4 – psql vs. tabs + wrapped output
MySQL has this nifty/annoying feature/bug of special data type “TIMESTAMP". It is like a DATETIME, but it gets automatically updated whenever you modify the row.
I'll try to add the same feature to PostgreSQL.
PostgreSQL 8.3 brought us many great new features. Among them were concurrent autovacuum, enums, tsearch in core.
On of the changes though made a lot of people dislike 8.3. It was removal of implicit casts.
Continue reading “ERROR: operator does not exist: integer = text" how to fix it?
3 new functionalities from 3 people:
Today another two new additions to PostgreSQL – as You can see may commit-fest seems to work pretty good 🙂
Continue reading Waiting for 8.4 – RETURN QUERY EXECUTE and cursor_tuple_fraction
Today, we have 2 new changes in psql. One of them is not actually new feature, but I decided to write about it anyway, because of its implications.
Friend from my previous job asked this question: “What does success mean to You"?
One of the answers that I remember he got was:
“Get “brand recognition" of my name, and get a job with monthly salary of 40,000 PLN."
(I'm not sure if “brand recognition" is correct phrase – I mean that he wanted his name/person to be well known among people working in the same area as he is.
40,000 PLN – to give some perspective, is a bit over 10% of value of new Jaguar XK convertible (not XKR).
I would like to ask You, to tell me what does “success" mean to You. What would You have to achieve to feel successful.
Yesterday, Alvaro Herrera committed patch written by Pavel Stehule which adds generate_subscripts(…) function.
English disclaimer: this post will be in Polish only, as it's use for other nationalities is somehow limited 🙂
Continue reading Polish TSearch in 8.3 (polski tsearch w postgresie 8.3)
Tom Lane committed his patch which modifies output of “EXPLAIN VERBOSE" command.