talenat wrote:
Hi,
I have a mandrake 10.1 server running Postgres 8.1beta3 with hr_HR
locale. Client is a XP with WIN1250 code page.
When I use ORDER BY in query collation is out of order.
I have tried with client encoding WIN1250 and LATIN2 but with no luck.
If I use XP as a server with postgr
On Thu, 13 Oct 2005, Ivan Yu. Zolotukhin wrote:
> Hello,
>
> I'm trying to organize storage and processing of a graph (pretty spare,
> 100,000 vertices and 5,000,000 edges) with PostgreSQL.
>
> I have two main problems:
> - standart problem of finding all shortest paths between two given vertice
Matthew Peter <[EMAIL PROTECTED]> writes:
> I was trying to search a array with a GTE to value and
> it doesn't work. Is this supported? Or am I missing
> something?
> SELECT * FROM sal_emp WHERE 1 >= ALL (pay_by_quarter);
Define "doesn't work". Do you get an error --- if so, what exactly?
D
On Oct 17, 2005, at 12:47 , CSN wrote:
I've been meaning to try out PostGIS and see what it
is capable of. Is anybody using it? Do you have
accompanying URLs?
The best place to get information on PostGIS is from the PostGIS
site. You may want to join their mailing list as well.
http://post
Since nobody has told me why my proposal doesn't work, I figure I will
point out that it does solve this problem nicely. However, it makes the
assumptions that we treat the identifiers as quoted when the backend
uses them to look them up in the system catalogs. Also I am rethinking
a few deta
Matthew Peter wrote:
I was trying to search a array with a GTE to value and
it doesn't work. Is this supported? Or am I missing
something?
SELECT * FROM sal_emp WHERE 1 >= ALL (pay_by_quarter);
Works for me:
CREATE TABLE sal_emp (
name text,
pay_by_quarter integer[],
schedule text[][]
Hi,
I have a mandrake 10.1 server running Postgres 8.1beta3 with hr_HR
locale. Client is a XP with WIN1250 code page.
When I use ORDER BY in query collation is out of order.
I have tried with client encoding WIN1250 and LATIN2 but with no luck.
If I use XP as a server with postgres 8.1beta3 then
I've been meaning to try out PostGIS and see what it
is capable of. Is anybody using it? Do you have
accompanying URLs?
Thanks,
CSN
__
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/
--
On 10/16/2005 5:25 PM, Marc G. Fournier wrote:
On Sun, 16 Oct 2005, Chris Travers wrote:
Marc G. Fournier wrote:
They do not "own" MaxDB. They license it, just like Innodb.
Damn, do they ever have alot of "loose ends" ... what part, exactly,
constitutes "MySQL" vs third party add ons?
Ever since I installed a particular program, PHPWiki, I am seeing idle
postgres sessions.. even days old. Is it safe to delete them?
For example:
postmaster: wiki simplicato_wiki [local] idle (postgres)
Ultimately I will either switch wiki or take the time and find the piece
of code that is ca
<[EMAIL PROTECTED]> writes:
> are there any way to make them global for all the instances?
Put them in shared memory. This probably isn't trival, as all the
shared memory is allocated up front and used for existing purposes (at
least, as I understand it).
I guess you could always allocate your
are there any way to make them global for all the instances?
On 10/14/2005, "Douglas McNaught" <[EMAIL PROTECTED]> wrote:
>TJ O'Donnell <[EMAIL PROTECTED]> writes:
>
>> I have begun to use some static variables in my c-language
>> functions to maintain state (3rd party licensing issues) during
>
El Dom 16 Oct 2005 01:20, Chris Travers escribió:
>
> The only real downside is that I could see MySQL developing a
> FirebirdSQL table handler if too much pressure is put on them. This
> might actually work OK since Firebird has an embeddable engine. If they
> do this then Oracle might end u
Chris Travers <[EMAIL PROTECTED]> writes:
> I make the following assumptions:
> 1) All backend references to identifiers are treated as quoted by the
> backend as mentioned in a previous thread.
> 2) Same with official clients like psql.
> 3) We don't guarantee complete backward compatibility
On Sun, 16 Oct 2005, Chris Travers wrote:
Marc G. Fournier wrote:
They do not "own" MaxDB. They license it, just like Innodb.
Damn, do they ever have alot of "loose ends" ... what part, exactly,
constitutes "MySQL" vs third party add ons? :)
If MaxDB, InnoDB, and DBD engines are all
Marc G. Fournier wrote:
They do not "own" MaxDB. They license it, just like Innodb.
Damn, do they ever have alot of "loose ends" ... what part, exactly,
constitutes "MySQL" vs third party add ons? :)
If MaxDB, InnoDB, and DBD engines are all licensed, then they have problems.
MyISAM?
Joshua D. Drake wrote:
But what if they came in sideways and bought Command Prompt?
Well then I would be sitting on a beach in New Zealend with an umbrella
drink :)
(As an
example.) You could do a lot more to destroy PostgreSQL's market in the
business world by destroying the vari
Martijn van Oosterhout wrote:
On Sat, Oct 15, 2005 at 05:46:03PM -0700, Chris Travers wrote:
This is largely what I have been suggesting. However, you still have
two (small) problems that could be solved fairly easily I think. Take
Tom's example:
SELECT MAX(relpages) FROM pg_class;
Now
I was trying to search a array with a GTE to value and
it doesn't work. Is this supported? Or am I missing
something?
SELECT * FROM sal_emp WHERE 1 >= ALL (pay_by_quarter);
__
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
Am Freitag, den 14.10.2005, 08:52 -0700 schrieb Joshua D. Drake:
> Hello,
>
> Command Prompt has started a community project to allow for easier
> inspection of the
> PostgreSQL source. The project is no where near complete but this is
> what we have
> done:
>
> 1. Converted the entire PostgreS
Matthew writes:
> Is it worth having a GUC variable that enables / disable this?
That's a given, I think. We're certainly not going to make smash-to-
lower-case the only available behavior.
One issue we might want to reflect on is how easy it should be to change
the variable's setting. Our ba
Matthew wrote:
Tom Lane wrote:
Although ... it's true that there seem to be very few apps relying on
case sensitivity per se, ie, expecting "Foo" and "foo" to be different.
The complaints that I can remember were about programs that expected
"FOO" and FOO (not quoted) to be the same. So alway
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> I guess you could get around that if you leave the case-folding in the
> lexer as is but instead make the nameeq function case insensitive.
If you do that then you have to nail down the behavior at initdb time
(else flipping the switch will corrupt
Martijn van Oosterhout writes:
> Okay, how do we refer to the "RI_FKey_cascade_del" function then? Or
> trigger "RI_ConstraintTrigger_2204908". Using $$ quoting? Invent
> another quoting style?
Yeah, I was wondering about those myself. Probably we could just change
their names to something that
"Andrew Janian" <[EMAIL PROTECTED]> writes:
> If I cancel the update then I can drop the new column, rename the old
> column, do a vacuum, and then I should be left with what I started with,
> right?
Right.
> How can I expand that column without using this query?
Basically you want to alter the
Tom Lane wrote:
> > Note to implementor: In 'SELECT 1 as "Title"', the quoted string
> > should not be lowercased, even if you are lowercasing everything
> > else...
>
> You don't get to have that, I think, because the lexer is not context
> aware. It's not clear to me why it's a good idea anyway.
Tom Lane wrote:
Although ... it's true that there seem to be very few apps relying on
case sensitivity per se, ie, expecting "Foo" and "foo" to be different.
The complaints that I can remember were about programs that expected
"FOO" and FOO (not quoted) to be the same. So always-smash-to-lower-
On Sun, Oct 16, 2005 at 12:40:25PM -0400, Tom Lane wrote:
> Martijn van Oosterhout writes:
> > Actually, perhaps an even more restricted version would be better.
> > Lowercase quoted identifiers only if they are all uppercase. So then:
>
> No, I think the original proposal was better. This one d
The actual table that I am updating is 134GB of the 135GB. Each row has
one foreign key to another table, but no tables have a foreign key to
this table.
If I cancel the update then I can drop the new column, rename the old
column, do a vacuum, and then I should be left with what I started with,
jeff sacksteder wrote:
The sign doesn't concern me. I am storing a value that is unsigned and 16
bits wide natively. I'll have to just use an int4 and waste twice the space
I actually need.
Are you sure you'd really save space with a 16 bit type? Often times
that savings gets lost in alignme
On Sat, Oct 15, 2005 at 05:46:03PM -0700, Chris Travers wrote:
> This is largely what I have been suggesting. However, you still have
> two (small) problems that could be solved fairly easily I think. Take
> Tom's example:
>
> SELECT MAX(relpages) FROM pg_class;
>
> Now, I am perfectly happy
"Andrew Janian" <[EMAIL PROTECTED]> writes:
> I needed to expand the size of one of the varchar columns in a table of
> my 135GB database.
How big is the particular table you are doing this on? What foreign key
relationships is it involved in? (I wonder if the time is going into FK
checking more
Martijn van Oosterhout writes:
> Actually, perhaps an even more restricted version would be better.
> Lowercase quoted identifiers only if they are all uppercase. So then:
No, I think the original proposal was better. This one doesn't fix
things for the lusers who think "MixedCase" and unquoted
I needed to expand the size of one of the varchar columns in
a table of my 135GB database. To do this, I used the following command:
ALTER TABLE mb_fix_message RENAME COLUMN mb_symbol TO
mb_symbol_old;
ALTER TABLE mb_fix_message ADD COLUMN mb_symbol VARCHAR(25);
UPDATE mb_fix_message
Jan Wieck wrote:
On 10/13/2005 2:40 PM, Tom Lane wrote:
Chris Travers <[EMAIL PROTECTED]> writes:
So basically, the problem is that any fix for case folding would
touch a fair bit of code and possibly cause other problems.
However, I haven't seen anyone worry about performance issues in
s
Andrew Sullivan wrote:
On Fri, Oct 14, 2005 at 11:54:19PM +0900, Tatsuo Ishii wrote:
Enforcement? There would be plenty of ways to achieve that. For
example, you could set pg_hba.conf so that on ly the host where pgpool
is running on could connect to the host where postmaster is running
on.
Tom Lane wrote:
That's a really interesting angle --- not only does Oracle get rid of
what they may or may not see as serious competition, but they get a
chance to make some money at the same time. I'm not convinced about the
"only one table handler" part of your story. Oracle certainly has th
For the record, I am trying to flesh out my thoughts on this issue. I
am not asking Tom to do this BTW :-) because I am sure he has more
pressing contributions to make. However, because it can be an issue for
those migrating from, say, Oracle, it would be good to have a discussion
on what wou
On Sun, Oct 16, 2005 at 10:00:25PM +0800, Lincoln Yeoh wrote:
> >Martijn van Oosterhout writes:
> >> Seems to me we'd be better off creating an option
> >> "lowercase_quoted_anyway" which solves everything, at the expense of
> >> being even less compliant.
>
> I think that'll be a good option to
Hi,
First of all, I don't know whether this is the right place to ask about
the usage of my2pg.pl. Sorry if I'm wrong :)
I'm trying to find a web-based project management that's based on
postgresql. So far I found none. So I'm trying whether it's possible
to convert dotProject from mysql to po
At 11:43 AM 10/15/2005 -0400, Tom Lane wrote:
Martijn van Oosterhout writes:
> Seems to me we'd be better off creating an option
> "lowercase_quoted_anyway" which solves everything, at the expense of
> being even less compliant.
I think that'll be a good option to have.
paying attention to
On Sun, Oct 16, 2005 at 11:03:52AM +0200, Sim Zacks wrote:
> I tried to create a new type with input and output functions in plpgsql and
> it didn't work.
> The error I got is there is no type uint2.
> Is this because plpgsql does not allow you to create input/output fuctions?
> It is a very simple
I tried to create a new type with input and output functions in plpgsql and
it didn't work.
The error I got is there is no type uint2.
Is this because plpgsql does not allow you to create input/output fuctions?
It is a very simple function, so I didn't want to do it in C.
Is there a reason that it
You can create a new type based on int2 called uint2.
he input function should subtract 32768 and the output function should
add 32768. The result should be an int4 so that a number such as 4
can be displayed. The storage space required would still only be an
int2. The actual value stored in th
44 matches
Mail list logo
