Blog Archives

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

Very interesting message appeared on the 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 2.6.1 Beta 2 is available

Attention should be paid to specific PostgreSQL 9.0.2 features testing especially dump and restore functionality including updated 8.4.6 libraries. Bug with bytea hex representation in PostgreSQL 9.x branch fixed. You’re welcome to download the PostgresDAC v2.6.1 Beta 2 right now

Tagged with: , , , , ,
Posted in PostgresDAC

PgMDD 1.2.11 released

Due to hidden bug found in internal SQL parser there is hotfix available. Bug reveals itself during executing CREATE FUNCTION statements using SQL Executor in pre-validation mode “Execute SQL (F9)”. It is still possible to execute such statements using “Execute

Tagged with: , ,
Posted in MicroOLAP Database Designer for PostgreSQL

Oops! We did it again… PgMDD 1.2.9a

Due to nasty bug found in Database Designer for PostgreSQL 1.2.9 there is 1.2.9a hotfix available. You may re-download the full installation package from Database Designer Download page. This bug may reveal itself during script execution. Sorry for inconveniences!

Tagged with: , ,
Posted in MicroOLAP Database Designer for PostgreSQL
Map of wandering

Get every new post delivered to your Inbox.

Join 456 other followers