Re: [GENERAL] ORDER BY col is NULL in UNION causes error?

2007-01-11 Thread Mike Benoit
On Thu, 2007-01-11 at 13:44 -0500, Bruce Momjian wrote: Tom Lane wrote: Michael Glaesemann [EMAIL PROTECTED] writes: On Dec 26, 2006, at 18:39 , Mike Benoit wrote: ERROR: ORDER BY on a UNION/INTERSECT/EXCEPT result must be on one of the result columns Even though state

[GENERAL] ORDER BY col is NULL in UNION causes error?

2006-12-26 Thread Mike Benoit
by GCC x86_64-mandriva-linux-gnu-gcc (GCC) 4.1.1 20060724 (prerelease) (4.1.1-3mdk) -- Mike Benoit [EMAIL PROTECTED] signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Best practices: Handling Daylight-saving time

2005-03-11 Thread Mike Benoit
? Don't use DST. Use GMT/UTC. That makes the issue go away. -- Mike Benoit [EMAIL PROTECTED] signature.asc Description: This is a digitally signed message part

Re: [GENERAL] Best practices: Handling Daylight-saving time

2005-03-11 Thread Mike Benoit
wrote: On 2005-03-11, Mike Benoit [EMAIL PROTECTED] wrote: Here is a scenario I ran in to with collecting bandwidth usage and displaying it back in graph form to customers. You can store the timestamps in GMT, but the customer wants to see when spikes happen in his localtime, which most

[GENERAL] Postgresql v8.0 debian packages.

2005-01-28 Thread Mike Benoit
? Thanks. -- Mike Benoit [EMAIL PROTECTED] signature.asc Description: This is a digitally signed message part

Re: [GENERAL] 8.0 and Mandrake 10.1

2005-01-21 Thread Mike Benoit
://archives.postgresql.org -- Mike Benoit [EMAIL PROTECTED] signature.asc Description: This is a digitally signed message part

[GENERAL] PSQL undesired transaction behavior when connection is lost.

2004-10-07 Thread Mike Benoit
had a syntax error in the first delete command, I definitely would not want the second delete to succeed, which had the potential to happen in the above case. (Luckily it didn't) BTW: I had restarted the server manually, so it didn't crash or anything. -- Mike Benoit [EMAIL PROTECTED

Re: [GENERAL] Ordering by IN

2004-08-25 Thread Mike Benoit
100120 | 90005 | 101 | 1 | 2 | 1 100120 | 90074 | 101 | 1 | 2 | 1 Is this even possible? Thanks -- Mike Benoit [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner

Re: [GENERAL] Recomended FS

2003-10-20 Thread Mike Benoit
-- ---(end of broadcast)--- TIP 8: explain analyze is your friend ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Best Regards, Mike Benoit

Re: [GENERAL] Auditing idea

2003-08-14 Thread Mike Benoit
---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Best Regards, Mike Benoit ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Alternative replication method.

2003-06-25 Thread Mike Benoit
that buffer and wait for IO completion. 3. Continue with 1. ... /snip On Wed, 2003-06-25 at 07:44, Tom Lane wrote: Mike Benoit [EMAIL PROTECTED] writes: Has anyone used PostgreSQL with Drbd (http://www.complang.tuwien.ac.at/reisner/drbd/)? Does it guarantee preservation of write ordering

[GENERAL] Alternative replication method.

2003-06-24 Thread Mike Benoit
-spare database server? -- Best Regards, Mike Benoit NetNation Communications Inc. Systems Engineer Tel: 604-684-6892 or 888-983-6600 --- Disclaimer: Opinions expressed here are my own and not necessarily those of my employer

Re: [GENERAL] capturing and storing query statement with rules

2003-06-24 Thread Mike Benoit
---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Best Regards, Mike Benoit NetNation Communications Inc. Systems Engineer Tel: 604-684-6892 or 888-983-6600