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

2001-08-27 Thread Lincoln Yeoh
At 03:05 PM 27-08-2001 -0400, Alex Pilosov wrote: >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

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 partici

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] 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

[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 su

[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 l

[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

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? > >

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? ht

[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 byte

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 <[EM

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 e

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 yo

[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

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 u

[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 at

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 ---

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 static-v

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 documentai

[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 broadcast)

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 cle

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

[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? http://www.postgresql.

[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 > > #include > > the compiler complains: > > > T

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 ---(en

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

2001-08-27 Thread jason . ory
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 picture of any of this,from the book from Bruce, the e-mail archives. Ive

[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 read/p

[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 Joh

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

[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 As

[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 approach

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 ve

[HACKERS] Re: [PATCHES] encoding names

2001-08-27 Thread Karel Zak
On Fri, Aug 24, 2001 at 09:29:06PM +0200, Peter Eisentraut wrote: > Tatsuo Ishii writes: > > > > Maybe we should not touch getdatabaseencoding() right now, given that the > > > names we currently use are apparently almost correct anyway and > > > considering the pain it creates to alter them, and