Skip to content

=$
|

  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 14
    • … PostgreSQL 13
    • … PostgreSQL 12
    • … PostgreSQL 11
    • … PostgreSQL 10
    • … PostgreSQL 9.6
    • … PostgreSQL 9.5
    • … PostgreSQL 9.4
    • … PostgreSQL 9.3
    • … PostgreSQL 9.2
    • … PostgreSQL 9.1
    • … PostgreSQL 9.0
    • … PostgreSQL 8.5
    • … PostgreSQL 8.4
  • Projects
  • Contact

Month: June 2008

Conditional DDL?

Every now and then I see people ask the question – how to create table if it doesn't exist yet, how to drop it, but only if it does exist and so on.

Well, starting from 8.2 dropping should be not a problem anymore. But what about create? Alter?

Let's try to do it…

Continue reading Conditional DDL?

Posted on 2008-06-18|Tags conditions, ddl, functions, plpgsql, postgresql, sql|7 Comments on Conditional DDL?

Waiting for 8.4 – timing on/off

Yes, finally! David Fetter wrote, and Heikki Linnakangas committed patch which adds on/off arguments to \timing:

Continue reading Waiting for 8.4 – timing on/off

Posted on 2008-06-112019-05-15|Tags pg84, postgresql, psql, waiting|7 Comments on Waiting for 8.4 – timing on/off

pgsql-tools/analyze.pgsql.logs.pl

Changes:

  1. normalize PREPARE … statements
  2. normalize DEALLOCATE … statements

SVN repo at: http://svn.depesz.com/svn/pgsql-tools/trunk

Posted on 2008-06-08|Tags announcements|

pgsql-tools/analyze.pgsql.logs.pl

Changes:

  1. properly handle cases where non-LOG: lines contain “\n"

SVN repo at: http://svn.depesz.com/svn/pgsql-tools/trunk

Posted on 2008-06-07|Tags announcements|

Search

Follow me

  • Comments RSS
  • Posts RSS

Popular Posts

  • Starting with Pg – where/how can I set configuration parameters? 528 views | 0 comments
  • Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses 370 views | 0 comments
  • Explaining the unexplainable – part 3 189 views | 0 comments
  • CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT – UPDATED 2010-03-03 181 views | 0 comments
  • Explaining the unexplainable – part 2 164 views | 0 comments
  • Why is UPSERT so complicated? 111 views | 0 comments
  • “ERROR: operator does not exist: integer = text” how to fix it? 91 views | 0 comments
  • Waiting for PostgreSQL 11 – Fast ALTER TABLE ADD COLUMN with a non-NULL default 91 views | 0 comments
  • Fixed display of Backward scans on explain.depesz.com 85 views | 0 comments
  • explain.depesz.com. 83 views | 0 comments

PostgreSQL

  • Documentation
  • Explain Analyze analyzer
  • IRC help channel
  • Mailing Lists search
  • PG Planet
  • PostgreSQL Home Page

About me

  • CPAN
  • GitLab
  • Linked In
  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 14
    • … PostgreSQL 13
    • … PostgreSQL 12
    • … PostgreSQL 11
    • … PostgreSQL 10
    • … PostgreSQL 9.6
    • … PostgreSQL 9.5
    • … PostgreSQL 9.4
    • … PostgreSQL 9.3
    • … PostgreSQL 9.2
    • … PostgreSQL 9.1
    • … PostgreSQL 9.0
    • … PostgreSQL 8.5
    • … PostgreSQL 8.4
  • Projects
  • Contact