Blog Archives

Dump and restore of PostgreSQL: version compatibility FAQ

Many newbies are confused about how PostgreSQL dump and restore work. And even more questions appeared about version mismatches of the server itself and tools used. After fresh PostgresDAC release we’ve faced with the same questions. Utilities used for dump

Tagged with: , , ,
Posted in PostgresDAC, PostgreSQL

Development using Lazarus and PostgresDAC. Installation

Preface There are a lot of tools for PostgreSQL development. I want to propose you one more. Why Lazarus: Lazarus is shipped with open-source Pascal compiler; it has a high degree of Delphi compatibility; availability on a variety of platforms,

Tagged with: , , , ,
Posted in PostgresDAC

Do we need LIMIT clause in UPDATE and DELETE statements for PostgreSQL?

Was working with MySQL recently. Noticed that UPDATE command of it has special LIMIT clause which is really useful as for me, e.g. UPDATE `Product_download` SET `version`=’9.2.1′ WHERE `product_download_id`=367 LIMIT 1;

Posted in Polls, PostgreSQL

Number into words convertion in PostgreSQL

I was playing with some unit tests for PostgresDAC recently. And one test case was to check TPSQLDataset.Locate routine which allows partial-string and case-sensitive matching options. So I want to have some test result set with integer and text columns.

Tagged with: , ,
Posted in Coding, PostgresDAC

PGConf.EU 2012: My schedule

Well, I suppose it’s time to choose the most interesting talks to visit at PGConf.EU 2012. I sketched out a rough list. Wednesday, October 24 11:10 – 12:00 Writing a foreign data wrapper Bernd Helmle 12:10 – 13:00 MultiMaster Replication:

Tagged with: ,
Posted in PostgreSQL
Archives
Map of wandering
Follow

Get every new post delivered to your Inbox.

Join 73 other followers