IsEven or IsEvenER?

Recently friend of mine sent me a funny picture:

IsEven on Java
IsEven on Java

Cool, ha?!

Continue reading “IsEven or IsEvenER?”

Advertisements

Hackers and Bugs lists migration and GMail’s filters

Hackers and Bugs are heavy loaded lists. So it’s wise to turn notification off for them. This may be done using Gmail’s filters. “Mark as Read” is the key to success.

Filters looking for terms in Subject
Filters looking for terms in Subject

Yesterday I began to receive strange notifications on my phone from GMail. First was from Stephen Frost, then from Tatsuo Ishii and so on.

I was sure that unlikely all these good people were mailing to me directly, so I opened my mail client to throw some light on the situation.

The letter from Stephen explained what is happening – pgsql-hackers and pgsql-bugs mailing lists migrated to a new software known as ‘PGLister’. You may find all details following this link https://wiki.postgresql.org/wiki/PGLister_Announce.

The “Subject:” header will no longer be changed to include the name of the list (for example, “[HACKERS]”).

Aha, I see now. So my filters are not working anymore. Time for changes.

If you filter your email based on those “Subject:” header insertions, you will need to adjust your filtering rules. We recommend looking at the industry standard “List-ID:” header instead.

You should use “list: pgsql-hackers.lists.postgresql.org” in “Has the words” field now.

Use "list: " operator instead
Use “list: ” operator instead

Then apply some labels, mark as read and, of course, never send it to Spam!

2017-11-14 09_43_41-Search results - pavel.golub@gf.microolap.com - Microolap Mail
Apply some actions

Database Designer for PostgreSQL 1.12.1 is out

PgMDD boxDatabase Designer for PostgreSQL is an comprehensive CASE tool which works natively under Windows OS family and Linux under Wine/WineHQ allowing you to

  • build a clear and effective database structure visually,
  • see the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects,
  • easily generate a physical database on a server,
  • modify it according to any changes you made to the diagram using fast ALTER statements,
  • import already existing diagram from the server,
  • export diagram to the common graphic formats or as SQL script,
  • create detailed printings and reports.

This maintenance release fixes bug with sequence Reverse Engineering and introduces support for PostgreSQL 10.1 minor release.

Download

You’re welcome to download the Database Designer for PostgreSQL 1.12.1 right now at: http://microolap.com/products/database/postgresql-designer/download/

Feedback

Please don’t hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/

Full changelog:

[!] Support for PostgreSQL 10.1 added
[+] "Report bug" functionality added to detailed error dialog
[-] "Column 'min_value' does not exist" Reverse Engineering error fixed

Serial-Identity mix

Serial-identity
Serial-identity
As you probably know PostgreSQL 10 introduced IDENTITY columns. They are pretty much like serial columns from the first sight. To learn about differences one may refer to the perfect blog post by Peter Eisentraut.

So I was wondering what if I mix some serial with some identity. So I executed such simple query:

CREATE TABLE foo(
id SERIAL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY
);

Of course, I got an error:

ERROR: both default and identity specified for column "id" of table "foo"
SQL state: 42601

“SQL state: 42601” stands for a syntax error. But the interesting thing is that SERIAL, as you know, converted to CREATE SEQUENCE and SET DEFAULT.

So now I know what exactly the reason of error. You cannot have both DEFAULT and IDENTITY for a column.

MicroOLAP Database Designer meets PostgreSQL 10!

PgMDD boxDatabase Designer for PostgreSQL is an comprehensive CASE tool which works natively under Windows OS family and Linux under Wine/WineHQ allowing you to

  • build a clear and effective database structure visually,
  • see the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects,
  • easily generate a physical database on a server,
  • modify it according to any changes you made to the diagram using fast ALTER statements,
  • import already existing diagram from the server,
  • export diagram to the common graphic formats or as SQL script,
  • create detailed printings and reports.

This release introduces preliminary support for PostgreSQL v10.

A huge amount of internal and architecture tasks were done either. Updated visual controls used as well as new exception tracer introduced.

Several new sample models were added: “USDA Food database”, “Chinook” and “AdventureWorks for Postgres”. There are many changes and bug fixes.

This slideshow requires JavaScript.

Download

You’re welcome to download the Database Designer for PostgreSQL 1.12.0 right now at: http://microolap.com/products/database/postgresql-designer/download/

Feedback

Please don’t hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/

Full change log:

  • [!] SQL Executor and Validator support v10.0 grammar now
  • [+] “AdventureWorks for Postgres” model added as sample
  • [+] “Font Color” options added to Display Preferences
  • [+] “Font Color” options added to object editors
  • [+] “Quote Default value” option added for Domain editor
  • [+] Chinook database model added as sample
  • [+] macaddr8 type support added
  • [+] New detailed error dialog introduced for Reverse Engineering
  • [+] PARALLEL option added for stored routines
  • [+] PL/sh procedural language support added
  • [+] PL/v8 procedural language support added
  • [+] SQL keywords are properly highlighted according to 10.0 version
  • [+] USDA Food database model added as sample
  • [*] “Execution interrupted by user” error dialog replaced
  • [*] “Modify process interrupted by user” message box added
  • [*] Copyright info label updated
  • [*] Improved main window position and state restoring for maximized state
  • [*] Old unfancy loader removed
  • [*] Reverse Engineering respects role permissions on sequences now
  • [*] Splash screen updated
  • [-] “‘Rules…’ pop-up menu doesn’t work for tables on diagram” bug fixed
  • [-] “Comments not displayed for views on diagram” bug fixed
  • [-] “Domains with time and timestamp base types were reversed with 0 type modifier, e.g. time(0)” bug fixed
  • [-] “EConvertError during time out for SSH connection” bug fixed
  • [-] “ERangeError after applying some colors to model background” bug fixed
  • [-] “Most Recent Used list of files for Access Import is empty after restart” bug fixed
  • [-] “Rare EAccessViolation during renaming references in the Reference Manager” bug fixed
  • [-] “Some views and stored routines need to be redrawn after Reverse Engineering by Redisplay menu” bug fixed
  • [-] “Universal Reverse Engineering returns empty model for sources with schemas” bug fixed

PostgresDAC 3.3.0 meets PostgreSQL 10!

Microolap Technologies is pleased to announce the availability of PostgresDAC 3.3.0.

PostgresDAC 3.3.0 introduces support for PostgreSQL 10 – a major new version of the world’s most advanced Open Source database.

Full change log:
[!] v10.0 client libraries added
[!] v10.0 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
[!] PostgresDAC components are enabled on IDE Component pallette for all platforms from now
[+] doNoPublications option added to TPSQLDump.Options
[+] doNoSubscriptions option added to TPSQLDump.Options
[+] doNoSync option added to TPSQLDump.Options
[+] roNoPublications option added to TPSQLRestore.Options
[+] roNoSubscriptions option added to TPSQLRestore.Options
[-] Сrash fixed in TPSQLRestore when using parallel mode and using a list file to select a subset of items

You’re welcome to download the PostgresDAC v3.3.0 right now at:
http://microolap.com/products/connectivity/postgresdac/download/
or login to your private area on our site at
http://microolap.com/my/downloads/