Re: [PATCHES] Re: [HACKERS] Re: nocreatetable for 7.1.2 [patch]

2001-08-27 Thread Karel Zak
On Fri, Aug 24, 2001 at 04:05:57PM -0400, Bruce Momjian wrote: Were are we on this? We keep talking about NOCREATETABLE permission for every release but can't seem to get it in there because people want a redesign of permissions. My feeling is that it should be added to 7.2. I know very

[HACKERS] extern + static issue in datetime.c

2001-08-27 Thread Zeugswetter Andreas SB SD
Current sources don't compile on AIX with xlc compiler because of the combined (and inconsistent ? or compiler bug) use of extern and static for the datetktbl in datetime.c. header unconditionally has: extern datetkn datetktbl[]; source has: static datetkn datetktbl[] = { The usual

[HACKERS] GiST vacation

2001-08-27 Thread Oleg Bartunov
Hi, I'm going to vacation and will be totally offline and Teodor is already enjoy Cyprus. He will be back september 8-9. I'll be back september 19. Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of

Re: [HACKERS] User locks code

2001-08-27 Thread Massimo Dal Zotto
Tom Lane wrote: I definitely agree with Vadim here: it's fairly silly that the contrib userlock code is GPL'd, when it consists only of a few dozen lines of wrapper for the real functionality that's in the main backend. I was incorrect in something I said to Vadim. I said

[HACKERS] Re: AW: Re: OID wraparound: summary and proposal

2001-08-27 Thread Dale Johnson
The way I see it there are 4 options for the OID: What about a vacuum analyze for the database that renumbers theOIDs back at some baseline? There is still a limitation on the total number of active rows in the database (0.5 * 2^32), but at least we wouldn't have this timebomb. Dale

[HACKERS] Re: List response time...

2001-08-27 Thread Colin 't Hart
Marc wrote: Actually, the 'multi-day' delay is generally related to posts from ppl that aren't subscribed to the lists that I have to approve manually ... Is there a quick(er) way to 'subscribe, set nomail' on all the mailing lists that are mirrored to news.postgresql.org? I prefer to

[HACKERS] Re: C++ and bool constants (was Re: [NOVICE] gcc 3.0.1)

2001-08-27 Thread Leandro Fanzone
Fine for me also. Leandro. Tom Lane wrote: Leandro Fanzone [EMAIL PROTECTED] writes: I have compiled PostgreSQL 7.1.2 with gcc 3.0.1, and have the following problem: if I include first libpq++.h before iostream, id est: #include libpq++.h #include iostream the compiler complains:

Re: [HACKERS] Toast,bytea, Text -blob all confusing

2001-08-27 Thread Frank Joerdens
On Thu, Aug 23, 2001 at 01:09:14PM -0400, [EMAIL PROTECTED] wrote: I'm trying my best to convert from MySQL to PgSQL but I cant get a good answer about certian questions. It was an easy task in mysql but all this talk about , text , toast and bytea is just confusing me. I cant get a clear

[HACKERS] Where can I learn more about Multi-Version Concurrency Control?

2001-08-27 Thread Carfield Yim
I would like to learn more about Multi-Version Concurrency Control Other than http://pgsql.profnet.pl/osdn/transactions.pdf, where can I find more resource? -- Carfield Yim, visit my homepage at http://www.carfield.com.hk ---(end of

Re: [HACKERS] /include/config.h

2001-08-27 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Is include/config.h still supposed to be in CVS? What? config.h was never supposed to be in CVS. config.h.in has been renamed to pg_config.h.in, see Peter's recent activity ... regards, tom lane ---(end

[HACKERS] Problem with postgres's date

2001-08-27 Thread Juan Manuel GarcĂ­a Arias
How is posible show the date in european format. By defalut it's ISO. I can show with SET datestyle=postgres but is validate from one sesion only. Thanks ---(end of broadcast)--- TIP 6: Have you searched our list archives?

Re: [HACKERS] Permissions for large-object comments

2001-08-27 Thread Shane Wegner
On Sat, Aug 25, 2001 at 02:45:40AM +0200, Peter Eisentraut wrote: Tom Lane writes: Shane Wegner [EMAIL PROTECTED] writes: test= \lo_unlink 89803 ERROR: pg_description: Permission denied. Hmm. Maybe those client-side comment manipulations in psql aren't such a hot idea. I know

Re: [HACKERS] Toast,bytea, Text -blob all confusing

2001-08-27 Thread Alex Pilosov
On Thu, 23 Aug 2001 [EMAIL PROTECTED] wrote: THIS IS WHAT I CANT SEEM TO FIGURE OUT IN POSTGRESQL 1. I cant get a clear answer on what kind of data type to use for my large text string? TEXT, ???, ??? or something about TOAST I have seen in the e-mail archive but cant find any documentaion?

Re: [HACKERS] extern + static issue in datetime.c

2001-08-27 Thread Tom Lane
Zeugswetter Andreas SB SD [EMAIL PROTECTED] writes: Current sources don't compile on AIX with xlc compiler because of the combined (and inconsistent ? or compiler bug) use of extern and static for the datetktbl in datetime.c. Fixed. A pass with HP's compiler also showed up a

Re: [HACKERS] extern + static issue in datetime.c

2001-08-27 Thread Tom Lane
Zeugswetter Andreas SB SD [EMAIL PROTECTED] writes: Attached is a patch that might be considered (remove static for these globals). Actually, they are not globals AFAICS, so removing the header extern seemed the more appropriate fix. regards, tom lane

[HACKERS] libpq++ current sources don't compile with older C++ compilers

2001-08-27 Thread Tom Lane
Today I did something I usually do about once per release cycle: try to build the system with HP's vendor cc, rather than gcc which I prefer. This usually turns up some portability issues, and indeed I found some. One that I'm not entirely sure about how to fix is that libpq++ no longer builds

Re: [HACKERS] Upcoming events

2001-08-27 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: ... Beta may start as soon as Saturday, September 1. My guess is that end of *next* week would be more appropriate. Personally I've finished all the major items I wanted to do for 7.2, but there are still some little things that it'd be nice to clean up.

[HACKERS] Re: Locale by default?

2001-08-27 Thread Thomas Lockhart
Face it, everything has locale support these day. PostgreSQL is one of the few packages that even has it as an option to turn it off. Users of binary packages of PostgreSQL are all invariably faced with locale features. So it's not like sudden unasked-for locale support is going to be a

Re: [HACKERS] Upcoming events

2001-08-27 Thread Joe Conway
Does anyone else have work that they're trying to finish up before we go beta? Well, I did have a question that got lost in the details of the recent bytea discussion. Specifically it was this: is there a good reason that byteaout octal escapes all non-printable characters? ISTM that if you

Re: [HACKERS] libpq++ current sources don't compile with older C++ compilers

2001-08-27 Thread pgsql-hackers
On Mon, Aug 27, 2001 at 04:16:57PM -0400, Tom Lane wrote: Today I did something I usually do about once per release cycle: try to build the system with HP's vendor cc, rather than gcc which I prefer. This usually turns up some portability issues, and indeed I found some. One that I'm not

Re: [HACKERS] libpq++ current sources don't compile with older C++ compilers

2001-08-27 Thread Tom Lane
[EMAIL PROTECTED] writes: What version of aCC are you using? $ what /opt/aCC/bin/aCC /opt/aCC/bin/aCC: HP aC++ B3910B A.01.00 HP ANSI C++ B3910B A.00.03 /usr/lib/libc: $Revision: 76.3 $ It's whatever shipped with HPUX 10.20, AFAIR. For my purposes, the fact that it's

Re: [HACKERS] Upcoming events

2001-08-27 Thread Marc G. Fournier
Ya, lets go with the 10th of Sept, which is a Monday, start of the week and all that, everyone has had a chance to relax once the kids are back in school and all that :) On Mon, 27 Aug 2001, Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: ... Beta may start as soon as Saturday,

Re: [HACKERS] Re: Link to bug webpage

2001-08-27 Thread Tom Lane
Thomas Lockhart [EMAIL PROTECTED] writes: The fundamental problem with bug tracking has been that the available tools do not fit with our obviously successful mailing-list centered development process. I certainly would consider it a distraction to consult that tool to be able to participate

RE: [HACKERS] Upcoming events

2001-08-27 Thread Christopher Kings-Lynne
Do we want ADD PRIMARY KEY? Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane Sent: Tuesday, 28 August 2001 8:56 AM To: Bruce Momjian Cc: PostgreSQL-development Subject: Re: [HACKERS] Upcoming events Bruce Momjian [EMAIL

[HACKERS] bytea escaping

2001-08-27 Thread Tom Lane
Joe Conway [EMAIL PROTECTED] writes: ... is there a good reason that byteaout octal escapes all non-printable characters? Well, AFAICS it *has to* escape nulls (zero bytes). Whether it escapes more stuff is a matter of taste once you accept that. What we really need to have to make bytea

Re: [HACKERS] Upcoming events

2001-08-27 Thread Tom Lane
Christopher Kings-Lynne [EMAIL PROTECTED] writes: Do we want ADD PRIMARY KEY? If you can get it done in the next week or so ... regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

Re: [HACKERS] Upcoming events

2001-08-27 Thread Joe Conway
Does anyone else have work that they're trying to finish up before we go beta? Well, I did have a question that got lost in the details of the recent bytea discussion. Specifically it was this: is there a good reason that byteaout octal escapes all non-printable characters? ISTM that

[HACKERS] Re: Locale by default?

2001-08-27 Thread Tatsuo Ishii
Face it, everything has locale support these day. PostgreSQL is one of the few packages that even has it as an option to turn it off. Users of binary packages of PostgreSQL are all invariably faced with locale features. So it's not like sudden unasked-for locale support is going to

[HACKERS] Re: Link to bug webpage

2001-08-27 Thread Thomas Lockhart
*whimper* I've been out of town for a week, and will not be able to catch up with ~2000 email messages. So I can't even get to the end of this thread. But I must agree that PostgreSQL development is pushing the limits of what a person can keep up with. I am not interested in finding a mailing

[HACKERS] Re: Locale by default?

2001-08-27 Thread Thomas Lockhart
Certainly everyone would agree that locale support is desirable. No... That is why I put locale support in double-quotes. Sorry that I was cryptic, but I do understand your concern that OS-specific locale support is suspect for some languages. In my opinion, with the SQL99 collate support,