When there's a deadlock detected, the error message recorded in the
log prints out the query being aborted, and the process id of the
other transaction involved in the deadlock. It would be great if more
context was printed for the other query (e.g. the query itself), as
opposed to just th
I'm running into a problem with maintaining referential integrity with
inheritance-based partitioning. Imagine a situation where partitions
are based on time. Two tables A and B are partitioned, and B
references A. If records in B are added some time after records in A,
the insertion tim
grant statement that I'd like to get rid of. How can I
reassign ownership of the entire database, or just give default
permissions on all new tables to 'tdc'?
Thanks,
Dan Chak
--
--------
dan chak ! 372 memorial driv
