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

19h
revised domain group is db_owner of database, yet has no right for CREATE TABLE
edited tags
1d
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)
1d
comment Source of error on psql data load
What do you mean with "but that is a weak reaction"?
1d
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"
1d
comment How to create a view with added rows for missing dates?
Which DBMS are you using?
1d
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
1d
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.
2d
revised Why do I get this error in a query with SUM?
added 40 characters in body
2d
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
2d
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
2d
revised What are the Pros and Cons of modelling a ready only query system with Multiple databases vs Multiple schemas?
edited tags
2d
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)
2d
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
2d
answered what is difference between oracle instant client and oci?
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
10
awarded  Enlightened
Feb
10
awarded  Nice Answer
Feb
10
answered Can we use subquery in GRANT statement in postgres
Feb
10
revised Can we use subquery in GRANT statement in postgres
added 44 characters in body