meta user
network profile
| bio | website | |
|---|---|---|
| location | Munich | |
| age | ||
| visits | member for | 2 years |
| seen | 2 hours ago | |
| stats | profile views | 723 |
I'm looking for job as a software developer (Java) with focus on relational database technologies (Oracle, PostgreSQL)
|
Jul 24 |
answered | Are there any in-memory hybrid databases available? |
|
Jul 22 |
revised |
Understanding Oracle's ALL_TAB_COLUMNS fixed spelling mistake |
|
Jul 21 |
comment |
Merge queries into one Why shouldn't between used? Any reason for that? |
|
Jul 21 |
answered | Understanding Oracle's ALL_TAB_COLUMNS |
|
Jul 20 |
comment |
How to troubleshoot COPY FROM inserting less rows then expected? You could export the table again (using copy) and compare the two files after you have sorted them. |
|
Jul 20 |
comment |
Understanding Oracle's ALL_TAB_COLUMNS Most probably there are three schemas (users) that have that table. You need to include OWNER = 'FOOBAR' in your query to all_tab_columns (or use user_tab_columns). You can also include the OWNER column in your select list to verify this. |
|
Jul 20 |
comment |
Are there any good and free tools for managing a PostgreSQL database? There is a long list in the PostgreSQL Wiki: wiki.postgresql.org/wiki/… |
|
Jul 19 |
comment |
Deleting duplicates with group by and count This won't work as MySQL does not allow to use the tables that is being deleted in a sub-select. |
|
Jul 18 |
comment |
enq: TX - row lock contention creating session waits Commiting in a loop is not a good idea it makes things slower: asktom.oracle.com/pls/apex/… |
|
Jul 18 |
revised |
Database schema size result differs from file size when exported added 11 characters in body |
|
Jul 18 |
answered | Database schema size result differs from file size when exported |
|
Jul 18 |
comment |
What free database software support sequences @ChrisAldrich: thanks, very helpful. |
|
Jul 17 |
comment |
PostgreSQL Initial Database Size File system fragmentation is not really a big issue with NTFS nowadays. |
|
Jul 17 |
comment |
PostgreSQL Initial Database Size I doubt that it's the file resizing operation. My guess is that maintaining the indexes is what's slowing down the inserts. There is a current discussion on the PG mailing list regarding this (though without a solution): postgresql.1045698.n5.nabble.com/… |
|
Jul 17 |
comment |
What free database software support sequences @ChrisAldrich: thanks. I didn't know that there was a difference between Express and Express-C. |
|
Jul 17 |
revised |
What free database software support sequences added 2 characters in body; added 55 characters in body |
|
Jul 16 |
answered | Drop and restore PostgresSQL database without losing settings |
|
Jul 16 |
comment |
Should I add an arbitrary length limit to VARCHAR columns? @dezso: looks even better! I assumed changing a domain would require the same work as changing the column type - but it doesn't seem to be that case. |
|
Jul 16 |
answered | Should I add an arbitrary length limit to VARCHAR columns? |
|
Jul 16 |
comment |
What free database software support sequences @ssmusoke: An auto_increment is something different than a sequence |
