Blog Archives

Script slicing by PgMDD

Preface November, 4th. Release Candidate 1 of Database Designer for PostgreSQL 1.2.9 become available. Among three changes comparing to the last beta there is the one which attracts attention — “Execute Script In Single Transaction (Alt + F9)” functionality added.

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

Simple Parse Tree

It was amazing cognac time and talking about parser with a good old college friend. E.g. to demonstrate how PostgreSQL analyses some queries. Statement SELECT field1 AS customer FROM “FooSchema”.”Bar” inside server’s brain will become: stmtmulti stmt SelectStmt select_no_parens simple_select

Tagged with: , , ,
Posted in Coding, PostgreSQL

Non-obvious ALTER statements are gone

Decided to read PostgreSQL 8.4 Release notes before going to sleep and was pleasantly surprised. The fact of ALTER statements mess (which I described in my post) is now fixed: Modify the ALTER TABLE syntax to allow all reasonable combinations

Tagged with: , , , ,
Posted in PostgreSQL

Metamorphosis of gram.y: 8.4 beta1

PostgreSQL 8.4 beta1 is out. Thus grammar will not be changed a lot I suppose. :) So I decided to update handy HTML version of native gram.y (revision 2.663). Details and tips on using processed file can be found in

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

Windows path in PostgreSQL statements

This article available in Russian. There are not so many statements which take filesystem path as an argument. Of the top of my head: CREATE TABLESPACE … CREATE FUNCTION … (in case of dynamic loading C-Language functions) So, the thing

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

Get every new post delivered to your Inbox.

Join 78 other followers