"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 las
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, myval
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 5
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 "
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 clea
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 wr
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 o
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?
N
On Fri, 11 May 2001, Kaare Rasmussen wrote:
> In developers corner, search returns this:
>
> #!/usr/bin/perl
>
> print "Content-type: text/html\r\n\r\n";
>
> print " CONTENT=\"0;URL=search.html\">\r\n\r\n";
>
>
What are you using for a browser and what mirror are you using? I just
tried from th
Tom-
Thanks for the detective work. This makes perfect sense now, and explains
the radically different behaviour between 7.1RC1 and 7.1.1. I will change
my rules to not have to depend on Pg choosing which WHERE clause to
evaluate first.
-Jon
PS: (Talking *way* above my head now) Would be p
I've create a few types, including BOX3D (a simple bounding volume) and
AGG_POINTS3D (a list of points with a BOX3D bounding volume).
I've managed to get an rtree index on both the BOX3D type and
AGG_POINTS3D.
The agg_points3d index cheats by using the bounding volume inside the
AGG_POINTS3D typ
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;
>
> insert into a (n2) value (1);
> n1.nextval: you don't have permission to set seque
In developers corner, search returns this:
#!/usr/bin/perl
print "Content-type: text/html\r\n\r\n";
print "\r\n\r\n";
--
Kaare Rasmussen--Linux, spil,--Tlf:3816 2582
Kaki Datatshirts, merchandize Fax:3816 2501
Howitzvej 75
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 sampleid<>NEW.sampleid AND
> active='t'] one time! My understa
Hi,
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;
insert into a (n2) value (1);
n1.nextval: you don't have permission to set sequence n1
It worked on 7.0.3
Regards,
--
Olivier PRE
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
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-view
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 Oliv
> 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 a
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
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 broadcast)---
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 broad
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'
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
From: Ricardo Galli ([EMAIL PROTECTED])
Date: Wed May 09 2001 - 20:45:46 EDT
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, no
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 crea
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 billio
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 app
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
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. Ar
Hi,
Can PostgreSQL's Stored Procedure return a ReccordSet?
I want to send a parameter to stored procedure, and receive a recordset.
Is that possible?
How to do it?
Could I have a example? or where can I try that example?
my os: linux
my database: PostgreSQL
=
> > 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
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 tho
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
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.
>Th
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
36 matches
Mail list logo
