Re: [HACKERS] add server include files to default installation?

2004-05-18 Thread Fabien COELHO
> This is from an extension module author's point of view. My module will > reference these two files only: > > Makefile.global > Makefile.shlib These files possibly include other makefiles. > I'm not the least interested in how these files are organized internally Sure. > If I have a "pg_conf

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
Tatsuo Ishii wrote: At least in Japan PHP is much more popular than Python. If we have plpython in core, I see no reason we do not have plPHP in core at least from the "popularity" point of view. Well I don't know anywhere that PHP isn't more popular than Python. The question I think i

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
So, why tie it into the PostgreSQL source tree? Won't it be popular enough to live on its own, that it has to be distributed as part of the core? Honestly, I don't know if it would be popular enough on its own. Now the plPerlNG that Andrew and us are working, yes but plPHP? It is nifty, it is

Re: [HACKERS] pg_autovacuum seems to be a neat freak and cleans

2004-05-18 Thread Matthew T. O'Connor
On Tue, 2004-05-18 at 22:21, Brian Hirt wrote: > there might be another similar bug that was fixed in 7.4.2 This bug is fixed, but it didn't make in 7.4.2, it is in CVS (both 7.4 and HEAD). Please grab pg_autovacuum.c and .h from CVS, if that doesn't fix it please let me know. Thanks, Matthew

Re: [HACKERS] psql weirdness in HEAD

2004-05-18 Thread Bruce Momjian
Christopher Kings-Lynne wrote: > I run psql and I get this: > > -bash-2.05b$ psql template1 > Welcome to psql 7.5devel, the PostgreSQL interactive terminal. > > Type: \copyright for distribution terms > \h for help with SQL commands > \? for help with psql commands > \g o

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Bruce Momjian
Marc G. Fournier wrote: > On Mon, 17 May 2004, Alvaro Herrera Munoz wrote: > > > I have some confidence in that I will be able to deliver it maybe the last > > week of May. I can only hope, however, that it will not be rejected because > > it's presented too close to feature freeze. > > There is

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Tatsuo Ishii
> On Tue, 18 May 2004, Joshua D. Drake wrote: > > > Actually plPHP doesn't require the PostgreSQL source tree... you would > > just have to modify the Make file to point to the right places. > > So, why tie it into the PostgreSQL source tree? Won't it be popular > enough to live on its own, that

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Marc G. Fournier
On Mon, 17 May 2004, Alvaro Herrera Munoz wrote: > I have some confidence in that I will be able to deliver it maybe the last > week of May. I can only hope, however, that it will not be rejected because > it's presented too close to feature freeze. There is no such thing as "too close to featur

Re: [HACKERS] Clean-up callbacks for non-SR functions

2004-05-18 Thread Tom Lane
James William Pye <[EMAIL PROTECTED]> writes: > I know I can use RegisterExprContextCallback and the RSI's econtext to > register a callback for SRFs, but this--or similar > functionality--does not appear to be available for non-SRFs. Hm? That functionality works for any function, whether it retu

Re: [HACKERS] [GENERAL] PgSQL 7.4.2 - NaN on Tru64 UNIX

2004-05-18 Thread Tom Lane
Nikola Milutinovic <[EMAIL PROTECTED]> writes: > [ about NaN on Tru64 ] > This compiles on Tru64 4.0D (the compiler swallows it), but fails on > Tru64 UNIX 5.1B. Both basic CC and DTK Compaq CC break on that file > complaining on that constant evaluation. The best way to solve it is to > use sys

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Marc G. Fournier
On Tue, 18 May 2004, Joshua D. Drake wrote: > Actually plPHP doesn't require the PostgreSQL source tree... you would > just have to modify the Make file to point to the right places. So, why tie it into the PostgreSQL source tree? Won't it be popular enough to live on its own, that it has to be

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Marc G. Fournier
On Tue, 18 May 2004, Heikki Linnakangas wrote: > I'd like to get the patch committed as soon as the 7.6 release cycle > begins, with whatever limitations it has at that time. The nice thing of this is that then you have a development cycle for others to help ... your patch lays down the "this is

Re: [HACKERS] psql weirdness in HEAD

2004-05-18 Thread Christopher Kings-Lynne
I get a similar failure running pg_dumpall and initdb as well. Chris Christopher Kings-Lynne wrote: I run psql and I get this: -bash-2.05b$ psql template1 Welcome to psql 7.5devel, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands

[HACKERS] psql weirdness in HEAD

2004-05-18 Thread Christopher Kings-Lynne
I run psql and I get this: -bash-2.05b$ psql template1 Welcome to psql 7.5devel, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Lamar Owen
On Tuesday 18 May 2004 21:58, Joshua D. Drake wrote: > > So you then have to build PHP twice, in an RPM build environment. You > > mean I can't just have the headers installed to build plPHP? So, follow > > the > No you need to make sure that PHP is available as a shared lib. Which requires you

Re: [HACKERS] pg_autovacuum seems to be a neat freak and cleans way too much

2004-05-18 Thread Brian Hirt
there might be another similar bug that was fixed in 7.4.2 i just doubled checked the 7.4.2 tarball, and it does have this problem. you might want to double check to see if it's fixed in 7.4.3, or i can grab cvs and check it if you like. On May 18, 2004, at 8:06 PM, Bruce Momjian wrote: I think

Re: [HACKERS] pg_autovacuum seems to be a neat freak and cleans way

2004-05-18 Thread Bruce Momjian
I think we already fixed that in 7.4.2. We also have a few bugs still in 7.4.2 and we need to get those fixed soon and release 7.4.3. --- Brian Hirt wrote: > I'm following up on my own email and cross posting to hackers, be

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
So you then have to build PHP twice, in an RPM build environment. You mean I can't just have the headers installed to build plPHP? So, follow the No you need to make sure that PHP is available as a shared lib. 1.) Build PostgreSQL 2.) Build PHP (with PostgreSQL client support) 3.) Build plPHP

Re: [HACKERS] pg_autovacuum seems to be a neat freak and cleans way too much

2004-05-18 Thread Brian Hirt
I'm following up on my own email and cross posting to hackers, because there is a bug that needs fixed. I spent some more time digging into this, and I found the cause of the problem. reltuples in pg_class is defined as a real, reltuples in pg_autovacuum is defined as an int. the query

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Lamar Owen
On Tuesday 18 May 2004 17:33, Joshua D. Drake wrote: > > But most binary packages do, and they are the ones I'm talking about. > > And surely you do not advocate that, in order to build PL/PHP, the > > packagers instead disable the client side support in PHP? > Of course not, but I still don't see

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Claudio Natoli
Greg Copeland writes: > My primary fear about delivering Win32 with all of these other great > features is that, IMO, there is a higher level of risk associated with > these advanced features. At the same time, this will be the > first trial for many Win32 users. Should there be some problems,

Re: [HACKERS] bitwise and/or aggregate functions?

2004-05-18 Thread Bruce Momjian
Tom Lane wrote: > Neil Conway <[EMAIL PROTECTED]> writes: > > Fabien COELHO wrote: > >> Neil - can you check your SQL2003 copy to see if it mentions standard > >> aggregates on bit types? > > > I couldn't see any mention of any aggregates specific to the bit types, > > There certainly are none,

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Christopher Kings-Lynne
Seriously though, we all have the roles that we play. I don't think redirecting specific resources to other resources will help beyond slowing up the original resources. And now Neil's on holidays :) Perhaps we need more committers. The deluge of patches is starting to strain the major develope

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > What can be done? Well, money from Fujitsu and other companies > (Afilias/Sloney, Command Prompt/ecpg-plPHP), is allowing us to hit > some of these bigger items, so hopefully that will move us forward > in these complex areas. I am not sure what

Re: [HACKERS] bitwise and/or aggregate functions?

2004-05-18 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > Fabien COELHO wrote: >> Neil - can you check your SQL2003 copy to see if it mentions standard >> aggregates on bit types? > I couldn't see any mention of any aggregates specific to the bit types, There certainly are none, since in fact SQL2003 removes th

Re: [HACKERS] Fixed directory locations in installs

2004-05-18 Thread Bruce Momjian
Peter Eisentraut wrote: > Tom Lane wrote: > > > What use could printing the relative path possibly have? > > > > Debugging. If I can't see it, I *know* I'm going to wish I could. > > Well, you can just look inside, it's not that big. Supporting extra > options might make the script twice as big

Re: [HACKERS] Fixed directory locations in installs

2004-05-18 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> I guess what you are saying is we should have a configure-time option to > >> address configured directories via relative paths from the executable's > >> directory, rather than absolute paths? Seems reasonable ..

Re: [HACKERS] question about information_schema

2004-05-18 Thread Tom Lane
Dave Cramer <[EMAIL PROTECTED]> writes: > While I'm asking how can I find all of the user defined types, assuming > that the user is the owner of the cluster. I see that pg_dump can do > this ? IIRC, what pg_dump actually does is look for types that are not in the pg_catalog schema. Plus you prob

Re: [HACKERS] XactIsoLevel handling

2004-05-18 Thread Tom Lane
Heikki Linnakangas <[EMAIL PROTECTED]> writes: > Why is the isLocal-parameter false? Couldn't it be true as well? It works > as it is, since the XactIsoLevel variable is reset to default value in > StartTransaction anyway, but it looks silly to me to define the variable > as a session variable when

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Jan Wieck
Bruce Momjian wrote: Peter Eisentraut wrote: Jan Wieck wrote: > Boy, nobody was suggesting 100% static linking. What kind of madness > are you getting into if you link libpq.a into psql? There is > something between all or nothing, isn't there? It's not going to be only psql and libpq. The next th

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
Peter Eisentraut wrote: Joshua D. Drake wrote: Of course not, but I still don't see your point. plPHP doesn't need PHP+PostgreSQL support. Nor does PHP+PostgreSQL conflict with using plPHP... PHP doesn't even need to be installed for plPHP to work... You just need the source tree for building. O.

Re: [HACKERS] add server include files to default installation?

2004-05-18 Thread Thomas Hallgren
Fabien COELHO wrote: Any idea? The best I have would be to create a "src" subdir in the installation, so that top_builddir could be set to ".../include/postgresql/config" and everything would work from that point of view. This is from an extension module author's point of view. My module will refe

Re: [HACKERS] Why new features only in magior releases ?

2004-05-18 Thread Neil Conway
Gaetano Mendola wrote: Currently some changes are back ported to old branches ( BTW, why not to switch to use "subversion"? ) so I don't think this actualy a big issue The only changes that are presently backported are bug fixes that the committing developer feels confident will not cause a regres

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Peter Eisentraut
Joshua D. Drake wrote: > Of course not, but I still don't see your point. plPHP doesn't need > PHP+PostgreSQL support. Nor does PHP+PostgreSQL conflict with using > plPHP... > > PHP doesn't even need to be installed for plPHP to work... You just > need the source tree for building. I don't talk ab

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Bruce Momjian
Peter Eisentraut wrote: > Jan Wieck wrote: > > Boy, nobody was suggesting 100% static linking. What kind of madness > > are you getting into if you link libpq.a into psql? There is > > something between all or nothing, isn't there? > > It's not going to be only psql and libpq. The next thing is,

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Peter Eisentraut
Jan Wieck wrote: > Boy, nobody was suggesting 100% static linking. What kind of madness > are you getting into if you link libpq.a into psql? There is > something between all or nothing, isn't there? It's not going to be only psql and libpq. The next thing is, someone wants to have a relocatable

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Bruce Momjian
Peter Eisentraut wrote: > Bruce Momjian wrote: > > Peter Eisentraut wrote: > > > Bruce Momjian wrote: > > > > We already have --disable-rpath. Seems we would just need > > > > something to use the *.a files. > > > > > > I think it is perfectly sufficient to say that if you want a > > > relocatable

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Peter Eisentraut
Bruce Momjian wrote: > Peter Eisentraut wrote: > > Bruce Momjian wrote: > > > We already have --disable-rpath. Seems we would just need > > > something to use the *.a files. > > > > I think it is perfectly sufficient to say that if you want a > > relocatable install, don't use rpath. Static linki

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Peter Eisentraut
Joshua D. Drake wrote: > Also PHP does not compile the PostgreSQL support by default. But most binary packages do, and they are the ones I'm talking about. And surely you do not advocate that, in order to build PL/PHP, the packagers instead disable the client side support in PHP?

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
But most binary packages do, and they are the ones I'm talking about. And surely you do not advocate that, in order to build PL/PHP, the packagers instead disable the client side support in PHP? Of course not, but I still don't see your point. plPHP doesn't need PHP+PostgreSQL support. Nor does

Re: [HACKERS] Why new features only in magior releases ?

2004-05-18 Thread Gaetano Mendola
Neil Conway wrote: Gaetano Mendola wrote: I well understand the reason to wait a 7.5 in order to delivery BIG changes that are requiring a initdb, but I don't understand why little enhancement can not be delivered in a 7.4.3 ( may be with a short period with a 7.4.3beta ) like the "vacuum delayed".

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Jan Wieck
Bruce Momjian wrote: Peter Eisentraut wrote: Bruce Momjian wrote: > We already have --disable-rpath. Seems we would just need something > to use the *.a files. I think it is perfectly sufficient to say that if you want a relocatable install, don't use rpath. Static linking will lead to all other

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Jan Wieck
Peter Eisentraut wrote: Bruce Momjian wrote: We already have --disable-rpath. Seems we would just need something to use the *.a files. I think it is perfectly sufficient to say that if you want a relocatable install, don't use rpath. Static linking will lead to all other kinds of madness. Boy,

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Bruce Momjian
Peter Eisentraut wrote: > Bruce Momjian wrote: > > We already have --disable-rpath. Seems we would just need something > > to use the *.a files. > > I think it is perfectly sufficient to say that if you want a relocatable > install, don't use rpath. Static linking will lead to all other kinds

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Bruce Momjian
Peter Eisentraut wrote: > Bruce Momjian wrote: > > We already have --disable-rpath. Seems we would just need something > > to use the *.a files. > > I think it is perfectly sufficient to say that if you want a relocatable > install, don't use rpath. Static linking will lead to all other kinds

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Peter Eisentraut
Bruce Momjian wrote: > We already have --disable-rpath. Seems we would just need something > to use the *.a files. I think it is perfectly sufficient to say that if you want a relocatable install, don't use rpath. Static linking will lead to all other kinds of madness. Also, some platforms of

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Peter Eisentraut
Joshua D. Drake wrote: > > This is very much different, because the PHP distribution contains > > the PostgreSQL driver, whereas the other languages do not. So you > > would have > > > > PHP build depends on PostgreSQL > > Ahh I see your point, EXCEPT :) plPHP does not require PostgreSQL > support

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
That is irrelevant. A normal binary package of PHP does build the PostgreSQL support (which is surely in our interest), so the build dependency holds. Then I am afraid I don't understand the actual problem. plPHP does not create a circular dependency because it doesn't require PHP to have Pos

Re: [HACKERS] proposal: be smarter about i/o patterns in index scan

2004-05-18 Thread Glen Parker
> The basic problem is that Pg seeks far too much when performing an index > scan. I have saved an strace of a backend which is selecting 170,000 > rows from a 240,000,000 row table via index scan. The strace shows > 134,000 seeks and reads, or almost one seek for every tuple in the > result set.

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
This is very much different, because the PHP distribution contains the PostgreSQL driver, whereas the other languages do not. So you would have PHP build depends on PostgreSQL Ahh I see your point, EXCEPT :) plPHP does not require PostgreSQL support to be built into PHP. Sincerely, Joshua D.

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Andrew Dunstan
Jan Wieck wrote: If I remore the whole -rpath thing, and remove the two -L options and the -lpq and -lpgport, and add the libpq.a and libpgport.a explicitly to the linker call, the psql executable on my Linux box grows from 421761 to 677682 bytes in size. It is still shared linked against libc,

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Peter Eisentraut
Marko Karppinen wrote: > I guess the key thing is that pgFoundry shouldn't be a community > distinct from the core. The same community standards need to apply > on both sides of the fence. Yes, and the best way to achieve that would be to not have anything to pgfoundry and keep everything in the

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Peter Eisentraut
Joshua D. Drake wrote: > >One reason against including plPHP in the core would be that it > > would create a circular build dependency between the packages > > postgresql and php. I think we should rather avoid that. > > It is no different that the dependency between plPerl and Perl, > plPython an

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Bruce Momjian
Jan Wieck wrote: > > Static linking of our binaries? Hmmm. Makes sense. We would need a > > special flag for that. I can add it to the TODO. > > > > Seems my testing was flawed because I didn't clean out my hard-coded > > directory properly. I see now: > > > > $ bin/initdb > > bin/in

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Greg Stark
Bruce Momjian <[EMAIL PROTECTED]> writes: > Greg Stark wrote: > > Jan Wieck <[EMAIL PROTECTED]> writes: > > > > > You know how much trouble that causes? The existance of LD_LIBRARY_PATH in your > > > environment disables setuid() for security reasons on some platforms. So one > > > would have to

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Jan Wieck
Bruce Momjian wrote: Jan Wieck wrote: Bruce Momjian wrote: > Jan Wieck wrote: >> > I think if we go for the plan outlined, we will not need a special >> > configure flag. (People might decide to move the install dir long after >> > they install it.) By default, everything sits under pgsql as pgsq

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Bruce Momjian
Joshua D. Drake wrote: > >Except you miss one key point here ... if Bruce/Tom/Jan have that sort of > >time, why aren't they doing it now? > > > > > Well I think you might of missed his point. His point was if he could > pick their priorities. I would kind > of agree with Robert except that ther

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Jan Wieck
Greg Stark wrote: Jan Wieck <[EMAIL PROTECTED]> writes: You know how much trouble that causes? The existance of LD_LIBRARY_PATH in your environment disables setuid() for security reasons on some platforms. So one would have to wrap every PG related program into equally named shell scripts or aliase

Re: [HACKERS] Table Spaces

2004-05-18 Thread pgsql
> [EMAIL PROTECTED] wrote: > >> This makes me worried. That's the way we *used* to do things, but the >> sleazy IP lawyers are looking for anything with which they can create >> the >> impression of impropriety. The open source and free projects are ground >> zero for this crap. >> >> We *really* n

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
Marc G. Fournier wrote: On Tue, 18 May 2004, Robert Treat wrote: Just like Bruce has often asked the community how they feel about him balancing his time between things like speaking engagements and patch applications, core developers have a limited amount of time they can spend o

Re: [HACKERS] bitwise and/or aggregate functions?

2004-05-18 Thread Neil Conway
Alvaro Herrera Munoz wrote: Those are PDFs AFAIR, not easily greppable Not greppable, but any half-decent PDF viewer should have a "search" feature that should allow much the same thing. Checking the index is another way to go, although it is somewhat time-consuming. I don't have access to an AS

Re: [HACKERS] Table Spaces

2004-05-18 Thread Bruce Momjian
[EMAIL PROTECTED] wrote: > >> Let's just make sure we keep records of the generic sources of where we > >> find things. I get *really* scared when I see sentences like "I assume > >> we > >> can just look at the source and write our own version bypassing any > >> license." That is categorically a f

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Greg Copeland
On Tue, 2004-05-18 at 09:30, Andrew Sullivan wrote: > On Sun, May 16, 2004 at 02:46:38PM -0400, Jan Wieck wrote: > > > fact that checkpoints, vacuum runs and pg_dumps bog down their machines > > to the state where simple queries take several seconds care that much > > for any Win32 port? Do you

Re: [HACKERS] Table Spaces

2004-05-18 Thread pgsql
> [EMAIL PROTECTED] wrote: >> >> >> >We've looked at it before. Apart from anything else I don't think >> >> >> >its license is compatible with PostgreSQL's. >> >> >> >> >> >> Well, people can still use it. We just can't distribute >> >> it... We can >> >> >> always link to it. >> >> >> But unless

Re: [HACKERS] bitwise and/or aggregate functions?

2004-05-18 Thread Alvaro Herrera Munoz
On Tue, May 18, 2004 at 12:39:08PM -0400, Neil Conway wrote: > A copy that claims to "represent an almost indistinuishable delta on the > actual SQL 2003 database standard" is available online here: > > http://www.wiscorp.com/sql/sql_2003_standard.zip Those are PDFs AFAIR, not easily greppable

Re: [HACKERS] Table Spaces

2004-05-18 Thread Bruce Momjian
[EMAIL PROTECTED] wrote: > >> >> >We've looked at it before. Apart from anything else I don't think > >> >> >its license is compatible with PostgreSQL's. > >> >> > >> >> Well, people can still use it. We just can't distribute > >> it... We can > >> >> always link to it. > >> >> But unless there is

Re: [HACKERS] Why new features only in magior releases ?

2004-05-18 Thread Neil Conway
Gaetano Mendola wrote: I well understand the reason to wait a 7.5 in order to delivery BIG changes that are requiring a initdb, but I don't understand why little enhancement can not be delivered in a 7.4.3 ( may be with a short period with a 7.4.3beta ) like the "vacuum delayed". I don't think this

Re: [HACKERS] bitwise and/or aggregate functions?

2004-05-18 Thread Neil Conway
[ Sorry for the latency of my response, Chris -- this got buried in my inbox... ] Fabien COELHO wrote: I don't know where these standards are available online... It seems they are not available:-( A copy that claims to "represent an almost indistinuishable delta on the actual SQL 2003 database s

Re: [HACKERS] Table Spaces

2004-05-18 Thread pgsql
>> >> >We've looked at it before. Apart from anything else I don't think >> >> >its license is compatible with PostgreSQL's. >> >> >> >> Well, people can still use it. We just can't distribute >> it... We can >> >> always link to it. >> >> But unless there is a GUI tool (actually, unless it shows u

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Bruce Momjian
Marc G. Fournier wrote: > On Tue, 18 May 2004, Robert Treat wrote: > > > Just like Bruce has often asked the community how they feel about him > > balancing his time between things like speaking engagements and patch > > applications, core developers have a limited amount of time they can > > spen

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Bruce Momjian
Greg Stark wrote: > Jan Wieck <[EMAIL PROTECTED]> writes: > > > You know how much trouble that causes? The existance of LD_LIBRARY_PATH in your > > environment disables setuid() for security reasons on some platforms. So one > > would have to wrap every PG related program into equally named shell

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Bruce Momjian
Jan Wieck wrote: > Bruce Momjian wrote: > > Jan Wieck wrote: > >> > I think if we go for the plan outlined, we will not need a special > >> > configure flag. (People might decide to move the install dir long after > >> > they install it.) By default, everything sits under pgsql as pgsql/bin, > >>

[HACKERS] Why new features only in magior releases ?

2004-05-18 Thread Gaetano Mendola
Hi all, may be this was already discussed, I'm quite new to postgres ( only 3 years ), I try however. I seen the debate around the time freeze for 7.5, who say to wait in order to have more "chance" to have PITR, Win32, 2PC... and who say that wait a month more will not change nothing. I well under

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Andrew Sullivan
On Sun, May 16, 2004 at 02:46:38PM -0400, Jan Wieck wrote: > fact that checkpoints, vacuum runs and pg_dumps bog down their machines > to the state where simple queries take several seconds care that much > for any Win32 port? Do you think it is a good sign for those who have Yes. I am one su

Re: [HACKERS] Table Spaces

2004-05-18 Thread Magnus Hagander
> >> >We've looked at it before. Apart from anything else I don't think > >> >its license is compatible with PostgreSQL's. > >> > >> Well, people can still use it. We just can't distribute > it... We can > >> always link to it. > >> But unless there is a GUI tool (actually, unless it shows up in

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Greg Stark
Jan Wieck <[EMAIL PROTECTED]> writes: > You know how much trouble that causes? The existance of LD_LIBRARY_PATH in your > environment disables setuid() for security reasons on some platforms. So one > would have to wrap every PG related program into equally named shell scripts or > aliases to just

Re: [HACKERS] Table Spaces

2004-05-18 Thread pgsql
> Magnus Hagander wrote: >> >>If you run NTFS, it's still possible to use arbitrary links. >> >In the Windows >> >>world, they are called junctions. Microsoft does not provide >> >a junction tool >> >>for some reason (perhaps because it's limited to NTFS). A >> >good tool, free >> >>and with source

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Marc G. Fournier
On Tue, 18 May 2004, Robert Treat wrote: > Just like Bruce has often asked the community how they feel about him > balancing his time between things like speaking engagements and patch > applications, core developers have a limited amount of time they can > spend on any given development effort. I

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Robert Treat
On Mon, 2004-05-17 at 19:39, Marc G. Fournier wrote: > On Mon, 17 May 2004, Mike Mascari wrote: > > Greg Stark wrote: > > > Simon Riggs <[EMAIL PROTECTED]> writes: > > > > > >>I can't complete by 1 June. Think worse of me if you choose. > > > > > ... > > > So in my perfect world I picture 7.5 freez

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
Peter Eisentraut wrote: Joshua D. Drake wrote: Uhhh?? Are you ripping out all core pls then? plPerlNG is supposed to replace plPerl, I was talking with Bruce and he seemed to think that (as long as the code was good enough) that we could incorporate plPHP??? One reason a

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
a release, etc ... I'd almost say that time would be better spent on coming up with an effective upgrade method so that upgrading to new releases is easier ... Please note that I'm not against the backporting, but do understand the arguments against it in terms of time and manpower ... I believ

Re: [HACKERS] question about information_schema

2004-05-18 Thread Kris Jurka
On Tue, 18 May 2004, Dave Cramer wrote: > If I do create type testint8 as (i int8) and then select typbasetype > from pg_type where typname='testint8' the value is 0? You've created a complex type here, not a domain. See typtype and typrelid for this case. create domain testint8 as int8; wi

[HACKERS] XactIsoLevel handling

2004-05-18 Thread Heikki Linnakangas
In tcop/utility.c, the isolation level is set with a call like: SetPGVariable("transaction_isolation", makeList(item->arg), false) when a BEGIN SERIALIZABLE etc. call is made. Why is the isLocal-parameter false? Couldn't it be true as well? It works as it is, since the XactIsoLevel variable is r

Re: [HACKERS] Relocatable installs

2004-05-18 Thread Jan Wieck
Bruce Momjian wrote: Jan Wieck wrote: > I think if we go for the plan outlined, we will not need a special > configure flag. (People might decide to move the install dir long after > they install it.) By default, everything sits under pgsql as pgsql/bin, > pgsql/lib, etc. I can't see how making

Re: [HACKERS] add server include files to default installation?

2004-05-18 Thread Fabien COELHO
Dear Jan, > Depending on the OS you also need funny things like mkldexport shell > scripts and the like. Possibly, yes... I don't know. I really need a list, then it is pretty easy to update all makefiles. > I thought we had a consensus of providing a template build environment > for external m

Re: [HACKERS] add server include files to default installation?

2004-05-18 Thread Jan Wieck
Marc G. Fournier wrote: On Sat, 15 May 2004, Bruce Momjian wrote: Fabien COELHO wrote: > > Dear hackers, > > I wish to submit a small patch so that server includes and > all necessary configuration files could be installed *by default*. > > The current status is that server includes files are only

[HACKERS] question about information_schema

2004-05-18 Thread Dave Cramer
I'm trying to implement getUDT for the jdbc driver. It requires the basetype of a type. If I do create type testint8 as (i int8) and then select typbasetype from pg_type where typname='testint8' the value is 0? While I'm asking how can I find all of the user defined types, assuming that the user

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Magnus Hagander
> > That is the plan ... unless someone knows a reason why they > can't be > > built independently of the core? > > How about this one: Everything we have moved from the core > to gborg so far has been a miserable failure. The code is no > longer maintained, or maintained by three different

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Heikki Linnakangas
On Mon, 17 May 2004, Alvaro Herrera Munoz wrote: > On Mon, May 17, 2004 at 04:55:50PM +0200, Zeugswetter Andreas SB SD wrote: > > Can we try to do the 2PC patch now instead of waiting for subtransactions ? > > The last post from Heikki I read said that he discovered some serious > problems with hi

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Richard Huxton
Marko Karppinen wrote: I guess the key thing is that pgFoundry shouldn't be a community distinct from the core. The same community standards need to apply on both sides of the fence. [snip] Thanks Marko, you just wrote exactly what I was concerned about with "features" rather than "applications" b

Re: [HACKERS] [PATCHES] Current-stream read for psql's \copy

2004-05-18 Thread Richard Huxton
Bruce Momjian wrote: Also, I came upon this gem: $ echo '\\copy test to stdout' | psql -o /tmp/z test 444 444 444 444 444 Seems 'copy to stdout' also has this split idea of sending \copy output to a different place from other output. I guess my big qu

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Marko Karppinen
Peter Eisentraut wrote: How about this one: Everything we have moved from the core to gborg so far has been a miserable failure. The code is no longer maintained, or maintained by three different competing groups, the documentation has disappeared, the portability is no longer taken care of, and

Re: [HACKERS] Table Spaces

2004-05-18 Thread Zeugswetter Andreas SB SD
> >If you run NTFS, it's still possible to use arbitrary links. In the Windows > >world, they are called junctions. Microsoft does not provide a junction tool > >for some reason (perhaps because it's limited to NTFS). A good tool, free > >and with source, can be found here > >http://www.sysinterna

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Tatsuo Ishii
> How about this one: Everything we have moved from the core to gborg so > far has been a miserable failure. The code is no longer maintained, or > maintained by three different competing groups, the documentation has > disappeared, the portability is no longer taken care of, and only the > b

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Peter Eisentraut
Joshua D. Drake wrote: > Uhhh?? Are you ripping out all core pls then? plPerlNG is supposed to > replace plPerl, I was talking with Bruce and he seemed to think that > (as long as the code was good enough) that we could incorporate > plPHP??? One reason against including plPHP in the core would be