On Tue, 5 Sep 2006, Nick Bower wrote:
Thanks - but what do you call big?
Several billions of stars. You can try our Cone Search service at
http://vo.astronet.ru/cas/conesearch.php
Oleg
My application is satellite data btw so the reference could be useful.
On Tue, 5 Sep 2006 01:40
Nick Bower wrote:
Thanks - but what do you call big?
How many stars do you think there are? :-)
My application is satellite data btw so the reference could be useful.
On Tue, 5 Sep 2006 01:40 pm, Oleg Bartunov wrote:
Nick,
if you need very fast spatial queries (spherical) you may use our
Thanks - but what do you call big?
My application is satellite data btw so the reference could be useful.
On Tue, 5 Sep 2006 01:40 pm, Oleg Bartunov wrote:
> Nick,
>
> if you need very fast spatial queries (spherical) you may use our
> Q3C module for POstgreSQL (q3c.sf.net). We use it for providi
Nick,
if you need very fast spatial queries (spherical) you may use our
Q3C module for POstgreSQL (q3c.sf.net). We use it for providing access
to very big astronomical catalogs.
Oleg
On Tue, 5 Sep 2006, Nick Bower wrote:
We're considering using Postgresql for storing gridded metadata - eac
On Mon, Sep 04, 2006 at 06:16:49PM +0200, Philippe Lang wrote:
> > I have deleted the subroutines now, but problem remains. Does
> > that mean the variables created inside a plperl function are
> > alive for the duration of the database connection?
>
> It seems to be the case: if I rename all the
In Windows XP Pro (SP2) I tried to upgrade
PostgreSQL server from 8.1.2 to 8.1.4., by using upgrade.bat. Everything
goes nice until end of installation when the following error apears:
"Service 'PostgreSQL Database Server 8.1' (pgsql-8.1) could not be
installed. Verify that you have suffic
On Tue, Sep 05, 2006 at 09:26:59AM +0800, Nick Bower wrote:
> So given 4000x700x2x365x10 > 2 billion, is this going to be a problem if we
> will be wanting to query on datetimes, Postgis lat/lon, and integer-based
> metadata flags?
That figure is about 20 billion, which is indeed > 2 billion :-
We're considering using Postgresql for storing gridded metadata - each point
of our grids has a variety of metadata attached to it (including lat/lon,
measurements, etc) and would constitute a record in Postgresql+Postgis.
Size-wise, grids are about 4000x700 and are collected twice daily over sa
> I need to porting many old ORACLE-oriented-SQL files and I have many
> problem with this code. Sometimes the code use some types not supported
> in PosgSQL like "number" or "varchar2", there fore, can I write some
> type of declaration (like in c : #define alias_name name) in order to
> mak
gustavo halperin wrote:
Hello
I need to porting many old ORACLE-oriented-SQL files and I have many
problem with this code. Sometimes the code use some types not supported
in PosgSQL like "number" or "varchar2", there fore, can I write some
type of declaration (like in c : #define alias_name n
Clarence Gardner <[EMAIL PROTECTED]> writes:
> The difference I'm asking about is that my artificial ones always involve
> waiting on a transaction, while the ones from the real application always
> involve one transaction wait and one tuple wait.
> The first question is, is there any significance
I am trying to locate the source of some deadlocks that have started
cropping up recently, with little success, and I have a question regarding
the message that accompanies them.
The message my application gets is like this:
Process 244 waits for ShareLock on transaction 39523645; blocked by
proc
Hello
I need to porting many old ORACLE-oriented-SQL files and I have many
problem with this code. Sometimes the code use some types not supported
in PosgSQL like "number" or "varchar2", there fore, can I write some
type of declaration (like in c : #define alias_name name) in order to
make Po
On 9/3/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Fri, Sep 01, 2006 at 11:55:32AM -0400, Christopher Murtagh wrote:
> I've got a function that returns and array $foo, and an array $bar.
> Is there an elegant way to test if $bar is a subset of $foo? I've been
> looking through the docs and hav
On 9/4/06, Alban Hertroys <[EMAIL PROTECTED]> wrote:
Michael Glaesemann wrote:
> Note that epoch does not mean 1900-01-01 00:00:00.
select *, timestamp 'EPOCH' + "timestamp" * interval '1 second' as
tstamp from ccmanager_log where id > 15400
select *, timestamp '1900-01-01 00:00:00' + "times
You need to provide more details.
Oleg
On Fri, 1 Sep 2006, Michelle Konzack wrote:
Hello Jonatan,
Am 2006-08-30 19:09:19, schrieb Yonatan Ben-Nes:
I want to use Tsearch2 for a current project I have but I can't seem to
find a way to implement it on hebrew content.
I have the same problem si
test
Hi,
I forgot to mention that we are using plphp version 1.1 but I guess that
in the process of making a pg_restore this issue does not really matter.
Thanks Mario.
Mario Lopez escribió:
Hi,
The platform as you have seen is Debian testing branch. I have
activated log_statement but again not
Mario Lopez <[EMAIL PROTECTED]> writes:
> PID:8069 CMD_TAG:idle XID:274157581 LOG: 0: sentencia: INSERT INTO
> scannmap4 VALUES (1719914, 2, 117, 28, 1155, 17073, 1, 1, '', '', '',
> '', NULL);
> PID:8069 CMD_TAG:idle XID:274157581 UBICACIÓN: log_after_parse,
> postgres.c:605
> PID:8025 CM
[EMAIL PROTECTED] wrote:
> Tom Lane wrote:
>> "Philippe Lang" <[EMAIL PROTECTED]> writes:
>>> Here is a reduced example that shows the problem.
>>
>> Hm, I'm no Perl guru, but isn't the second script to be loaded going
>> to redefine those subroutines that the first script defined? I'm
>> pretty
Tom Lane wrote:
> "Philippe Lang" <[EMAIL PROTECTED]> writes:
>> Here is a reduced example that shows the problem.
>
> Hm, I'm no Perl guru, but isn't the second script to be
> loaded going to redefine those subroutines that the first
> script defined? I'm pretty sure that there's not an implicit
Hi,
The platform as you have seen is Debian testing branch. I have activated
log_statement but again nothing clear, the query that makes the system
fail has nothing strange on it here is a dump.
I do not know how toget a stack trace and the "crash" does not provide a
core dump :(. Could you
"Philippe Lang" <[EMAIL PROTECTED]> writes:
> Here is a reduced example that shows the problem.
Hm, I'm no Perl guru, but isn't the second script to be loaded going to
redefine those subroutines that the first script defined? I'm pretty
sure that there's not an implicit independent namespace for
"Philippe Lang" <[EMAIL PROTECTED]> writes:
> I've got a strange bug with two plperl functions using OUT parameters:
What PG version is this? (If it's not recent, I'm wondering about the
perl locale-reset issues we fixed awhile ago.)
If it is an up-to-date version, please provide a self-containe
Hello Jonatan,
Am 2006-08-30 19:09:19, schrieb Yonatan Ben-Nes:
> I want to use Tsearch2 for a current project I have but I can't seem to
> find a way to implement it on hebrew content.
I have the same problem since I have an UTF-8 Database of arround
380 GByte (growing 100 MByte per day) in ove
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Maybe someone else has an idea? The previous-to-last message below is
> "server process exited with exit code 255".
That's very strange if the platform is Linux --- I was guessing it was
Windows.
Please try to get a core dump from the crash and provid
Hi again..
There are no kernel messages and I do not seem to find anything related
to this error code. The version installed is the last version available
in Debian testing branch:
postgresql-8.18.1.4-6
I have searched and there are not any known bugs about XID or pro
Hola,
Mario Lopez wrote:
> Hola Alvaro,
>
> The process that are being reaped are postgresql child processes, more
> precisely the process that is attending my queryes...
>
> Here I have another log that has the %p %i and %x in that order but I
> see no clear difference.
I see the same as you
Hola Alvaro,
The process that are being reaped are postgresql child processes, more
precisely the process that is attending my queryes...
Here I have another log that has the %p %i and %x in that order but I
see no clear difference.
Thanks.
Alvaro Herrera escribió:
Mario Lopez wrote:
[EMAIL PROTECTED] wrote:
> Hi,
>
> I've got a strange bug with two plperl functions using OUT
> parameters: with a fresh ODBC or pgAdmin connection, I can
> call the first function, but then all further calls to the
> second function fail, or call the the second function, but
> then all further ca
Mario Lopez wrote:
> Hi Alvaro,
>
> Ok, maybe is not a crash but this issue makes postgresql reap all of
> it's child processes and restart operations, after this error I get in
> pg_restore this message:
>
> pg_restore: [archivador (bd)] Error durante PROCESAMIENTO DE TABLA DE
> CONTENIDOS:
Hi Alvaro,
Ok, maybe is not a crash but this issue makes postgresql reap all of
it's child processes and restart operations, after this error I get in
pg_restore this message:
pg_restore: [archivador (bd)] Error durante PROCESAMIENTO DE TABLA DE
CONTENIDOS:
pg_restore: [archivador (bd)] Err
Mario Lopez wrote:
> Hi!,
>
> I am having an XID issue with PostgreSQL, while doing a pg_restore from
> a 200MB saved database I get a server crash, searching through the debug
> messages I have found that PostgreSQL crashes due to a exausted XID
> resource with a message that looks this way (s
Hi!,
I am having an XID issue with PostgreSQL, while doing a pg_restore from
a 200MB saved database I get a server crash, searching through the debug
messages I have found that PostgreSQL crashes due to a exausted XID
resource with a message that looks this way (sorry for the Spanish log)
UB
Hi,
I've got a strange bug with two plperl functions using OUT parameters: with a
fresh ODBC or pgAdmin connection, I can call the first function, but then all
further calls to the second function fail, or call the the second function, but
then all further calls to the first function fail. Even
Michael Glaesemann wrote:
Note that epoch does not mean 1900-01-01 00:00:00.
Indeed! Where did this 1900 sneak in? Aren't timestamps usually based on
epoch?
--
Alban Hertroys
[EMAIL PROTECTED]
magproductions b.v.
T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbu
[EMAIL PROTECTED] wrote:
Wouldn't this be the perfect opportunity for one of
the gurus to
announce their killer new online gratis training
program?
My ideas; There must be some universities that have courses into
database design and implementation that are based on PostgreSQL.
If syllables(s
Sean O'Loughlin wrote:
> I have a question about how a certain function would look. Basically, what I
> want to do is having something that would take in a 'from' date (day, month,
> year) and a 'to' date (also day, month and year) and then spit back a series
> of records whose timestamps
On Sep 4, 2006, at 17:58 , Alban Hertroys wrote:
Peter Eisentraut wrote:
It's not clear what the meaning of a double precision as a
timestamp would be. How about you make that explicit:
"timestamp" * interval '1 second' + timestamp '1900-01-01 00:00:00'
There's also 'EPOCH', which is shor
Peter Eisentraut wrote:
Frank Church wrote:
error: cannot cast tupe double precision to timestamp without time
zone
What is the right syntax?
It's not clear what the meaning of a double precision as a timestamp
would be. How about you make that explicit:
"timestamp" * interval '1 second'
On Sun, 3 Sep 2006, mdean wrote:
Guys, a multiple perspective is important. Your perspective is valid, but
doesn't address the true purpose of these easy certs. They are designed to
give the companies involved larger mind space among programmers, admins, and
companies hiring them. They are a
41 matches
Mail list logo
