Skip to content

=$
|

  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 18
    • … PostgreSQL 17
    • … PostgreSQL 16
    • … PostgreSQL 15
    • … 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

Tag: databases

Designing database for storing human-human relations

Absolutely great post about designing database schema to contain information about marriages and partnerships with emphasis on changes brought to us by modern day – gay marriages, non-trivial sex/gender identities and polygamy.

Posted on 2008-11-22|Tags databases, gay, marriage, schema|1 Comment on Designing database for storing human-human relations

Waiting for 8.4 – generate_subscripts

Yesterday, Alvaro Herrera committed patch written by Pavel Stehule which adds generate_subscripts(…) function.

Continue reading Waiting for 8.4 – generate_subscripts

Posted on 2008-04-292019-05-15|Tags arrays, databases, generate_subscripts, pg84, postgresql, waiting|

Waiting for 8.4 – “EXPLAIN VERBOSE”

Tom Lane committed his patch which modifies output of “EXPLAIN VERBOSE" command.

Continue reading Waiting for 8.4 – “EXPLAIN VERBOSE"

Posted on 2008-04-182019-05-15|Tags databases, explain, pg84, postgresql, waiting|2 Comments on Waiting for 8.4 – “EXPLAIN VERBOSE”

waiting for 8.4 – current_query()

unfrotunatelly i can't point you to message in archives, as there is some problem with them, and i dont see posts newer than “Fri Apr 04 12:00:08 2008".

this patch was written by tomas doran, and commited by bruce momjian:

Continue reading waiting for 8.4 – current_query()

Posted on 2008-04-052019-05-15|Tags current_query, databases, pg84, plpgsql, postgresql, waiting|7 Comments on waiting for 8.4 – current_query()

waiting for 8.4

another very interesting addon. pavel stehule wrote, and tom lane commited “execute using" in plpgsql.

Continue reading waiting for 8.4

Posted on 2008-04-022019-05-15|Tags databases, execute, pg84, plpgsql, postgresql, waiting|5 Comments on waiting for 8.4

waiting for 8.4

in today “waiting for 8.4" i will show you 3 new patches. all of them add new functionality to psql – the most common tool to access postrgesql database.

Continue reading waiting for 8.4

Posted on 2008-03-312019-05-15|Tags databases, pg84, postgresql, psql, waiting|1 Comment on waiting for 8.4

waiting for 8.4

another new, cool feature commited by tom lane: “Support statement-level ON TRUNCATE triggers."

original patch was submitted by simon riggs, and tom commited it today/yesterday (depending on time zone).

Continue reading waiting for 8.4

Posted on 2008-03-282019-05-15|Tags databases, pg84, plpgsql, postgresql, sql, triggers, truncate, waiting|4 Comments on waiting for 8.4

Search

Follow me

  • Comments RSS
  • Posts RSS

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 18
    • … PostgreSQL 17
    • … PostgreSQL 16
    • … PostgreSQL 15
    • … 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