From owner-freebsd-database Mon Mar 23 17:06:49 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id RAA00349 for freebsd-database-outgoing; Mon, 23 Mar 1998 17:06:49 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from sendero.simon-shapiro.org (sendero-fddi.Simon-Shapiro.ORG [206.190.148.2]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id RAA00331 for ; Mon, 23 Mar 1998 17:06:45 -0800 (PST) (envelope-from shimon@simon-shapiro.org) Received: (qmail 3627 invoked from network); 24 Mar 1998 01:11:55 -0000 Received: from localhost.simon-shapiro.org (HELO sendero-fxp0.simon-shapiro.org) (@127.0.0.1) by localhost.simon-shapiro.org with SMTP; 24 Mar 1998 01:11:55 -0000 Message-ID: X-Mailer: XFMail 1.3-alpha-031798 [p0] on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: <199803232225.OAA15304@rah.star-gate.com> Date: Mon, 23 Mar 1998 17:11:55 -0800 (PST) Reply-To: shimon@simon-shapiro.org Organization: The Simon Shapiro Foundation From: Simon Shapiro To: Amancio Hasty , freebsd-database@FreeBSD.ORG Subject: Pgaccess doesn't run on -current anymore, Update Cc: andreas@klemm.gtn.com, pgsql-ports@postgreSQL.org, current@FreeBSD.ORG, scrappy@hub.org, Bruce Momjian Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk With lots of help from many good people, here is how far I got: a. The port still talks about 6.2.1, so forget that. b. When configuring, make sure you specify ``/usr/locl/include/tcl{whatever _version} /usr/local/include/tk{whatever_version}'' c. In configure (you can/should do it to configure.in and regenerate it via autoconf - I'll let YOU figh this one :-) you should specify the explicit libraries, as in TCL_LIB = tcl8.1 and TK_LIB = tk8.1, instead of the generic TCL_LIB = tcl These above steps are curtesy of the changes to the .mk files that deprive FreeBSD from a normal, default tcl/tk installation in an attempt to acomodate all the versions necessary in many different places. More steps: d. Edit src/bin/pgaccess/pgaccess.tcl to remove the line ``load libpgtcl'' e. Install the above directory someplace sensible (other then the source tree. I put it in ~pgsql/bin/pgaccess.dir f. Write yourself a bit script that does ``pgtksh -f /usr/local/pgsql/bin/pgaccess.ir/pgaccess.tcl'' The script will promptly start very nicely. More Fun: g. Pull down the Database menu, select Open h. Enter your favorite database name and connection data i. Since tcl is interpreted/embedded it is immune to C programming errors. Thus it will promptly generate a segmentation fault and die. j. Post the results to the FreeBSD current list, and to the pgsql list and home the readers still have patience for your klutziness. Have fun! BTW, My offer of a ``free login'' still stands. Oh, did I start from a clean source tree, etc? Yes. I am cross-posting this to freebsd-database, as most -current users do not care about database stuff. Please follow up in freebsd-databases, not free-bsd-current. Simon To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Mar 24 17:44:50 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id RAA06498 for freebsd-database-outgoing; Tue, 24 Mar 1998 17:44:50 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from sendero.simon-shapiro.org (sendero-fddi.Simon-Shapiro.ORG [206.190.148.2]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id RAA06460 for ; Tue, 24 Mar 1998 17:44:20 -0800 (PST) (envelope-from shimon@simon-shapiro.org) Received: (qmail 24654 invoked from network); 25 Mar 1998 01:48:06 -0000 Received: from localhost.simon-shapiro.org (HELO sendero-fxp0.simon-shapiro.org) (@127.0.0.1) by localhost.simon-shapiro.org with SMTP; 25 Mar 1998 01:48:06 -0000 Message-ID: X-Mailer: XFMail 1.3-alpha-032398 [p0] on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: <199803250136.UAA23188@candle.pha.pa.us> Date: Tue, 24 Mar 1998 17:48:05 -0800 (PST) Reply-To: shimon@simon-shapiro.org Organization: The Simon Shapiro Foundation From: Simon Shapiro To: Bruce Momjian Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update Cc: scrappy@hub.org, current@FreeBSD.ORG, pgsql-ports@postgreSQL.org, andreas@klemm.gtn.com, freebsd-database@FreeBSD.ORG, hasty@rah.star-gate.com Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On 25-Mar-98 Bruce Momjian wrote: ... > One other solution is to make a symbolic link from libtcl8.1.so to > libtcl.so, and when you upgrade tcl, you update the symbolic link so > libtcl.so always points to the most recent version. Do the same with > libtk, tcl.h and tk.h. That is what BSDI does. This is what FreeBSD USED TO do. This was removed, to the point that either ports or world cannot be built if it is there. ... > Just to let you know, pgaccess works fine under BSDI. I use versions > tcl7.5 and tk4.1. After an all-night dash, it also works on FreeBSD, except (and I will nag until someone answers :-) that pgaccess, in the query window, only appears to process SELECTs correctly. All others fail with ``syntax error''. ---------- Sincerely Yours, Simon Shapiro Shimon@Simon-Shapiro.ORG Voice: 503.799.2313 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Mar 24 17:57:07 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id RAA10087 for freebsd-database-outgoing; Tue, 24 Mar 1998 17:57:07 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id RAA10069; Tue, 24 Mar 1998 17:56:57 -0800 (PST) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.8.5/8.8.5) id UAA23188; Tue, 24 Mar 1998 20:36:07 -0500 (EST) From: Bruce Momjian Message-Id: <199803250136.UAA23188@candle.pha.pa.us> Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update To: shimon@simon-shapiro.org Date: Tue, 24 Mar 1998 20:36:07 -0500 (EST) Cc: hasty@rah.star-gate.com, freebsd-database@FreeBSD.ORG, andreas@klemm.gtn.com, pgsql-ports@postgreSQL.org, current@FreeBSD.ORG, scrappy@hub.org In-Reply-To: from "Simon Shapiro" at Mar 23, 98 05:11:55 pm X-Mailer: ELM [version 2.4 PL25] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk > > With lots of help from many good people, here is how far I got: > > a. The port still talks about 6.2.1, so forget that. > > b. When configuring, make sure you specify ``/usr/locl/include/tcl{whatever > _version} /usr/local/include/tk{whatever_version}'' > > c. In configure (you can/should do it to configure.in and regenerate it > via autoconf - I'll let YOU figh this one :-) you should specify the > explicit libraries, as in TCL_LIB = tcl8.1 and TK_LIB = tk8.1, instead > of the generic TCL_LIB = tcl One other solution is to make a symbolic link from libtcl8.1.so to libtcl.so, and when you upgrade tcl, you update the symbolic link so libtcl.so always points to the most recent version. Do the same with libtk, tcl.h and tk.h. That is what BSDI does. > > These above steps are curtesy of the changes to the .mk files that deprive > FreeBSD from a normal, default tcl/tk installation in an attempt to > acomodate all the versions necessary in many different places. > > More steps: > > d. Edit src/bin/pgaccess/pgaccess.tcl to remove the line ``load libpgtcl'' > > e. Install the above directory someplace sensible (other then the source > tree. I put it in ~pgsql/bin/pgaccess.dir > > f. Write yourself a bit script that does ``pgtksh -f > /usr/local/pgsql/bin/pgaccess.ir/pgaccess.tcl'' > > The script will promptly start very nicely. > > More Fun: > > g. Pull down the Database menu, select Open > > h. Enter your favorite database name and connection data > > i. Since tcl is interpreted/embedded it is immune to C programming errors. > Thus it will promptly generate a segmentation fault and die. Just to let you know, pgaccess works fine under BSDI. I use versions tcl7.5 and tk4.1. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h) To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Mar 24 17:59:55 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id RAA10862 for freebsd-database-outgoing; Tue, 24 Mar 1998 17:59:55 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from vader.cs.berkeley.edu (vader.CS.Berkeley.EDU [128.32.38.234]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id RAA10857; Tue, 24 Mar 1998 17:59:54 -0800 (PST) (envelope-from asami@vader.cs.berkeley.edu) Received: from bubble.didi.com (tfx-us6-21.ix.netcom.com [204.30.67.213]) by vader.cs.berkeley.edu (8.8.7/8.7.3) with ESMTP id RAA08659; Tue, 24 Mar 1998 17:59:27 -0800 (PST) Received: (from asami@localhost) by bubble.didi.com (8.8.7/8.8.8) id UAA02139; Tue, 24 Mar 1998 20:59:17 -0500 (EST) (envelope-from asami) Date: Tue, 24 Mar 1998 20:59:17 -0500 (EST) Message-Id: <199803250159.UAA02139@bubble.didi.com> To: shimon@simon-shapiro.org CC: maillist@candle.pha.pa.us, scrappy@hub.org, current@FreeBSD.ORG, pgsql-ports@postgreSQL.org, andreas@klemm.gtn.com, freebsd-database@FreeBSD.ORG, hasty@rah.star-gate.com In-reply-to: (message from Simon Shapiro on Tue, 24 Mar 1998 17:48:05 -0800 (PST)) Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update From: asami@FreeBSD.ORG (Satoshi Asami) Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk * > One other solution is to make a symbolic link from libtcl8.1.so to * This is what FreeBSD USED TO do. This was removed, to the point that Can you guys stop talking about tcl now? We've gone through this before many, many times, and the only reason why we are doing things the way it is now is because we found out (the hard way, i.e., we tried pretty much everything) that no other method works for something as large and diverse as the ports collection. Satoshi To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Mar 24 18:10:14 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id SAA12488 for freebsd-database-outgoing; Tue, 24 Mar 1998 18:10:14 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from sendero.simon-shapiro.org (sendero-fddi.Simon-Shapiro.ORG [206.190.148.2]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id SAA12416 for ; Tue, 24 Mar 1998 18:10:00 -0800 (PST) (envelope-from shimon@simon-shapiro.org) Received: (qmail 14255 invoked from network); 25 Mar 1998 02:14:03 -0000 Received: from localhost.simon-shapiro.org (HELO sendero-fxp0.simon-shapiro.org) (@127.0.0.1) by localhost.simon-shapiro.org with SMTP; 25 Mar 1998 02:14:03 -0000 Message-ID: X-Mailer: XFMail 1.3-alpha-032398 [p0] on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: <199803250159.UAA02139@bubble.didi.com> Date: Tue, 24 Mar 1998 18:14:02 -0800 (PST) Reply-To: shimon@simon-shapiro.org Organization: The Simon Shapiro Foundation From: Simon Shapiro To: (Satoshi Asami) Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update Cc: hasty@rah.star-gate.com, freebsd-database@FreeBSD.ORG, andreas@klemm.gtn.com, pgsql-ports@postgreSQL.org, current@FreeBSD.ORG, scrappy@hub.org, maillist@candle.pha.pa.us Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On 25-Mar-98 Satoshi Asami wrote: > * > One other solution is to make a symbolic link from libtcl8.1.so to > > * This is what FreeBSD USED TO do. This was removed, to the point that > > Can you guys stop talking about tcl now? Why? > We've gone through this before many, many times, and the only reason > why we are doing things the way it is now is because we found out (the > hard way, i.e., we tried pretty much everything) that no other method > works for something as large and diverse as the ports collection. Nobody claimed nor hinted that the tcl move on your part was anything but correct. Nevertheless, it broke things that used to work, and that work on a number of other Unix platforms. Some of the people who helped identify and solve this problem are less familiar with FreeBSD and its history on this matter. Others (like myself) break in sweat and get itchy all over every time something in tcl/tk stops working. I belive the issue is clear, and the course of action identified. Rather than shutting us up, maybe you suggest how we avoid the breakage on the next package? I certainly do not know how (in the context of not having {tcl,tk}.h and lib{tcl,tk} where it is normally found). ---------- Sincerely Yours, Simon Shapiro Shimon@Simon-Shapiro.ORG Voice: 503.799.2313 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Mar 24 18:47:39 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id SAA16774 for freebsd-database-outgoing; Tue, 24 Mar 1998 18:47:39 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from vader.cs.berkeley.edu (vader.CS.Berkeley.EDU [128.32.38.234]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id SAA16737; Tue, 24 Mar 1998 18:47:30 -0800 (PST) (envelope-from asami@vader.cs.berkeley.edu) Received: from bubble.didi.com (tfx-us5-13.ix.netcom.com [204.30.67.173]) by vader.cs.berkeley.edu (8.8.7/8.7.3) with ESMTP id SAA08720; Tue, 24 Mar 1998 18:47:27 -0800 (PST) Received: (from asami@localhost) by bubble.didi.com (8.8.7/8.8.8) id VAA02286; Tue, 24 Mar 1998 21:17:06 -0500 (EST) (envelope-from asami) Date: Tue, 24 Mar 1998 21:17:06 -0500 (EST) Message-Id: <199803250217.VAA02286@bubble.didi.com> To: shimon@simon-shapiro.org CC: hasty@rah.star-gate.com, freebsd-database@FreeBSD.ORG, andreas@klemm.gtn.com, pgsql-ports@postgreSQL.org, current@FreeBSD.ORG, scrappy@hub.org, maillist@candle.pha.pa.us In-reply-to: (message from Simon Shapiro on Tue, 24 Mar 1998 18:14:02 -0800 (PST)) Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update From: asami@FreeBSD.ORG (Satoshi Asami) Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk * Why? Because it's a waste of time. If you want to know what happened before, anyone can go check the mail archives. * I belive the issue is clear, and the course of action identified. Rather * than shutting us up, maybe you suggest how we avoid the breakage on the * next package? I certainly do not know how (in the context of not having As already suggested, specify the full pathname. Satoshi To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Mar 24 19:57:49 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id TAA26447 for freebsd-database-outgoing; Tue, 24 Mar 1998 19:57:49 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id TAA26442; Tue, 24 Mar 1998 19:57:44 -0800 (PST) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.8.5/8.8.5) id WAA25338; Tue, 24 Mar 1998 22:42:56 -0500 (EST) From: Bruce Momjian Message-Id: <199803250342.WAA25338@candle.pha.pa.us> Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update To: shimon@simon-shapiro.org Date: Tue, 24 Mar 1998 22:40:25 -0500 (EST) Cc: scrappy@hub.org, current@FreeBSD.ORG, pgsql-ports@postgreSQL.org, andreas@klemm.gtn.com, freebsd-database@FreeBSD.ORG, hasty@rah.star-gate.com, teo@flex.ro In-Reply-To: from "Simon Shapiro" at Mar 24, 98 05:48:05 pm X-Mailer: ELM [version 2.4 PL25] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk > > Just to let you know, pgaccess works fine under BSDI. I use versions > > tcl7.5 and tk4.1. > > After an all-night dash, it also works on FreeBSD, except (and I will nag > until someone answers :-) that pgaccess, in the query window, only appears > to process SELECTs correctly. All others fail with ``syntax error''. [Man, that CC line is long. I have added the pgaccess maintainer to it.] BSDI has the same problem with non-select queries. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h) To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Mar 24 19:59:33 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id TAA26843 for freebsd-database-outgoing; Tue, 24 Mar 1998 19:59:33 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from rah.star-gate.com (rah.star-gate.com [209.133.7.234]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id TAA26838; Tue, 24 Mar 1998 19:59:32 -0800 (PST) (envelope-from hasty@rah.star-gate.com) Received: from rah.star-gate.com (localhost.star-gate.com [127.0.0.1]) by rah.star-gate.com (8.8.8/8.8.8) with ESMTP id TAA27161; Tue, 24 Mar 1998 19:58:02 -0800 (PST) (envelope-from hasty@rah.star-gate.com) Message-Id: <199803250358.TAA27161@rah.star-gate.com> X-Mailer: exmh version 2.0.2 2/24/98 To: Bruce Momjian cc: shimon@simon-shapiro.org, scrappy@hub.org, current@FreeBSD.ORG, pgsql-ports@postgreSQL.org, andreas@klemm.gtn.com, freebsd-database@FreeBSD.ORG, teo@flex.ro Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update In-reply-to: Your message of "Tue, 24 Mar 1998 22:40:25 EST." <199803250342.WAA25338@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Tue, 24 Mar 1998 19:58:02 -0800 From: Amancio Hasty Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Hi Guys, You have to be a little bit more specific as to what is failing. Had not problems creating a table and adding fields with the pgaccess script found in postgress 6.3.1. Regards, Amancio > > > Just to let you know, pgaccess works fine under BSDI. I use versions > > > tcl7.5 and tk4.1. > > > > After an all-night dash, it also works on FreeBSD, except (and I will nag > > until someone answers :-) that pgaccess, in the query window, only appears > > to process SELECTs correctly. All others fail with ``syntax error''. > > [Man, that CC line is long. I have added the pgaccess maintainer to > it.] > > BSDI has the same problem with non-select queries. > > > > -- > Bruce Momjian | 830 Blythe Avenue > maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 > + If your life is a hard drive, | (610) 353-9879(w) > + Christ can be your backup. | (610) 853-3000(h) To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Mar 24 20:18:04 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id UAA00188 for freebsd-database-outgoing; Tue, 24 Mar 1998 20:18:04 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from fallout.campusview.indiana.edu (fallout.campusview.indiana.edu [149.159.1.1]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id UAA00159; Tue, 24 Mar 1998 20:17:57 -0800 (PST) (envelope-from jfieber@indiana.edu) Received: from localhost (jfieber@localhost) by fallout.campusview.indiana.edu (8.8.7/8.8.7) with SMTP id XAA04393; Tue, 24 Mar 1998 23:17:58 -0500 (EST) Date: Tue, 24 Mar 1998 23:17:58 -0500 (EST) From: John Fieber To: Satoshi Asami cc: database@FreeBSD.ORG, ports@FreeBSD.ORG Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update In-Reply-To: <199803250217.VAA02286@bubble.didi.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Tue, 24 Mar 1998, Satoshi Asami wrote: > * Why? > > Because it's a waste of time. If you want to know what happened > before, anyone can go check the mail archives. I've watched all the tcl battles rage on from a distance, not paying too much attention in general. If things have indeed settled down, it would be good to put a couple paragraphs in the porting manual to explain the tcl mess, maybe with a little note about why the current scheme is less evil than other possible strategies. -john To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Mar 24 20:42:47 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id UAA03463 for freebsd-database-outgoing; Tue, 24 Mar 1998 20:42:47 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from sendero.simon-shapiro.org (sendero-fddi.Simon-Shapiro.ORG [206.190.148.2]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id UAA03443 for ; Tue, 24 Mar 1998 20:42:22 -0800 (PST) (envelope-from shimon@simon-shapiro.org) Received: (qmail 6548 invoked from network); 25 Mar 1998 04:46:01 -0000 Received: from localhost.simon-shapiro.org (HELO sendero-fxp0.simon-shapiro.org) (@127.0.0.1) by localhost.simon-shapiro.org with SMTP; 25 Mar 1998 04:46:01 -0000 Message-ID: X-Mailer: XFMail 1.3-alpha-032398 [p0] on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: <199803250217.VAA02286@bubble.didi.com> Date: Tue, 24 Mar 1998 20:46:01 -0800 (PST) Reply-To: shimon@simon-shapiro.org Organization: The Simon Shapiro Foundation From: Simon Shapiro To: (Satoshi Asami) Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update Cc: maillist@candle.pha.pa.us, scrappy@hub.org, current@FreeBSD.ORG, pgsql-ports@postgreSQL.org, andreas@klemm.gtn.com, freebsd-database@FreeBSD.ORG, hasty@rah.star-gate.com Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On 25-Mar-98 Satoshi Asami wrote: > * Why? > > Because it's a waste of time. If you want to know what happened > before, anyone can go check the mail archives. I think you are still missing the point, by a wide margin: a. It is not a waste of time, because people have to learn, adjust, comprehend and accept. b. The original discussion was on the merits/demerits of the change in the context of FreeBSD build. This discussion was about the impact on unforseen new evidence. The people involved have the right to fit the two realities into a coherent picture. c. The name and location of various pieces of tcl/tk in FreeBSD is a minor discovery in resolving this issue. d. No one has disputed the wisdom of the original reason for the change. No one challenged it either. People simply wanted to know what happened. e. If there is any problem here, it evolves around either making the change in such a manner that established packages, writen and maintained by several people, all broke due to lack of documented migration path. If failure at all (notice the IF), it is of no one of the people involved in this issue, but of someone who is very noisy all of a sudden to squash the discussion. > * I belive the issue is clear, and the course of action identified. > Rather > * than shutting us up, maybe you suggest how we avoid the breakage on > the > * next package? I certainly do not know how (in the context of not > having > > As already suggested, specify the full pathname. That was already done, without any grumbling, nor objection. Relax :-) ---------- Sincerely Yours, Simon Shapiro Shimon@Simon-Shapiro.ORG Voice: 503.799.2313 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Mar 24 20:47:59 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id UAA04351 for freebsd-database-outgoing; Tue, 24 Mar 1998 20:47:59 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from sendero.simon-shapiro.org (sendero-fddi.Simon-Shapiro.ORG [206.190.148.2]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id UAA04342 for ; Tue, 24 Mar 1998 20:47:48 -0800 (PST) (envelope-from shimon@simon-shapiro.org) Received: (qmail 6711 invoked from network); 25 Mar 1998 04:51:42 -0000 Received: from localhost.simon-shapiro.org (HELO sendero-fxp0.simon-shapiro.org) (@127.0.0.1) by localhost.simon-shapiro.org with SMTP; 25 Mar 1998 04:51:42 -0000 Message-ID: X-Mailer: XFMail 1.3-alpha-032398 [p0] on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: <199803250342.WAA25338@candle.pha.pa.us> Date: Tue, 24 Mar 1998 20:51:41 -0800 (PST) Reply-To: shimon@simon-shapiro.org Organization: The Simon Shapiro Foundation From: Simon Shapiro To: Bruce Momjian Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update Cc: teo@flex.ro, hasty@rah.star-gate.com, freebsd-database@FreeBSD.ORG, andreas@klemm.gtn.com, pgsql-ports@postgreSQL.org, scrappy@hub.org Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk [ Please, please, remove freebsd-current from this discussion, some of these maestroes get all irked up when their private, favorite list is abused by something they are not interested in, like database issues ] .. > BSDI has the same problem with non-select queries. I did not think this is a FreeBSD specific thing. Did not look like it. ---------- Sincerely Yours, Simon Shapiro Shimon@Simon-Shapiro.ORG Voice: 503.799.2313 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Mar 24 20:51:33 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id UAA04700 for freebsd-database-outgoing; Tue, 24 Mar 1998 20:51:33 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from rah.star-gate.com (rah.star-gate.com [209.133.7.234]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id UAA04694; Tue, 24 Mar 1998 20:51:31 -0800 (PST) (envelope-from hasty@rah.star-gate.com) Received: from rah.star-gate.com (localhost.star-gate.com [127.0.0.1]) by rah.star-gate.com (8.8.8/8.8.8) with ESMTP id UAA27558; Tue, 24 Mar 1998 20:50:45 -0800 (PST) (envelope-from hasty@rah.star-gate.com) Message-Id: <199803250450.UAA27558@rah.star-gate.com> X-Mailer: exmh version 2.0.2 2/24/98 To: shimon@simon-shapiro.org cc: asami@FreeBSD.ORG (Satoshi Asami), maillist@candle.pha.pa.us, scrappy@hub.org, current@FreeBSD.ORG, pgsql-ports@postgreSQL.org, andreas@klemm.gtn.com, freebsd-database@FreeBSD.ORG Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update In-reply-to: Your message of "Tue, 24 Mar 1998 20:46:01 PST." Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Tue, 24 Mar 1998 20:50:45 -0800 From: Amancio Hasty Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On 25-Mar-98 Satoshi Asami wrote: > * Why? > Because it's a waste of time. If you want to know what happened > before, anyone can go check the mail archives. We need a decent search engine for the mail archives and possibly also provide a threaded list of the archived messages. If I am not mistaken, the mail archives are stored in ftp.freebsd.org so there is a wonderful opportunity for someone to provide a useful service to the FreeBSD community. If no one takes action as Satoshi said: "anyone can go check the mail archives". Have Fun, Amancio To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Mar 24 21:05:43 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id VAA06108 for freebsd-database-outgoing; Tue, 24 Mar 1998 21:05:43 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from sendero.simon-shapiro.org (sendero-fddi.Simon-Shapiro.ORG [206.190.148.2]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id VAA06082 for ; Tue, 24 Mar 1998 21:05:20 -0800 (PST) (envelope-from shimon@simon-shapiro.org) Received: (qmail 5892 invoked from network); 25 Mar 1998 05:08:57 -0000 Received: from localhost.simon-shapiro.org (HELO sendero-fxp0.simon-shapiro.org) (@127.0.0.1) by localhost.simon-shapiro.org with SMTP; 25 Mar 1998 05:08:57 -0000 Message-ID: X-Mailer: XFMail 1.3-alpha-032398 [p0] on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: <199803250358.TAA27161@rah.star-gate.com> Date: Tue, 24 Mar 1998 21:08:56 -0800 (PST) Reply-To: shimon@simon-shapiro.org Organization: The Simon Shapiro Foundation From: Simon Shapiro To: Amancio Hasty Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update Cc: teo@flex.ro, freebsd-database@FreeBSD.ORG, andreas@klemm.gtn.com, pgsql-ports@postgreSQL.org, current@FreeBSD.ORG, scrappy@hub.org, Bruce Momjian Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On 25-Mar-98 Amancio Hasty wrote: > Hi Guys, > > You have to be a little bit more specific as to what is failing. > > Had not problems creating a table and adding fields with the > pgaccess script found in postgress 6.3.1. Oh, sorry. Go to the Query tab in the main menu, select it, press New, then enter a non-SELECT query. Execute it. It will fail with a syntax error near the first word (create/insert/update/delete/etc. I think the API used to send queries to the database uses different execution paths for SELECT and all others (SELECT is the only one returning instances, etc.). The problem may be that pgaccess call the SELECT type routine for all queries. The ``syntax error'' message is probably misleading. Let's wait to hear from the author. Simon To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Mar 24 21:16:59 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id VAA08283 for freebsd-database-outgoing; Tue, 24 Mar 1998 21:16:59 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from rah.star-gate.com (rah.star-gate.com [209.133.7.234]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id VAA08278 for ; Tue, 24 Mar 1998 21:16:57 -0800 (PST) (envelope-from hasty@rah.star-gate.com) Received: from rah.star-gate.com (localhost.star-gate.com [127.0.0.1]) by rah.star-gate.com (8.8.8/8.8.8) with ESMTP id VAA27684; Tue, 24 Mar 1998 21:16:07 -0800 (PST) (envelope-from hasty@rah.star-gate.com) Message-Id: <199803250516.VAA27684@rah.star-gate.com> X-Mailer: exmh version 2.0.2 2/24/98 To: shimon@simon-shapiro.org cc: teo@flex.ro, freebsd-database@FreeBSD.ORG, andreas@klemm.gtn.com, pgsql-ports@postgreSQL.org, scrappy@hub.org, Bruce Momjian Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update In-reply-to: Your message of "Tue, 24 Mar 1998 21:08:56 PST." Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Tue, 24 Mar 1998 21:16:07 -0800 From: Amancio Hasty Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk We can wait, if you like, wish8.0 -f pgaccess.tcl Selected Object->New Then I entered: Table: Simon Field: User Field type : text Default : FreeBSD Click on : "Add Field" Voila, I have a table entry!! Again, this is with the pgaccess that came with postgres 6.3.1 and I am using tcl8.0 and tk8.0 Cheers, Amancio > > On 25-Mar-98 Amancio Hasty wrote: > > Hi Guys, > > > > You have to be a little bit more specific as to what is failing. > > > > Had not problems creating a table and adding fields with the > > pgaccess script found in postgress 6.3.1. > > Oh, sorry. Go to the Query tab in the main menu, select it, press New, > then enter a non-SELECT query. Execute it. It will fail with a syntax > error near the first word (create/insert/update/delete/etc. > > I think the API used to send queries to the database uses different > execution paths for SELECT and all others (SELECT is the only one returning > instances, etc.). The problem may be that pgaccess call the SELECT type > routine for all queries. The ``syntax error'' message is > probably misleading. > > Let's wait to hear from the author. > > Simon > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Mar 24 21:33:39 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id VAA10190 for freebsd-database-outgoing; Tue, 24 Mar 1998 21:33:39 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from sendero.simon-shapiro.org (sendero-fddi.Simon-Shapiro.ORG [206.190.148.2]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id VAA10159 for ; Tue, 24 Mar 1998 21:33:17 -0800 (PST) (envelope-from shimon@simon-shapiro.org) Received: (qmail 29514 invoked from network); 25 Mar 1998 05:37:02 -0000 Received: from localhost.simon-shapiro.org (HELO sendero-fxp0.simon-shapiro.org) (@127.0.0.1) by localhost.simon-shapiro.org with SMTP; 25 Mar 1998 05:37:02 -0000 Message-ID: X-Mailer: XFMail 1.3-alpha-032398 [p0] on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: <199803250516.VAA27684@rah.star-gate.com> Date: Tue, 24 Mar 1998 21:37:02 -0800 (PST) Reply-To: shimon@simon-shapiro.org Organization: The Simon Shapiro Foundation From: Simon Shapiro To: Amancio Hasty Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update Cc: teo@flex.ro, freebsd-database@FreeBSD.ORG, andreas@klemm.gtn.com, pgsql-ports@postgreSQL.org, scrappy@hub.org, Bruce Momjian Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On 25-Mar-98 Amancio Hasty wrote: > We can wait, if you like, > > wish8.0 -f pgaccess.tcl > > Selected Object->New > > Then I entered: > Table: Simon > Field: User > Field type : text > Default : FreeBSD > > Click on : "Add Field" > > Voila, I have a table entry!! > > Again, this is with the pgaccess that came with postgres 6.3.1 and I am > using > tcl8.0 and tk8.0 Oh, this works. We database nerds overloaded the word query. In English it means to ask, search for an answer, etc. In SQL it means ``any request made to the database''. What the English speaking person means by query, we call SELECT. You need to select (not SELECT :-) the Queries tab, press the New button above, click in the large window (to get focus), type ``insert into junk values(1);'' and click the Execute query button. You will get a Table Browser window, and an Error (popup) window. The Error popup will say: Error executing SQL command insert into junk values(1); Error message:ERROR: parser: parse errorat or near "insert" As I said before, it could be intentional for that window to fail on all non-SELECT queries, but I am not the only one who makes the mistake of assuming it to be a bug. Simon To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Mar 24 21:50:10 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id VAA12262 for freebsd-database-outgoing; Tue, 24 Mar 1998 21:50:10 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from rah.star-gate.com (rah.star-gate.com [209.133.7.234]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id VAA12240 for ; Tue, 24 Mar 1998 21:50:06 -0800 (PST) (envelope-from hasty@rah.star-gate.com) Received: from rah.star-gate.com (localhost.star-gate.com [127.0.0.1]) by rah.star-gate.com (8.8.8/8.8.8) with ESMTP id VAA27868; Tue, 24 Mar 1998 21:48:56 -0800 (PST) (envelope-from hasty@rah.star-gate.com) Message-Id: <199803250548.VAA27868@rah.star-gate.com> X-Mailer: exmh version 2.0.2 2/24/98 To: shimon@simon-shapiro.org cc: teo@flex.ro, freebsd-database@FreeBSD.ORG, andreas@klemm.gtn.com, pgsql-ports@postgreSQL.org, scrappy@hub.org, Bruce Momjian Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update In-reply-to: Your message of "Tue, 24 Mar 1998 21:37:02 PST." Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Tue, 24 Mar 1998 21:48:55 -0800 From: Amancio Hasty Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Cool, now it is clear what you are having problems with and I don't know how the window or in this case the functionality for the tab "Query" is supposed so work so you are right it is best left to the author to answer the question. "Me thinks " that you are having too much fun! Amancio > > On 25-Mar-98 Amancio Hasty wrote: > > > We can wait, if you like, > > > > wish8.0 -f pgaccess.tcl > > > > Selected Object->New > > > > Then I entered: > > Table: Simon > > Field: User > > Field type : text > > Default : FreeBSD > > > > Click on : "Add Field" > > > > Voila, I have a table entry!! > > > > Again, this is with the pgaccess that came with postgres 6.3.1 and I am > > using > > tcl8.0 and tk8.0 > > Oh, this works. We database nerds overloaded the word query. In English > it means to ask, search for an answer, etc. In SQL it means ``any request > made to the database''. What the English speaking person means by query, > we call SELECT. You need to select (not SELECT :-) the Queries tab, press > the New button above, click in the large window (to get focus), type > ``insert into junk values(1);'' and click the Execute query button. > You will get a Table Browser window, and an Error (popup) window. > The Error popup will say: Error executing SQL command insert into junk > values(1); Error message:ERROR: parser: parse errorat or near "insert" > > As I said before, it could be intentional for that window to fail on all > non-SELECT queries, but I am not the only one who makes the mistake of > assuming it to be a bug. > > Simon > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Tue Mar 24 23:37:37 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id XAA26077 for freebsd-database-outgoing; Tue, 24 Mar 1998 23:37:37 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from flex.flex.ro (flex.flex.ro [193.230.255.2]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id XAA26065 for ; Tue, 24 Mar 1998 23:37:29 -0800 (PST) (envelope-from teo@flex.ro) Received: from flex.flex.ro (localhost [127.0.0.1]) by flex.flex.ro (8.8.8/8.7.3) with SMTP id JAA29224; Wed, 25 Mar 1998 09:42:18 +0200 Message-ID: <3518B55A.298A1DEF@flex.ro> Date: Wed, 25 Mar 1998 09:42:18 +0200 From: Constantin Teodorescu Organization: FLEX Consulting Braila X-Mailer: Mozilla 3.04Gold (X11; I; Linux 2.0.32 i586) MIME-Version: 1.0 To: Amancio Hasty CC: shimon@simon-shapiro.org, freebsd-database@FreeBSD.ORG, andreas@klemm.gtn.com, pgsql-ports@postgreSQL.org, scrappy@hub.org, Bruce Momjian Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update References: <199803250548.VAA27868@rah.star-gate.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk > > Oh, this works. We database nerds overloaded the word query. In English > > it means to ask, search for an answer, etc. In SQL it means ``any request > > made to the database''. What the English speaking person means by query, > > we call SELECT. You need to select (not SELECT :-) the Queries tab, press > > the New button above, click in the large window (to get focus), type > > ``insert into junk values(1);'' and click the Execute query button. > > You will get a Table Browser window, and an Error (popup) window. > > The Error popup will say: Error executing SQL command insert into junk > > values(1); Error message:ERROR: parser: parse errorat or near "insert" When "Query design" window is on the screen, "exec" queries cannot be executed. Save the query and then "Open" it. It will exec the query. In next version I will probably fix this behaviour. Any other bugs ? -- Constantin Teodorescu FLEX Consulting Braila, ROMANIA To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Mar 25 01:10:25 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id BAA04780 for freebsd-database-outgoing; Wed, 25 Mar 1998 01:10:25 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from sendero.simon-shapiro.org (sendero-fddi.Simon-Shapiro.ORG [206.190.148.2]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id BAA04747 for ; Wed, 25 Mar 1998 01:10:01 -0800 (PST) (envelope-from shimon@simon-shapiro.org) Received: (qmail 13461 invoked from network); 25 Mar 1998 09:13:25 -0000 Received: from localhost.simon-shapiro.org (HELO sendero-fxp0.simon-shapiro.org) (@127.0.0.1) by localhost.simon-shapiro.org with SMTP; 25 Mar 1998 09:13:25 -0000 Message-ID: X-Mailer: XFMail 1.3-alpha-032398 [p0] on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: <3518B55A.298A1DEF@flex.ro> Date: Wed, 25 Mar 1998 01:13:25 -0800 (PST) Reply-To: shimon@simon-shapiro.org Organization: The Simon Shapiro Foundation From: Simon Shapiro To: Constantin Teodorescu Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update Cc: Bruce Momjian , scrappy@hub.org, pgsql-ports@postgreSQL.org, andreas@klemm.gtn.com, freebsd-database@FreeBSD.ORG, Amancio Hasty Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On 25-Mar-98 Constantin Teodorescu wrote: >> > Oh, this works. We database nerds overloaded the word query. In >> > English >> > it means to ask, search for an answer, etc. In SQL it means ``any >> > request >> > made to the database''. What the English speaking person means by >> > query, >> > we call SELECT. You need to select (not SELECT :-) the Queries tab, >> > press >> > the New button above, click in the large window (to get focus), type >> > ``insert into junk values(1);'' and click the Execute query button. >> > You will get a Table Browser window, and an Error (popup) window. >> > The Error popup will say: Error executing SQL command insert into >> > junk >> > values(1); Error message:ERROR: parser: parse errorat or near "insert" > > When "Query design" window is on the screen, "exec" queries cannot be > executed. > Save the query and then "Open" it. It will exec the query. > > In next version I will probably fix this behaviour. > > Any other bugs ? No, Works like a charm. As long as one does not press the Save as View button. Sort of makes sense. Thanx! Where do you announce new versions? ---------- Sincerely Yours, Simon Shapiro Shimon@Simon-Shapiro.ORG Voice: 503.799.2313 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Mar 25 06:50:20 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id GAA18627 for freebsd-database-outgoing; Wed, 25 Mar 1998 06:50:20 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id GAA18612 for ; Wed, 25 Mar 1998 06:50:07 -0800 (PST) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.8.5/8.8.5) id JAA05333; Wed, 25 Mar 1998 09:45:45 -0500 (EST) From: Bruce Momjian Message-Id: <199803251445.JAA05333@candle.pha.pa.us> Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update To: teo@flex.ro (Constantin Teodorescu) Date: Wed, 25 Mar 1998 09:45:45 -0500 (EST) Cc: hasty@rah.star-gate.com, shimon@simon-shapiro.org, freebsd-database@FreeBSD.ORG, andreas@klemm.gtn.com, pgsql-ports@postgreSQL.org, scrappy@hub.org In-Reply-To: <3518B55A.298A1DEF@flex.ro> from "Constantin Teodorescu" at Mar 25, 98 09:42:18 am X-Mailer: ELM [version 2.4 PL25] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk > When "Query design" window is on the screen, "exec" queries cannot be > executed. > Save the query and then "Open" it. It will exec the query. > > In next version I will probably fix this behaviour. > > Any other bugs ? I feel like I am CC'ing the world on this one, but I just wanted to say that the whole reason for this tcl/tk clammor is because everyone likes pgaccess, and thinks it is a great program. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h) To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Mar 25 07:04:00 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id HAA21072 for freebsd-database-outgoing; Wed, 25 Mar 1998 07:04:00 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from flex.flex.ro (flex.flex.ro [193.230.255.2]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id HAA21063 for ; Wed, 25 Mar 1998 07:03:49 -0800 (PST) (envelope-from teo@flex.ro) Received: from flex.flex.ro (localhost [127.0.0.1]) by flex.flex.ro (8.8.8/8.7.3) with SMTP id RAA06382; Wed, 25 Mar 1998 17:09:49 +0200 Message-ID: <35191E3D.66E50A78@flex.ro> Date: Wed, 25 Mar 1998 17:09:49 +0200 From: Constantin Teodorescu Organization: FLEX Consulting Braila X-Mailer: Mozilla 3.04Gold (X11; I; Linux 2.0.32 i586) MIME-Version: 1.0 To: Bruce Momjian CC: hasty@rah.star-gate.com, shimon@simon-shapiro.org, freebsd-database@FreeBSD.ORG, andreas@klemm.gtn.com, scrappy@hub.org Subject: Re: [PORTS] Pgaccess doesn't ... (yet) :-) References: <199803251445.JAA05333@candle.pha.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Bruce Momjian wrote: > > I feel like I am CC'ing the world on this one, but I just wanted to say > that the whole reason for this tcl/tk clammor is because everyone likes > pgaccess, and thinks it is a great program. Thanks Bruce. And thanks for all the folks who encouraged me writting PgAccess. I hope I will have the time to develop it further. I must say also : thanks for PostgreSQL. -- Constantin Teodorescu FLEX Consulting Braila, ROMANIA To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Mar 25 07:06:39 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id HAA21373 for freebsd-database-outgoing; Wed, 25 Mar 1998 07:06:39 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from fallout.campusview.indiana.edu (fallout.campusview.indiana.edu [149.159.1.1]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id HAA21365; Wed, 25 Mar 1998 07:06:37 -0800 (PST) (envelope-from jfieber@indiana.edu) Received: from localhost (jfieber@localhost) by fallout.campusview.indiana.edu (8.8.7/8.8.7) with SMTP id KAA05652; Wed, 25 Mar 1998 10:06:36 -0500 (EST) Date: Wed, 25 Mar 1998 10:06:36 -0500 (EST) From: John Fieber To: Amancio Hasty cc: ports@FreeBSD.ORG, freebsd-database@FreeBSD.ORG Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update In-Reply-To: <199803250450.UAA27558@rah.star-gate.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Tue, 24 Mar 1998, Amancio Hasty wrote: > On 25-Mar-98 Satoshi Asami wrote: > > * Why? > > Because it's a waste of time. If you want to know what happened > > before, anyone can go check the mail archives. > > We need a decent search engine for the mail archives and possibly also > provide a threaded list of the archived messages. Show me a free mail threader that won't be completely crushed when you throw 600+ megabytes of mail at it and I'll be most appreciative. I've actually considered postgres for a thread index based on message-id, but mail clients are a lot worse, on average, with proper referencing than news clients so the threading achieved by this method is little better than sorting by subject line. Anyway, what is needed in this case is for someone to write up a summary of the state of tcl as it pertains to ports and porting, and add that to the porting section of the handbook (www.freebsd.org/handbook/porting.html). -john To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Mar 25 07:25:37 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id HAA23688 for freebsd-database-outgoing; Wed, 25 Mar 1998 07:25:37 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from ns1.yes.no (ns1.yes.no [195.119.24.10]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id HAA23676; Wed, 25 Mar 1998 07:25:24 -0800 (PST) (envelope-from eivind@bitbox.follo.net) Received: from bitbox.follo.net (bitbox.follo.net [194.198.43.36]) by ns1.yes.no (8.8.7/8.8.7) with ESMTP id PAA16882; Wed, 25 Mar 1998 15:25:10 GMT Received: (from eivind@localhost) by bitbox.follo.net (8.8.6/8.8.6) id QAA05633; Wed, 25 Mar 1998 16:25:09 +0100 (MET) Message-ID: <19980325162504.05717@follo.net> Date: Wed, 25 Mar 1998 16:25:04 +0100 From: Eivind Eklund To: John Fieber , Amancio Hasty Cc: ports@FreeBSD.ORG, freebsd-database@FreeBSD.ORG Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update References: <199803250450.UAA27558@rah.star-gate.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.89.1i In-Reply-To: ; from John Fieber on Wed, Mar 25, 1998 at 10:06:36AM -0500 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Wed, Mar 25, 1998 at 10:06:36AM -0500, John Fieber wrote: > On Tue, 24 Mar 1998, Amancio Hasty wrote: > > > On 25-Mar-98 Satoshi Asami wrote: > > > * Why? > > > Because it's a waste of time. If you want to know what happened > > > before, anyone can go check the mail archives. > > > > We need a decent search engine for the mail archives and possibly also > > provide a threaded list of the archived messages. > > Show me a free mail threader that won't be completely crushed > when you throw 600+ megabytes of mail at it and I'll be most > appreciative. I've actually considered postgres for a thread > index based on message-id, but mail clients are a lot worse, on > average, with proper referencing than news clients so the > threading achieved by this method is little better than sorting > by subject line. www.findmail.com has offered to archive the lists. They have all the databases and stuff needed, and I'd guess they also could take the old message log. They also have a very nice interface to archived mail. Eivind. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Mar 25 07:39:17 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id HAA26142 for freebsd-database-outgoing; Wed, 25 Mar 1998 07:39:17 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from tyree.iii.co.uk (tyree.iii.co.uk [195.89.149.230]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id HAA26136 for ; Wed, 25 Mar 1998 07:39:13 -0800 (PST) (envelope-from nik@iii.co.uk) From: nik@iii.co.uk Received: from carrig.strand.iii.co.uk (carrig.strand.iii.co.uk [192.168.7.25]) by tyree.iii.co.uk (8.8.8/8.8.8) with ESMTP id PAA29759; Wed, 25 Mar 1998 15:39:04 GMT Received: (from nik@localhost) by carrig.strand.iii.co.uk (8.8.8/8.8.7) id PAA01589; Wed, 25 Mar 1998 15:39:00 GMT Message-ID: <19980325153859.50022@iii.co.uk> Date: Wed, 25 Mar 1998 15:38:59 +0000 To: John Fieber Cc: Amancio Hasty , freebsd-database@FreeBSD.ORG Subject: Mailing list archives References: <199803250450.UAA27558@rah.star-gate.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.85e In-Reply-To: ; from John Fieber on Wed, Mar 25, 1998 at 10:06:36AM -0500 Organization: interactive investor Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk [Trimmed the cc: line, lost -ports] On Wed, Mar 25, 1998 at 10:06:36AM -0500, John Fieber wrote: > On Tue, 24 Mar 1998, Amancio Hasty wrote: > > We need a decent search engine for the mail archives and possibly also > > provide a threaded list of the archived messages. > > Show me a free mail threader that won't be completely crushed > when you throw 600+ megabytes of mail at it and I'll be most > appreciative. Possibly (and I stress possibly) MHonArc v2.2. I've been doing a bunch of stuff with it at work recently, and I hope to be able to test out some of these changes by throwing it at chunks of the -hackers archives. I'll be doing this testing on my own box, *not* freefall :-) About the only problem with the MHonArc + glimpse approach (if it can handle the amount of messages) will be that you will lose the ability to search multiple mailing lists at once. That's not an insurmountable problem though. I should be doing this testing sometime within the next week, free time permitting. > I've actually considered postgres for a thread > index based on message-id, but mail clients are a lot worse, on > average, with proper referencing than news clients so the > threading achieved by this method is little better than sorting > by subject line. A cursory glance at the index of my MUA (Mutt) which does references and/or in-reply-to threading, shows that 90% (+/- 5%) of the messages I've got stored from the FreeBSD lists thread correctly, so it may be more pervasive than you think. N -- Work: nik@iii.co.uk | FreeBSD + Perl + Apache Rest: nik@nothing-going-on.demon.co.uk | Remind me again why we need Play: nik@freebsd.org | Microsoft? To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Mar 26 09:15:21 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id JAA17175 for freebsd-database-outgoing; Thu, 26 Mar 1998 09:15:21 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from flex.flex.ro (flex.flex.ro [193.230.255.2]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id JAA17152 for ; Thu, 26 Mar 1998 09:15:05 -0800 (PST) (envelope-from teo@flex.ro) Received: from flex.flex.ro (localhost [127.0.0.1]) by flex.flex.ro (8.8.8/8.7.3) with SMTP id TAA03763; Thu, 26 Mar 1998 19:20:07 +0200 Message-ID: <351A8E46.2B097E89@flex.ro> Date: Thu, 26 Mar 1998 19:20:06 +0200 From: Constantin Teodorescu Organization: FLEX Consulting Braila X-Mailer: Mozilla 3.04Gold (X11; I; Linux 2.0.32 i586) MIME-Version: 1.0 To: PostgreSQL Interfaces CC: hasty@rah.star-gate.com, shimon@simon-shapiro.org, freebsd-database@FreeBSD.ORG, andreas@klemm.gtn.com, pgsql-ports@postgresql.org, scrappy@hub.org Subject: Re: PgAccess small bug fix References: <199803251445.JAA05333@candle.pha.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk > > When "Query design" window is on the screen, "exec" queries cannot be > > executed. > > Save the query and then "Open" it. It will exec the query. Not any more :-) The new version, 0.85 that I have fixed this evening takes the appropriate action for "Execute query" button in the design mode. If it is a "SELECT ..." it will open the query/table viewer, if it's an action query (Update, Delete, Grant, Insert ...) it will "pg_exec" the query. -- Constantin Teodorescu FLEX Consulting Braila, ROMANIA To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Mar 26 16:13:48 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id QAA18773 for freebsd-database-outgoing; Thu, 26 Mar 1998 16:13:48 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from mail.cs.tu-berlin.de (root@mail.cs.tu-berlin.de [130.149.17.13]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id QAA18719; Thu, 26 Mar 1998 16:13:40 -0800 (PST) (envelope-from wosch@cs.tu-berlin.de) Received: from panke.panke.de (anonymous215.ppp.cs.tu-berlin.de [130.149.17.215]) by mail.cs.tu-berlin.de (8.8.8/8.8.8) with ESMTP id BAA25894; Fri, 27 Mar 1998 01:05:46 +0100 (MET) Received: (from wosch@localhost) by panke.panke.de (8.8.5/8.6.12) id XAA00471; Thu, 26 Mar 1998 23:29:46 +0100 (MET) To: Amancio Hasty Cc: shimon@simon-shapiro.org, asami@FreeBSD.ORG (Satoshi Asami), maillist@candle.pha.pa.us, scrappy@hub.org, current@FreeBSD.ORG, pgsql-ports@postgreSQL.org, andreas@klemm.gtn.com, freebsd-database@FreeBSD.ORG Subject: Re: [PORTS] Pgaccess doesn't run on -current anymore, Update References: <199803250450.UAA27558@rah.star-gate.com> From: Wolfram Schneider Date: 26 Mar 1998 23:29:44 +0100 In-Reply-To: Amancio Hasty's message of Tue, 24 Mar 1998 20:50:45 -0800 Message-ID: Lines: 21 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Amancio Hasty writes: > On 25-Mar-98 Satoshi Asami wrote: > > * Why? > > Because it's a waste of time. If you want to know what happened > > before, anyone can go check the mail archives. > > We need a decent search engine for the mail archives and possibly also > provide a threaded list of the archived messages. The FreeBSD mailing list search interface support threads. The thread database will be updated hourly. Of course there are many things to do to make the threads more user friendly. > If I am not mistaken, the mail archives are stored in ftp.freebsd.org so > there is a wonderful opportunity for someone to provide a useful service > to the FreeBSD community. If no one takes action as Satoshi said: > "anyone can go check the mail archives". -- Wolfram Schneider http://www.freebsd.org/~wosch/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message