6,424 reputation
31436
bio website
location Berlin, Germany
age 38
visits member for 2 years, 5 months
seen 2 hours ago

3h
answered Will insert and update query wait while a table is being vacummed?
5h
awarded  Popular Question
19h
comment Conditionally sum a column based on a mod result
Just a tip for the future: it is much easier to understand queries if you use meaningful table aliases. Also, when asking questions here it may make sense to translate the table names you mention into English. Furthermore (I cannot be sure as I don't speak Portuguese) usually there is no sense in using abbreviations and/or acronyms for table and column names. In PostgreSQL, you have 63 characters for naming your stuff, it is very rare when it is not enough.
19h
revised Conditionally sum a column based on a mod result
deleted 40 characters in body
19h
comment Conditionally sum a column based on a mod result
So, you don't need to express your opinion if you cannot do it in a polite manner. Also, it is usually better to wait until the OP clarifies their intent.
22h
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