Re: [HACKERS] Please, apply patch of tsearch for current CVS & 7.3.1

2002-12-05 Thread Bruce Momjian
Patch applied to HEAD and 7.3. Thanks. --- Teodor Sigaev wrote: > Thank you very much, you catch it :). This bug had a long life, because it > exists if and only if locale of postmaster > was a different from C (or ru_RU.

[HACKERS] IPv6 patch rejected

2002-12-05 Thread Bruce Momjian
The INETv6 patch was rejected because of this report, and an error on postmaster startup from BSD/OS: LOG: FATAL: StreamServerPort: getaddrinfo2() failed: hostname nor servname provided, or not known Please submit a new patch that addresses these issues. I can work with you to

Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster

2002-12-05 Thread Justin Clift
Hi Mark, mlw wrote: Justin: Are you involved with gborg? Nope, that's Chris Ryan's area. :) I have been thinking about Igor's console and my installer. I think there is a good enough need to host a project that contains HOWTOs, scripts, and tools to make PostgreSQL easy for Windows deplo

Re: [HACKERS] configure error on cvs tip

2002-12-05 Thread Joe Conway
Bruce Momjian wrote: Sorry. Run autoconf. OK -- works now. I've never needed to do that before. Thanks! Joe ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTE

Re: [HACKERS] configure error on cvs tip

2002-12-05 Thread Bruce Momjian
BJoe Conway wrote: > Bruce Momjian wrote: > > Yep, I am about to yank out the whole patch. I am seeing on postmaster > > startup: > > > > LOG: FATAL: StreamServerPort: getaddrinfo2() failed: hostname > > nor servname provided, or not known > > > > What is strange is that initdb work

Re: [HACKERS] configure error on cvs tip

2002-12-05 Thread Joe Conway
Bruce Momjian wrote: Yep, I am about to yank out the whole patch. I am seeing on postmaster startup: LOG: FATAL: StreamServerPort: getaddrinfo2() failed: hostname nor servname provided, or not known What is strange is that initdb worked. I will just throw it back to the author. Done. Code

Re: [HACKERS] configure error on cvs tip

2002-12-05 Thread Bruce Momjian
Yep, I am about to yank out the whole patch. I am seeing on postmaster startup: LOG: FATAL: StreamServerPort: getaddrinfo2() failed: hostname nor servname provided, or not known What is strange is that initdb worked. I will just throw it back to the author. Done. Code

Re: [HACKERS] configure error on cvs tip

2002-12-05 Thread Joe Conway
Bruce Momjian wrote: Fixing now. This just isn't my night --- another patch with a missing file. OK - I can run configure and make now, but I'm getting these warnings: In file included from ../../../../src/include/libpq/libpq.h:22, from printtup.c:20: ../../../../src/include/

Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster

2002-12-05 Thread mlw
Justin: Are you involved with gborg? I have been thinking about Igor's console and my installer. I think there is a good enough need to host a project that contains HOWTOs, scripts, and tools to make PostgreSQL easy for Windows deployment. I am working on a HOWTO, a set of Windows batch files,

Re: [HACKERS] configure error on cvs tip

2002-12-05 Thread Bruce Momjian
Fixing now. This just isn't my night --- another patch with a missing file. --- Joe Conway wrote: > I just sync'd up with cvs and tried to make clean then configure, and I'm > getting this: > > config.status: linking ./s

[HACKERS] configure error on cvs tip

2002-12-05 Thread Joe Conway
I just sync'd up with cvs and tried to make clean then configure, and I'm getting this: config.status: linking ./src/backend/libpq/v6util.c to src/interfaces/libpq/v6util.c config.status: error: ./src/backend/libpq/v6util.c: file not found Is this a missing file from the ipv6 stuff that just go

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

2002-12-05 Thread Robert Treat
On Thu, 05 Dec 2002 21:26:13 -0500, Philip Warner wrote: > At 12:12 AM 5/12/2002 -0500, Robert Treat wrote: > I am happy with increasing market share so long a development is not > distorted or current users inconvenienced. We have seen the latter with > the misplaced announcements. It seems to me

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

2002-12-05 Thread Philip Warner
At 12:12 AM 5/12/2002 -0500, Robert Treat wrote: > > What are the consequences of the problem? > One consequence that probably hits home for everyone here is it makes it extremely hard to make a living working with postgresql. ... You can't win marketshare on technology alone I am happy with

Re: [HACKERS] Wishlist for 7.4: Plan stability

2002-12-05 Thread Greg Stark
Tom Lane <[EMAIL PROTECTED]> writes: > Greg Stark <[EMAIL PROTECTED]> writes: > > Really it boils down to one point: there's really no reason to assume a user > > should be able to execute any new query he feels like. Creating a new query > > should be privileged operation just like creating a new

Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster

2002-12-05 Thread Justin Clift
mlw wrote: Once we do that, the we have the hook for more reliable and powerful systems. Yep, I pretty much agree. :-) Regards and best wishes, Justin Clift -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to

Re: [HACKERS] Quick Help

2002-12-05 Thread Rod Taylor
It works very similarly to the way that ALTER TABLE ... ADD CHECK .. works, with the tuple update added in. Anyway, it's something like the below: - Lock relation - Pull out tuple - Evaluate cooked default expression using EvalExpr - heap_modifytuple (shove datum that EvalExpr returns into column

Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster

2002-12-05 Thread mlw
Justin Clift wrote: Hi Igor, This would be a really good thing to get into GBorg as a project, so people could work on this through CVS. Would you like to register it as a project? Mark, do you feel it would be better to put your installer plus this together into one project on GBorg too?

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

2002-12-05 Thread Josh Berkus
Folks, We have a marketing group: PGSQL-ADVOCACY. Our problem is that we don't have enough volunteers. For example, last week Robert and Justin had job crises, and I left for the mountains for Thanksgiving. As a result Marc had to pitch in at the last minute to try to get some kind of release

Re: [PATCHES] [HACKERS] Patch to make Turks happy.

2002-12-05 Thread Bruce Momjian
OK, patch applied. Peter, should this appear in 7.3.1 too? --- Peter Eisentraut wrote: > Bruce Momjian writes: > > > I am not going to apply this patch because I think it will mess up the > > handling of other locales. >

Re: [PATCHES] [HACKERS] Patch to make Turks happy.

2002-12-05 Thread Bruce Momjian
OK, Peter, that helps. Thanks. I will apply it. --- Peter Eisentraut wrote: > Bruce Momjian writes: > > > I am not going to apply this patch because I think it will mess up the > > handling of other locales. > > This pat

Re: [PATCHES] [HACKERS] Patch to make Turks happy.

2002-12-05 Thread Peter Eisentraut
Bruce Momjian writes: > I am not going to apply this patch because I think it will mess up the > handling of other locales. This patch looks OK to me. Normally, character set names should use identifier case-folding rules anyway, so seems to be a step in the right direction. Much better than sa

Re: [HACKERS] PQnotifies() in 7.3 broken?

2002-12-05 Thread Peter Eisentraut
Tom Lane writes: > It is not real clear to me whether we need a major version bump, rather > than a minor one. We *do* need to signal binary incompatibility. Who > can clarify the rules here? Strictly speaking, it's platform-dependent, but our shared library code plays a bit of abuse with it.

Re: [HACKERS] PQnotifies() in 7.3 broken?

2002-12-05 Thread Bruce Momjian
Jeroen T. Vermeulen wrote: > On Thu, Dec 05, 2002 at 03:27:23PM -0500, Tom Lane wrote: > > > > It is not real clear to me whether we need a major version bump, rather > > than a minor one. We *do* need to signal binary incompatibility. Who > > can clarify the rules here? > > One thing I wonder

[HACKERS] Q: "unknown expression type 108" ?

2002-12-05 Thread Ian Barwick
Hi appended below is a simple database schema (which may not be a candidate for the next Nobel Prize for SQL Database Design, but represents enough of a production database to demonstrate the following problem). And that is: under 7.3 this statement: SELECT foo_id, thingy_name, bar_name

Re: [HACKERS] PQnotifies() in 7.3 broken?

2002-12-05 Thread Jeroen T. Vermeulen
On Thu, Dec 05, 2002 at 03:27:23PM -0500, Tom Lane wrote: > > It is not real clear to me whether we need a major version bump, rather > than a minor one. We *do* need to signal binary incompatibility. Who > can clarify the rules here? One thing I wonder about: should the rules make any distinct

Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster

2002-12-05 Thread mlw
Justin Clift wrote: Igor Georgiev wrote: I also be GLAD to read about plans for native windows port in 7.4. If anyone is interested i can post source code, or maybe this firrst steps can go to gborg as a separate project i'm not sure yet. Hi Igor, This would be a really good thing to get

Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster

2002-12-05 Thread Justin Clift
Igor Georgiev wrote: I also be GLAD to read about plans for native windows port in 7.4. If anyone is interested i can post source code, or maybe this firrst steps can go to gborg as a separate project i'm not sure yet. Hi Igor, This would be a really good thing to get into GBorg as a project,

[HACKERS] Quick Help

2002-12-05 Thread Christopher Kings-Lynne
Hi guys, Messing about with ADD COLUMN... I'm not certain how to re-evaluate the default expression for each row? How do I do this? I have access to raw_default and cooked_default it seems. Thanks, Chris ---(end of broadcast)--- TIP 4: Don't '

Re: [HACKERS] dbmirror

2002-12-05 Thread Bruce Momjian
Thanks. Applied to 7.3 and CVS HEAD. It was me who added those commands to set the envirnment, and I didn't realize it was the first use of those variables, hence the need for 'my'. Thanks. Fix will be in 7.3.1. --- Stev

Re: [HACKERS] Patch to make Turks happy.

2002-12-05 Thread Nicolai Tufar
Bruce Momjian wrote: I am not going to apply this patch because I think it will mess up the handling of other locales. As far as I figured from the source code this function only deals with cleaning up locale names and nothing else. Since all the locale names are in plain ASCII I think it will

Re: [HACKERS] dbmirror

2002-12-05 Thread Steven Singer
On Thu, 5 Dec 2002, Bruce Momjian wrote: It looks like the problem was introduced when the "SET autocommit" and "SET search_path" commands were added to the beginning of the script. The attatched patch should fix the problem. It probably should be applied against the 7.3 and 7.4 branches. >

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 15:36, Tom Lane wrote: > "Dan Langille" <[EMAIL PROTECTED]> writes: > >> You can do that now. > >> ALTER TABLE ADD CONSTRAINT FOREIGN KEY > > > That I know. That syntax is radically different from that proposed. > > So you're proposing we replace a SQL-spec-compliant syn

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Tom Lane
"Dan Langille" <[EMAIL PROTECTED]> writes: >> You can do that now. >> ALTER TABLE ADD CONSTRAINT FOREIGN KEY > That I know. That syntax is radically different from that proposed. So you're proposing we replace a SQL-spec-compliant syntax with one that is not? Why?

Re: [HACKERS] PQnotifies() in 7.3 broken?

2002-12-05 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Fernando Nasser wrote: >> Bruce Momjian wrote: >> Bruce, why is it too late? >> >> Most (all) will upgrade to 7.3.1 anyway, so it is a chance to get things right. > Oh. yes. Is it safe to do that? The RPM packagers should probably have a say in this,

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 12:09, Christopher Kings-Lynne wrote: > > > Isn't it identical? The CONSTRAINT is SQL standard optional > clause > > > for all commands that add constraints. > > > > Except that one is ADD CONSTRAINT, the other is an ADD FOREIGN KEY. > > They are similar in nature but different

Re: [HACKERS] PQnotifies() in 7.3 broken?

2002-12-05 Thread Bruce Momjian
Fernando Nasser wrote: > Bruce Momjian wrote: > > > > I will update for 7.4 now. Too late for 7.3 clearly. > > > > Bruce, why is it too late? > > Most (all) will upgrade to 7.3.1 anyway, so it is a chance to get things right. Oh. yes. Is it safe to do that? -- Bruce Momjian

Re: [HACKERS] 7.3 pg_relcheck oddness

2002-12-05 Thread Tom Lane
Paul Ramsey <[EMAIL PROTECTED]> writes: >\d thetable > returns >ERROR: Relation "pg_relcheck" does not exist I think you are using a 7.2 psql with the 7.3 server. There will be quite a few problems with backslash commands in that combination (or the reverse), because of the extensive cat

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Rod Taylor
On Thu, 2002-12-05 at 14:52, Christopher Kings-Lynne wrote: > > > > Thanks. I guess I should rename my thread to 7.4 - TODO : allow > > > > constraint names when using the "ALTER TABLE ADD FOREIGN KEY" > > > > syntax. > > > > > > You can do that now. > > > > > > ALTER TABLE ADD CONSTRAINT FOREI

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Christopher Kings-Lynne
> > Isn't it identical? The CONSTRAINT is SQL standard optional clause > > for all commands that add constraints. > > Except that one is ADD CONSTRAINT, the other is an ADD FOREIGN KEY. > They are similar in nature but different overall. I think you're getting a little confused here, Dan. http:

[HACKERS] 7.3-2 RPMset released.

2002-12-05 Thread Lamar Owen
Due to a late-night typo, the 7.3-1 RPMset released last night would start the postmaster for the first time, but not subsequent times. I have corrected the problem and uploaded a 7.3-2 RPMset. If you do not want to download the whole set again to fix a single-character bug, edit the file /et

Re: [HACKERS] PQnotifies() in 7.3 broken?

2002-12-05 Thread Fernando Nasser
Bruce Momjian wrote: I will update for 7.4 now. Too late for 7.3 clearly. Bruce, why is it too late? Most (all) will upgrade to 7.3.1 anyway, so it is a chance to get things right. -- Fernando Nasser Red Hat - Toronto E-Mail: [EMAIL PROTECTED] 2323 Yonge Street, Suite

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 11:52, Christopher Kings-Lynne wrote: > > > > Thanks. I guess I should rename my thread to 7.4 - TODO : allow > > > > constraint names when using the "ALTER TABLE ADD FOREIGN KEY" > > > > syntax. > > > > > > You can do that now. > > > > > > ALTER TABLE ADD CONSTRAINT FOREIGN K

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Christopher Kings-Lynne
> > > Thanks. I guess I should rename my thread to 7.4 - TODO : allow > > > constraint names when using the "ALTER TABLE ADD FOREIGN KEY" > > > syntax. > > > > You can do that now. > > > > ALTER TABLE ADD CONSTRAINT FOREIGN KEY > > That I know. That syntax is radically different from that

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 14:17, Fernando Nasser wrote: > Dan Langille wrote:> On 5 Dec 2002 at 11:47, Dan Langille wrote: > > > > drop trigger "RI_ConstraintTrigger_4278488" on watch_list_staging; > > > > You should now go to the table this RI constraint was referring to and delete > the two triggers

Re: [HACKERS] PQnotifies() in 7.3 broken?

2002-12-05 Thread Bruce Momjian
Lee Kindness wrote: > Bruce Momjian writes: > > Tom Lane wrote: > > > Lee Kindness <[EMAIL PROTECTED]> writes: > > > > Perhaps the .so name should have been updated for PostgreSQL 7.3? > > > > > > It should have been. If it wasn't, that was a serious oversight. > > > Not sure if we should c

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 14:04, Rod Taylor wrote: > > Thanks. I guess I should rename my thread to 7.4 - TODO : allow > > constraint names when using the "ALTER TABLE ADD FOREIGN KEY" > > syntax. > > You can do that now. > > ALTER TABLE ADD CONSTRAINT FOREIGN KEY That I know. That syntax is

Re: [HACKERS] [ADMIN] how to alter sequence.

2002-12-05 Thread Bruce Momjian
I don't think you can drop/recreate the sequence because the dependency code knows other tables depend on it. --- Rajesh Kumar Mallah. wrote: > > Doesn't dropping and recreating the sequence suit the bill ? > > whats' the

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group Announces

2002-12-05 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Peter Eisentraut wrote: >> Marc G. Fournier writes: >>> It isn't, but those working on -advocacy were asked to help come up with a >>> stronger release *announcement* then we've had in the past ... >> >> Consider that a failed experiment. PostgreSQL is

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Fernando Nasser
Dan Langille wrote:> On 5 Dec 2002 at 11:47, Dan Langille wrote: Primary key: watch_list_staging_pkey Check constraints: "watch_list_stag_from_watch_list" ((from_watch_list = 't'::bool) OR (from_watch_list = 'f'::bool)) "watch_list_stagin_from_pkg_info" ((from_pkg_info = 't':

Re: [HACKERS] big text field -> message type 0x44

2002-12-05 Thread Bruce Momjian
Tom Lane wrote: > Lee Kindness <[EMAIL PROTECTED]> writes: > > Tom Lane writes: > >>> Okay, so it seems -D_REENTRANT is the appropriate fix. > > > However, _REENTRANT is not a Solarisism... On all (recent) UNIX > > systems it toggles on correct handling for thread specific instances > > of histori

Re: [HACKERS] big text field -> message type 0x44

2002-12-05 Thread Larry Rosenman
--On Thursday, December 05, 2002 14:02:04 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: Lee Kindness <[EMAIL PROTECTED]> writes: Tom Lane writes: Okay, so it seems -D_REENTRANT is the appropriate fix. However, _REENTRANT is not a Solarisism... On all (recent) UNIX systems it toggles on correct

Re: [HACKERS] 7.3 pg_relcheck oddness

2002-12-05 Thread Paul Ramsey
On further investigation, the problem is related to using a 7.2 psql against a 7.3 backend. The \d from the 7.2 psql is not compatible with the 7.3 backend in the case of tables with non-standard types apparently. P. Paul Ramsey wrote: I am poking around at upgrading PostGIS to work with versi

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Rod Taylor
> Thanks. I guess I should rename my thread to 7.4 - TODO : allow > constraint names when using the "ALTER TABLE ADD FOREIGN KEY" > syntax. You can do that now. ALTER TABLE ADD CONSTRAINT FOREIGN KEY -- Rod Taylor <[EMAIL PROTECTED]> PGP Key: http://www.rbt.ca/rbtpub.asc signatur

Re: [HACKERS] big text field -> message type 0x44

2002-12-05 Thread Tom Lane
Lee Kindness <[EMAIL PROTECTED]> writes: > Tom Lane writes: >>> Okay, so it seems -D_REENTRANT is the appropriate fix. > However, _REENTRANT is not a Solarisism... On all (recent) UNIX > systems it toggles on correct handling for thread specific instances > of historically global variables (eg err

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group Announces

2002-12-05 Thread Bruce Momjian
Marc G. Fournier wrote: > On Wed, 4 Dec 2002 [EMAIL PROTECTED] wrote: > > > It is unfortunate that it is almost impossible to have a marketing group > > without there being some wilful blinders involved; it's vital for there to be > > some technical involvement in the marketing group to pop whatev

[HACKERS] 7.3 pg_relcheck oddness

2002-12-05 Thread Paul Ramsey
I am poking around at upgrading PostGIS to work with version 7.3. So far, the changes seem relatively minor. There is one odd quirk though. Having gotten the PostGIS types and index bindings loaded, and having loaded a table full of spatial data, trying to do \d thetable returns ERROR:

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 9:51, Stephan Szabo wrote: > On Thu, 5 Dec 2002, Dan Langille wrote: > > > On 5 Dec 2002 at 9:31, Stephan Szabo wrote: > > > > > When we talk about ALTER TABLE ADD FOREIGN KEY we're being imprecise, so > > > I think that might be why we're talking past each other here. > > > > >

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Stephan Szabo
On Thu, 5 Dec 2002, Dan Langille wrote: > On 5 Dec 2002 at 9:31, Stephan Szabo wrote: > > > When we talk about ALTER TABLE ADD FOREIGN KEY we're being imprecise, so > > I think that might be why we're talking past each other here. > > > > Technically the syntax in question is: > > ALTER TABLE AD

Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster windows

2002-12-05 Thread mlw
Hey this is a cool project. I have been thinking doing the exact ame thing, the console Window of 2K/XP just kills the daemon, yuck. What can I do to help? Igor Georgiev wrote: >I am working on getting a shrink-wrapped version of PostgreSQL for Windows >Currently it insta

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 9:31, Stephan Szabo wrote: > When we talk about ALTER TABLE ADD FOREIGN KEY we're being imprecise, so > I think that might be why we're talking past each other here. > > Technically the syntax in question is: > ALTER TABLE ADD > where CONSTRAINT is an optional leading clause

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Stephan Szabo
On Thu, 5 Dec 2002, Dan Langille wrote: > On 5 Dec 2002 at 9:02, Stephan Szabo wrote: > > > On Thu, 5 Dec 2002, Dan Langille wrote: > > > > > Found the solution: > > > > > > drop trigger "RI_ConstraintTrigger_4278488" on watch_list_staging; > > > > Actually there are three triggers for the constra

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 9:02, Stephan Szabo wrote: > On Thu, 5 Dec 2002, Dan Langille wrote: > > > Found the solution: > > > > drop trigger "RI_ConstraintTrigger_4278488" on watch_list_staging; > > Actually there are three triggers for the constraint. You may have > dangling triggers on the other tabl

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Stephan Szabo
On Thu, 5 Dec 2002, Dan Langille wrote: > Found the solution: > > drop trigger "RI_ConstraintTrigger_4278488" on watch_list_staging; Actually there are three triggers for the constraint. You may have dangling triggers on the other table of the constraint. It's one on the table the constraint's

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

2002-12-05 Thread Lamar Owen
On Thursday 05 December 2002 09:37, Marc G. Fournier wrote: > On Wed, 4 Dec 2002, Lamar Owen wrote: > > However, I seriously question the need in the long term for our sites to > > be as fractured as they are. Good grief! We've got > note that altho they are seperate URLs, the end result is goin

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 11:47, Dan Langille wrote: > On 5 Dec 2002 at 8:44, Stephan Szabo wrote: > > > On Thu, 5 Dec 2002, Dan Langille wrote: > > > > > On 5 Dec 2002 at 8:20, Stephan Szabo wrote: > > > > > > > > > > > On Thu, 5 Dec 2002, Dan Langille wrote: > > > > > > > > > We support "alter table ad

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 8:44, Stephan Szabo wrote: > On Thu, 5 Dec 2002, Dan Langille wrote: > > > On 5 Dec 2002 at 8:20, Stephan Szabo wrote: > > > > > > > > On Thu, 5 Dec 2002, Dan Langille wrote: > > > > > > > We support "alter table add foreign key". How about supporting > > > > "alter table drop f

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Stephan Szabo
On Thu, 5 Dec 2002, Dan Langille wrote: > On 5 Dec 2002 at 8:20, Stephan Szabo wrote: > > > > > On Thu, 5 Dec 2002, Dan Langille wrote: > > > > > We support "alter table add foreign key". How about supporting > > > "alter table drop foreign key"? > > > > > > - he said as he went to drop a foreign

Re: [HACKERS] 7.4 - TODO : IpcSemaphoreCreate: No space left on

2002-12-05 Thread Neil Conway
On Thu, 2002-12-05 at 10:13, Dan Langille wrote: > This error is accompanied by a suggestion to change SEMMNI or SEMMNS. > In this case, that suggestion is not appropriate. Read below for > the scenario. > Suggestion: Can we modify the error message to include checking for a > running postmas

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 8:20, Stephan Szabo wrote: > > On Thu, 5 Dec 2002, Dan Langille wrote: > > > We support "alter table add foreign key". How about supporting > > "alter table drop foreign key"? > > > > - he said as he went to drop a foreign key > > It seems to work for me on my 7.3b2 system wit

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
On 5 Dec 2002 at 8:20, Stephan Szabo wrote: > > On Thu, 5 Dec 2002, Dan Langille wrote: > > > We support "alter table add foreign key". How about supporting > > "alter table drop foreign key"? > > > > - he said as he went to drop a foreign key > > It seems to work for me on my 7.3b2 system wit

Re: [HACKERS] big text field -> message type 0x44

2002-12-05 Thread Tomas Berndtsson
Doug McNaught <[EMAIL PROTECTED]> writes: > Lee Kindness <[EMAIL PROTECTED]> writes: > > > Tom Lane writes: > > > Okay, so it seems -D_REENTRANT is the appropriate fix. > > > > > > We could either add that to the template/solaris file, or just add a > > > note to FAQ_Solaris advising that it

Re: [HACKERS] big text field -> message type 0x44

2002-12-05 Thread Tomas Berndtsson
Lee Kindness <[EMAIL PROTECTED]> writes: > Tom Lane writes: > > Okay, so it seems -D_REENTRANT is the appropriate fix. > > > > We could either add that to the template/solaris file, or just add a > > note to FAQ_Solaris advising that it be added to the configure switches > > if people intend

Re: [HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Stephan Szabo
On Thu, 5 Dec 2002, Dan Langille wrote: > We support "alter table add foreign key". How about supporting > "alter table drop foreign key"? > > - he said as he went to drop a foreign key It seems to work for me on my 7.3b2 system with alter table drop constraint ; ---(

Re: [HACKERS] big text field -> message type 0x44

2002-12-05 Thread Doug McNaught
Lee Kindness <[EMAIL PROTECTED]> writes: > Tom Lane writes: > > Okay, so it seems -D_REENTRANT is the appropriate fix. > > > > We could either add that to the template/solaris file, or just add a > > note to FAQ_Solaris advising that it be added to the configure switches > > if people intend

[HACKERS] 7.4 - TODO : alter table drop foreign key

2002-12-05 Thread Dan Langille
We support "alter table add foreign key". How about supporting "alter table drop foreign key"? - he said as he went to drop a foreign key -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 6: Have you searched our list archi

Re: [HACKERS] big text field -> message type 0x44

2002-12-05 Thread Lee Kindness
Tom Lane writes: > Okay, so it seems -D_REENTRANT is the appropriate fix. > > We could either add that to the template/solaris file, or just add a > note to FAQ_Solaris advising that it be added to the configure switches > if people intend to use libpq in threaded programs. Is there any > c

Re: [HACKERS] big text field -> message type 0x44

2002-12-05 Thread Tomas Berndtsson
Tom Lane <[EMAIL PROTECTED]> writes: > Tomas Berndtsson <[EMAIL PROTECTED]> writes: > > Indeed you were right in this. But, if I added -D_REENTRANT to the > > Makefile for libpq, it started to set it. If libpq should be thread > > safe, I believe it should be compiled with -D_REENTRANT. > > > Wh

Re: [HACKERS] big text field -> message type 0x44

2002-12-05 Thread Tom Lane
Tomas Berndtsson <[EMAIL PROTECTED]> writes: > Indeed you were right in this. But, if I added -D_REENTRANT to the > Makefile for libpq, it started to set it. If libpq should be thread > safe, I believe it should be compiled with -D_REENTRANT. > When I did this, recv still returns error, but now s

[HACKERS] 7.4 - TODO : IpcSemaphoreCreate: No space left on device

2002-12-05 Thread Dan Langille
This error is accompanied by a suggestion to change SEMMNI or SEMMNS. In this case, that suggestion is not appropriate. Read below for the scenario. Suggestion: Can we modify the error message to include checking for a running postmaster? Reasoning: During my dbinit, I found the following e

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

2002-12-05 Thread Robert Treat
On Thu, 2002-12-05 at 03:28, Dave Page wrote: > www is a closed group consisting of a few of us who actually do the work > on the sites. This is one of the primary reasons the sites are so fractured. We have 4 different mailing lists for website development (and I'm not counting advocacy as one o

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

2002-12-05 Thread Marc G. Fournier
On Thu, 5 Dec 2002, Scott Lamb wrote: > Is this list the appropriate place to discuss the websites? or should I > take it to -advocacy? My impression here is that the two sites are > maintained separately and the people involved haven't interacted very > much. Is that accurate or no? Expect some

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

2002-12-05 Thread Marc G. Fournier
On Wed, 4 Dec 2002, Lamar Owen wrote: > However, I seriously question the need in the long term for our sites to be as > fractured as they are. Good grief! We've got advocacy.postgresql.org, > techdocs.postgresql.org, odbc.postgresql.org, gborg.postgresql.org, > developer.postgresql.org, jdbc.po

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group Announces

2002-12-05 Thread Marc G. Fournier
On Thu, 5 Dec 2002, Philip Warner wrote: > At 05:48 PM 4/12/2002 -0800, Christopher Kings-Lynne wrote: > >Lack of marketing is one of Postgres's major problems. > > What are the consequences of the problem? Well, I'd have to say the major one is a difficult in increasing our user base, as ppl lik

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group Announces

2002-12-05 Thread Marc G. Fournier
On Wed, 4 Dec 2002 [EMAIL PROTECTED] wrote: > It is unfortunate that it is almost impossible to have a marketing group > without there being some wilful blinders involved; it's vital for there to be > some technical involvement in the marketing group to pop whatever bubbles they > grow that are wo

Re: [HACKERS] PQnotifies() in 7.3 broken?

2002-12-05 Thread Lee Kindness
Bruce Momjian writes: > Tom Lane wrote: > > Lee Kindness <[EMAIL PROTECTED]> writes: > > > Perhaps the .so name should have been updated for PostgreSQL 7.3? > > > > It should have been. If it wasn't, that was a serious oversight. > > Not sure if we should change it in 7.3.1 or not, though;

Re: [HACKERS] contrib/ltree patches

2002-12-05 Thread Dan Langille
Thanks for asking. I have been diverted to other tasks and won't be able to get back to this for a short while. The basics work (i.e. population and simple compares) but I know for sure that certain functions will not work now that we allow what were previously operators to be part of the nod

Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster windows shell)

2002-12-05 Thread Igor Georgiev
>I am working on getting a shrink-wrapped version of PostgreSQL for Windows>Currently it installs a customized version of Cygwin, PostgreSQL 7.2.3, cygipc, psqlodbc, and pgadminII>I currently have the setup done.   Cool :)   I'm now working on postmaster windows shell. It's not finished yet

Re: [HACKERS] big text field -> message type 0x44

2002-12-05 Thread Tomas Berndtsson
Tom Lane <[EMAIL PROTECTED]> writes: > Tomas Berndtsson <[EMAIL PROTECTED]> writes: > > After it tries again, it always gets error from recv() for some reason > > that I don't know. I also don't understand why errno is set to ENOTTY > > at this point, that makes no sense at all. > > Are you sure

Re: [HACKERS] contrib/ltree patches

2002-12-05 Thread Teodor Sigaev
Don't do it! It's a wrong patch. Dan will prepare correct patch (with other changes). Bruce Momjian wrote: Dan, is this ready to be applied to CVS? --- Dan Langille wrote: I have been looking at contrib/ltree in the Post

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

2002-12-05 Thread Dave Page
> -Original Message- > From: Scott Lamb [mailto:[EMAIL PROTECTED]] > Sent: 05 December 2002 06:37 > To: [EMAIL PROTECTED] > Subject: Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group > > I'm volunteering to do work here. I could at the very least > go through > the sites and

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

2002-12-05 Thread Dave Page
> -Original Message- > From: Lamar Owen [mailto:[EMAIL PROTECTED]] > Sent: 05 December 2002 04:23 > To: PostgreSQL-development > Subject: Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group > > However, I seriously question the need in the long term for > our sites to be as >