Tom Lane wrote:
At least in Linux, mysql replaces the password in the command line
argument with "" so you can't see them via "ps" nor via peeking
into /proc//cmdline.
There is a short period where the password is visible though.
Are there any other risks? Or is the reason for not doing
Michael Fuhr <[EMAIL PROTECTED]> writes:
> What *does* matter is that one specify (lat, lon) instead of
> (lon, lat):
The earthdistance README does specify that latitude is the first
argument, but it doesn't get the function name right :-( ... it
says ll_to_cube instead of ll_to_earth. Anyone wan
On Sat, Oct 02, 2004 at 09:29:16PM -0400, Jean-Luc Lachance wrote:
> Maybe it would work with the right long & lat...
> try
> Protland OR -122.67555, 45.51184
> Seattle WA -122.32956, 47.60342
It doesn't matter which hemisphere the longitudes are in as long
as they're in the same hemisphere:
test
[EMAIL PROTECTED] (Aleksey Serba) wrote:
>Hello!
>
>I have 24/7 production server under high load.
>I need to perform vacuum full on several tables to recover disk
>space / memory usage frequently ( the server must be online during
>vacuum time )
The main thought is: "Don't do
Maybe it would work with the right long & lat...
try
Protland OR -122.67555, 45.51184
Seattle WA -122.32956, 47.60342
Also, do not forget that it is the line distance not the driving distance.
Michael Fuhr wrote:
On Sat, Oct 02, 2004 at 07:09:25PM -0400, Tom Lane wrote:
mike cox <[EMAIL PROTECTED]
On Sat, Oct 02, 2004 at 17:55:31 -0600,
Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Sat, Oct 02, 2004 at 07:09:25PM -0400, Tom Lane wrote:
> > mike cox <[EMAIL PROTECTED]> writes:
> > > The distance from Portland to Seattle is not 128862
> > > miles.
> >
> > How about 128.8 kilometers? The ear
On Sat, Oct 02, 2004 at 07:09:25PM -0400, Tom Lane wrote:
> mike cox <[EMAIL PROTECTED]> writes:
> > The distance from Portland to Seattle is not 128862
> > miles.
>
> How about 128.8 kilometers? The earthdistance docs say it's in meters
> unless you've redefined the base unit.
128.8 kilometers
Aleksey Serba <[EMAIL PROTECTED]> writes:
>I have 24/7 production server under high load.
>I need to perform vacuum full on several tables to recover disk
>space / memory usage frequently ( the server must be online during
> vacuum time )
Don't use VACUUM FULL; plain VACUUM should be
mike cox <[EMAIL PROTECTED]> writes:
> The distance from Portland to Seattle is not 128862
> miles.
How about 128.8 kilometers? The earthdistance docs say it's in meters
unless you've redefined the base unit.
regards, tom lane
---(end of broadcast
=?ISO-8859-1?Q?Sebastian_B=F6ck?= <[EMAIL PROTECTED]> writes:
> I investigated a little bit further and can be more precisely
> about the whole thing. This (wrong) behaviour only occurs, if
> the view has an order by clause.
The bug is triggered by the combination of an inherited UPDATE target
and
Matt Roberts <[EMAIL PROTECTED]> writes:
> Please accept my apologies if this is answered elsewhere in the archives
> or docs but I have searched without luck.
>
> I've always assumed that default ordering of selects are based on a first
> in first out principle and that this remains true at the r
Hello,
I have 3 tables which are joined that I need to create a summation for
and I just cannot get this to work.
Here's an example:
CREATE table1 (
id1INTEGER,
title1 VARCHAR
);
INSERT INTO table1 (1, 'Heading #1');
INSERT INTO table1 (2, 'Heading #2');
CREATE table2 (
id1I
Please accept my apologies if this is answered elsewhere in the archives
or docs but I have searched without luck.
I've always assumed that default ordering of selects are based on a first
in first out principle and that this remains true at the row level despite
edits to columns.
However I'm dea
Hello!
I have 24/7 production server under high load.
I need to perform vacuum full on several tables to recover disk
space / memory usage frequently ( the server must be online during
vacuum time )
The one trick that i see is to try to vacuum duplicate of
production database (
I would like to subscribe to you mail list. I'm not highly technical, but am
extremely interested in learning as much as I can.
Thank-you very much.
Phil Bolton
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTEC
I'm running PostgreSQL 8.0 beta 1. I'm using the
earthdistance to find the distance between two
different latitude and logitude locations.
Unfortunately, the result seems to be wrong.
Here is what I'm doing:
select
earth_distance(ll_to_earth('122.55688','45.513746'),ll_to_earth('122.396357','47.
Astha Raj wrote:
Hi All,
I want to connect to PostgreSQL 7.4 from my Windows machine. What ODBC
version is needed? Is there any other important settings required? I am very
new to this database.
Search on google: "odbc postgresql" and I'm feeling lucky.
Regards
Gaetano Mendola
Tom Lane wrote:
Is it possible that we setup the password in the pg_dump command line
You might as well put it on a billboard --- anything in the command line
can be seen by anyone who runs "ps".
If you don't want to supply it manually, put it in ~/.pgpass.
At least in Linux, mysql replaces the pa
David Garamond <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>>> Is it possible that we setup the password in the pg_dump command line
>>
>> You might as well put it on a billboard --- anything in the command line
>> can be seen by anyone who runs "ps".
>>
>> If you don't want to supply it manua
Dear list, many thanks to all of you who've replied in such a
helpful way -- your support is much appreciated! Have a nice
weekend, Bernd
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgre
Tom Lane wrote:
=?ISO-8859-1?Q?Sebastian_B=F6ck?= <[EMAIL PROTECTED]> writes:
Is this a known limitation with views, rules and
inherited tables i haven't heard of? Or is it a bug?
When you haven't shown us any details, it's impossible to tell.
Let's see the actual table, view, and rule definitions
21 matches
Mail list logo
