Re: [GENERAL] what is the date format in binary query results

2007-12-12 Thread Gerald Timothy Quimpo
On Wed, 2007-12-12 at 10:16 -0800, Samantha Atkins wrote: > OK, I read it again. I don't see anything about how the timezone is > specified for this type of column. I went to the manual instead, see below for a useful section. Since the "internally stored value is always in UTC", it doesn't ne

Re: [GENERAL] Continual uptime while loading data ... COPY vs INSERTS within a transaction.

2008-02-11 Thread Gerald Timothy Quimpo
On Sat, 2008-02-09 at 19:27 -0500, Tom Lane wrote: > Benjamin Arai <[EMAIL PROTECTED]> writes: > > We are thinking of modifying our system to use COPY to replace these > > large INSERT transactions but we are concerned that it will greatly > > impact the user experience (i.e., exclusively lock t