Re: [HACKERS] I am done

2002-09-05 Thread Gavin Sherry
On Wed, 4 Sep 2002, Tom Lane wrote: Gavin Sherry [EMAIL PROTECTED] writes: Does anyone else have an opinion on this? If not, I will implement it per Bruce's commentary. On Mon, 2 Sep 2002, Bruce Momjian wrote: I think the second, passing an arg to say whether it is server or client,

[HACKERS] Please rename split(text,text,int) to splitpart

2002-09-05 Thread Hannu Krosing
It seems that my last mail on this did not get through to the list ;( Please consider renaming the new builtin function split(text,text,int) to something else, perhaps split_part(text,text,int) (like date_part) The reason for this request is that 3 most popular scripting languages

[HACKERS] contrib/tsearch

2002-09-05 Thread Christopher Kings-Lynne
Hi Oleg/Teodor, I'm sorry to keep posting bugs without patches, but I'm just hoping you guys know the answer faster than I...I know you're busy. What does tsearch have against the word 'herring' (as in the fish). Why is it considered a stopword? Attached is example queries... Chris usa=#

Re: [HACKERS] contrib/tsearch

2002-09-05 Thread Christopher Kings-Lynne
Hmmm...thinking about it, maybe 'herring' is being reduced to 'her' after the stemming process and hence is thought to be a stopword? This is a bug, but how should it be fixed? Although, tests don't support that: usa=# select food_id, brand,description,ftiidx from food_foods where ftiidx ##

Re: [HACKERS] Inheritance

2002-09-05 Thread Hannu Krosing
On Thu, 2002-09-05 at 03:57, Curt Sampson wrote: On Tue, 3 Sep 2002, Bruce Momjian wrote: Yep, this is where we are stuck; having an index span multiple tables in some way. Or implementing it by keeping all data in the table in which it was declared. (I.e., supertable holds all rows;

Re: [HACKERS] Inheritance

2002-09-05 Thread Curt Sampson
On 5 Sep 2002, Hannu Krosing wrote: On Thu, 2002-09-05 at 03:57, Curt Sampson wrote: Or implementing it by keeping all data in the table in which it was declared. (I.e., supertable holds all rows; subtable holds only the primary key and those columns of the row that are not in the

Re: [HACKERS] Inheritance

2002-09-05 Thread Hannu Krosing
On Thu, 2002-09-05 at 09:28, Curt Sampson wrote: On 5 Sep 2002, Hannu Krosing wrote: On Thu, 2002-09-05 at 03:57, Curt Sampson wrote: Or implementing it by keeping all data in the table in which it was declared. (I.e., supertable holds all rows; subtable holds only the primary key

Re: [HACKERS] 7.3 gotchas for applications and client libraries

2002-09-05 Thread Christopher Kings-Lynne
Was this going to make it into the release notes or something? Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane Sent: Tuesday, 3 September 2002 9:54 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [HACKERS] 7.3 gotchas for

Re: [HACKERS] Inheritance

2002-09-05 Thread Curt Sampson
On 5 Sep 2002, Hannu Krosing wrote: What I meant was that it is relatively more costly to update several physical tables than updating one . Oh, I see. Not that this is that big a deal, I think. Given that it doesn't work correctly at the moment, making it work fast is a definite second

Re: [HACKERS] Inheritance

2002-09-05 Thread Jeff Davis
I have a question about inheritance: You have 2 tables: Programmer and employee. Programmer inherits employee. You put in a generic employee record for someone, but then she becomes a programmer. What do you do? (I borrowed this example from a book by C.J. Date, who posed this question). Do

Re: [HACKERS] Inheritance

2002-09-05 Thread Curt Sampson
On Thu, 5 Sep 2002, Jeff Davis wrote: You have 2 tables: Programmer and employee. Programmer inherits employee. You put in a generic employee record for someone, but then she becomes a programmer. What do you do? (I borrowed this example from a book by C.J. Date, who posed this question). Do

Re: [HACKERS] Inheritance

2002-09-05 Thread Hannu Krosing
On Thu, 2002-09-05 at 10:52, Curt Sampson wrote: On 5 Sep 2002, Hannu Krosing wrote: What I meant was that it is relatively more costly to update several physical tables than updating one . Oh, I see. Not that this is that big a deal, I think. Given that it doesn't work correctly at

Re: [HACKERS] Inheritance

2002-09-05 Thread Curt Sampson
On 5 Sep 2002, Hannu Krosing wrote: Oh, I see. Not that this is that big a deal, I think. Given that it doesn't work correctly at the moment, making it work fast is a definite second priority, I would think. But choosing an implementation that _can_be_ made to work fast is not. I would

Re: [HACKERS] contrib/tsearch

2002-09-05 Thread Oleg Bartunov
On Thu, 5 Sep 2002, Christopher Kings-Lynne wrote: Hmmm...thinking about it, maybe 'herring' is being reduced to 'her' after the stemming process and hence is thought to be a stopword? This is a bug, but how should it be fixed? It's difficult question how to use stop words. We'll see what

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Vince Vielhaber
On Wed, 4 Sep 2002, Marc G. Fournier wrote: %ls -lt ~ftp/pub/source/v7.3beta Is this where you're putting it this time? Last time was ~ftp/pub/beta. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]

Re: [HACKERS] Inheritance

2002-09-05 Thread Jeff Davis
This is not so wrong. If you think about it, you have the same problem in most object-oriented programming languages: a person object can't generally easily become a subclass of itself after being created. This is a case, I would say, where you simply don't want to use inheritance. A

Re: [HACKERS] Map of developers

2002-09-05 Thread Vince Vielhaber
On Thu, 5 Sep 2002, Christopher Kings-Lynne wrote: Anyone else think we should add some more pins to the developer map? At the moment, it looks like we have very few developers! If so then now's the time to do it 'cuze I'm planning on generating a new one as soon as I get this tcl tool

Re: [HACKERS] Map of developers

2002-09-05 Thread Vince Vielhaber
On Thu, 5 Sep 2002, Bruce Momjian wrote: I will work on that this month. It is part of the advocacy project. Since when? --- Christopher Kings-Lynne wrote: Anyone else think we should add some more pins to the

[HACKERS] 7.3 Beta 1 Build Error on Cygwin

2002-09-05 Thread Dave Page
I get the following error when building beta 1 on CYGWIN_NT-5.1 PC9 1.3.10(0.51/3/2) 2002-02-25 11:14 i686 unknown: make[3]: Entering directory `/usr/local/src/postgresql-7.3b1/src/backend/utils/mb/conversion_procs/c yrillic_and_mic' gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Marc G. Fournier
On Thu, 5 Sep 2002, Vince Vielhaber wrote: On Wed, 4 Sep 2002, Marc G. Fournier wrote: %ls -lt ~ftp/pub/source/v7.3beta Is this where you're putting it this time? Last time was ~ftp/pub/beta. actually, should be a symlink, but until I know the packaging and all is well, I'm avoiding put

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Vince Vielhaber
On Thu, 5 Sep 2002, Marc G. Fournier wrote: On Thu, 5 Sep 2002, Vince Vielhaber wrote: On Wed, 4 Sep 2002, Marc G. Fournier wrote: %ls -lt ~ftp/pub/source/v7.3beta Is this where you're putting it this time? Last time was ~ftp/pub/beta. actually, should be a symlink, but until I

Re: [HACKERS] Inheritance

2002-09-05 Thread Hannu Krosing
On Thu, 2002-09-05 at 11:34, Curt Sampson wrote: On 5 Sep 2002, Hannu Krosing wrote: Oh, I see. Not that this is that big a deal, I think. Given that it doesn't work correctly at the moment, making it work fast is a definite second priority, I would think. But choosing an

Re: [HACKERS] Inheritance

2002-09-05 Thread Hannu Krosing
On Thu, 2002-09-05 at 12:29, Jeff Davis wrote: This is not so wrong. If you think about it, you have the same problem in most object-oriented programming languages: a person object can't generally easily become a subclass of itself after being created. This is a case, I would say,

Re: [HACKERS] locking of referenced table during constraint

2002-09-05 Thread Tom Lane
Scott Shattuck [EMAIL PROTECTED] writes: ...why don't they allow the selects to read through adding a constraint? Hmm. We could probably allow that --- at least for some forms of ALTER TABLE, a ShareRowExclusive lock ought to be good enough. (That would allow SELECT and SELECT FOR UPDATE to

Re: [HACKERS] I am done

2002-09-05 Thread Tom Lane
Gavin Sherry [EMAIL PROTECTED] writes: Since the flawed code is now in beta, it will need to be fixed. Do people like the above solution or should I just revert to having a seperate function for each GUC variable affected? I do not see a good reason why fatal and off shouldn't be allowed

Re: [HACKERS] TODO item on triggers

2002-09-05 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Is this item completed? It sure looks like it: * Make triggers refer to columns by number, not name It is not necessary anymore. The triggers still use names, but there's code in ALTER...RENAME to fix the trigger parameters. I'm perfectly happy

Re: [HACKERS] 7.2 - 7.3 activity

2002-09-05 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Good question. As far as lines of *.[chy] code in pgsql/src, you have: Date | Release | Lines of code --+--+ ... 2002-02-04 | 7.2 | 394,274

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Tom Lane
Marc G. Fournier [EMAIL PROTECTED] writes: actually, should be a symlink, but until I know the packaging and all is well, I'm avoiding put it in there ... I pulled down the main tarball -- looks good AFAICT. regards, tom lane ---(end of

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Rod Taylor
On Wed, 2002-09-04 at 22:39, Marc G. Fournier wrote: will announce it on -announce tomorrow, if ppl want to take a quick look at it ... man pages weren't included, but I did regenerate the docs per Peter's suggested commands ... './configure make check' passes on i386 FreeBSD. SunOS

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Tom Lane
Rod Taylor [EMAIL PROTECTED] writes: SunOS control.shared2 5.7 Generic_106541-20 sun4u sparc SUNW,Ultra-5_10 shows an error in ALTER TABLE tests: ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable(ptest1); NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY

Re: [HACKERS] Inheritance

2002-09-05 Thread Tom Lane
I really like Hannu's idea of storing an entire (single-inheritance) hierarchy in a single file. I guess the question we need to ask ourselves is if we're prepared to abandon support of multiple inheritance. Personally I am, but... regards, tom lane

Re: [HACKERS] 7.2 - 7.3 activity

2002-09-05 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Good question. As far as lines of *.[chy] code in pgsql/src, you have: Date | Release | Lines of code --+--+ ... 2002-02-04 | 7.2 | 394,274

Re: [HACKERS] Please rename split(text,text,int) to splitpart

2002-09-05 Thread Joe Conway
Hannu Krosing wrote: It seems that my last mail on this did not get through to the list ;( Please consider renaming the new builtin function split(text,text,int) to something else, perhaps split_part(text,text,int) (like date_part) The reason for this request is that 3

Re: [HACKERS] I am done

2002-09-05 Thread Bruce Momjian
Tom Lane wrote: Gavin Sherry [EMAIL PROTECTED] writes: Since the flawed code is now in beta, it will need to be fixed. Do people like the above solution or should I just revert to having a seperate function for each GUC variable affected? I do not see a good reason why fatal and off

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Rod Taylor
On Thu, 2002-09-05 at 11:19, Tom Lane wrote: Rod Taylor [EMAIL PROTECTED] writes: SunOS control.shared2 5.7 Generic_106541-20 sun4u sparc SUNW,Ultra-5_10 shows an error in ALTER TABLE tests: ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable(ptest1); NOTICE: ALTER

Re: [HACKERS] possible vacuum improvement?

2002-09-05 Thread Richard Tucker
How about counting the number of dead tuples examined and the number of live tuples returned. As the ratio of dead tuples over live tuples visited increases the table becomes a candidate for vacuuming. -regards richt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

[HACKERS] Ok, I broke down...

2002-09-05 Thread Rod Taylor
In the process of upgrading a few systems for the Beta, I ended up writing a tool to upgrade the Foreign key, Unique, and Serial objects to their 7.3 version from the 7.2 version (may work on prior -- but not guarenteed). I imagine it'll fail miserably on mixed case, or names with spaces -- but

Re: [HACKERS] I am done

2002-09-05 Thread Bruce Momjian
Tom Lane wrote: There's some value in being able to kick the log level up a notch for a specific session, but knocking it down from the admin's default could be considered a bad thing. I suppose we could invent a PGC_SIGHUP min_server_min_messages variable that sets a minimum value below

Re: [HACKERS] [CYGWIN] 7.3 Beta 1 Build Error on Cygwin

2002-09-05 Thread Jason Tishler
Dave, On Thu, Sep 05, 2002 at 12:54:50PM +0100, Dave Page wrote: I get the following error when building beta 1 on CYGWIN_NT-5.1 PC9 1.3.10(0.51/3/2) 2002-02-25 11:14 i686 unknown: make[3]: Entering directory

Re: [HACKERS] I am done

2002-09-05 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: I do not see a good reason why fatal and off shouldn't be allowed values for all three message variables. If we just did that, then you'd be back to sharable code. I recommended he only allow valid values for each variable. I think if we say we only

Re: [HACKERS] [CYGWIN] 7.3 Beta 1 Build Error on Cygwin

2002-09-05 Thread Dave Page
-Original Message- From: Jason Tishler [mailto:[EMAIL PROTECTED]] Sent: 05 September 2002 16:30 To: Dave Page Cc: pgsql-hackers; pgsql-cygwin Subject: Re: [CYGWIN] 7.3 Beta 1 Build Error on Cygwin I just submitted a patch to pgsql-patches to fix the above and to add a

Re: [HACKERS] I am done

2002-09-05 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I do not see a good reason why fatal and off shouldn't be allowed values for all three message variables. If we just did that, then you'd be back to sharable code. I recommended he only allow valid values for each variable. I

Re: [HACKERS] I am done

2002-09-05 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: But the client side doesn't make any sense to support FATAL. Am I missing something? Hm. I suppose a client setting above ERROR might break some application programs that expect either ERROR or a command-complete response ... but do we need to go out

Re: [HACKERS] I am done

2002-09-05 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: But the client side doesn't make any sense to support FATAL. Am I missing something? Hm. I suppose a client setting above ERROR might break some application programs that expect either ERROR or a command-complete response ... but

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Manuel Sugawara
Guys, postgresql7.3b1 does not build :-(, seems like a missing multibyte directory ' | make[4]: Entering directory |`/home/masm/download/postgresql-7.3b1/src/backend/utils/time' | gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations

Re: [HACKERS] I am done

2002-09-05 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: of course I don't think a fatal or panic ever makes it to the client side. Of course it does. Try entering a bad password as a trivial example. We punt *after* we send the elog. regards, tom lane ---(end

Re: [HACKERS] Map of developers

2002-09-05 Thread Bruce Momjian
Vince Vielhaber wrote: On Thu, 5 Sep 2002, Bruce Momjian wrote: I will work on that this month. It is part of the advocacy project. Since when? Since I decide to take over the world. :-) What I meant was that it was on my TODO list as part of advocacy stuff I plan for September. --

Re: [HACKERS] Map of developers

2002-09-05 Thread Vince Vielhaber
On Thu, 5 Sep 2002, Bruce Momjian wrote: Vince Vielhaber wrote: On Thu, 5 Sep 2002, Bruce Momjian wrote: I will work on that this month. It is part of the advocacy project. Since when? Since I decide to take over the world. :-) What I meant was that it was on my TODO list as

Re: [HACKERS] contrib/tsearch

2002-09-05 Thread Martin Porter
Oleg, The Porter stemming stems herring and herrings to her, which is a bit unfortunate. A quick fix is to put 'herring/herrings' in the exception list in the english (porter2) stemmer, but I'll look at this case over the next few days and see if I can come up with something a bit better.

Re: [HACKERS] TODO item on triggers

2002-09-05 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Is this item completed? It sure looks like it: * Make triggers refer to columns by number, not name It is not necessary anymore. The triggers still use names, but there's code in ALTER...RENAME to fix the trigger parameters.

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Tom Lane
Manuel Sugawara [EMAIL PROTECTED] writes: or I'm missing something? So it would seem. The utils/mb directory is certainly there in the full tarball that I pulled from ftp.us.postgresql.org this morning. How did you acquire your source tree, exactly? regards, tom lane

Re: [HACKERS] I am done

2002-09-05 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: of course I don't think a fatal or panic ever makes it to the client side. Of course it does. Try entering a bad password as a trivial example. We punt *after* we send the elog. Oh, that's good. I guess it was PANIC I assumed

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Manuel Sugawara
Tom Lane [EMAIL PROTECTED] writes: So it would seem. The utils/mb directory is certainly there in the full tarball that I pulled from ftp.us.postgresql.org this morning. How did you acquire your source tree, exactly? The file is postgresql-base-7.3b1.tar.gz from

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Marc G. Fournier
On 5 Sep 2002, Manuel Sugawara wrote: Tom Lane [EMAIL PROTECTED] writes: So it would seem. The utils/mb directory is certainly there in the full tarball that I pulled from ftp.us.postgresql.org this morning. How did you acquire your source tree, exactly? The file is

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Manuel Sugawara
Marc G. Fournier [EMAIL PROTECTED] writes: You need either the 7.3b1.tar.gz (which is everything), or you need to get all the various -*- parts (which are more manageable) Oh, well. Thanks Regards, Manuel. -- No es que no puedan hallar la soluciĆ³n: es que no ven el problema. G.K. Chesterson

Re: [HACKERS] Map of developers

2002-09-05 Thread Vince Vielhaber
On Thu, 5 Sep 2002, Bruce Momjian wrote: Vince Vielhaber wrote: On Thu, 5 Sep 2002, Bruce Momjian wrote: Vince Vielhaber wrote: On Thu, 5 Sep 2002, Bruce Momjian wrote: I will work on that this month. It is part of the advocacy project. Since when? Since

Re: [HACKERS] Inheritance

2002-09-05 Thread Ross J. Reedstrom
On Thu, Sep 05, 2002 at 10:23:02AM -0400, Tom Lane wrote: I really like Hannu's idea of storing an entire (single-inheritance) hierarchy in a single file. Wouldn't this require solving the ALTER TABLE ADD COLUMN (to parent) column ordering problem? I guess the question we need to ask

[HACKERS] test, please ignore

2002-09-05 Thread Hannu Krosing
I'm suspecting that something blocks mail from my home computer This is sent to test if it is so. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Inheritance

2002-09-05 Thread Hannu Krosing
On Thu, 2002-09-05 at 19:23, Tom Lane wrote: I really like Hannu's idea of storing an entire (single-inheritance) hierarchy in a single file. I guess the question we need to ask ourselves is if we're prepared to abandon support of multiple inheritance. Personally I am, but... So am I, but

[HACKERS] Libpq.dll Souce Code

2002-09-05 Thread Achmad Amin
Dear all, I want to make library for visual basic to connect to PostgreSQL, but I have problem to get libpq.dll source code. Can somebody help me ? (Sorry for bad english :)) Best Regards, Achmad Amin __ Do You Yahoo!? Yahoo! Finance - Get

Re: [HACKERS] Inheritance

2002-09-05 Thread Curt Sampson
On Thu, 5 Sep 2002, Jeff Davis wrote: But a person is-a employee (allow me to momentarily step aside from the rules of english grammer, if you would), and a person is-a programmer. That's why I didn't call my table job :) [1] Certainly it's not the case that a person is-a job, by virtue of

Re: [HACKERS] contrib/tsearch

2002-09-05 Thread Oleg Bartunov
On Thu, 5 Sep 2002, Martin Porter wrote: Oleg, The Porter stemming stems herring and herrings to her, which is a bit unfortunate. A quick fix is to put 'herring/herrings' in the exception list in the english (porter2) stemmer, but I'll look at this case over the next few days and see if I

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Bruce Momjian
Marc G. Fournier wrote: On 5 Sep 2002, Manuel Sugawara wrote: Tom Lane [EMAIL PROTECTED] writes: So it would seem. The utils/mb directory is certainly there in the full tarball that I pulled from ftp.us.postgresql.org this morning. How did you acquire your source tree, exactly?

Re: [HACKERS] 7.2 - 7.3 activity

2002-09-05 Thread Hannu Krosing
On Thu, 2002-09-05 at 20:12, Bruce Momjian wrote: Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Good question. As far as lines of *.[chy] code in pgsql/src, you have: Date | Release | Lines of code --+--+ ...

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Manuel Sugawara
Bruce Momjian [EMAIL PROTECTED] writes: You need either the 7.3b1.tar.gz (which is everything), or you need to get all the various -*- parts (which are more manageable) I am confused. Are you saying the base file isn't compilable? My idea was that it is. Regards, Manuel.

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Marc G. Fournier
On Thu, 5 Sep 2002, Bruce Momjian wrote: Marc G. Fournier wrote: On 5 Sep 2002, Manuel Sugawara wrote: Tom Lane [EMAIL PROTECTED] writes: So it would seem. The utils/mb directory is certainly there in the full tarball that I pulled from ftp.us.postgresql.org this morning.

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Peter Eisentraut
Bruce Momjian writes: I am confused. Are you saying the base file isn't compilable? The mb stuff is missing because it used to be optional in the old splitting scheme. Needs to be rethought. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Peter Eisentraut
Marc G. Fournier writes: Scary, even with removing a load of stuff over to gborg, its still gotten bigger then the last release :) Not hard to find the culprit: 7.2: 3.4Msrc/backend/utils/mb 7.3: 9.6Msrc/backend/utils/mb -- Peter Eisentraut [EMAIL PROTECTED]

Re: [HACKERS] 7.3 Beta 1 Build Error on Cygwin

2002-09-05 Thread Peter Eisentraut
Dave Page writes: I get the following error when building beta 1 on CYGWIN_NT-5.1 PC9 1.3.10(0.51/3/2) 2002-02-25 11:14 i686 unknown: Should all be fixed now. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't

Re: [HACKERS] contrib Makefile

2002-09-05 Thread Peter Eisentraut
Joe Conway writes: I just tried to build all of contrib, and it stops at earthdistance. Whoops... -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Tom Lane
Marc G. Fournier [EMAIL PROTECTED] writes: Hrmm ... that is odd, now that you mention it ... but the file 'distributions' between v7.2 and v7.3beta appear to be the same, so -base- was broken in the old one too? It was never intended that the base tarfile was alone sufficient to do anything,

Re: [HACKERS] 7.3 Beta 1 Build Error on Cygwin

2002-09-05 Thread Jason Tishler
Peter, On Thu, Sep 05, 2002 at 08:33:20PM +0200, Peter Eisentraut wrote: Dave Page writes: I get the following error when building beta 1 on CYGWIN_NT-5.1 PC9 1.3.10(0.51/3/2) 2002-02-25 11:14 i686 unknown: Should all be fixed now. Huh? I don't see any recent CVS commits to indicate

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Bruce Momjian
Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: Hrmm ... that is odd, now that you mention it ... but the file 'distributions' between v7.2 and v7.3beta appear to be the same, so -base- was broken in the old one too? It was never intended that the base tarfile was alone

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Bruce Momjian
Peter Eisentraut wrote: Marc G. Fournier writes: Scary, even with removing a load of stuff over to gborg, its still gotten bigger then the last release :) Not hard to find the culprit: 7.2: 3.4Msrc/backend/utils/mb 7.3: 9.6Msrc/backend/utils/mb Wow. Just checking

[HACKERS] postgres crowd may find this interesting ;)

2002-09-05 Thread Hannu Krosing
Just in time for 7.3 beta 1 : http://dsc.discovery.com/news/briefs/20020902/elephant.html --- Hannu ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] 7.3 Beta 1 Build Error on Cygwin

2002-09-05 Thread Jason Tishler
Peter, On Thu, Sep 05, 2002 at 02:51:31PM -0400, Bruce Momjian wrote: Jason Tishler wrote: On Thu, Sep 05, 2002 at 08:33:20PM +0200, Peter Eisentraut wrote: Should all be fixed now. Huh? I don't see any recent CVS commits to indicate this. I see as a commit: [snip] I assume

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: OK, so if base isn't compilable, then what is it good for? I don't see any add-on packages that would make it usable. AFAIR, the only reason for having the split packaging is to accommodate people who are downloading across flaky connections --- less to

Re: [HACKERS] PL/Perl?

2002-09-05 Thread Larry Rosenman
On Wed, 2002-09-04 at 19:41, Larry Rosenman wrote: On Wed, 2002-09-04 at 17:54, Tom Lane wrote: Larry Rosenman [EMAIL PROTECTED] writes: I upgraded PostgreSQL to 7.2.1 from a 7.2beta (yeah, I know). One of my users requested plperl, so I got it to createlang, but it SIGSEGV's on any

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: OK, so if base isn't compilable, then what is it good for? I don't see any add-on packages that would make it usable. AFAIR, the only reason for having the split packaging is to accommodate people who are downloading across flaky

[HACKERS] Add check constraint bug

2002-09-05 Thread Peter Eisentraut
The following happens in latest CVS and a fresh database: create table test (a int); insert into test values (1); alter table test add column b text check (b ''); alter table test add check (a 0); alter table test add check (a 1); After the last command I get ERROR: CheckConstraintFetch:

Re: [HACKERS] Multibyte support in oracle_compat.c

2002-09-05 Thread Peter Eisentraut
Tatsuo Ishii writes: BTW, nls has same problem as above, no? I guess nls depeneds on locale and it may conflict with the database-specific encoding and/or the automatic FE/BE encoding conversion. GNU gettext does its own encoding conversion. It reads the program's character encoding from

[HACKERS] Removal of PGPASSWORDFILE in beta

2002-09-05 Thread Bruce Momjian
I have removed PGPASSWORDFILE in CVS and therefore in beta2. It was decided that $HOME/.pgpass should always be tested, rather than have an environment variable for it. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 +

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Marc G. Fournier
0On Thu, 5 Sep 2002, Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: OK, so if base isn't compilable, then what is it good for? I don't see any add-on packages that would make it usable. AFAIR, the only reason for having the split packaging is to accommodate people who are

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Bruce Momjian
Marc G. Fournier wrote: 0On Thu, 5 Sep 2002, Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: OK, so if base isn't compilable, then what is it good for? I don't see any add-on packages that would make it usable. AFAIR, the only reason for having the split packaging is to

Re: [HACKERS] Inheritance

2002-09-05 Thread Greg Copeland
On Thu, 2002-09-05 at 08:15, Hannu Krosing wrote: On Thu, 2002-09-05 at 11:34, Curt Sampson wrote: On 5 Sep 2002, Hannu Krosing wrote: If that trigger is acting as an integrety constraint on the base table, you might destroy the table's integrity. What I try to say is that you should

Re: [HACKERS] Add check constraint bug

2002-09-05 Thread Stephan Szabo
On Thu, 5 Sep 2002, Peter Eisentraut wrote: The following happens in latest CVS and a fresh database: create table test (a int); insert into test values (1); alter table test add column b text check (b ''); alter table test add check (a 0); alter table test add check (a 1); After

Re: [HACKERS] Inheritance

2002-09-05 Thread Hannu Krosing
On Fri, 2002-09-06 at 03:19, Greg Copeland wrote: On Thu, 2002-09-05 at 08:15, Hannu Krosing wrote: On Thu, 2002-09-05 at 11:34, Curt Sampson wrote: On 5 Sep 2002, Hannu Krosing wrote: If that trigger is acting as an integrety constraint on the base table, you might destroy the

Re: [HACKERS] beta1 packaged

2002-09-05 Thread Hannu Krosing
On Fri, 2002-09-06 at 03:14, Marc G. Fournier wrote: 0On Thu, 5 Sep 2002, Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: OK, so if base isn't compilable, then what is it good for? I don't see any add-on packages that would make it usable. AFAIR, the only reason for having

Re: [HACKERS] Add check constraint bug

2002-09-05 Thread scott.marlowe
On Thu, 5 Sep 2002, Stephan Szabo wrote: On Thu, 5 Sep 2002, Peter Eisentraut wrote: The following happens in latest CVS and a fresh database: create table test (a int); insert into test values (1); alter table test add column b text check (b ''); alter table test add check (a

Re: [HACKERS] Add check constraint bug

2002-09-05 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: The following happens in latest CVS and a fresh database: create table test (a int); insert into test values (1); alter table test add column b text check (b ''); This bug's been there awhile I fear. The failure occurs when AlterTableAddColumn

Re: [HACKERS] I am done

2002-09-05 Thread Gavin Sherry
On Thu, 5 Sep 2002, Tom Lane wrote: Gavin Sherry [EMAIL PROTECTED] writes: Since the flawed code is now in beta, it will need to be fixed. Do people like the above solution or should I just revert to having a seperate function for each GUC variable affected? I do not see a good reason

Re: [HACKERS] Add check constraint bug

2002-09-05 Thread Bruce Momjian
Is there a TODO here? --- Tom Lane wrote: Peter Eisentraut [EMAIL PROTECTED] writes: The following happens in latest CVS and a fresh database: create table test (a int); insert into test values (1); alter table

Re: [HACKERS] I am done

2002-09-05 Thread Bruce Momjian
Gavin Sherry wrote: On Thu, 5 Sep 2002, Tom Lane wrote: Gavin Sherry [EMAIL PROTECTED] writes: Since the flawed code is now in beta, it will need to be fixed. Do people like the above solution or should I just revert to having a seperate function for each GUC variable affected?

Re: [HACKERS] Multibyte support in oracle_compat.c

2002-09-05 Thread Tatsuo Ishii
GNU gettext does its own encoding conversion. It reads the program's character encoding from the LC_CTYPE locale and converts the material in the translation catalogs on the fly for output. This is great in general, really, but for the postmaster it's a problem. If LC_CTYPE is fixed for

Re: [HACKERS] Add check constraint bug

2002-09-05 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Is there a TODO here? I've committed a fix for the immediate problem. I want to take a very hard look at the other heap_mark4update calls, though. regards, tom lane ---(end of

Re: [HACKERS] 7.2 - 7.3 activity

2002-09-05 Thread Christopher Kings-Lynne
Bruce Momjian [EMAIL PROTECTED] writes: Good question. As far as lines of *.[chy] code in pgsql/src, you have: Date | Release | Lines of code --+--+ ... 2002-02-04 | 7.2 | 394,274 2002-??-?? |

Re: [HACKERS] PL/Perl?

2002-09-05 Thread Larry Rosenman
On Thu, 2002-09-05 at 15:16, Larry Rosenman wrote: On Wed, 2002-09-04 at 19:41, Larry Rosenman wrote: On Wed, 2002-09-04 at 17:54, Tom Lane wrote: Larry Rosenman [EMAIL PROTECTED] writes: I upgraded PostgreSQL to 7.2.1 from a 7.2beta (yeah, I know). One of my users requested

Re: [HACKERS] Ok, I broke down...

2002-09-05 Thread Christopher Kings-Lynne
Whoot! I was just thinking about writing such a tool. Thanks. Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rod Taylor Sent: Friday, 6 September 2002 12:38 AM To: PostgreSQL-development Subject: [HACKERS] Ok, I broke down... In the

[HACKERS] Contrib installcheck problems

2002-09-05 Thread Christopher Kings-Lynne
OK, I note that the regression tests for the following contribs are failing: cube intarray seg Chris ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[HACKERS] 7.3 beta announcement

2002-09-05 Thread Bruce Momjian
I haven't see the beta announcement on the announce list. Do we announce it there? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.

  1   2   >