6,890 reputation
31439
bio website
location Berlin, Germany
age 38
visits member for 2 years, 9 months
seen 23 hours ago

Jul
22
revised Conditionally sum a column based on a mod result
deleted 40 characters in body
Jul
22
comment Conditionally sum a column based on a mod result
What do you exactly mean by 'merge'?
Jul
18
comment Promotion of PostgreSQL standby and application reconnection
@a_horse_with_no_name I guess you should write up an answer with this.
Jul
17
comment PostgreSQL/ Linux, way to have DNS forward to a port/cluster?
iptables. But it certainly would help if you clarified your needs a bit further.
Jul
17
comment Primary key with randomly varying increments (so it cannot be guessed easily)
If it may be a problem if users can guess IDs, you should seriously reconsider your design. A random increment may be easily overcome by a bot that is diligent enough in guessing.
Jul
15
comment Index for finding an element in a JSON Array in PostgreSQL (with multiple JSON fields)
Could you actually provide an example where you get back the wrong row?
Jul
15
revised On Heroku in production, how can I copy database A to database B on command?
edited tags
Jul
13
revised Connect to PgAdmin III via localhost
edited tags
Jul
13
revised database normalization to 3NF
edited tags
Jul
13
revised database normalization to 3NF
rolled back to a previous revision
Jul
13
revised database normalization to 3NF
rolled back to a previous revision
Jul
13
comment Limiting read access in postgres to few rows
@klin You definitely can. Our application users are only able to call functions, they have no direct access to any table. The functions are defined with SECURITY DEFINER by a suitable user.
Jul
12
comment How to configure pgmodeler?
Is your DB up and running at all?
Jul
11
answered Update new column with value from old columns for all the rows
Jul
11
comment Pgpooladmin pcp commands does not work
It clearly says AuthorizationError. Are you sure you give the right password (compared to pcp.conf)?
Jul
11
revised What is the meaning of different roles available(DB Admin etc.)
added 7 characters in body; edited tags
Jul
11
comment Is there a way I can use currval() without selecting it more than once?
Thanks, I keep forgetting about lastval()...
Jul
10
comment Recursive calls in stored procedure and temporary tables
Alternatively, one can simply check if the table exists and create it only if necessary. Of course, all depends on if the data inserted from the outer calls should persist for the inner calls or not.
Jul
10
answered Organizing Database Objects in a Database that are not part of the systems original Database Objects?
Jul
10
answered How to log DML statements executed by a pl/pgsql function?