7,044 reputation
31640
bio website
location Berlin, Germany
age 39
visits member for 2 years, 11 months
seen Dec 19 at 14:25

Dec
19
comment Get columns from NEW when execute update on postgresql
It simply means there is no column named niveope in the table operador. At the same time, your example shows something called nivope - I guess you just mistyped something.
Dec
18
comment Are A or D series VMs better for deploying PostgreSQL on Azure?
@CraigRinger ... and in this case, faster disks (which we don't know here if those are the SSDs or not) give an advantage, especially when much WAL is written, right?
Dec
12
comment How to do a pgdump with strings encoded?
You are not supposed to restore plain sql dumps with pg_restore but psql. See postgresql.org/docs/9.3/static/app-pgrestore.html
Dec
12
comment What is the etymology of the hstore datatype in postgres?
I'd suggest writing a mail to the authors. Ther addresses can be found at the bottom of the documentation page.
Dec
12
comment Backing up AWS database to an on premise server
PostgreSQL RDS has a very limited replication option (see aws.amazon.com/rds/postgresql/#Replication). I am not sure if a 'normal' PostgreSQL server on AWS can be set up to replicate to a non-AWS location.
Dec
12
comment Translate psql meta-command to SQL
Alternatively, when already in psql, issue the \set ECHO_HIDDEN on command. Both -E and this do exactly the same.
Dec
11
comment create insertion rule on view returning id
Could you please show the view and table definitions?
Dec
11
comment Getting wrong results from fulltext search in PostgreSQL
After running all above commands, I get only one row. I guess you have data that is not what you expect.
Dec
4
comment migrate standalone postgresql database cluster to high availability cluster
I guess it's already obvious from your question that 1) is an easier/better way. Redirecting the application (whatever actual steps it means) has to be done in both cases. Then creating a slave for the existing DB can be done while it's in use, so the only downtime you may need is for the above mentioned switching.
Dec
2
comment Using EXCEPTION to ignore duplicates during bulk inserts
You can do also the following: insert your data into a staging table (without a unique constraint), remove the duplicates and insert the remainder into the final table. Depending on some factors (like the amount of data) this may be better or worse performance-wise than the approach in your comment.
Dec
2
comment Trying to connect to PostgreSQL with Entity Framework via Npgsql and C#
Please add the important points to your answer to prevent link rot.
Dec
2
comment Using EXCEPTION to ignore duplicates during bulk inserts
The code you use above is meant to be the body of a pl/pgsql function. You can either create a real function using it, or use a DO block. However, be careful, this way you won't silently get over the failing row. The whole thing won't throw an error but you won't have any lines inserted, either.
Nov
27
comment ERROR: relation “name” does not exist
If this really starts like that, than there should be an error saying ERROR: relation "accessories_id_seq" does not exist
Nov
27
comment ERROR: relation “name” does not exist
You mention postgresql.sql:33: ERROR: syntax error at or near "" LINE 1: /* - I see no /* anywhere.
Nov
27
comment ERROR: relation “name” does not exist
It sounds like that the dump is somehow incomplete. It would be interesting to see the original command used for taking the dump. Also, possibly showing the top 40 line if the dump could help in helping you.
Nov
27
comment UPDATE/DELETE performance on partitioned table
Well, it seems that an EXPLAIN ANALYZE DELETE ... does not report the number of rows in the row count. (Nevertheless, it gets executed.) It was a misunderstanding on my side.
Nov
26
comment UPDATE/DELETE performance on partitioned table
You are doing some dirty magic. The EXPLAIN ANALYZE output shows 0 rows affected. Afterwards, you are able to delete a number of rows. Twice. (Note that the plans show that the DELETE via the parent table is even faster.) Could you clarify what you are actually doing?
Nov
26
comment Postgresql - Streaming replication - STONITH
Agreed, one has to try other methods only if they have the time and the ability to deal with possible corruption.
Nov
25
comment UPDATE/DELETE performance on partitioned table
Inspect the output of \d events. Do you see a trigger that fires on DELETE?
Nov
25
comment Reassigning surrogate keys?
I am wondering if you use OID in a rather unorthodox sense here. See postgresql.org/docs/9.3/static/… and postgresql.org/docs/9.3/static/sql-createtable.html for details.