Hello All,
I know there's been quite a few posts on Zip Code Proximity.
Can anyone point me in the right direction to find the code to calulate
the distance between two zip codes?
I'm basically trying to take a zip code given by a user and return them
all of the zip codes within, say 10 miles o
Richard J Kuhns <[EMAIL PROTECTED]> writes:
> Now for the question. What's the reason for using this method, as opposed
> to using, say, a system catalog to hold the valid locations? Historical?
> Having to stop and restart the backend so it can re-read its environment
> seems kind of archaic.
Paul Condon wrote:
>
> I am attempting to migrate to 7.0 using the RPMs that were recently
> announced.
> I use >rpm -Uvh
> During the processing of several of the RPMs I get a message:
> /sbin/ldconfig: warning: /usr/lib/libnewt.so.0.50 is not a symlink
> What does this mean? Should I be worrie
Hi,
When I try to use pg_dump, I get this error. Can it have something to
do with a custom type I added. I made sure I added the input/output functions
and comparision functions for sorting and queries.
The type works fine in SQL queries in general.
> pg_dump -s scm
\connect - d23adm
failed s
>
I don't know the internals of PostgreSQL, but logically INTERSECT is a join, but with
an automatic
default generation of the WHERE clause. As such, there should not be any difference in
performance
on tables that are large enough to mask small differences in the time it takes to
parse the
co
hi,
we're looking at migrating from ORACLE to postgres in the
very near future and we've run into a small problem. there's
a data type defined "LINE". we have named one of our tables
as "LINE" also and it would require a great deal of code
changes to rename that table. is it possible to sim
Dear All,
I'll be away for a few weeks... can anyone tell me how to switch my mail
from this mailing list off for the duration, and how to switch it to digest
mode on my return?
Thanks much
Rob
If I set the block size from 8k to 16k by editing /include/config.h, then all
tuples will take up 16k on disk? If true, it just wastes lots of disk space if
you are really not going to be storing more than 8k in most tuples?
--
Robert B. Easter
[EMAIL PROTECTED]
On Wed, May 17, 2000 at 02:53:17PM -0400, Robert B. Easter wrote:
>
> If I set the block size from 8k to 16k by editing /include/config.h, then all
> tuples will take up 16k on disk? If true, it just wastes lots of disk space if
> you are really not going to be storing more than 8k in most tuple
I believe there is a bug, or at least a not very nice feature in initdb.
If initdb does not succeed, it attempts to "exit_nicely". By default
this involved deleting the $PGDATA directory!! So if you have put other
things in you $PGDATA directory or (as in my case) you attempt to create
a datab
I've just created a new database and I am wondering...
Why are all sequence files 8K? They're one freaking int.
How come the indexes are so large? They tend to be larger than the
database files themselves. In one case I have a 16K index on an empty
table.
-rw---1 postgres postgre
-Original Message-
From: Joseph Shraibman <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, May 17, 2000 4:33 PM
Subject: [GENERAL] why so big?
>I've just created a new database and I am wondering...
>
>Why are all sequence files 8K? They're one freaking int
Jeffery Collins writes:
> Wanna' bet? Perhaps I had an even older version?
FWIW, it turns out that mine is actually 2.2.1.
> I don't know alot about the readline library, but perhaps it would be
> sufficient to check for the presence of "using_history" in the library
> and not bother to check f
Jeffery Collins writes:
> It seems like it would be a whole lot "nicer" if initdb only deleted
> the files that it attempted to create OR if the default was not to
> delete anything.
Okay, I could go for the former. What do others think?
--
Peter Eisentraut Sernanders väg 10:1
I'd like to write some functions in embedded perl. I have installed
Mandrake from the RPMS recommended on this list a few days ago ( They
worked great, by the way). I have also downloaded the source so I can
compile plperl.so. But I can't because appearantly libperl.so is not
configured proper
Peter Eisentraut <[EMAIL PROTECTED]> writes:
>> It seems like it would be a whole lot "nicer" if initdb only deleted
>> the files that it attempted to create OR if the default was not to
>> delete anything.
> Okay, I could go for the former. What do others think?
It'd be a bit of a pain but I ca
> I want to build a database in chinese.
> But when I input chinese in the linux psql client , it doent's display well.
> So how can I solve it?
Does your cat command show your Chinese texts correctly? If not, that
might not be a PostgreSQL problem.
BTW, what kind of encoding are you using for
Travis Bauer <[EMAIL PROTECTED]> writes:
> compile plperl.so. But I can't because appearantly libperl.so is not
> configured properly on my machine. I'm using Mandrake 7.0, and the only
> copy of libperl.so that I can find is in: /usr/lib/apache (thanks to the
> mod-perl rpm).
Probably your
> A slightly more reasonable example is where the admin has already
> inserted his own pg_hba.conf in the directory; would be nice if initdb
> didn't overwrite it (nor delete it on failure), but I'm not sure it's
> worth the trouble.
I am inclined to leave it as is too. I can imagine many bug re
Thanks Jeff. I'm the guy that started that thread. Been meaning to get
back to the problem but had other issues on the project. Now I know what to
do next. Appreciate your posting the solution.
-=michael=-
*
* Michael S. Kelly
* 4800 SW G
Patrick Robin <[EMAIL PROTECTED]> writes:
> When I try to use pg_dump, I get this error. Can it have something to
> do with a custom type I added. I made sure I added the input/output functions
> and comparision functions for sorting and queries.
> The type works fine in SQL queries in general.
>
> > Tom Lane wrote:
> >
> > > Travis Bauer <[EMAIL PROTECTED]> writes:
> > > > compile plperl.so. But I can't because appearantly libperl.so is not
> > > > configured properly on my machine. I'm using Mandrake 7.0, and the only
> > > > copy of libperl.so that I can find is in: /usr/lib/apache (
Tom Lane wrote:
> Karl DeBisschop <[EMAIL PROTECTED]> writes:
> > or 'ar -a libperl.a' into a directory then gcc the resulting .o
files into a
> > single libperl.so
>
> That will only work on platforms where code is compiled
> position-independent by default.
Yes. Such seems to be the case for
23 matches
Mail list logo
