Reputation
8,292
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
3 18 43
Newest
 Informed
Impact
~405k people reached

Jun
24
comment Multiple left join where not in another table
You have an inner join where a (supposedly) primary key column (user.id) is null - this does not help in getting any results :)
Jun
24
comment Multiple left join where not in another table
As this is a database question, it would be more handy to have the data in the form of an INSERT statement...
Jun
24
comment Exchange Partition
What is the exact error message?
Jun
24
comment Is there an equivalent in postgresql to MySQL's “safe update mode” or “safe delete mode”?
And one more question: the MySQL names suggest that this (whatever it is) is safe. Safe from what? In other words: what's your intended use of this?
Jun
24
comment How can I install Oracle (10g or above) on my MacBook running OS X Yosemite (10.10.4)?
docs.oracle.com/html/B13954_01/toc.htm
Jun
24
comment DBMS_REDEFINITION don't copy data?
2M rows usually do not require partitioning - these days it's not even considered as a big amount of data (unless the table is very wide). You possibly want to change the relevant settings :) On the other hand, it is also possible to remove the rows in small batches.
Jun
24
comment DBMS_REDEFINITION don't copy data?
From the documentation it looks like this is not in the scope - the aim is to change how the table is stored or its structure. Why cannot you simply delete the unnecessary data before redefining the table?
Jun
24
comment SQL Server : trigger FOR DELETE
And don't forget to add some explanation. Without it, your post was automatically flagged as low quality.
Jun
24
comment stored procedure vs. function in postgresql and which is better for executing dml statements
@CraigRinger OK, I was not aware that you can handle transactions in an Oracle SP - in the end it makes sense considering nested transactions.
Jun
24
comment stored procedure vs. function in postgresql and which is better for executing dml statements
@CraigRinger if you define SP as you do, not that many RDBMS has that functionality, right?
Jun
24
comment stored procedure vs. function in postgresql and which is better for executing dml statements
From an other viewpoint, a PostgreSQL function can do whatever a stored procedure can in other systems (more or less). I find it not uncommon to call functions stored procedures, possibly for this reason.
Jun
23
comment Optional Relational Filters
I cannot tell without actually knowing your data model and the background (what can happen to which entity, for example).
Jun
23
comment Optional Relational Filters
How about adding two columns, each referencing one of those tables, with the second allowing nulls?
Jun
23
comment Bulk insert M:N relation in PostgreSQL
@OndřejBouda it might be possible to build the tables as CTE queries, but it might get quite complicated pretty fast. The (temp) table solution gives you the luxury of testing the steps individually, by checking the row counts, for example.
Jun
23
comment How to reinstall PostgreSQL over an existing installation
Have you tried to follow the hint in the error and replace \ with /? See a related issue: dba.stackexchange.com/a/29773/6219
Jun
23
comment Estimating the size (of the records) and the overhead in Postgres
One has to also observe that PostgreSQL always uses full pages, so a single row of the above structure or 50 of them will still take 8 kB disk space (on the table alone). As the table gets bigger, this effect gets smaller. Furthermore, indexes are stored very similarly to tables, there is always a page header (+ padding as necessary) and row headers. For example, a freshly recreated index of 999903 integer values (the PK) takes 22478848 bytes on my local test box.
Jun
23
comment Reporting Service 2014 Service Pack 1 Failing to work with error - wrong database version
You might want to add the solution as an answer, then (later) accept it. This way the question won't hang out unanswered for a long time.
Jun
22
comment I want to move the listbox one to another listbox and update the particular listbox value
So, any errors? Or other description about how it does not work? And what role does VBA play here? Does the query alone does what you want?
Jun
22
comment Remove all character except A-Za-z0-9 without regex
If you have a list of all possible other characters, you can use translate() for this.
Jun
22
comment Problems with GO keyword
Why don't you simply prepare two separate strings and execute them one by one? Have you tried to add a semicolon after ON?