meta user
network profile
| bio | website | |
|---|---|---|
| location | Berlin, Germany | |
| age | 37 | |
| visits | member for | 1 year, 3 months |
| seen | 4 hours ago | |
| stats | profile views | 394 |
|
Mar 19 |
comment |
Very slow DELETE in PostgreSQL, workaround? @jd. You can ALTER TABLE tablename DISABLE TRIGGER ALL; DELETE ...; ALTER TABLE tablename ENABLE TRIGGER ALL; |
|
Mar 19 |
comment |
Very slow DELETE in PostgreSQL, workaround? Is it possible that you have ON DELETE triggers somewhere down the cascading chain? |
|
Mar 13 |
comment |
Is there a Postgres admin GUI that can execute a master file containing multiple sql files OK, then I will be clear: you presumably can't do that in pgAdmin. Anyway, I can't really see why this is a problem (I may be too used to this limitation). |
|
Mar 12 |
comment |
Is there a Postgres admin GUI that can execute a master file containing multiple sql files You can edit your SQL files in any editor (there are much better options than pgAdmin) and then only run a single command in psql (say psql -f master.sql). |
|
Mar 9 |
comment |
UPPER Case issue postgreSQL when importing from text file From this: COPY "hotels" ("","sequence_number"... it looks like that the problem is in the column mapping. |
|
Mar 8 |
comment |
UPPER Case issue postgreSQL when importing from text file Could you present here the first three rows of your file, the error code and maybe the table definition? |
|
Mar 8 |
comment |
Export Postgres table on remote server to CSV file on local machine? @CraigRinger because I'm not used to it, haha :) |
|
Mar 7 |
comment |
PostgreSQL user can not connect to server after changing password Can't one simply set the password again once logged in as postgres? |
|
Mar 7 |
comment |
PostgreSQL user can not connect to server after changing password No-no, I just thought that changing passwords in the GUI does just the same. If it does I can't imagine what could go wrong? |
|
Mar 7 |
comment |
PostgreSQL user can not connect to server after changing password Shouldn't pgAdmin perform just the same command? |
|
Mar 6 |
comment |
Can PostgreSQL's COPY create CSV with Locale-specific number formatting? Look at this thread: postgresql.1045698.n5.nabble.com/… I'm afraid that you have to find a solution with to_char. I'd expect performing a conversion with Excel may be easier (no actual idea how to do that, just has some faint memories about doing that years ago). |
|
Mar 1 |
comment |
What is ERROR_STATE() in SQL Server and how it can be used? @jaczjill There are not so many techies who know more about SQL Server than Aaron, and most of them never show up here. And your question is answered here (most probably as exactly as it could go). |
|
Mar 1 |
comment |
How to calculate running total based on dynamic values? It depends on your use case. If there are, say, 1000 updates per second, then the answer is no. If only one, then possibly yes. From an other point of view, if you do the update on every change, you have only to add/substract the change of the amount. |
|
Mar 1 |
comment |
How to calculate running total based on dynamic values? I'm not sure I understand what you want to achieve. Is your aim to update the totals automagically when a live item changes? In this case you can either add this functionality to your existsing code or create a trigger on Invoices which will look after the totals. |
|
Feb 28 |
comment |
SQL Server 2005 Replication FYI, it is SQL Server 2005. |
|
Feb 27 |
comment |
Group By days interval (aging type) And your question is? What do you have already? |
|
Feb 27 |
comment |
How to pass a table type with an array field to a function in postgresql Sorry, the correct one is ave_book((179, 'the art of war', 'fiction', '{190,220}')::book, just as Andriy said. |
|
Feb 27 |
comment |
How to pass a table type with an array field to a function in postgresql Your function looks a bit overcomplicated for me, but anways. An array literal must be enclosed by single quotes, so try the following: ave_book((179,the art of war,fiction,'{190,220}')::book. The constructed row does not need the quotes. |
|
Feb 27 |
comment |
Truncate table is taking too long in PostgreSQL What do you get from SELECT * FROM pg_locks WHERE relation = 'exceptions'::regclass::oid? |
|
Feb 27 |
comment |
Can this array group count query be improved? In the query plan all the row estimates are far off from actual numbers - don't you think a few ANALYZE commands would make things (maybe only slightly) faster? |
