Blog Archives

Get PostgreSQL sources using SVN

As you probably know PostgreSQL sources are managed by Git version control system. Which is great, but for me as SVN user it would be much better to get access to the sources using familiar tools, e.g. TortoiseSVN. Mainly because

Tagged with: , , , ,
Posted in Coding, 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

Backward compatibility? Never heard of it!

Playing with fresh PostgreSQL 9.2beta2 I cannot find spclocation column of a system catalog pg_tablespace. First my thought was that I’m too tired. But then I found mentioning about this at pgsql-hackers by Magnus Hagander: And IIRC, we don’t actually

Tagged with: , , ,
Posted in PostgreSQL

Engineering Management: Why are software development task estimations regularly off by a factor of 2-3?

Found the greatest post ever about development planning. That’s why I do not prefer long terms plans.

Tagged with: ,
Posted in General

Why you cannot create table and PK constraint with the same name

Very interesting message appeared on the pgsql-bugs@postgresql.org list today: When I do this CREATE TABLE “T1″ ( “T1_ID” bigint NOT NULL, CONSTRAINT “T1″ PRIMARY KEY (“T1_ID” ) ); I get the following message: NOTICE: CREATE TABLE / PRIMARY KEY will

Tagged with: , , , ,
Posted in PostgreSQL

PostgresDAC meets Delphi XE2

We here, in MicroOLAP, have conducted tests of the new Embarcadero RAD Studio XE2. And with the all responsibility we may say that PostgresDAC is ready for use with it.

Tagged with: , , , ,
Posted in PostgresDAC

Delete tuple from libpq’s PGresult

I wrote how to modify result set in underlying libpq’s PGresult object with new ones. But there was no solution for deletion. Here I want to propose one solution. The main idea is to copy existing PGresult content to the

Tagged with: , , , , , ,
Posted in Coding, PostgresDAC
Archives
Map of wandering
Follow

Get every new post delivered to your Inbox.

Join 78 other followers