Greg Stark wrote:
> Neil Conway <[EMAIL PROTECTED]> writes:
>
>
>>I think debbugs is fairly close to what we'd need, for reasons stated
>>earlier:
>>
>>http://archives.postgresql.org/pgsql-hackers/2005-05/msg01156.php
>>
>>(I think Bugzilla is *completely* the wrong tool for the Postgres
>>develo
I agree that select for update will be the best choice but it does not have any effect with insert statements.
if you try the following sequence in two different transactions, the select for update will succeed but the insert will be blocked.
begin transaction;select employee_id from employees
On Wed, 2005-10-12 at 16:49 -0500, Scott Marlowe wrote:
> On Wed, 2005-10-12 at 16:16, Chris Travers wrote:
> > Denis G Dudhia wrote:
> >
> > > Hello There...
> > >
> > > I am new to PostgreSQL.
> > >
> > > I usually check out negative sides of any software or system, before
> > > implementing it
On Tuesday 11 October 2005 01:50, Jim C. Nasby wrote:
> What's the datatype on naamvrouw? Notice that it's being casted to text,
> which means an index on that column won't be used.
>
Datatype is text. My problem is that I want it to use the date of birth index.
I've increased the statistics to 10
Hi everyone,
I just want to know if there is an equivalent method in PostgreSQL that acts like SQL Server's extended stored procedure. I want to run a stored procedure that can update a file in the file system.. I dont know whether I can do this using PL/pgSQL or do i need to use another metho
Hello,
my question must be rather common though I've not seen it discussed it
anywhere yet: what is the most efficient way to get all different values
of a given column with low cardinality ? For instance I have a table
with columns DAY, NAME, ID, etc. Now I would like to list all values
for DA
am 13.10.2005, um 3:36:19 -0700 mailte Josephine E. de Castro folgendes:
> Hi everyone,
>
> I just want to know if there is an equivalent method in PostgreSQL
> that acts like SQL Server's extended stored procedure. I want to run a
> stored procedure that can update a file in the file system.
On 10/13/05 6:36 AM, "Josephine E. de Castro" <[EMAIL PROTECTED]>
wrote:
> Hi everyone,
>
> I just want to know if there is an equivalent method in PostgreSQL that acts
> like SQL Server's extended stored procedure. I want to run a stored procedure
> that can update a file in the file system..
Hi Sean! Thanks for your reply. :)
My knowledge of PL/Perl is limited and confined to knowing that such language exist.
Is there no 'trusted' way of doing this? How about creating a trigger using C? Or should i stick with something like PL/pgSQL and look for its 'untrusted' flavors?
Anywa
Thanks Andreas!
I will try yours and Sean's suggestions and see where it will take me! :)
I've got some learning to do and I'm really grateful for the replies that I got from this group!
Again, my utmost gratitude!
:)
"A. Kretschmer" <[EMAIL PROTECTED]> wrote:
PL/pgsql i a trusted language
You
should have a look at the following item of documentation :
http://www.postgresql.org/docs/8.0/interactive/xfunc-c.html
Patrick
---
Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36
18 -
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 vertices;
- search thru vertices' properties with ordering by path
On Thu, Oct 13, 2005 at 04:20:39AM -0700,
Josephine E. de Castro <[EMAIL PROTECTED]> wrote
a message of 49 lines which said:
> Is there no 'trusted' way of doing this?
By definition, certainly not. A "trusted" procedure can be installed
by an ordinary user so it MUST NOT play outside of the s
Hello,
I have a table column TIMESTAMP (6) WITHOUT TIME ZONE
that I am trying to read and write as binary. Postgres
is configured to use int64 for timestamps (not
double).
I found tm2timestamp() in libpgtypes.so that seems to
convert struct tm to a Postgres timestamp correctly
(at least for the d
[EMAIL PROTECTED] writes:
> I've increased the statistics to 1000, and only occasionally, because of the
> very uneven distribution of surnames, the planner does the wrong thing.
> I've tried to set an even higher limit, but 1000 seems to be the maximum.
> Is this hardcoded, or can I set a higher
I have a table that has some columns which store 'custom' fields so the
content varies according to the user that the row belongs to. For one
of the groups of users the field is a date (the type of the field is
'text' though). I'm trying to perform a query where it only returns
values in a certai
Hello,
i'm using postgresql 7.4.7 on a debian system with a 2.00GHz CPU hyperthreaded,
1GB RAM and 160GB
SCSI disk.
We optimize some parameters to increase performance:
shared_buffers=18750
effective_cache_size=62500
wal_buffers=64
default_statistics_target=100
vacuum_mem=10
deadlock_timeout
[snipped]
> May not be the best choice on Windows for production use, though for
> development, it should be adequate.
Are there known issues with the Windows version for production use, or
is this simply because of the relative newness of the Windows-native
version?
- Bill
-
You seem to be assuming that conjuncts in the where clause are
processed in order, a la many programming languages (this is sometimes
called "short circuiting"). I don't think this is so in SQL, else many
optimizations would not be possible. I have even see the planner break
up and rearrange
julien WICQUART wrote:
But we still have insert that take more that 1s on little table (24000 tupples
with 10 rows).
We've got 633 connexions/mn on our all databases (68 databases with less than
10 rows each) which
How often are you vacuuming?
What does "VACUUM FULL VERBOSE little_table" s
Bill Bartlett wrote:
[snipped]
May not be the best choice on Windows for production use, though for
development, it should be adequate.
Are there known issues with the Windows version for production use, or
is this simply because of the relative newness of the Windows-native
version?
Perfor
I would like to believe that its the latter, it should improve with time.
On Wed, 12 Oct 2005, Bill Bartlett wrote:
>
>[snipped]
>
>> May not be the best choice on Windows for production use, though for
>> development, it should be adequate.
>
>Are there known issues with the Windows version for
> > [snipped]
> >
> >> May not be the best choice on Windows for production use,
> though for
> >> development, it should be adequate.
> >
> > Are there known issues with the Windows version for
> production use, or
> > is this simply because of the relative newness of the
> Windows-native
Installing PPG_80R3_WIN on windows xp sp2 with
jdk1.5.0_04 intalled. Getting error msg "This
platform is not supported by Pervasive Postgres".
The same binary installs without any problem on
windows server 2003 with j2sdk-1_4_2_09-windows-i586-p installed.
I am getting this msg at start
On Tue, Oct 11, 2005 at 11:38:22AM -0500, Scott Marlowe wrote:
>
> Don't get me wrong, if replication is one of the things you need, then
> consider it, but if you're putting bad data into your database, what
> good is replicating it gonna do ya?
But if real, ORAC-style clustering is what you nee
Why not something like Mantis bug tracker? (http://www.mantisbt.org)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stuart Bishop
Sent: Jueves, 13 de Octubre de 2005 01:42 a.m.
To: Greg Stark
Cc: Neil Conway; pgsql-general@postgresql.org
Subject: Re: [GEN
On 10/13/05 8:27 AM, "Ivan Yu. Zolotukhin" <[EMAIL PROTECTED]> 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 bet
On Wed, Oct 12, 2005 at 06:15:36PM -0400, Robert Treat wrote:
>
> IIRC Slony wont run on anything < 7.3.6, so you would have to do an in place
> upgrade to 7.3.x as appropriate, and then you could set up slony to propogate
> to the 8.x system.
You should do that anyway, because on older release
On Wed, 2005-10-12 at 23:11, Chris Travers wrote:
> Scott Marlowe wrote:
> >Thought I'd comment on this.
> >
> >According to the author of the innodb engine, innodb uses MVCC.
> >OTOH, I consider innodb to be broken in production, due to issues with
> >constant growth and no way to reclaim the los
On Wed, 2005-10-12 at 20:08, Michael Fuhr wrote:
> On Wed, Oct 12, 2005 at 04:49:59PM -0500, Scott Marlowe wrote:
> > On Wed, 2005-10-12 at 16:16, Chris Travers wrote:
> > > Compared to MySQL, I can't think of any downsides. All relevant
> > > usability issues have been solved, though there are s
Andrew,
I disagree, I wouldn't want to contend with all the complexities
and kludge of Oracle thank you very much. If there was a way to get
PostgreSQL to do better than the current clustering methods, then why not, it
would be a
big win for us.
PostgreSQL *is* an enterprise clas
On Thu, 2005-10-13 at 00:32, Chris Travers wrote:
> Scott Marlowe wrote:
> >Strict Mode and Error handling: Not an option, but always on in
> >PostgreSQL. There are still plenty of things that "fall through the
> >cracks" on MySQL, like my previously mentioned problem with column level
> >constr
On Thu, Oct 13, 2005 at 10:46:29AM -0500, Scott Marlowe wrote:
> choice in another. So, multi-master replication isn't likely to become
> a plug in module for postgresql any time soon.
It's not even a thing, so it can't become a plug-in.
Consider just two kinds of multi-master:
1. Oracle's
What's the point of a binary search if the list is small enough to fit
on a line or two? And if a query can be substituted for N1-NN, you have
to read all the values anyway, and then the function is trivially
expressed as a normal query with no decrease in speed.
-- Dean
On Wed, 2005-10-12 a
Scott Marlowe <[EMAIL PROTECTED]> writes:
> I could see how it might be possible to make a two argument user defined
> function that took an argument like:
> select intvl(10,'20 30 40 50 60');
> so that the multiple arguments are really just a space or comma
> separated list fed to the function.
I have to admit, my thoughts on it were to build a query with case
statements in it and execute it. That sounds about like you're
proposing, right?
On Thu, 2005-10-13 at 11:30, Dean Gibson (DB Administrator) wrote:
> What's the point of a binary search if the list is small enough to fit
> on a l
Actualy to me, it seems like postgres is a perfect partner for MS
Access. Throw out Jet, and use Pgsql. It's infinately
better than Jet, so operating in a Win98 environment seems reasonable
in this scenario.
I swear you could build a business just building MS Access apps on a
Postgresql database
>>Instance Manager: Uniquely MySQL. It allows things like starting and
>stopping the database remotely.>>I cannot think of a reason ever to need this when we have OpenSSH
I'm just curious, but how does this work for a windows box?
>>Federated Storage Engine: Allows MySQL to access tables in
On Thu, Oct 13, 2005 at 03:00:32PM +0200, Stephane Bortzmeyer wrote:
> Note that a common trick, when you want to do X and you cannot do it
> directly from PostgreSQL (or are unwilling to force the sysadmin to
> install stuff like plWhatever - for instance, I was never able to make
> plPython run o
On Thu, Oct 13, 2005 at 10:06:51AM -0600, Aly S.P Dharshi wrote:
> Andrew,
>
> I disagree, I wouldn't want to contend with all the complexities
> and kludge of Oracle thank you very much. If there was a way to get
> PostgreSQL to do better than the current clustering methods, then why not, i
On Thu, Oct 13, 2005 at 01:00:03PM -0400, Alex Turner wrote:
>
> > >Instance Manager: Uniquely MySQL. It allows things like starting
> > >and stopping the database remotely.
> > >
> > I cannot think of a reason ever to need this when we have
> > OpenSSH
>
> I'm just curious, but how does t
On Thu, Oct 13, 2005 at 09:35:18AM -0600, Cristian Prieto wrote:
> Why not something like Mantis bug tracker? (http://www.mantisbt.org)
Because according to that URL:
Mantis is a php/MySQL/web based bugtracking system.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive
Tom Lane wrote:
Stephen Frost <[EMAIL PROTECTED]> writes:
Unquoted object names fold to lower case
I don't really see this as too much of an issue, personally, but I do
know some people have run into it. The example they give seems a bit
off tho, as I thought Oracle just folded to upper-
On Thu, Oct 13, 2005 at 10:53:51AM -0700, Chris Travers wrote:
> Now, what about PgPool as a multimaster sync replication solution? Sure
> it is statement level But is there any reason why you cannot have
> multiple PgPool instances running against a number of DB servers?
Well, to begin wi
On Thu, 2005-10-13 at 13:09, Chris Travers wrote:
> Any chance of adding a configuration option for future versions in order
> to set case folding behavior? It seems that PostgreSQL has really
> attempted to be as standards-compliant as possible and this is one area
> where improvement could b
Chris Travers <[EMAIL PROTECTED]> writes:
> Any chance of adding a configuration option for future versions in order
> to set case folding behavior? It seems that PostgreSQL has really
> attempted to be as standards-compliant as possible and this is one area
> where improvement could be made wi
Nikolay Samokhvalov wrote:
On 08/10/05, Martijn van Oosterhout wrote:
On Sat, Oct 08, 2005 at 03:32:00PM +0400, Nikolay Samokhvalov wrote:
http://chernowiki.ru/Dev/PostgreSQLComparedWithSQL2003AndOracleSQLServerDB2Etc
Perhaps I'm wrong with some issues - any comments are welcome.
Am Donnerstag, den 13.10.2005, 13:00 -0400 schrieb Alex Turner:
...
>
>
>
> If I had just one wish for postgresql it would be to support
> cross-database queries like Oracle. This is a HUGE pain in the ass,
> and DBI-Link syntax is clunky as hell.
>
> I would switch to Oracle t
Andrew Sullivan <[EMAIL PROTECTED]> writes:
> On Thu, Oct 13, 2005 at 10:53:51AM -0700, Chris Travers wrote:
>> Now, what about PgPool as a multimaster sync replication solution? Sure
>> it is statement level But is there any reason why you cannot have
>> multiple PgPool instances running a
Scott Marlowe wrote:
On Thu, 2005-10-13 at 13:09, Chris Travers wrote:
The problem, as explained to me when I floated this idea, is that the
CATALOGS are all in lower case, and many references to them are behind
the case folding mechanism (i.e. they get accessed by their lower case
names direct
On Thu, Oct 13, 2005 at 02:30:11PM -0400, Tom Lane wrote:
>
> This particular issue is fixable as of 8.1: pgpool should be using
> 2-phase commit.
Sure, but if we're talking about what people can put in production
today, I don't think 8.1 + pgpool with 2-phase commit is on the list.
(We got star
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 such a fix, just that it
> might be a fair bit of work.
Dave,
Sorry to be so late in responding to this but I may have just the
solution for you.
Please check out Veil at pgfoundry. This is an add-on to Postgres that
I think does just what you are looking for. As the developer of this
project, I would be pleased to offer you assistance.
http://veil.
I could, but it would breach the terms of our contract. Our
contract with the data providers clearly specifies seperate databases
;), so I'm kind of tied down by the legalese.
I have certainly considered just putting them in schemas, but I talked to legal and they didn't really like that idea ;).
Ok. I was completely unclear regarding how I think Slony would fit into
a multimaster async solution with updates.
Andrew Sullivan wrote:
Also, there is still (or was last I checked) a limitation on the
number of machines pgpool could address, and there are some stability
and reliability issue
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 such a fix, just that it
might be a fair
On Thu, Oct 13, 2005 at 12:01:19PM -0700, Chris Travers wrote:
> Stages 1 and 4 could be handled by Slony, while 2 and 3 would require
> custom triggers. In essence this is really master/slave that appears
> multimaster. You will have tradeoffs here in granularity of conflict
> resolution vers
Since no one else has mentioned it, there has been discussion this week
on one of the lists (probably -general or -hackers) about expanding the
capabilities of pg_dump. I've advocated for allowing a file that
specifies what objects to dump and what kind of filtering to apply to
the name. Allowing f
AFAIK you can't, and there's not really much point anyway. Anyone with
taccess to that file will be able to connect to the database.
Have you looked at using ident authentication on localhost?
On Wed, Oct 12, 2005 at 10:12:31AM +0200, Zlatko Matic wrote:
> If I put password in pgpass file it's st
Chris Travers <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Since the end reward for all this work would be having to read CATALOGS
>> WRITTEN IN ALL UPPER CASE, none of the key developers seem very
>> interested ...
>>
> Why would this be required?
If you write, say,
select max(relpa
Here's one (of many) solutions:
CREATE OR REPLACE FUNCTION range( ANYELEMENT, ANYARRAY ) RETURNS INTEGER
LANGUAGE SQL AS
'SELECT CASE array_upper( $2, 1 ) WHEN 1 THEN 0 ELSE range( $1, $2[
1:(array_upper( $2, 1 ) - 1) ] ) END
+ CASE WHEN $1 > $2[ array_upper( $2, 1 ) ] THEN 1 ELSE 0 END;
If separate databases are required by contract, and oracle lets you
treat multiple databases like one big one, wouldn't using oracle breach
your contract then? In this case, PostgreSQL's schemas and Oracle's
separate databases are functionally identical, nomenclature aside.
On Thu, 2005-10-13 at
Of course, but _legaly_ we would be complying with the contract ;)
AlexOn 10/13/05, Scott Marlowe <[EMAIL PROTECTED]> wrote:
If separate databases are required by contract, and oracle lets youtreat multiple databases like one big one, wouldn't using oracle breachyour contract then? In this case,
I wouldn't be so sure of that. IT might be that in order to be
considered to be complying with the contract you have to setup oracle in
such a way as to disable any database to database access / joining.
Seems to me the second you can run a query that hits both databases you
might well be in brea
heh... anythings possible ;) I guess we are okay for now then seeing that we are using postgresql with no dblinkg ;)
AlexOn 10/13/05, Scott Marlowe <[EMAIL PROTECTED]> wrote:
I wouldn't be so sure of that. IT might be that in order to beconsidered to be complying with the contract you have to se
This error is shown after choose the language in the installation of
Postgresql 8.0.3 in windows 2000:
"The installer has detected an incompatible version of OpenSSL installed in
your system PATH. PostgreSQL requires OpenSSL 0.9.7 or later. If you remove
your OpenSSL files (LIBEAY32.DLL and SS
Am Donnerstag, den 13.10.2005, 15:44 -0400 schrieb Alex Turner:
> Of course, but _legaly_ we would be complying with the contract ;)
>
> Alex
>
> On 10/13/05, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> If separate databases are required by contract, and oracle
> lets you
...
>
On Thu, Oct 13, 2005 at 12:21:14PM -0700, Chris Travers wrote:
> >Since the end reward for all this work would be having to read CATALOGS
> >WRITTEN IN ALL UPPER CASE, none of the key developers seem very
> >interested ...
> >
> >
> Why would this be required? If an individual developer wants to
On Thursday 13 October 2005 16:06, Tom Lane wrote:
>
> You'd have to change the source code, but it's a simple tweak in the
> ALTER SET STATISTICS code.
>
I don't think I'd want to do that.
> > If the only penalty is slower analyzing, I don't care: we analyze at
> > night when these system are idl
Ok. here are some indepth thoughts after reviewing as many prior threads
as I could find on the archives.
Tom Lane wrote:
Chris Travers <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Since the end reward for all this work would be having to read CATALOGS
WRITTEN IN ALL UPPER CASE, none
Martijn van Oosterhout wrote:
On Thu, Oct 13, 2005 at 12:21:14PM -0700, Chris Travers wrote:
Since the end reward for all this work would be having to read CATALOGS
WRITTEN IN ALL UPPER CASE, none of the key developers seem very
interested ...
I think you're slightly missing the p
On Thu, 13 Oct 2005 10:00:31 -0700, firechaser wrote:
> Hello all,
>
[example snipped]
>
> I've got this working in sql server 2005 beta which implements a
> sub-set of XQuery on a native xml data type column, but I would prefer
> to use postgreSQL if at all possible.
>
Although there is suppo
> On Thu, Oct 13, 2005 at 10:53:51AM -0700, Chris Travers wrote:
> > Now, what about PgPool as a multimaster sync replication solution? Sure
> > it is statement level But is there any reason why you cannot have
> > multiple PgPool instances running against a number of DB servers?
>
> Well,
I'm trying to get this query to work:
update sectors set companies =(select companies from
industries where sector_id =sectors.id);
PG returns:
ERROR: more than one row returned by a subquery used
as an expression
Column companies is just a count of rows in the
related companies table. Queries
Jim C. Nasby wrote:
> On Thu, Oct 13, 2005 at 09:35:18AM -0600, Cristian Prieto wrote:
>> Why not something like Mantis bug tracker? (http://www.mantisbt.org)
>
> Because according to that URL:
>
> Mantis is a php/MySQL/web based bugtracking system.
Actually, the newest version also supports Pos
On Thu, Oct 13, 2005 at 05:05:56PM -0700, CSN wrote:
> I'm trying to get this query to work:
>
> update sectors set companies =(select companies from industries
> where sector_id =sectors.id);
>
> PG returns:
>
> ERROR: more than one row returned by a subquery used as an
> expression
It's doin
Please
unsubscribe my e-mail [EMAIL PROTECTED]
thank you
--- "Marc G. Fournier" <[EMAIL PROTECTED]>
escreveu:
>
> Like all of our beta periods, this one has been
> going smoothly ... but,
> unlike other ones, we're seeing most bugs found very
> early in the cycle,
> so right now its look
Hi all,
I am trying to create an installable for my metalscan java application. Here are the specs:- I have created the installable using GKsetup(Gkware.com) a third party tool. I am using Postgresql 8.0.2 as my database for my Java application(metalscan). When the setup executable is double clicke
On Thu, Oct 13, 2005 at 08:32:28AM +, Carlos Benkendorf wrote:
> I agree that select for update will be the best choice but it
> does not have any effect with insert statements.
>
> if you try the following sequence in two different transactions,
> the select for update will succeed but the i
hi ,
can any one send me the setailed step by step installaiton guide of postgre-sql on linux .
i am a novice user of linux ..
so i would be requiring very basic on information also ...
i have been given assignment on installing postgresql on linux today ...
so , friends , please help me ou
Tom Lane <[EMAIL PROTECTED]> writes:
> If you write, say,
>
> select max(relpages) from pg_class;
>
> and the lexer thinks that it should fold unquoted identifiers to upper
> case, then the catalog entries defining these names had better read
> PG_CLASS, RELPAGES, and MAX, not the lower-c
81 matches
Mail list logo
