13,917 reputation
12253
bio website
location Munich, Bavaria
age
visits member for 3 years, 10 months
seen 35 mins ago

17h
comment Oracle: built in SQL pretty-print?
There is no such feature inside the database. Oracle's SQL client "SQL Developer" can do that though
1d
comment SQL update multiple columns matching a pattern
I wrote "MySQL ignores inline foreign key constraints" which is still true with 5.6: sqlfiddle.com/#!9/fc801/1
1d
comment SQL update multiple columns matching a pattern
You don't need to run multiple updates, you can update more than one column in a single update.
1d
comment Have: Postgres database files. Need: Functioning database
I don't know Ubuntu, but with a "vanilla" Postgres all you need to do is point pg_ctl to the right data directory, e.g. pg_ctl -D /path/to/database/file start.
1d
comment Query that was working on MySQL is not working on PostgreSQL
Don't compare numbers and strings. Use proper numeric literals 37 is a number, '37' is a string.
1d
comment Query that was working on MySQL is not working on PostgreSQL
I also don't understand "Postgres - works" vs. "doesn't work on PostgreSQL" what exactly is "working" and what exactly is "not working"
2d
comment VACUUM FULL fails with 'ERROR: Check free disk space'
You probably need to vacuum each table individually and see which one generates the error. A vacuum full essentially re-writes the complete table by copying it. Why do you think you need vacuum full at all?
Mar
28
comment How can I drop and create postgresql views in dependency order?
Put each view into a single SQL script, create one script to drop all views and another one calling each "view script" to re-create the views
Mar
27
comment Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
Strange. The MacMini does the sort (in B2) much faster than the t420 even though it does it on disk and the t420 does it in memory. That sounds awfully strange.
Mar
27
comment Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
Can you show us the execution plans (explain (analyze, verbose, buffers) select ... ) from both servers for one of the slow queries?
Mar
27
comment PostgreSQL pg_upgrade --link mode performance issue after upgrade
Sounds as if the statistics aren't up-to-date. pg_upgrade creates a script for that. Did you run it?
Mar
27
comment SQL Server to Oracle migration
And what is your question?
Mar
26
comment Linking SQL Server tables to a PostgreSQL Server
wiki.postgresql.org/wiki/FDW
Mar
26
comment migrating from Postgres to MonetDB
pg_dump creates a SQL script, not a csv file. You can not just import a SQL script as if it was a CSV file. You need to use e.g. the copy command in psql or any other tool that can dump a database to text files.
Mar
26
comment Why is MySQL not saving inserted data?
See here: stackoverflow.com/questions/7655824/… or here: stackoverflow.com/questions/10742133/… or here: stackoverflow.com/questions/9318347/…
Mar
25
comment migrating from Postgres to MonetDB
The usual process for a DB migration: 1) create the tables in the target DB by adjusting the DDL scripts you have to the new syntax. 2) export the data from the source DB in a format that can be imported by the tools of the new DB 3) import the data into the new DB
Mar
25
comment Connect to Oracle DB 9i using SSH TUNNEL via putty
You need to create an entry in tnsnames.ora that points to localhost
Mar
24
comment Return type of JOINing stored procedure - PostgreSQL
Why no use a view instead?
Mar
24
comment hierarchical query
Which DBMS are you using? Postgres? Oracle?
Mar
24
comment SQL SUM of different product groups in one query?
Although probably not relevant for such a basic question, you should always mention the DBMS you are using (Postgres, Oracle, DB2, ...)