Reputation
15,079
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
2 28 55
Impact
~926k people reached

Jun
24
comment Is there an equivalent in postgresql to MySQL's “safe update mode” or “safe delete mode”?
Are you referring to the MySQL's command line client's parameter --i-am-a-dummy? That depends on the SQL client you are using. Some offer this, some don't. psql does not have such a parameter.
Jun
24
comment Insert from Another Table + Removing Duplicate Entries in Postgres
Exception handling is only available in PL/pgSQL, not in plain SQL - you need to write a stored function to catch an exception. In PL/pgSQL, BEGIN starts a block and does not need a ;. You are confusing BEGIN TRANSACTION; (which is a SQL statement) with the BEGIN from PL/pgSQL: postgresql.org/docs/current/static/plpgsql-structure.html
Jun
22
comment I want to move the listbox one to another listbox and update the particular listbox value
Are you really using Postgres and SQL Server and MySQL all at the same time?
Jun
22
comment How to see list of databases in Oracle?
@DevYudh: a tablespace in Oracle is something completely different than a "database" in MySQL. The first query if correct, the second query is plain wrong
Jun
22
comment Remove all character except A-Za-z0-9 without regex
What's wrong with using regex?
Jun
22
comment Pattern matching in PostgreSQL?
No it's not "mostly similar". The syntax is completely different between those three DBMS.
Jun
22
comment Pattern matching in PostgreSQL?
Why the mysql and oracle tags?
Jun
22
comment Sync many client database to one central database
Which DBMS are you using? "SQL" is a query language, not a specific DBMS
Jun
22
comment how to embed the ALTER statement into Stored Procedure?
Which DBMS are you using? Postgres? Oracle?
Jun
19
comment How can I create a copy of postgis db from one windows machine to another
pg_dump and pg_restore should work just fine (provided the target DB has PostGIS installed). Please show us the exact commands that you are using.
Jun
18
comment Replicating table level PostgreSQL 64bit windows
SymmetricDS is a Java based replication so it's independent of the architecture: symmetricds.org/docs/faq I have not used it though
Jun
18
comment Oracle SQL: update only some records
You need to add a where condition if you don't want to update all rows.
Jun
16
comment How to satisfy 1NF with food ingredients?
@adampski A (comma separated) list of values is not atomic because it consists of multiple values and thus isn't atomic which violates 1NF. Instead of storing a list of actual values you are now storing a list of FK values - but that's still a list, not a single value
Jun
15
comment How to create a Linked Server from SQL Server 2008 to DB2?
If SQL Server is a 64bit application you also need to define a 64bit ODBC datasource which means you need a 64bit ODBC driver for DB2. You also need to use the correct ODBC admin tool. According to: msdn.microsoft.com/en-us/library/cc645931.aspx you need to use %SystemRoot%\system32\odbcad32.exe
Jun
11
comment How to select first row from a join that returns multple rows on the primary key
Which DBMS are you using? Postgres? Oracle?
Jun
9
comment How to check/know the highest run queries
postgresql.org/docs/current/static/pgstatstatements.html
Jun
9
comment SQL Server DOUBLE keyword
You most probably don't want to use double (or float or real) anyway: floating-point-gui.de
Jun
9
comment How can we configure the Streaming Replication(master-slave) on single SAN storage in PostgreSQL?
You configure it the same way as any other replication configuration. Have two Postgres servers where the masters streams the WAL files to the slave - you just need to make sure that master and slave use different data directories.
Jun
8
comment Speed up creation of Postgres partial index
"Autovacuums are turned OFF" - why? That is a really bad idea. This prevents the collecting of statistics and thus will yield bad query plans
Jun
8
comment Count of distinct values of a table using sql
@Colin'tHart: that's why I said the question should be tagged with the appropriate DBMS.