Reputation
18,934
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
4 36 67
Newest
 Enlightened
Impact
~1.4m people reached

5h
comment Ignore white spaces for comparison in unique constraints of Oracle
@MohsenKashi: not, there is no such thing
2d
comment Source of error on psql data load
@Jerome: you can just remove it for the load and then re-create it afterwards. Or declare the constraint as deferrable and import everything in a single transaction (which you should do anyway)
2d
comment Source of error on psql data load
What do you mean with "but that is a weak reaction"?
2d
comment what are the options for the psql \copy command?
From the manual: "All options other than the data source/destination are as specified for COPY"
2d
comment How to create a view with added rows for missing dates?
Which DBMS are you using?
2d
comment Debug query on big table that is sometimes slow
You could install the auto_explain module which will log the execution plan of the slow queries. Maybe that will give you a hint
Feb
11
comment what is difference between oracle instant client and oci?
@DaeYoung: correct. If you use the Oracle JDBC (thin) driver, all you need is the driver's jar file and a Java runtime.
Feb
11
comment move a postgres cluster to another machine
Yes. Actually with 8.3 that's your only option. pg_upgrade only works with 8.4 and later
Feb
11
comment move a postgres cluster to another machine
You can't copy a data directory like that. You need to dump the old version and then restore into the new server. See the manual for details: postgresql.org/docs/current/static/backup-dump.html and postgresql.org/docs/current/static/upgrading.html
Feb
10
comment what is difference between oracle instant client and oci?
The JDBC driver doesn't need an Oracle client (at least not the thin driver which is recommended by Oracle)
Feb
10
comment what is difference between oracle instant client and oci?
@DaeYoung: no, the JDBC driver is something different. It doesn't use the OCI interface, it implements that internally and doesn't depend on the Oracle client being installed. The instant client is more like the ODBC driver
Feb
10
comment “TRUNCATE doesn't run ON DELETE trigger” true or false
The rows are deleted, but the delete trigger is not fired
Feb
10
comment “TRUNCATE doesn't run ON DELETE trigger” true or false
The link to the manual you posted is pretty cleaer: "the TRUNCATE TABLE statement does not invoke ON DELETE triggers"
Feb
8
comment How to create unique index for both cases
Which DBMS are you using?
Feb
7
comment transpose rows into colunms based on date grouping
which DBMS are you using?
Feb
6
comment is there a GUI client that can execute multiple queries and show its multiple results?
The Postgres wiki lists several GUI clients. I'm pretty sure there is something that meets your needs: wiki.postgresql.org/wiki/…
Feb
4
comment Using postgres with logstash - log filename is causing issues
The name of the logfile postgres uses, can be configured in postgresql.conf: postgresql.org/docs/current/static/…
Feb
4
comment Select into statement
Which DBMS are you using? select into is used to store scalar results into variables inside a procedural language. Not sure what you are asking here.
Feb
4
comment How do I set the isolation level for SELECT statement?
Well the NoSQL databases specifically give up on transactions, consistency and transaction isolation for performance (and scalability) reasons.
Feb
4
comment Execute system commands in postgresql
You can use an untrusted language like PL/perl which would allow you to call operating system commands: postgresql.org/docs/current/static/plperl-trusted.html