On Mon, Nov 2, 2009 at 4:41 PM, Jeff Davis wrote:
> On Tue, 2009-11-03 at 00:25 +0100, Viktor Rosenfeld wrote:
>> I'd like to know what kind of functions I have to implement for a R-Tree
>> index on numeric columns,
>
> NUMERIC is scalar, so an R-Tree doesn't make much sense. You can install
> btr
On 3/11/2009 12:20 AM, joeweder wrote:
>
> I have tried every solution that I have found for this problem but cannot get
> PostgreSQL to install. I am currently trying with 8.4.1. The installer fails
> on several machines. After investigation, I see that its during the initdb
> section.
[snip]
>
On Monday 02 November 2009 9:47:50 am Sam Jas wrote:
> Hi,
>
> I am first time posting on this forum.
>
> I am getting “Failed to update RowID generator” error
> when I am trying to load data in gridsql. I checked that error came from
> underlying database postgreSQL. We are using postgresql 8.2.
Also for one-dimensional ranges, consider contrib/seg
P.
On Mon, Nov 2, 2009 at 4:41 PM, Jeff Davis wrote:
> On Tue, 2009-11-03 at 00:25 +0100, Viktor Rosenfeld wrote:
>> I'd like to know what kind of functions I have to implement for a R-Tree
>> index on numeric columns,
>
> NUMERIC is scalar,
On Mon, Nov 2, 2009 at 3:56 PM, Brooks Lyrette wrote:
> I wish the solution was that simple. I rent the zone and that is my
> providers cap.
Am I misunderstanding this? You rent an image with 32Gigs of ram.
Your provider limits you to any single process / application being 1G
total by a cap? Th
On Tue, 2009-11-03 at 00:25 +0100, Viktor Rosenfeld wrote:
> I'd like to know what kind of functions I have to implement for a R-Tree
> index on numeric columns,
NUMERIC is scalar, so an R-Tree doesn't make much sense. You can install
btree_gist (a contrib module) to be able to use numeric column
Hi,
I'd like to create an R-Tree index on two numeric columns. As far as I
know, PostgreSQL supports R-Trees via the GiST index class for some
spatial types (box and the like). When I create a GiST index on two
numeric columns, I get the error message:
ERROR: data type numeric has no default
On Mon, Nov 2, 2009 at 1:11 PM, Brooks Lyrette wrote:
> Thanks for all the help guys.
> So this is what I get from all this. My solaris zone will cap me at around
> 900M-1000M RSS memory. Therefore using the math from a pervious reply I can
> only have about 23 connections to my database without m
On 02/11/2009, at 20:01, John DeSoi wrote:
On Nov 2, 2009, at 12:17 PM, Raimon Fernandez wrote:
when postgres has finished processing the select, just before
sending the first row(1), in the middle(2), or at the end(3), when
the last row has been sent ?
If I send the CancelRequest when
I have tried every solution that I have found for this problem but cannot get
PostgreSQL to install. I am currently trying with 8.4.1. The installer fails
on several machines. After investigation, I see that its during the initdb
section.
I got it to install successfully once; I used the installe
Thanks for all the help guys.
So this is what I get from all this. My solaris zone will cap me at
around 900M-1000M RSS memory. Therefore using the math from a pervious
reply I can only have about 23 connections to my database without
maxing out the machines memory?
This seems a little lo
On 02/11/2009 19:47, Vick Khera wrote:
> On Sat, Oct 31, 2009 at 1:06 AM, David Fetter wrote:
>>> I fully agree that it's broken, but my users just see the delay. I
>>> might have to try some sort of proxy arrangement.
>> This is not your problem. Treating it as though it were your problem
>> wi
On Sat, Oct 31, 2009 at 1:06 AM, David Fetter wrote:
>> I fully agree that it's broken, but my users just see the delay. I
>> might have to try some sort of proxy arrangement.
>
> This is not your problem. Treating it as though it were your problem
> will only lead to enormous pain to you, and w
Magnus Hagander writes:
> On Mon, Nov 2, 2009 at 18:54, Tom Lane wrote:
>> [ rename some conversion libraries to shorten source path names ]
> Seems like this would be a major PITA for packagers and end-user.
If we actually wanted to back-patch it, I think the least painful way
would be to twea
On Nov 2, 2009, at 12:17 PM, Raimon Fernandez wrote:
when postgres has finished processing the select, just before
sending the first row(1), in the middle(2), or at the end(3), when
the last row has been sent ?
If I send the CancelRequest when postgres is in point 3, I'm too
late, but if
On Mon, Nov 2, 2009 at 18:54, Tom Lane wrote:
> Steve Atkins writes:
>> I've also seen it with winzip. Again, ISTR that the exact limits were
>> obscure but that restricting the path to less than 100 characters
>> avoided any problems.
>
> Hmm. It strikes me that the names seen by tar include "p
Steve Atkins writes:
> I've also seen it with winzip. Again, ISTR that the exact limits were
> obscure but that restricting the path to less than 100 characters
> avoided any problems.
Hmm. It strikes me that the names seen by tar include "postgresql-x.y.z/".
The only file paths that approach 10
Hi,
I am first time posting on this forum.
I am getting “Failed to update RowID generator” error
when I am trying to load data in gridsql. I checked that error came from
underlying database postgreSQL. We are using postgresql 8.2.
ERROR [DatabaseLoad] -> Error While Loading :
org.postgre
Jasen Betts wrote:
> On 2009-11-01, Lew wrote:
> > I'm writing this at about 8:35 p.m. New York time on October 31, 2009.
> > From
> > now, adding interval '1 day -25 hours' yields right now, New York time.
>
> This year halloween is the longest night. Interesting.
Not the first time this h
On 02/11/2009, at 17:53, Tom Lane wrote:
Raimon Fernandez writes:
The sentence 'backend has finished processing the query' means that
postgresql has finished processing the select and also has sent all
the rows ?
There is no distinction; rows are sent as they are generated.
Yes, but a SEL
On Nov 1, 2009, at 10:19 PM, Tom Lane wrote:
Craig Ringer writes:
On 2/11/2009 11:40 AM, Tom Lane wrote:
src/backend/utils/mb/conversion_procs/
euc_jis_2004_and_shift_jis_2004/euc_jis_2004_and_shift_jis_2004.c
We have seen reports of certain versions of "tar" failing to extract
this file fr
Raimon Fernandez writes:
> The sentence 'backend has ï¬nished processing the query' means that
> postgresql has finished processing the select and also has sent all
> the rows ?
There is no distinction; rows are sent as they are generated.
regards, tom lane
--
Sent v
On 02/11/2009, at 17:35, Tom Lane wrote:
Raimon Fernandez writes:
Quoted from the documentation:
"The cancellation signal might or might not have any effect — for
example, if it arrives after the
backend has finished processing the query, then it will have no
effect.
Here I understand that
On 2/11/2009 10:38 PM, Tom Lane wrote:
> Craig Ringer writes:
>> On 2/11/2009 5:15 PM, Raimon Fernandez wrote:
>>> If for example I send a SELECT * from myTable, it has 2 rows, and
>>> postgre starts sending the rows, how I can cancel this operation ?
>
>> Assuming you're asking "is there an
Raimon Fernandez writes:
> Quoted from the documentation:
> "The cancellation signal might or might not have any effect â for
> example, if it arrives after the
> backend has ï¬nished processing the query, then it will have no
> effect.
> Here I understand that maybe it will have NO effect,
On 02/11/2009, at 15:12, John DeSoi wrote:
On Nov 2, 2009, at 4:15 AM, Raimon Fernandez wrote:
If for example I send a SELECT * from myTable, it has 2 rows,
and postgre starts sending the rows, how I can cancel this
operation ?
I thought Cancelling Requests would be perfect for thi
On 02/11/2009, at 15:38, Tom Lane wrote:
Craig Ringer writes:
On 2/11/2009 5:15 PM, Raimon Fernandez wrote:
If for example I send a SELECT * from myTable, it has 2 rows,
and
postgre starts sending the rows, how I can cancel this operation ?
Assuming you're asking "is there any way t
On Mon, Nov 02, 2009 at 10:03:49AM -0500, Tom Lane wrote:
> Sam Mason writes:
> > Rotating the array by 180 degrees in every dimension would give the same
> > answer for 1-dimensional arrays and give sensible answers for higher
> > dimensional arrays.
>
> The easy implementation at the C level wo
On Mon, Nov 02, 2009 at 09:55:20AM -0500, Merlin Moncure wrote:
> On Mon, Nov 2, 2009 at 9:51 AM, Sam Mason wrote:
> > On Mon, Nov 02, 2009 at 09:20:38AM -0500, Tom Lane wrote:
> >> Craig Ringer writes:
> >> > Before I go ahead and try to write a decent quality version: is there
> >> > any chance
On Mon, 02 Nov 2009 09:53:06 -0500
Tom Lane wrote:
> Ivan Sergio Borgonovo writes:
> > This statement succede in 8.3.8
> > alter table shop_commerce_gift drop constraint
> > shop_commerce_gift_pkey;
> > but failed in 8.3.4.
>
> Uh, that doesn't seem to match the name of the index?
Yep... that
Sam Mason writes:
> On Mon, Nov 02, 2009 at 09:20:38AM -0500, Tom Lane wrote:
>> What would it mean for a multi-dimensional array?
> Rotating the array by 180 degrees in every dimension would give the same
> answer for 1-dimensional arrays and give sensible answers for higher
> dimensional arrays
On Mon, Nov 2, 2009 at 9:51 AM, Sam Mason wrote:
> On Mon, Nov 02, 2009 at 09:20:38AM -0500, Tom Lane wrote:
>> Craig Ringer writes:
>> > Before I go ahead and try to write a decent quality version: is there
>> > any chance an array_reverse() function (in C) would be accepted into Pg
>> > mainlin
Ivan Sergio Borgonovo writes:
> This statement succede in 8.3.8
> alter table shop_commerce_gift drop constraint
> shop_commerce_gift_pkey;
> but failed in 8.3.4.
Uh, that doesn't seem to match the name of the index?
> Indexes:
> "shop_commerce_gift_giftcode_key" UNIQUE, btree (giftcode)
On Mon, Nov 02, 2009 at 09:20:38AM -0500, Tom Lane wrote:
> Craig Ringer writes:
> > Before I go ahead and try to write a decent quality version: is there
> > any chance an array_reverse() function (in C) would be accepted into Pg
> > mainline?
>
> What would it mean for a multi-dimensional array
"Bernard Grosperrin" writes:
>> The problem with doing anything is that we have only a couple of reports
>> and so no solid picture of what the restriction is.
> If it help, I am using WinZip. And checking in the archive (now that I know
> what to look for), I can see those 2 files are there! Hum
Craig Ringer writes:
> On 2/11/2009 5:15 PM, Raimon Fernandez wrote:
>> If for example I send a SELECT * from myTable, it has 2 rows, and
>> postgre starts sending the rows, how I can cancel this operation ?
> Assuming you're asking "is there any way to cancel a running query using
> the pos
2009/11/2 Grant Masan
> Size is "6154 MB". I have checked all queries, and those are as good as
> they can be in this situation. You think that this confs doesn't make really
> no difference at all ?
>
> you gotta hit 'reply all' next time ;)
configuration makes difference, but you need to know w
On Mon, Nov 2, 2009 at 9:20 AM, Tom Lane wrote:
> Craig Ringer writes:
>> Before I go ahead and try to write a decent quality version: is there
>> any chance an array_reverse() function (in C) would be accepted into Pg
>> mainline?
>
> What would it mean for a multi-dimensional array?
Couple of
Craig Ringer writes:
> Before I go ahead and try to write a decent quality version: is there
> any chance an array_reverse() function (in C) would be accepted into Pg
> mainline?
What would it mean for a multi-dimensional array?
regards, tom lane
--
Sent via pgsql-gener
On Mon, Nov 2, 2009 at 1:49 AM, Craig Ringer
wrote:
>
> Hi all
>
> Before I go ahead and try to write a decent quality version: is there
> any chance an array_reverse() function (in C) would be accepted into Pg
> mainline? If not, I probably won't bother cleaning up my current
> awful-hack quality
On Nov 2, 2009, at 4:15 AM, Raimon Fernandez wrote:
If for example I send a SELECT * from myTable, it has 2 rows,
and postgre starts sending the rows, how I can cancel this operation ?
I thought Cancelling Requests would be perfect for this ... the
workaround is closing and opening ag
On Mon, Nov 02, 2009 at 10:52:40AM +, Jasen Betts wrote:
> what's the absolute value of '1month -30 days'::interval
>
> if I add it to the first of march it goes forwards if I add it to the
In march a month has 31 days.
> first of february if goes backwards. if I add it to the first of april
On Mon, Nov 02, 2009 at 10:52:40AM +, Jasen Betts wrote:
> what's the absolute value of '1month -30 days'::interval
Curious what a use case for taking the absolute value
of such mixed intervals might be.
I could imagine such intervals being used for stuff like
"XXX is due in Y months but need
On 02/11/2009 13:55, Chris Barnes wrote:
> We are seeing the error ( 2009-11-02 08:31:30
> EST:recog...@192.168.3.153(48990):4562ERROR: current transaction is
> aborted, commands ignored until end of transaction block )
> consistantly in the database and I'm not sure if there was something
> left
I hope someone can help me determine what is going on with my database.
We have released code this weekend to our application and I have switched over
to my hot standby that has been tuned and modified to raid10. It is up and
appeared come on line and pitr is running to the standby (ok)
We
On Mon, Nov 02, 2009 at 10:52:40AM +, Jasen Betts wrote:
> what's the absolute value of '1month -30 days'::interval
>
> if I add it to the first of march it goes forwards if I add it to the
> first of february if goes backwards. if I add it to the first of april
> it goes nowhere.
>
> select
On Mon, Nov 02, 2009 at 11:22:00AM +, Jasen Betts wrote:
> On 2009-10-27, Sam Mason wrote:
> > On Tue, Oct 27, 2009 at 03:25:02PM +, Sam Mason wrote:
> >> If the absolute value of an interval was defined to strip out all the
> >> negation signs you'd get the "wrong" answers out.
> >
> > Oo
В Пнд, 02/11/2009 в 13:29 +0100, Harald Fuchs пишет:
> In article <1257149236.3426.9.ca...@localhost>,
> Vasiliy G Tolstov writes:
>
> > Hello.
> > I have table with cidr data type column (table is white/black list of
> > networks).
>
> > Does it possible to query - is the some address contains
In article <1257149236.3426.9.ca...@localhost>,
Vasiliy G Tolstov writes:
> Hello.
> I have table with cidr data type column (table is white/black list of
> networks).
> Does it possible to query - is the some address contains in any cidr
> network in this table? (for all networks in the table
On 2009-11-01, Lew wrote:
> Tom Lane wrote:
>> Sam Mason writes:
>>> On Tue, Oct 27, 2009 at 11:27:17AM -0300, Joshua Berry wrote:
I couldn't find the operator '@' for intervals
>>
>>> A simple SQL implementation would look like:
>>
>>> CREATE FUNCTION absinterval(interval) RETURNS inte
On 2009-10-27, Joshua Berry wrote:
> I couldn't find the operator '@' for intervals and found this thread
> from over six years ago:
> http://archives.postgresql.org/pgsql-general/2003-09/msg00292.php
>
>| "Claudio Lapidus" writes:
>| > Bruce Momjian wrote:
>| >> Why would you want an abolute val
On 2009-10-27, Sam Mason wrote:
> On Tue, Oct 27, 2009 at 03:25:02PM +, Sam Mason wrote:
>> If the absolute value of an interval was defined to strip out all the
>> negation signs you'd get the "wrong" answers out.
>
> Oops, forgot another reason! For maths to work (n) and (-(-n)) should
> ev
On 2009-10-27, Sam Mason wrote:
> On Tue, Oct 27, 2009 at 10:55:31AM -0400, Tom Lane wrote:
>> Sam Mason writes:
>> > On Tue, Oct 27, 2009 at 11:27:17AM -0300, Joshua Berry wrote:
>> >> I couldn't find the operator '@' for intervals
>>
>> > A simple SQL implementation would look like:
>>
>> >
On 2009-10-27, Joshua Berry wrote:
> I couldn't find the operator '@' for intervals and found this thread
> from over six years ago:
> http://archives.postgresql.org/pgsql-general/2003-09/msg00292.php
>
>| "Claudio Lapidus" writes:
>| > Bruce Momjian wrote:
>| >> Why would you want an abolute val
I prepared a script to upgrade the schema in a 8.3.8 dev box and now
I was trying to replicate the change in a staging 8.3.4 box... and
it failed.
I don't have a recent backup of my dev box so I can't check if I'm
day dreaming.
This statement succede in 8.3.8
alter table shop_commerce_gift drop c
On 2 Nov 2009, at 11:15, Alban Hertroys wrote:
That is -1.
Pressed Send too soon, that's only true for signed 32-bit integers of
course.
Alban Hertroys
--
Screwing up is the best way to attach something to the ceiling.
!DSPAM:737,4aeeb49f11071380273732!
--
Sent via pgsql-general mail
On 2 Nov 2009, at 10:21, Raimon Fernandez wrote:
byte 1: 255 &HFF
byte 2: 255 &HFF
byte 3: 255 &HFF
byte 4: 255 &HFF
-
1020 decimal or
Thou shalt not sum the byte-values of a 32-bit number!
&H 4294967295
but never -1
That is -1.
Alban Hertroys
--
Screwing up is
On 02/11/2009, at 10:37, Craig Ringer wrote:
On 2/11/2009 5:21 PM, Raimon Fernandez wrote:
Here I'm again ...
I'm parsing the DataRow(B), and I'm having problems with NULL values.
In the docs I can read they have a -1 value, an no bytes follow
them for
the value.
But I'm getting a 1020
On 02/11/2009, at 10:29, Craig Ringer wrote:
On 2/11/2009 5:15 PM, Raimon Fernandez wrote:
For what I've read in the manuals, this operation is only valid
before
PostgreSQL has finished processing the SELECT statement ?
If for example I send a SELECT * from myTable, it has 2 rows,
a
>The problem with doing anything is that we have only a couple of reports
>and so no solid picture of what the restriction is.
If it help, I am using WinZip. And checking in the archive (now that I know
what to look for), I can see those 2 files are there! Hum... Cost me quite a
few hours.
Re
On 2/11/2009 5:21 PM, Raimon Fernandez wrote:
> Here I'm again ...
>
>
> I'm parsing the DataRow(B), and I'm having problems with NULL values.
>
> In the docs I can read they have a -1 value, an no bytes follow them for
> the value.
>
> But I'm getting a 1020 value instead of -1
You're using R
On 2/11/2009 5:15 PM, Raimon Fernandez wrote:
> For what I've read in the manuals, this operation is only valid before
> PostgreSQL has finished processing the SELECT statement ?
>
> If for example I send a SELECT * from myTable, it has 2 rows, and
> postgre starts sending the rows, how I can
Thanks Tom, took me a while to realize those files were missing. The build
script did not report the source of the error, but trying to compile just
those projects in VS showed the reason immediately. Took them of the source
documentation, put them back, and compiled without any error!
take care,
Here I'm again ...
I'm parsing the DataRow(B), and I'm having problems with NULL values.
In the docs I can read they have a -1 value, an no bytes follow them
for the value.
But I'm getting a 1020 value instead of -1
Int32 The length of the column value, in bytes (this count does not
inc
Hello,
For what I've read in the manuals, this operation is only valid before
PostgreSQL has finished processing the SELECT statement ?
If for example I send a SELECT * from myTable, it has 2 rows, and
postgre starts sending the rows, how I can cancel this operation ?
I thought Canc
В Пнд, 02/11/2009 в 00:34 -0800, John R Pierce пишет:
> Vasiliy G Tolstov wrote:
> > Hello.
> > I have table with cidr data type column (table is white/black list of
> > networks).
> >
> > Does it possible to query - is the some address contains in any cidr
> > network in this table? (for all netw
Vasiliy G Tolstov wrote:
Hello.
I have table with cidr data type column (table is white/black list of
networks).
Does it possible to query - is the some address contains in any cidr
network in this table? (for all networks in the table do "contains or equals"
http://www.postgresql.org/docs/8
db de wrote:
> Below is what I did:
> I opened a super user connection to creat a super user
> statement. Then use the super user statement to execute
> "SELECT pg_start_backup('label')".
>
> try
> {
> superuserCont = java.sql.DriverManager.getConnection(URL, su,
> suPassword);
>
Hello.
I have table with cidr data type column (table is white/black list of
networks).
Does it possible to query - is the some address contains in any cidr
network in this table? (for all networks in the table do "contains or
equals"
http://www.postgresql.org/docs/8.4/interactive/functions-net.h
69 matches
Mail list logo
