Am Donnerstag, 10. Mai 2001 19:23 schrieb Roberto Mello:
On Thu, May 10, 2001 at 03:33:27PM +0200, Klaus Reger wrote:
Have you looked at the Porting From Oracle PL/SQL chapter of the
PostgreSQL Programmer's Guide? I am expanding that guide to include more
things, like queries. The goas
At 01:28 11/05/01 -0400, Tom Lane wrote:
Philip Warner [EMAIL PROTECTED] writes:
Yes - it's waiting on the problem Zoltan reported (the select from
pg_rewrite etc). I can't reproduce the problem on any of my DBs.
I've just realized that the problem is a lot simpler than it appears.
The given
As an aside, I do however think, that optimizing the O_SYNC path of
the WAL code to block writes to larger blocks (doesn't need to be
more than 256k) would lead to nearly the same performance as a raw
device on most filesystems. (Maybe also add code to reuse backed up
logfiles to avoid
Hi all!
I have to convert functions and procedures from Oracle to PostgreSQL. I
looked at all the stuff of the Pg-Homepage and I ask me if there are any
tools, that support the conversion.
Writing PS/PGSQL tools seems to be a bit hard, because of the existing
tool-infrastructure on linux.
On Thu, 10 May 2001, Tom Lane wrote:
Philip Warner [EMAIL PROTECTED] writes:
Can anyone suggest why this might be happening (I think it's in 7.1b4):
Can't duplicate in current sources:
regression=# SELECT definition as viewdef,
regression-# (select oid from pg_rewrite where
On Thu, May 10, 2001 at 06:44:39PM -0400, Tom Lane wrote:
Next question: do you still have your 7.0.* DB up? Can you get an
EXPLAIN that shows how it did it (on the real tables)?
Tom-
Okay. I started from a clean slate, by recompiling both Pgv7.1.1 and
Pgv7.1RC1, initdb'ing each (after
Hello:
I can bet that in about a year's time, PostgreSQL user base will
explode.
(there is broadband connection everywhere in USA and Europe!!! 63% of
american households
have internet connection compare that to India, where 0.002% of Indian
homes have internet
connection and there are 1.1
Hi!
I am facing two problems in porting from oracle to Postgres SQL.
1 There is a code in Oracle like
Type Tstate is table of number(9)
index by binary_integer;
.
To define a runtime table, basically it works like a array, How can it
be possible in Postgres SQL,
I have tried
On Tue, 8 May 2001 09:09:08 + (UTC), [EMAIL PROTECTED] (Giles
Lean) wrote:
Good performance on such storage systems might depend on keeping as
much work up to it as possible, to let the device determine what order
to service the requests. Attempts to minimise head movement may
hurt, not
Hello !
I am forwarding the following from lkml
It seems that the only case when XFS is slow is the 'rm -rf linux'
[which can be considered as a good sign for linux]. For all other
operation XFS is the winner.
YAS
MessageFromLKML
From: Ricardo Galli ([EMAIL PROTECTED])
Date: Wed May 09 2001
See my prior reply to Philip: the problem is that the given string is
longer than NAMEDATALEN. When you write
rulename = 'foo'
(rulename is of type NAME) the untyped literal string 'foo' gets coerced
to NAME, ie truncated to fit, and all is well. When you write
rulename = ('foo'
Jon Lapham [EMAIL PROTECTED] writes:
I didn't do Pgv7.0.3 b/c I think it may be unnecessary
since 7.1RC1 doesn't show this problem, while 7.1.1 does. But, if you
really think it necessary, I will repeat his using 7.0.3.
No, that seems like useless work.
1) As usual, the 7.1RC1 returns from
From: [EMAIL PROTECTED]
Date: Fri, 11 May 2001 10:41:57 +1200
Here is a small list of big TODO items. I was wondering which ones
people were thinking about for 7.2?
The need for stored procedures that return a record set.
This is required to migrate from MSSQL, Interbase and others.
Bruce Momjian wrote:
Here is a small list of big TODO items. I was wondering which ones
people were thinking about for 7.2?
* Allow inherited tables to inherit index, UNIQUE constraint, and primary key
[inheritance]
i was wondering if there was any thought still being given to Oliver
On Tuesday 08 May 2001 10:16, Tom Lane wrote:
Thomas Lockhart [EMAIL PROTECTED] writes:
I've built RPMs for 7.1.1, but perhaps we should wait until 7.1.2 to
post them given the pgtcl problem? Lamar, what are you planning for
7.1.1?
Given my plpgsql screwup, and the dump-7.0-views thing
On Tuesday 08 May 2001 11:14, Thomas Lockhart wrote:
As to the group write permissions, Thomas.. The perms on the RPMS
subdir now set g+w. Sorry. I'll need to set my umask a little more
appropriately.
Great. I'll move things around. btw, I've found that things like scp
don't
Jon Lapham [EMAIL PROTECTED] writes:
But, there is definitely something wrong here, b/c the rule that is
causing this *should* only need to run the subselect [SELECT count(*) FROM
tplantorgan WHERE tplantid=NEW.tplantid AND sampleidNEW.sampleid AND
active='t'] one time! My understanding
Olivier PRENANT [EMAIL PROTECTED] writes:
I've just noticed that (after a upgrade from 7.0.3 to 7.1) the following
did'nt work anymore:
create tabla a (n1 serial, n2 int);
grant all on a to nobody;
reconnect as user nobody
insert into a (n2) value (1);
n1.nextval: you don't have
Dave Blasby [EMAIL PROTECTED] writes:
gives the correct results. Postgres automatically uses the
agg_points3d() function to convert the BOX3D into an AGG_POINTS3D.
Unfortunately, it doesn't use the index scan anymore; it does a sequence
scan.
First question: what Postgres version?
Next
I'm using 7.1.1, and your suggestion WORKED!
Thanks for your prompt reply!
Refractions Research will be releasing (open source) postGIS very soon
(as soon as its in a releasable state).
It will contain GIS data types (box3d, multi-point3d, multi-polyline3d,
multi-complex-polygon3d) and GIS
Hello,
PgAdmin http://www.greatbridge.org/project/pgadmin/projdisplay.php is the
windows administration interface of PostgreSQL.
The new upcoming version features a function, trigger and view IDE. When
functions are modified, it is possible to rebuild dependencies.
It is the perfect tool for
I'm not sure if this is still needed in postgres to define the length of
a variable/table name.
In postgres_ext.h, I changed:
#define NAMEDATALEN 32
to
#define NAMEDATALEN 51
Everything compiled and installed. However, the initdb started up but
then just said that it failed.
I did a gmake
In addition to my RedHat 6.2 server, I'm installing Postgres 7.1.1 on an
SGI O2 (IRIX 6.5.10). The configure works, but the 'gmake all' fails
when it tries to compile 'xact.c':
cc-1521 cc: WARNING File = /usr/include/setjmp.h, Line = 26
A nonstandard preprocessing directive is used.
#ident
Sorry, I forgot to include that I'm compiling this on RedHat 6.2,
Pentium III with Postgres 7.1.1.
-Tony
I'm not sure if this is still needed in postgres to define the length of
a variable/table name.
In postgres_ext.h, I changed:
#define NAMEDATALEN 32
to
#define NAMEDATALEN 51
I am having problems with transactions and foreign key constraints in
postgres 7.0-3 (RPM distribution). . The foreign key constraints were
blocking concurrent transactions. Here is an example where something blocked
but shouldn't have blocked:
create table hello10 (myid serial primary key,
G. Anthony Reina [EMAIL PROTECTED] writes:
In postgres_ext.h, I changed:
#define NAMEDATALEN 32
to
#define NAMEDATALEN 51
Everything compiled and installed. However, the initdb started up but
then just said that it failed.
I have not tried that in awhile, but the last time I did, it
it is a branch ... for lack of a better way to work it:
symbolic names:
REL7_1_STABLE: 1.106.0.2
REL7_1_BETA: 1.79
REL7_1_BETA3: 1.86
REL7_1_BETA2: 1.86
REL7_1: 1.102
REL7_0_PATCHES: 1.70.0.2
REL7_0: 1.70
REL6_5_PATCHES: 1.52.0.2
On Thu, 10 May 2001, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
Isn't this only critical for those that are using it? Does it affect
those that don't use plpgsql?
No, but I think it's pretty critical for those that do ...
So, why not create a quick patch for those that
Bruce Momjian [EMAIL PROTECTED] writes:
With our new /contrib policy, we could put it right in our PostgreSQL
CVS contrib.
?? What new contrib policy? I didn't notice any discussion of policy
changes ...
regards, tom lane
---(end of
Bruce Momjian [EMAIL PROTECTED] writes:
Can someone confirm that REL7_1_STABLE is a branch and not a tag?
Seems to work for committing stuff into the branch, so it must be
a branch ...
regards, tom lane
---(end of
30 matches
Mail list logo
