7,004 reputation
31640
bio website
location Berlin, Germany
age 39
visits member for 2 years, 10 months
seen 26 mins ago

Nov
13
comment Problem using pg_dump in Windows 7
Have you tried doing this in two steps, first writing the pg_dump output into a file and then feeding it to psql? And an actual error message (which may even show the row number it originates from) would be more than handy.
Nov
12
comment How to manipulate join order of PostgreSQL optimizer?
Why would you do that? Without modifying the source code, you cannot achieve this.
Nov
12
comment Trigger or Stored Procedure?
While I agree with you, I have to add a con: with many of these triggers it will be very hard to follow what happens on a simple INSERT. I used to spend much time debugging funny behaviour, partly induced by my denormalization triggers.
Nov
12
comment EXECUTE within function not using index?
@francs Why would it be any different in an other client?
Nov
11
comment Does PostgreSQL have a variable character storage layer that optimizes storage space by automatic dedupe?
You mean bytes?
Nov
11
revised Postgresql doesn't accept replication connection
added 82 characters in body
Nov
11
comment Does PostgreSQL have a variable character storage layer that optimizes storage space by automatic dedupe?
There is no mechanism that will do this for you behind the scenes. However, you can normalize these data into two separate tables (purchased_name and purchased_description, for example) and have a foreign key in the original table referencing these two.
Nov
10
comment Postgresql cluster over nfs
Yeah, exactly that's the idea behind replication - to have a replica.
Nov
10
revised PostgreSQL roles versus users, grant permissions
added 266 characters in body
Nov
10
comment Does Postgres shutdown gracefully when I restart my Mac?
From the PostgreSQL logs, you will see how it is being shut down. Otherwise yes, it should close PostgreSQL nicely.
Nov
10
revised PostgreSQL: Creation date of a table
added 6 characters in body
Nov
8
comment Are PostgreSQL dynamic arrays more wasteful than plain text?
I think the most important thing here is the last sentence.
Nov
8
comment Error: /var/lib/postgresql/9.3/main is not accessible or does not exist
And what was the weird error message? How did you take the dump? Is your installation in the directory in the title?
Nov
7
comment Are PostgreSQL dynamic arrays more wasteful than plain text?
Exactly what do you mean by dynamic arrays? How do they differ from the usual arrays?
Nov
7
revised why pg_restore ignores --create ? Error: failed: FATAL: database “new_db” does not exist
deleted 10 characters in body
Nov
7
comment PostgreSQL: Creation date of a table
unfortunately, it won't work on 'plain' PostgreSQL as this view is a greenplum addition.
Nov
7
revised PostgreSQL: Creation date of a table
formatting
Nov
7
reviewed No Action Needed Change Data Types large Live table
Nov
7
reviewed Close Show only records with latest date by displaying ID once only
Nov
7
reviewed Close query to pull one row per id when multiple rows of each id exist in table