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 >

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

2006-12-26 Thread Mike Benoit
ompiled 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
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 &

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

2005-03-11 Thread Mike Benoit
d I (at all could I???) make it transparent? > > 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

[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
st)--- > TIP 6: Have you searched our list archives? > >http://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
mand fail in this case, not just the begin? If I 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 c

Re: [GENERAL] Ordering by IN

2004-08-25 Thread Mike Benoit
+---+---+--- > +---+--- >100120 | 90072 | 101 | 1 | > 2 | 1 >100120 | 90005 | 101 | 1 | > 2 | 1 > 100120 | 90074 | 101 | 1 | > 2 |

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 fr

Re: [GENERAL] Auditing idea

2003-08-14 Thread Mike Benoit
p://www.ritterdosreis.br > [EMAIL PROTECTED] > Fone: 51-32303341 > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > >http://archives.postgresql.org -- Best Regards, Mike Benoit --

Re: [GENERAL] Alternative replication method.

2003-06-25 Thread Mike Benoit
e that buffer and wait for IO completion. 3. Continue with 1. ... 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

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

2003-06-24 Thread Mike Benoit
> Am I about to go in over my head (again)? > > Thanks, > > Andrew > > ---(end of broadcast)--- > TIP 7: don't forget to increase your free space map settings -- Best Regards, Mike Benoit NetNation

[GENERAL] Alternative replication method.

2003-06-24 Thread Mike Benoit
"hot-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 m