I'm interested in doing a project for calculating distances similar to
this. Anyone have suggestions on how/where this type of data can be
obtained? Is it freely available anywhere?
On 6/27/05, Uwe C. Schroeder <[EMAIL PROTECTED]> wrote:
>
> Actually it does.
> I'm using a bounding box too. I
How would you handle the migration of the data with these user
scripts? Dump it to a temp table?
On 6/9/05, elein <[EMAIL PROTECTED]> wrote:
> Up until the database goes into production,
> keep files: schema.sql (table creation),
> views.sql, functions.sql triggers.sql trigfunctions.sql
> in cvs
I was just curious how you guys implement storage / calculation of
monetary data in postgresql. The docs say to use the numeric data
type, but I'm curious what precision is typically defined for storing
monetary data in the numeric data type.
Thanks for any info...
---(en
I was just curious about what would happen given the following scenario:
- Unix user has their own tablespace (and corresponding database)
stored in /home/someuser/mydata
- Quotas are enabled on /home
- User reaches their quota, effectively causing only this tablespace
to run out of disk space.
I was just curious about the following scenario:
- Unix user has their own tablespace (and corresponding database)
stored in /home/someuser/mydata
- Quotas are enabled on /home
- /home runs out of disk space
What happens to the user's tablespace? How does postgres handle this scenario?
-
Actually, that's a thought.. I could even create a bash wrapper
script so I wouldn't have to type the database name each time. Will
give it a shot.
Thanks
On 4/25/05, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Mon, Apr 25, 2005 at 10:44:14AM -0500, John Browne wrote:
&
Yeah, I know about pg_dump. I just was curious if there was another
way, since I always have two psql consoles already open at all times
anyway. :-)
On 4/25/05, John Browne <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I was curious if there was a way to get the DDL for a particular t
Hello,
I was curious if there was a way to get the DDL for a particular table
from the psql client console? I have two postgres boxes (development
and production) and would like to copy & paste the DDL "CREATE TABLE"
statements from the development console to the production console when
I'm movin
Ok, I've been using postgres for a-while now, and am curious how you
guys handle this. What is the best way to make modifications to
tables that have lots of dependent objects, like views? Do you just
do the obvious drop...cascade and manually re-create your views? Do
you keep your "create view"
I was attempting to set up my psql client on the Win32 version of
postgres 8.0 beta 2 to be able to use an external editor. I set the
environment variable in windows like so:
PSQL_EDITOR="c:\progra~1\Textpa~1\Textpad.exe"
which does appear to work correctly. However, I get the following
when at
10 matches
Mail list logo
