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

Aug
13
comment PostgreSQL: Trigger for updating view doesn't work
Could you please include the view definition?
Aug
11
comment Matching array values in PostgreSQL with ActiveRecord
It should not be an array if you want to store a single value. Change to array: false.
Aug
11
comment Importing PostgreSQL backup into slightly different database
If you are lucky enough, you have the diff from the old schema to the new one at hand. Do the restore as @Craig said and apply the diff.
Aug
1
comment Can a connection's prepared statements be altered by Postgres's admin functionality?
@a_horse_with_no_name It is definitely not possible. The background is that each connection has its own process, which cannot be modified from the outside.
Jul
31
comment How to count all relationships in a database?
@blobbles please edit your answer with the WHERE clause.
Jul
31
comment How to count all relationships in a database?
@RumiP. then you may want to elaborate on your specification :)
Jul
31
comment How to count all relationships in a database?
msdn.microsoft.com/en-us/library/ms179987.aspx for the foreign keys
Jul
30
comment Index that is not used, yet influences query
I think the planner does not take the value of work_mem into account. If you raised it so that the sort fits into memory, if would still use the same plan. Let me note here that the time difference (most of it) comes from the external disk sort.
Jul
30
comment Full Text Search With PostgreSQL
Some explanation could probably repel downvotes.
Jul
26
comment PostgreSQL user can not connect to server after changing password
For the pg_hba.conf to take effect, you need only a reload, not a restart. Furthermore, your suggestion looks incomplete as it is not clear how it would solve the issue in the end.
Jul
25
comment Why is my composite index not used for this table?
@Thomas the sequential scan runs through the whole table. As it is very fast, it would make no sense to go to the index. At least I guess this is what the planner is thinking :) depending on your DB version, probably changing SELECT * to the three indexed columns, you'd see the index being used.
Jul
24
comment Should one always VACUUM ANALYZE before REINDEXing in PostgreSQL 8.4?
Does anything prevent you from upgrading to 9.3? Otherwise, I don't remember 8.4 too much, but can it be that the sizes differ only because the table was not analyzed recently? I'd check (if possible) if after a plain ANALYZE the reported size decreases, too.
Jul
24
comment Custom personal monitor sql by writing the .psqlrc file
try \set v_scpname '\'tbs_skypcsuit_idx\''
Jul
22
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.
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
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.