Re: [HACKERS] Architecture Roadmap?

2003-10-07 Thread Hannu Krosing
James Rogers kirjutas T, 07.10.2003 kell 01:48: Hi, I guess what I am wondering is whether there is any kind of quasi-official mechanism for putting certain features in certain future versions depending on the nature and significance of implementing those features and the number of things

[HACKERS] Compilation problems on IRIX 6.5.5

2003-10-07 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I'm trying to compile PostgreSQL 7.4 beta4 on Irix 6.5.5, o200, r1 (IP27) with MIPSPro compilers version 6.5. I've read FAQ_IRIX and saw these lines: PostgreSQL 7.2 has been run on MIPS r8000, r1(both ip25 and ip27) and r12000(ip35)

Re: [HACKERS] Compilation problems on IRIX 6.5.5

2003-10-07 Thread Peter Eisentraut
Devrim GUNDUZ writes: /usr/freeware/bin/gcc -O2 -Wall -Wmissing-prototypes - -Wmissing-declarations -I../../src/include -U_NO_XOPEN4 -c -o isinf.o isinf.c In file included from ../../src/include/c.h:60, from isinf.c:3:

Re: [HACKERS] Thoughts on maintaining 7.3

2003-10-07 Thread Andrew Sullivan
On Fri, Oct 03, 2003 at 09:17:16AM -0700, Joshua D. Drake wrote: What if the feature does break compatibility with old features? What if it is truly a new feature? There is _no_ mechanism in the community right now for testing all these new features in the so-called stable tree. I have

Re: [HACKERS] psql italian translation

2003-10-07 Thread Peter Eisentraut
Gaetano Mendola writes: Some corrections. I don't understand why your patch changes è to e' and à to a'. Also, please make your next patch so that it can be applied to the file it.po (not psql.pot). -- Peter Eisentraut [EMAIL PROTECTED] ---(end of

Re: [HACKERS] psql italian translation

2003-10-07 Thread Gaetano Mendola
Peter Eisentraut wrote: Gaetano Mendola writes: Some corrections. I don't understand why your patch changes è to e' and à to a'. Also, please make your next patch so that it can be applied to the file it.po (not psql.pot). Because with some terminal the character è, à, and other characters

Re: [HACKERS] psql italian translation

2003-10-07 Thread Andreas Pflug
Gaetano Mendola wrote: Peter Eisentraut wrote: Gaetano Mendola writes: Some corrections. I don't understand why your patch changes è to e' and à to a'. Also, please make your next patch so that it can be applied to the file it.po (not psql.pot). Because with some terminal the character è,

[HACKERS] bsd indent

2003-10-07 Thread Andrew Dunstan
I grabbed the patched BSD indent from a mirror. Here's a couple of points: . with a little trial and error GNU indent 2.2.9 actually did quite a reasonable job for me last night. But I guess YMMV. I'm curious to know what nasty mangling it does. . the file is a compressed tar file - it would be

Re: [HACKERS] psql italian translation

2003-10-07 Thread Gaetano Mendola
Andreas Pflug wrote: Gaetano Mendola wrote: Peter Eisentraut wrote: Gaetano Mendola writes: Some corrections. I don't understand why your patch changes è to e' and à to a'. Also, please make your next patch so that it can be applied to the file it.po (not psql.pot). Because with some

Re: [HACKERS] psql italian translation

2003-10-07 Thread Andreas Pflug
Gaetano Mendola wrote: Right, anyway there was typos in the translation, and my vi was unable to display: è, à. Anyway is a common stuff and well accepted have a' instead of à. Hi Gaetano, in the era of unicode I don't quite see why this needs to be acceptable... I wouldn't accept it. It

Re: [HACKERS] psql italian translation

2003-10-07 Thread Gaetano Mendola
Andreas Pflug wrote: Gaetano Mendola wrote: Right, anyway there was typos in the translation, and my vi was unable to display: è, à. Anyway is a common stuff and well accepted have a' instead of à. Hi Gaetano, in the era of unicode I don't quite see why this needs to be acceptable... I

Re: [HACKERS] Thoughts on maintaining 7.3

2003-10-07 Thread Bruce Momjian
Andrew Sullivan wrote: On Fri, Oct 03, 2003 at 09:17:16AM -0700, Joshua D. Drake wrote: What if the feature does break compatibility with old features? What if it is truly a new feature? There is _no_ mechanism in the community right now for testing all these new features in the

Re: [HACKERS] bsd indent

2003-10-07 Thread Bruce Momjian
Andrew Dunstan wrote: I grabbed the patched BSD indent from a mirror. Here's a couple of points: . with a little trial and error GNU indent 2.2.9 actually did quite a reasonable job for me last night. But I guess YMMV. I'm curious to know what nasty mangling it does. GNU indent does a

Re: [HACKERS] Thoughts on maintaining 7.3

2003-10-07 Thread Andrew Dunstan
Bruce Momjian wrote: Andrew Sullivan wrote: On Fri, Oct 03, 2003 at 09:17:16AM -0700, Joshua D. Drake wrote: What if the feature does break compatibility with old features? What if it is truly a new feature? There is _no_ mechanism in the community right now for testing all these

Re: [HACKERS] Thoughts on maintaining 7.3

2003-10-07 Thread Bruce Momjian
Andrew Dunstan wrote: Agreed. Great Bridge was going to test our releases and only distribute the good ones --- obviously they were thinking of Linux kernels and not PostgreSQL. You almost need a commercial company to do testing with Linux kernels. PostgreSQL doesn't require this, and I

Re: [HACKERS] Disabling function validation

2003-10-07 Thread Peter Eisentraut
Bruce Momjian writes: I think we should change the check_function_bodies to something more general. I like restore_validation_mode because it could also be used to disable foreign key checks which we are discussing. An even more general idea would be to have something like restore_mode, and

Re: [HACKERS] Disabling function validation

2003-10-07 Thread Bruce Momjian
Peter Eisentraut wrote: Bruce Momjian writes: I think we should change the check_function_bodies to something more general. I like restore_validation_mode because it could also be used to disable foreign key checks which we are discussing. An even more general idea would be to have

[HACKERS] BigInt woes

2003-10-07 Thread Joshua D. Drake
Hello, I believe that the Int8/BigInt items are known issues but I have a knew programmer that ran into it over the weekend (he didn't call me when he encountered the problem, when he should of) and we have a customer that burned some significant time on it as well. Will this be fixed in 7.4?

Re: [HACKERS] bsd indent

2003-10-07 Thread Andrew Dunstan
Bruce Momjian wrote: Andrew Dunstan wrote: I grabbed the patched BSD indent from a mirror. Here's a couple of points: . with a little trial and error GNU indent 2.2.9 actually did quite a reasonable job for me last night. But I guess YMMV. I'm curious to know what nasty mangling it does.

Re: [HACKERS] bsd indent

2003-10-07 Thread Andrew Dunstan
BTW, there's a bug in entab.c, too. This line: #include ../include/c.h should read #include ../../include/c.h cheers andrew ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

Re: [HACKERS] bsd indent

2003-10-07 Thread Bruce Momjian
Andrew Dunstan wrote: BTW, there's a bug in entab.c, too. This line: #include ../include/c.h should read #include ../../include/c.h Thanks. Fixed. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your

Re: [HACKERS] Thoughts on maintaining 7.3

2003-10-07 Thread Joshua D. Drake
Hello, O.k. so everyone is basically in agreement of no new features to be backported. How do we implement a stable release maintainer for back releases? I assume we set a scope of of what would go in security/bug fixes only? Sincerely, Joshua Drake -- Command Prompt, Inc., home of Mammoth

Re: [HACKERS] Thoughts on maintaining 7.3

2003-10-07 Thread Bruce Momjian
Joshua D. Drake wrote: But the kernel goes through this reliable/unreliable cycle --- they would be better off just making the old kernel more and more reliable and focusing on the new kernel for features. The reliable/unreliable cycle will kill your user base. The popularity of

Re: [HACKERS] Thoughts on maintaining 7.3

2003-10-07 Thread Joshua D. Drake
But the kernel goes through this reliable/unreliable cycle --- they would be better off just making the old kernel more and more reliable and focusing on the new kernel for features. The reliable/unreliable cycle will kill your user base. The popularity of Linux would argue that statement a

[HACKERS] Dreaming About Redesigning SQL

2003-10-07 Thread Seun Osewa
Hi, This is for relational database theory experts on one hand and imlementers of real-world alications on the other hand. If there was a chance to start again and design SQL afresh, for best cleaness/power/performance what changes would you make? What would _your_ query language (and the

[HACKERS] Parallel postgresql

2003-10-07 Thread Martin Rusoff
I was just contemplating how to make postgres parallel (for DSS applications)... Has anyone done work on this? It looks to me like there are a couple of obvious places to add parallel operation: Stage 1) I/O , perhaps through MPIO - would improve tablescanning and load/unload operations. One

[HACKERS] Possible Commit Syntax Change for Improved TPS

2003-10-07 Thread Seun Osewa
Hi, I have been studying the basic limitation that the number of committed transactions per second possible in a relational databases. Since each transaction requires at least write-ahead log data to be flushed to disk the upper bound of transactions per second is equal to the number of

Re: [HACKERS] Possible Commit Syntax Change for Improved TPS

2003-10-07 Thread Seun Osewa
Hi Christopher, Just to go through your points. COMMIT NOSYNC; -- (sacrifice durability of non-critical transaction for overall speed). So, the question is what people, especially those who have done DBMS work, think about this! I think that whenever my organization cares THAT much about

[HACKERS] is the time ?..

2003-10-07 Thread sad
Hi, all. Hi, developers ! PostgreSQL is growing Applications are growing older and larger too. Don't we need some printing tools? I feel I need a tool to print relation and unheritance diagrams from sources on SQL. My sources are too large to drawing diagrams manually now. I believe it is

Re: [HACKERS] Possible Commit Syntax Change for Improved TPS

2003-10-07 Thread Seun Osewa
[EMAIL PROTECTED] (Tom Lane) wrote in message news:[EMAIL PROTECTED]... Christopher Browne [EMAIL PROTECTED] writes: In the last exciting episode, [EMAIL PROTECTED] (Seun Osewa) wrote: So I want to ask, what if databases have a 'COMMIT NOSYNC;' option? Another possibility in this would be

[HACKERS] buffer manager

2003-10-07 Thread monu agrawal
Hi I have developed a new buffer policy for biological databases, I want to implement it on postgresql.So I will have to buffer manager of pgsql.How should I do it? Which files I will have to change what type of changes I will have to make. Is there any document which describes code of buffer

Re: [HACKERS] Thoughts on maintaining 7.3

2003-10-07 Thread Hans-Jürgen Schönig
Joshua D. Drake wrote: eh.. i could see some things, like tsearch2 or pg_autovacuum, which afaik are almost if not completely compatible with 7.3, which will not get back ported. Also fixes in some of the extra tools like psql could be very doable, I know I had a custom psql for 7.2 that back

[HACKERS] US-CA DATABASE INTERNALS

2003-10-07 Thread Database
Looking for candidates who have experience in developing database/OS kernel using C/C++/Java This is for position(s) in south bay area, CA. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [HACKERS] 2-phase commit

2003-10-07 Thread Hans-Jürgen Schönig
Marc G. Fournier wrote: On Sat, 27 Sep 2003, Bruce Momjian wrote: I have been thinking it might be time to start allowing external programs to be called when certain events occur that require administrative attention --- this would be a good case for that. Administrators could configure shell

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-07 Thread Lauri Pietarinen
Christopher Browne [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... I think an implementor would be better off using an SQL database underneath, and using their code layer in between to accomplish the divorce from the aspects of SQL that they disapprove of. That is, in fact, the

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-07 Thread Lee Fesperman
Seun Osewa wrote: Sometimes I wonder why its so important to model data in the rela- tional way, to think of data in form of sets of tuples rather than tables or lists or whatever. I mean, though its elegant and based on mathematical principles I would like to know why its the _right_

Re: [HACKERS] Beta4 Tag'd and Bundled ...

2003-10-07 Thread Adam Witney
Hi, Many of the regression tests are failing on my OSX 10.2.6 machine. I have put the regression.diffs file here http://bugs.sghms.ac.uk/downloads/regression.diffs Has this been seen before? Thanks adam Check her over and let me know if there are any problems ... will do a full general

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-07 Thread Mike Sherrill
On 3 Oct 2003 21:39:03 GMT, Christopher Browne [EMAIL PROTECTED] wrote: There are two notable 'projects' out there: 1. There's Darwen and Date's Tutorial D language, defined as part of their Third Manifesto about relational databases. 2. newSQL http://newsql.sourceforge.net/, where

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-07 Thread Anthony W. Youngman
In article [EMAIL PROTECTED], Seun Osewa [EMAIL PROTECTED] writes Thanks for the links. Christopher Browne [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] 125932.news.uni-berlin.de... There are two notable 'projects' out there: 1. There's Darwen and Date's Tutorial D language,

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-07 Thread Anthony W. Youngman
In article [EMAIL PROTECTED], Lee Fesperman [EMAIL PROTECTED] writes If you don't care for mathematical principles, there's always ad-hoc database models. Check out Pick, OO and XML databases. They're interested in what works and ignore elegance and mathematical principles. Mathematical

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-07 Thread Bob Badour
Anthony W. Youngman [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... In article [EMAIL PROTECTED], Lee Fesperman [EMAIL PROTECTED] writes If you don't care for mathematical principles, there's always ad-hoc database models. Check out Pick, OO and XML databases. They're

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-07 Thread Seun Osewa
Thanks for the links. Christopher Browne [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... There are two notable 'projects' out there: 1. There's Darwen and Date's Tutorial D language, defined as part of their Third Manifesto about relational databases. 2. newSQL

Re: [HACKERS] Question regarding coopting Database Engine

2003-10-07 Thread Hans-Jürgen Schönig
Steve Yalovitser wrote: Hello, I'd like to know if its possible to coopt the postgres storage subsystem to rely entirely on ram based structures, rather than disk. Any documentation or ideas would be appreciated. Cheers, Steve ---(end of

Re: [HACKERS] Oracle/PostgreSQL incompatibilities

2003-10-07 Thread Rainer Klute
On Fri, 03 Oct 2003 11:53:05 -0400 Tom Lane [EMAIL PROTECTED] wrote: Rainer Klute [EMAIL PROTECTED] writes: [ some good comments, but a few things I want to respond to ] + CREATE SCHEMA: Sometimes a schema created in PostgreSQL disappears if there is nothing in it. This is more

[HACKERS] Learning PostgreSQL

2003-10-07 Thread Gevik Babakhani
Dear PostgreSQL masters, I know this might like a childish question and you probably might have a good laugh over this but I would like to learn how PostgreSQL works inside-out. Could anyone please give me some pointers of where to start in/from the sourcecode? I am grateful for any help.

Re: [HACKERS] buffer manager

2003-10-07 Thread Satoshi Nagayasu
[EMAIL PROTECTED] (monu agrawal) wrote: Hi I have developed a new buffer policy for biological databases, I want to implement it on postgresql.So I will have to buffer manager of pgsql.How should I do it? Which files I will have to change what type of changes I will have to make. Very

[HACKERS] Triggers on SELECT?

2003-10-07 Thread Josh Berkus
Folks, Pardon me if this has already been discussed and rejected for good reason. Now that we have Statement-level triggers, is there any reason we shouldn't have triggers on SELECT? Such triggers could be extremely useful for databases with tight security audit requirements. -- -Josh

Re: [HACKERS] ecpg doesn't compile (datetime.h/dtime_t)

2003-10-07 Thread Patrick Welche
On Fri, Oct 03, 2003 at 03:00:36PM +0100, Patrick Welche wrote: On Fri, Oct 03, 2003 at 12:59:19PM +0200, Michael Meskes wrote: On Mon, Sep 29, 2003 at 06:41:48PM +0100, Patrick Welche wrote: Today's cvs doesn't compile. I think it is due to cvs diff -r1.7 -r1.8

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-07 Thread Dann Corbit
-Original Message- From: Seun Osewa [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 11:52 AM To: [EMAIL PROTECTED] Subject: [HACKERS] Dreaming About Redesigning SQL Hi, This is for relational database theory experts on one hand and imlementers of real-world

Re: [HACKERS] Learning PostgreSQL

2003-10-07 Thread Roderick A. Anderson
On Sun, 5 Oct 2003, Bruce Momjian wrote: Neil Conway wrote: On Sun, 2003-10-05 at 17:45, Bruce Momjian wrote: Neil Conway wrote: Depending on what part of the source you're interested in, a book on DBMS implementation might also be useful, such as Wow, $100. Well, it's a

Re: [HACKERS] Parallel postgresql

2003-10-07 Thread Bruce Momjian
Martin Rusoff wrote: I was just contemplating how to make postgres parallel (for DSS applications)... Has anyone done work on this? It looks to me like there are a couple of obvious places to add parallel operation: Stage 1) I/O , perhaps through MPIO - would improve tablescanning and

OT: Re: [HACKERS] Thoughts on maintaining 7.3

2003-10-07 Thread Christopher Kings-Lynne
I have lately been taking the position that Linux is only a second-best choice for production use, precisely because of the constant introduction of shiny new features in the supposed stable branch. That's what all us FreeBSD users learnt a long time ago :P Chris

Re: [HACKERS] Disabling function validation

2003-10-07 Thread Christopher Kings-Lynne
Should we add a variable that is set from the dump filew that identifies the version of PostgreSQL that generated the dump? SET dumped_version = 7.3 With something like that, does it have to be reissued after every \connect in the dump? Chris ---(end of

Re: [HACKERS] Disabling function validation

2003-10-07 Thread Rod Taylor
On Tue, 2003-10-07 at 21:31, Christopher Kings-Lynne wrote: Should we add a variable that is set from the dump filew that identifies the version of PostgreSQL that generated the dump? SET dumped_version = 7.3 With something like that, does it have to be reissued after every

[HACKERS] HeapTuple-t_tableOid==0 after SPI_exec

2003-10-07 Thread achill
Hi, i notice that when HeapTuple data are populated by a trigger then the table oid can be retrieved from HeapTuple-t_tableOid. When HeapTuple is populated by SPI_exec(select * from foobar when id=667); tuple = SPI_tuptable-tvals[0] (id is PK and row with 667 exists) then tuple-t_tableOid is

Re: [HACKERS] [SQL] HeapTuple-t_tableOid==0 after SPI_exec

2003-10-07 Thread achill
On Fri, 3 Oct 2003, Tom Lane wrote: I think in 7.4 there may be an optimization that skips the tuple projection step in this particular case, but if you can in fact see t_tableOid in 7.4, it'd be an implementation artifact rather than something we will promise to support in future. The

Re: [HACKERS] Disabling function validation

2003-10-07 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Should we add a variable that is set from the dump filew that identifies the version of PostgreSQL that generated the dump? SET dumped_version = 7.3 Is that identifying the backend version, or the pg_dump version? Without a solid rationale for

Re: [HACKERS] BigInt woes

2003-10-07 Thread Tom Lane
Joshua D. Drake [EMAIL PROTECTED] writes: Will this be fixed in 7.4? No. regards, tom lane ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's

Re: [HACKERS] Disabling function validation

2003-10-07 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Should we add a variable that is set from the dump filew that identifies the version of PostgreSQL that generated the dump? SET dumped_version = 7.3 Is that identifying the backend version, or the pg_dump version? Without a

Re: [HACKERS] Triggers on SELECT?

2003-10-07 Thread Tom Lane
Josh Berkus [EMAIL PROTECTED] writes: Now that we have Statement-level triggers, is there any reason we shouldn't have triggers on SELECT? Plenty, although I'm too tired to recall 'em all. The fundamental problem with this is that it turns SELECT into an operation with side-effects.

[HACKERS] How to avoid users from viewing functions code

2003-10-07 Thread cad0022
Hi the problem is to avoid users from viewing functions code (in general db structures) when connecting to db by means of pgpadmin client. My db contains several tables and functions and I need to make users viewing only a restricted number of tables. It works for tables, as it's possible to