Re: [GENERAL] Nested Transactions in 7.5??

2003-12-26 Thread Tom Lane
Jim Rosenberg <[EMAIL PROTECTED]> writes: > How realistic is it to expect nested transactions to make it into > PostgreSQL 7.5? I wouldn't hold my breath. It's a complex problem. regards, tom lane ---(end of broadcast)---

Re: [GENERAL] Photos of PostgreSQL booth

2003-12-26 Thread Michael Meskes
On Thu, Dec 25, 2003 at 06:25:34PM -0400, Marc G. Fournier wrote: > whose manning the booth? The one one the photos is Noel Koethe. He manned the booth together with Peter Eisentraut and me. Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De ICQ: 179140304, AIM/Yahoo: michaelmeskes, J

Re: [GENERAL] Is my MySQL Gaining ?

2003-12-26 Thread Joshua D. Drake
http://www.mysql.com/doc/en/News-5.0.x.html Does this concern anyone. Well from one perspective MySQL is still playing catch up. While they are adding features that they still don't have stable OR that are labelled "Basic Support", PostgreSQL has had mature support for a long time. What I

Re: [GENERAL] Photos of PostgreSQL booth

2003-12-26 Thread Marc G. Fournier
On Fri, 26 Dec 2003, Michael Meskes wrote: > On Thu, Dec 25, 2003 at 06:25:34PM -0400, Marc G. Fournier wrote: > > whose manning the booth? > > The one one the photos is Noel Koethe. He manned the booth together with > Peter Eisentraut and me. One thought for future booths would be to have a "gro

Re: [GENERAL] Photos of PostgreSQL booth

2003-12-26 Thread Michael Meskes
On Fri, Dec 26, 2003 at 02:04:09PM -0400, Marc G. Fournier wrote: > One thought for future booths would be to have a "group photo" done that > we can add to the web site ... ? :) Yes, good idea. :-) Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De ICQ: 179140304, AIM/Yahoo: michaelm

Re: [GENERAL] Is my MySQL Gaining ?

2003-12-26 Thread Randal L. Schwartz
> "Jan" == Jan Wieck <[EMAIL PROTECTED]> writes: Jan> It seems to concern MySQL now at least. They have changed their minds Jan> on many enterprise features that PostgreSQL has for years. The Jan> strategy of misguiding people like "you don't need foreign keys", "you Jan> don't need stored pro

Re: [GENERAL] between

2003-12-26 Thread Martin Marques
El Vie 26 Dic 2003 13:02, Mike Nolan escribió: > > Is there any chance on supporting BETWEEN in the WHERE conditions of a SELECT > > clause? > > You mean like this? > > Welcome to psql 7.4.1, the PostgreSQL interactive terminal. > > Type: \copyright for distribution terms > \h for hel

Re: [GENERAL] Is my MySQL Gaining ?

2003-12-26 Thread Martin Marques
El Vie 26 Dic 2003 13:18, Sai Hertz And Control Systems escribió: > Dear Martin Marques, > > >>What do you think yes we PostgreSQL users need some introspection. > >> > >> > > > >1) This is in the 5.0.0 development tree, which could come out around. > >lets say 2 years maybe? > >2) Stored

Re: [GENERAL] Is my MySQL Gaining ?

2003-12-26 Thread Joshua D. Drake
I've noticed a similar strategy in the PHP vs Perl dimension. PHP started out being "simple and fast and easy to learn" by throwing off all of the "complexities of Perl that weren't needed". Slowly and steadily, lagging about 3 to 10 years behind, PHP has adding one-by-one all those "weird Perl f

Re: [GENERAL] bug in query planning?

2003-12-26 Thread Steven D.Arnold
Thanks to all for the detailed replies. I just wanted to let everyone know -- for future google searches as much as anything else -- that dumping the database, upgrading to 7.4.1 and reloading did solve the problem. All the queries I mentioned now use the available indices, except for underst

Re: [GENERAL] between

2003-12-26 Thread Tom Lane
Martin Marques <[EMAIL PROTECTED]> writes: >> That's been in PostgreSQL for a long time. > Damn, didn't find it in the docs, and just supposed it wasn't there. It's been shown on the 'Comparison Operators' page for a long time: http://www.postgresql.org/docs/7.1/static/functions-comparison.html

Re: [GENERAL] between

2003-12-26 Thread Martin Marques
El Vie 26 Dic 2003 16:26, escribió: > Martin Marques <[EMAIL PROTECTED]> writes: > >> That's been in PostgreSQL for a long time. > > > Damn, didn't find it in the docs, and just supposed it wasn't there. > > It's been shown on the 'Comparison Operators' page for a long time: > > http://www.postg

Re: [GENERAL] ecpg question

2003-12-26 Thread George Gensure
Cool. I only thought that tbl would need special treatment. Is that fix in cvs? Thanks, -George ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] between

2003-12-26 Thread Mike Nolan
> Damn, didn't find it in the docs, and just supposed it wasn't there. Try finding it in the online mysql docs. :-) Yes, it is there, but it took me far longer to wade through their docs to find it than in the postgresql docs. It took me less time with the Oracle SQL Language Reference Manua

Re: [GENERAL] between

2003-12-26 Thread Martin Marques
El Vie 26 Dic 2003 18:02, Mike Nolan escribió: > > Damn, didn't find it in the docs, and just supposed it wasn't there. > > Try finding it in the online mysql docs. :-) > > Yes, it is there, but it took me far longer to wade through their > docs to find it than in the postgresql docs. > > It

Re: [GENERAL] between

2003-12-26 Thread Tom Lane
Mike Nolan <[EMAIL PROTECTED]> writes: > It took me less time with the Oracle SQL Language Reference Manual, but > I cheated by looking it up in the index. Just FYI, there's an index entry for BETWEEN in the PG docs too: http://www.postgresql.org/docs/7.4/static/bookindex.html although it seems to

Re: [GENERAL] between

2003-12-26 Thread Martin Marques
El Vie 26 Dic 2003 18:27, Tom Lane escribió: > Mike Nolan <[EMAIL PROTECTED]> writes: > > It took me less time with the Oracle SQL Language Reference Manual, but > > I cheated by looking it up in the index. > > Just FYI, there's an index entry for BETWEEN in the PG docs too: > http://www.postgresq

Re: [GENERAL] between

2003-12-26 Thread Mike Nolan
> Just FYI, there's an index entry for BETWEEN in the PG docs too: > http://www.postgresql.org/docs/7.4/static/bookindex.html > although it seems to mistakenly be lowercase instead of uppercase > as one would expect. I think I tried searching on 'between' but didn't find anything. > In general th

Re: [GENERAL] between

2003-12-26 Thread Randal L. Schwartz
> "Martin" == Martin Marques <[EMAIL PROTECTED]> writes: Martin> A link to the URL above in the SELECT page? Uh, do you also want a link to "installing PostgreSQL" there too? After all, you have to install Pg before you can use the SELECT operator. It's not any more related to SELECT than it

Re: [GENERAL] between

2003-12-26 Thread Martin Marques
El Vie 26 Dic 2003 20:10, Randal L. Schwartz escribió: > > "Martin" == Martin Marques <[EMAIL PROTECTED]> writes: > > Martin> A link to the URL above in the SELECT page? > > Uh, do you also want a link to "installing PostgreSQL" there too? > After all, you have to install Pg before you can us

Re: [GENERAL] between

2003-12-26 Thread Tom Lane
Martin Marques <[EMAIL PROTECTED]> writes: > I personaly find this incomplete: > ==>CUT FROM THE SELECT MANUAL<=== So it is, but I think the solution is to eliminate the incomplete examples. Which, indeed, seems to have been done in the 7.4 docs: http://www

Re: [GENERAL] Is my MySQL Gaining ?

2003-12-26 Thread Chris Travers
Hi all; Regarding the questions of MySQL and PostgreSQL, I do expect PostgreSQL to continue to grow more slowly than MySQL for some time. However MySQL has a few problems in their approach that PostgreSQL lacks, and in time, there is no doubt in my mind that, of the open source databases availabl

Re: [GENERAL] Is my MySQL Gaining ?

2003-12-26 Thread Marc G. Fournier
On Sat, 27 Dec 2003, Chris Travers wrote: > 2: Maintaining centralized corporate control over everything in the > database manager. This slows their rate of development and we will > continue to move faster than them. This could be argued both ways, actually ... their model makes for less discus

[GENERAL] dump 7.3 into 7.2?

2003-12-26 Thread Russ Schneider
I need to transfer a dump from a psql 7.3 database to a 7.2 database. Is there any way to do this? -- [ Russ Schneider (a.k.a. Sugapablo) ] [ http://www.sugapablo.com <--music ] [ http://www.sugapablo.net <--personal ] [ [EMAIL PROTECTED] <--jabber IM ] ---(

Re: [GENERAL] dump 7.3 into 7.2?

2003-12-26 Thread Tom Lane
Russ Schneider <[EMAIL PROTECTED]> writes: > I need to transfer a dump from a psql 7.3 database to a 7.2 database. > Is there any way to do this? You will have to do some manual hacking on the schema declarations, almost certainly. I'd recommend dumping the schema and data separately so that th

Re: [GENERAL] dump 7.3 into 7.2?

2003-12-26 Thread Ausrack Webmaster
Tom, Do you know if it is possible to upgrade postgresql on a RAQ4? Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane Sent: Saturday, December 27, 2003 1:09 PM To: Russ Schneider Cc: pgsql-general Subject: Re: [GENERAL] dump 7.3 into 7.2?

Re: [GENERAL] Strange permission problem regarding pg_settings

2003-12-26 Thread Joe Conway
Tom Lane wrote: I suspect the fact that the pre-patch code made the "right" permissions check was really coincidental, and that the correct fix will not involve reversion of that patch but rather adding a facility somewhere to ensure that the original view gets properly permission-checked even if t