Blog Archives

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

PG 9.2beta2 installation on Windows XP fails? Don’t worry!

Shit happens guys. And sometimes PostgreSQL windows installer fails. Now I’m talking about EnterpriseDB One-Click Installer for PostgreSQL 9.2beta2 particularly. As for me, I got “An error occurred executing the Microsoft VC++ runtime installer” message. Strange. I have a holy

Tagged with: , ,
Posted in PostgreSQL

The tale of how PostgresDAC became the cross-platform component suite

As some probably know Delphi XE2 now have compilers for Win32, Win64, Mac and iOS. And as you probably guessed, we were inundated with questions from our customers about support for this zoo in our DACs. Frankly speaking this situation

Tagged with: , , , , ,
Posted in PostgresDAC, PostgreSQL

LibreOffice announces native support for PostgreSQL

Today I found out about new release of LibreOffice (version 3.5), which is now my choice instead of MS Office and it’s brother OpenOffice killed by Oracle. And the most pleasant surprise is PostgreSQL native support added in this minor

Tagged with: , , ,
Posted in PostgreSQL

Factorial using CTE in PostgreSQL

Not so long ago I used Common Table Expressions for Fibonacci Numbers calculation. Today I had a conversation with one client about SQL in general and about PosgreSQL dialect in particular. We talked about SQL’s Turing completeness also. Well my

Tagged with: , , , , ,
Posted in Coding, PostgreSQL

Joomla! 2.5 with PostgreSQL support officially released

Joomla, one of the world’s most popular open source content management systems (CMS) used for everything from websites to blogs to Intranets, today announces the immediate availability of Joomla 2.5. Along with new features such as advanced search and automatic

Tagged with: , , , ,
Posted in Announces, PostgreSQL

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
Archives
Map of wandering
Follow

Get every new post delivered to your Inbox.

Join 78 other followers