Reputation
11,829
Next tag badge:
686/1000 score
213/200 answers
Badges
7 32 55
Newest
 Revival
Impact
~590k people reached

Feb
4
revised Is there any point with a combined index on all columns in a table?
edited body
Feb
4
answered Is there any point with a combined index on all columns in a table?
Feb
4
comment Creating index using dynamic SQL
Please check what the format() function does and use it. Gives a much cleaner feeling.
Feb
4
revised Creating index using dynamic SQL
added 112 characters in body
Feb
4
revised Trigger for removing group with no users left in
added 1036 characters in body
Feb
4
comment Execute system commands in postgresql
Please note that this can also only be run with superuser rights (or using SECURITY DEFINER).
Feb
4
revised Execute system commands in postgresql
added 18 characters in body
Feb
4
revised How to verify disk hit by a query
added 26 characters in body; edited tags; edited title
Feb
4
answered Execute system commands in postgresql
Feb
3
comment How to estimate reindexing time?
You can possibly try one index - check its size, REINDEX with measuring the time needed. Then calculate the total size of your indexes and do some math.
Feb
3
comment Fatal error when not numeric value - PostgreSQL 9.2
I am wondering if this query can produce that error. You mention an UPDATE in your first sentence - where is it?
Feb
3
comment Trigger for removing group with no users left in
What you say is also an option, in some cases it might be even better. Care to post it as an answer? Re: the mutating table problem you can prevent from happening by tracking trigger depth, in newer versions. What's more, the table to be changed is different from the one the trigger is defined on.
Feb
3
revised Trigger for removing group with no users left in
added 18 characters in body; edited title
Feb
3
answered Trigger for removing group with no users left in
Feb
3
revised Stored procedure vs transaction anomaly
added 66 characters in body; edited title
Feb
3
comment Stored procedure vs transaction anomaly
What is the autocommit setting (I guess you connect to the DB using JDBC)?
Feb
3
revised Foreign key for array column
added 98 characters in body
Feb
3
revised Is it important to make transaction log backups?
added 15 characters in body; edited tags
Feb
3
revised Plpgsql (Postgres) function for sanity check
added 19 characters in body
Feb
3
comment Plpgsql (Postgres) function for sanity check
'The rows are not allow to be 0' - what exactly cannot be 0? or NULL, maybe?