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

Sep
12
comment Run and Save multiple SELECT statements
Also worth noting that from within a function (if it is really needed in this case) one cannot split the output to separate files (well, no file handling at all, unless one goes pl/python or something). A function has only one result set, regardless how many statements produce the output.
Sep
12
comment Suppression of statement in Postgresql logging
You have an option to log your stuff in CSV format. In that case, these two appear in one row (the format is more verbose, though).
Sep
11
comment Permission denied when importing a database
Apparently, you don't have access to the file with the DB dump. Can you open it in an editor?
Sep
11
comment Use cases for hstore vs json datatypes in postgresql
@ckarbass Thanks for the input. If you check the question history, the version that triggered my comment was very different from the present one.
Sep
3
comment Disable all constraints and table checks while restoring a dump
I am wondering, AFAIK there are no -X and -d options for pg_dump. pg_dump produces a dump that is restorable in an empty DB.
Sep
2
comment Reset password for 'postgres' on v9.3 (Win Srv)
What does telnet localhost 5432 respond to you?
Sep
1
comment Replace a materialized view in Postgres
@CraigRinger interested in adding this as an answer?
Aug
24
comment Saving arrays in database - PDO
Well, this is not 100% true as PostgreSQL has array types, for example. Other than that, I agree.
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.