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
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
?
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
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
?
Thanks.
--
Mike Benoit [EMAIL PROTECTED]
signature.asc
Description: This is a digitally signed message part
://archives.postgresql.org
--
Mike Benoit [EMAIL PROTECTED]
signature.asc
Description: This is a digitally signed message part
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
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
--
---(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
---(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
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
-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
---(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
13 matches
Mail list logo