10,382 reputation
11236
bio website
location Munich
age
visits member for 2 years, 11 months
seen 21 mins ago

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


Mar
22
comment How do I access a result set from a StoredProcedure… in another StoredProcedure
The only thing that comes to mind is using temp tables to "transfer" the data from one procedure to the other.
Mar
22
comment How to do WHERE x IN (val1, val2,…) in plpgsql
WHERE col0 = ANY (intarray)
Mar
21
comment How to config Enterprisedb work with PostgresXC ?
I don't think that is possible. PostgresXC uses a different code base as the normal Postgres versions (including EnterpriseDB) so you can only create a PostgresXC cluster using PostgresXC. What exactly are you trying to do?
Mar
21
comment Which RDBMS do return better error messages?
In my opinion Postgres' error message are much clearer.
Mar
20
comment How to grant select on a view … based on IP adress?
The only thing I can think of, is to write a function that checks the client's IP address and then runs different SELECT statements based on that.
Mar
20
comment INSERT using results of CTE INSERT to provide unique id values
You need to join ins and t3
Mar
18
comment Self-join unique pairs
Where does 1,4 or 6,8 come from? It's not the sample data (the first "table")
Mar
18
comment What is the instance name of the box I'm logged into?
What do you want to see if there is more than one instance? In most Linux distributions you can check the instances by looking at /etc/oratab
Mar
17
comment Trouble adding foreign key on lots of data in Postgres
This sounds as if your application is creating too many connections to the database server (or probably not closing them properly). Check the connection pool in your application (or whatever is used in your application to establish a connection)
Mar
17
comment A constant scan takes either 0 seconds or 2-3 minutes
Could it be a locking problem? DML statements from other sessions blocking the select on the table (which is the default behavior in SQL Server 2005)
Mar
16
comment save/export PGAdmin server list configuration settings
@Jaan: why don't you add that as an answer?
Mar
15
comment Has postgresql a fast add column optimization?
@ypercube: when the default is NULL (i.e. "no default") then Postgres won't write anything to the table as well. This question is specifically for a new NOT NULL column with a default (which obviously can't be null)
Mar
15
comment Why is adding a FK constraint slow in MySQL?
It needs to validate the foreign key, so for every row in A it needs to check if the referenced row in parent does exist.
Mar
14
comment Drop database owned by specific user in PostgreSQL
What happens if you use an UTF-8 enabled client, so that you can actually read that character?. Then you should be able to drop that database.
Mar
14
comment CentOS and Ubuntu differences with information_schema
I know it doesn't - but what is the use of accepting a statement without an error message that doesn't work? If you are migration existing scripts for other DBMS you might think everything is OK because MySQL did no complain (I have seen more than once) - it's the same story with check constraint.
Mar
13
comment Compare Number of Rows of Tables
@GismoRanas: it's not "Post", "gre" and "SQL" it's "Postgres" and "SQL" and the duplicated s is dropped. I think they should simply consider writing it differently: "PostgresQL", instead of "PostgreSQL" (because they can't really change the name any more)
Mar
13
comment CentOS and Ubuntu differences with information_schema
@jynus: there are still situations where foreign keys are silently ignored: sqlfiddle.com/#!2/db0d8/1 (try that with any other DBMS...)
Mar
12
comment CentOS and Ubuntu differences with information_schema
@watcher: or use a DBMS that fails if it can't comply with a request rather than trying to be smart and do "something" just to avoid an error message (that situation can still happen with current MySQL versions if for some reason the InnoDB engine could not be loaded/started)
Mar
12
comment Sharding Postgres Database
Please define "fairly large". Unless each and every table goes into hundreds of million of rows (and you have like hundreds of those tables) I don't think adding the complexity of sharding is worth the effort.
Mar
12
comment CentOS and Ubuntu differences with information_schema
I would say: whatever script you use to install/create your tables, that script didn't run properly on the CentOS machine. Another possibility: you don't have InnoDB enabled on CentOS and therefor your foreign keys weren't created.