10,392 reputation
11437
bio website
location Munich
age
visits member for 2 years, 11 months
seen 1 hour ago

I'm looking for job as a software developer (Java) with focus on relational database technologies (Oracle, PostgreSQL)


12h
comment Inserting empty string on Windows MySQL doesn't use default value
'' is not a valid number, it's a string - why would you ever want to insert a string into a number column? The difference in behavior probably comes from using a different value for the strict_mode or the no_auto_value_on_zero configuration parameter. If you do a show warnings on the Linux installation you'll probably see the explanation. In general you should not ignore the message 2 warnings.
1d
comment What happens when we call pg_dump while users are still using the system?
Short of buying faster harddisks - no. Note that pg_dump creates a "snapshot". Usually that is not considered a backup. Using WAL archiving you can create "real" backups that also allow restoring the data to a specific point in time. See the manual for details: postgresql.org/docs/current/static/continuous-archiving.html
1d
comment What happens when we call pg_dump while users are still using the system?
pg_dump takes a consistent snapshot from the database so it will not cause any inconsistencies.
2d
comment How to get back sql table data?
Restore your backup
Apr
20
comment What are suitable databases for GIS data for MapInfo and ArcGIS and WindPro?
My understanding is that Postgres + PostGIS is currently a very good choice (OpenStreetmap completely migrated to that)
Apr
19
comment Postgresql JDBC Table Valued Parameters
You insert into it and then you select from it. There is nothing special about using a temp table (apart from the fact that the rows automatically go away). Any decent JDBC tutorial will have examples for inserting and reading from a table.
Apr
19
comment Postgresql JDBC Table Valued Parameters
Why don't you use a temporary table?
Apr
19
comment Postgresql JDBC Table Valued Parameters
Cross posted: stackoverflow.com/questions/23008966
Apr
19
comment Oracle 12C, cannot drop NOT NULL constraint on a DEFAULT ON NULL column
Any triggers on the table?
Apr
19
comment Mirroring error #1418
Writing ALL UPPERCASE is considered SHOUTING and rude
Apr
18
comment SQL Server Implement Limit Functionality
The equivalent to limit would be top in SQL Server
Apr
17
comment DISTINCT not using an index
explain plan for select ...; select * from table(dbms_xplan.display);
Apr
17
comment DISTINCT not using an index
Well if the column is nullable the index cannot be used as tuples consisting completely of null values won't make it into the index. You can trick Oracle to index them nonetheless using an index defined as (column4, 1). Btw: why don't you just copy and paste the text result of an explain. That is usually much easier to read than an image or some other obfuscated output.
Apr
17
comment DISTINCT not using an index
Is the column nullable? And what does the execution plan say?
Apr
16
comment ORA-30009: Not enough memory for CONNECT BY operation
None of those tips will reduce the memory required by a connect by query.
Apr
16
comment ORA-30009: Not enough memory for CONNECT BY operation
Please show us the query and the execution plan.
Apr
16
comment PostgreSQL DB size increasing after restoring the same database backup
A pg_restore will only delete data if you use the --clean switch. I'm surprised you didn't get a bunch of errors when you tried to restore the data into the same database.
Apr
16
comment PostgreSQL DB size increasing after restoring the same database backup
You are not dropping the old DB or at least the old tables. If your tables don't have a primary or unique key (which would be very bad) then I guess it's possible that a restore into the same DB will just add the rows from the backup
Apr
16
comment Can comments in stored procedures cause problems
I have seen situations where such comments caused trouble (it's been a while, can't recall the exact circumstances). After using block comments /* ... */ instead of line comment things were OK.
Apr
15
comment postgresql being slow on count distinct for dates
wiki.postgresql.org/wiki/Slow_Query_Questions