Holiday discounts on pgmdd & postgresdac

Ded MorozHolidays came suddenly. I know we’re little bit late with Christmas presents, but who cares anyway!

Everybody is welcome to use “Christmas” coupon code till January 14 for 20% discount on any product from MicroOLAP Technologies including the most robust Database Designer for PostgreSQL and PostgresDAC component suite.

From all of us at MicroOLAP, we wish you happy holidays and a prosperous new year!

Extended trial for PgMDD

For all blog readers and @microolap followers! You may use special registration code to extend trial period for MicroOLAP Database Designer for PostgreSQL for two months. Just use in the registration window:

  • login: Blog Reader
  • key: 019TNG-A0EWBC-GKDNPG-9FW9HM-KU0RZC-GHN2K2-GGD0C0-55DJ38-6EG6WP-NX6K05

Thank you for using MicroOLAP Database Designer for PostgreSQL!
http://microolap.com/products/database/postgresql-designer/

@microolap

So, guys! You may follow @microolap on Twitter for the latest updates!

We have ignored this service for too long, but the time has come!

We will use such hashtags:

PgMDD: How to RETURNS TABLE

Our client asked:

I have a script that can be created directly from PgAdmin, but it is not possible to create these scripts in PgMDD.

The function has a simple structure as defined below. The important part, is the return type (TABLE)

CREATE FUNCTION function_name() RETURNS TABLE(column_name_1 integer, column_name_2 character varying)
AS
BEGIN
RETURN QUERY (SELECT id, name FROM customer);
END;

PgMDD does not allow you to to that.

Yeap, indeed PgMDD doesn’t support ANSI syntax RETURNS TABLE, but you may do this in PostgreSQL way by using OUT parameters.

There is a good article “Using RETURNS TABLE vs. OUT parameters” by Leo Hsu and Regina Obe describing this approach.

So this function may be defined like this using PgMDD:

CREATE FUNCTION function_name(
  OUT column_name_1 integer,  
  OUT column_name_2 character varyingRETURNS SETOF RECORD
AS
$BODY$
   RETURN QUERY (SELECT id, name FROM customer);
$BODY$;

PgMDD-1.8.0: How to use old connection profiles

Our client asked:

I lost every previously defined connection setup!! (from previous versions of MicroOLAP Database Designer for PostgreSQL)

Yes, since new release of PgMDD stores all information in Unicode we didn’t implement import of connection data from old ANSI profiles by default. We want to keep them intact.

And now we’ve added import functionality for the Connection manager. All you need to do to have all your defined connections is:

  1. Click Import button;
  2. Choose profiles.xml file.

Enjoy!