Re: [HACKERS] Roadmap for a Win32 port

2002-06-07 Thread Dave Page
-Original Message- From: Steve Howe [mailto:[EMAIL PROTECTED]] Sent: 06 June 2002 02:37 To: Bruce Momjian Cc: PostgreSQL-development Subject: Re: Roadmap for a Win32 port Hello Bruce, Wednesday, June 5, 2002, 1:33:44 AM, you wrote: BM INSTALLER BM - BM We

Re: [HACKERS] Use of /etc/services?

2002-06-07 Thread Marc G. Fournier
FreeBSD On Fri, 7 Jun 2002, Bruce Momjian wrote: Peter Eisentraut wrote: Since we now have an official entry in /etc/services, shouldn't we be able to make use of it, by using getservbyname() if a nonnumeric port number is specified? Is any OS actually shipping us in /etc/services?

Re: [HACKERS] Per tuple overhead, cmin, cmax, OID

2002-06-07 Thread Marc G. Fournier
On Fri, 7 Jun 2002, Bruce Momjian wrote: Tom Lane wrote: Manfred Koizar [EMAIL PROTECTED] writes: No comment on a planned 7.3 timeframe? :-( I think we are planning to go beta in late summer (end of August, say). Probably in July we'll start pressing people to finish up any major

Re: [HACKERS] Use of /etc/services?

2002-06-07 Thread Roderick A. Anderson
I see PostgreSQL in /etc/services on an upgraded Redhat Linux 7.3 system. Don't think it was me adding it since I didn't have PG running on the system. Rod -- Please don't tell my mother I'm a System Administrator. She thinks I play piano in a bordello.

[HACKERS] Missing types in C header files

2002-06-07 Thread Tony Griffiths
Hi, I'm trying to start to program with the PostgreSQL's geometric primitive types, and have started to write some code using them (PostgreSQL version 7.1.3, installed from source). However when I include the file utils/geo_decls.h I get an error starting that the type PGFunction (found in a file

Re: [HACKERS] Use of /etc/services?

2002-06-07 Thread NunoACHenriques
Hi! Mandrake Linux release 8.1 also and without postgres rpms installed. [nach@golfinho ~]$ cat /etc/services | grep 5432 # 5432-5434 Unassigned postgres5432/tcp# POSTGRES postgres5432/udp# POSTGRES

Re: [HACKERS] Use of /etc/services?

2002-06-07 Thread Andrew Sullivan
Debian woody (to be 3.0 RSN . . . or something) has this in /etc/services: postgres5432/tcp# POSTGRES postgres5432/udp# POSTGRES A -- Andrew Sullivan 87 Mowat Avenue Liberty RMS

[HACKERS] pgAdmin schema updates complete

2002-06-07 Thread Dave Page
I have just committed the last of the schema related changes to pgAdmin to CVS. This was a significant amount of work and there are bound to be some bugs, so if you have a Windows PC a little spare time, I would appreciate it if you could find some time to try it out with any of PostgreSQL

Re: [HACKERS] patch for contrib/intarray (7.2 and 7.3) (fwd)

2002-06-07 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://candle.pha.pa.us/cgi-bin/pgpatches I will try to apply it within the next 48 hours. --- Oleg Bartunov wrote: Patch to

Re: [HACKERS] Per tuple overhead, cmin, cmax, OID

2002-06-07 Thread Bruce Momjian
Marc G. Fournier wrote: On Fri, 7 Jun 2002, Bruce Momjian wrote: Tom Lane wrote: Manfred Koizar [EMAIL PROTECTED] writes: No comment on a planned 7.3 timeframe? :-( I think we are planning to go beta in late summer (end of August, say). Probably in July we'll start pressing

Re: [HACKERS] Use of /etc/services?

2002-06-07 Thread Michael Alan Dorman
Bruce Momjian [EMAIL PROTECTED] writes: Peter Eisentraut wrote: Since we now have an official entry in /etc/services, shouldn't we be able to make use of it, by using getservbyname() if a nonnumeric port number is specified? Is any OS actually shipping us in /etc/services? Debian

Re: [HACKERS] [SQL] PostgreSQL on AIX

2002-06-07 Thread Zeugswetter Andreas SB SD
Anyway, I am pretty sure that PostgreSQL is not the culprit here. As it happens this project is back on the table for me so it is interesting that your email popped up now. I just compiled the latest version of PostgreSQL on my AIX system and it generated lots of errors and then

Re: [HACKERS] Per tuple overhead, cmin, cmax, OID

2002-06-07 Thread Marc G. Fournier
On Fri, 7 Jun 2002, Bruce Momjian wrote: Marc G. Fournier wrote: On Fri, 7 Jun 2002, Bruce Momjian wrote: Tom Lane wrote: Manfred Koizar [EMAIL PROTECTED] writes: No comment on a planned 7.3 timeframe? :-( I think we are planning to go beta in late summer (end of August,

Re: [HACKERS] Per tuple overhead, cmin, cmax, OID

2002-06-07 Thread Bruce Momjian
Marc G. Fournier wrote: On Fri, 7 Jun 2002, Bruce Momjian wrote: I am concerned about slowing down too early. We did that in previous releases and didn't get the beta focus we needed, and it was too paralyzing on people to know what is to be slowed and what to keep going. I

Re: [HACKERS] Per tuple overhead, cmin, cmax, OID

2002-06-07 Thread Marc G. Fournier
On Fri, 7 Jun 2002, Bruce Momjian wrote: I will say that I was disapointed by previous release delays and will be more vocal about moving things forward than I have in the past. I don't know ... I kinda like being able to confidently say to clients that the latest release is always the most

Re: [HACKERS] Per tuple overhead, cmin, cmax, OID

2002-06-07 Thread Bruce Momjian
Marc G. Fournier wrote: On Fri, 7 Jun 2002, Bruce Momjian wrote: I will say that I was disappointed by previous release delays and will be more vocal about moving things forward than I have in the past. I don't know ... I kinda like being able to confidently say to clients that the

Re: [HACKERS] Roadmap for a Win32 port

2002-06-07 Thread Peter Eisentraut
Bruce Momjian writes: GUI --- pgAdmin2 http://pgadmin.postgresql.org/pgadmin2.php?ContentID=1 pgaccesshttp://pgaccess.org/ Java admin (to be written) Dev-C++ admin (to be written)

Re: [HACKERS] Use of /etc/services?

2002-06-07 Thread Larry Rosenman
On Fri, 2002-06-07 at 10:55, Michael Alan Dorman wrote: Bruce Momjian [EMAIL PROTECTED] writes: Peter Eisentraut wrote: Since we now have an official entry in /etc/services, shouldn't we be able to make use of it, by using getservbyname() if a nonnumeric port number is specified? Is

Re: [HACKERS] Per tuple overhead, cmin, cmax, OID

2002-06-07 Thread Manfred Koizar
On Fri, 7 Jun 2002 02:01:40 -0400 (EDT), Bruce Momjian [EMAIL PROTECTED] wrote: I think it is inevitable that there be enough binary file changes the pg_upgrade will not work for 7.3 --- it just seems it is only a matter of time. As far as it concerns changes proposed by me, I'll (try to)

Re: [HACKERS] Per tuple overhead, cmin, cmax, OID

2002-06-07 Thread Bruce Momjian
Manfred Koizar wrote: On Fri, 7 Jun 2002 02:01:40 -0400 (EDT), Bruce Momjian [EMAIL PROTECTED] wrote: I think it is inevitable that there be enough binary file changes the pg_upgrade will not work for 7.3 --- it just seems it is only a matter of time. As far as it concerns changes

Re: [HACKERS] patch for contrib/intarray (7.2 and 7.3) (fwd)

2002-06-07 Thread Bruce Momjian
Patch applied to 7.2.X and 7.3. Thanks. --- Oleg Bartunov wrote: Patch to contrib/intarray is attached to this message. Please apply it to 7.2 and CVS Regards, Oleg

Re: [HACKERS] revised sample SRF C function; proposed SRF API

2002-06-07 Thread Joe Conway
Tom Lane wrote: Definitely better. I'd suggest also thinking about whether the same/similar macros can support functions that return a set of a scalar (non-tuple) datatype. In my mind, the cleanest design would be some base macros that support functions-returning-set (of anything), and if

[HACKERS] Question whether this is a known problem in 7.1.2

2002-06-07 Thread Rachit Siamwalla
This problem was discovered in 7.1.2. Was wondering whether this is a known problem or not; we plan to test this on the latest postgres sometime later. We have a large table, lets call it A, millions of rows. And in the table is a field called time, which is TIMESTAMP type. We have an index

[HACKERS] How can we help?

2002-06-07 Thread Scott Shattuck
Hi all! Sorry for the length of this but I'm trying to get an idea of where my company can contribute to the best effect so I have a number of questions. To begin with my team and I have some energy/time/$ over the coming months to put directly into PostgreSQL-related development work.

Re: [HACKERS] Question whether this is a known problem in 7.1.2

2002-06-07 Thread Rachit Siamwalla
By the way, a colleague just reproduced this problem on a 7.2.1 postgres. -Original Message- From: Rachit Siamwalla [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 4:27 PM To: pgsql-hackers; Paul Menage Subject: [HACKERS] Question whether this is a known problem in 7.1.2 This

Re: [HACKERS] Use of /etc/services?

2002-06-07 Thread Peter Eisentraut
Bruce Momjian writes: Sure, then let's start using getservbyname(), if it works. One thing that had occurred to me is that this probably doesn't work in Java, so you couldn't do configure --with-pgport=postgresql. That reduces the potential value a lot. -- Peter Eisentraut [EMAIL

Re: [HACKERS] Missing types in C header files

2002-06-07 Thread Peter Eisentraut
Tony Griffiths writes: I've done a search of all the header files in my installation (and also all the source files that I compiled), and cannot find the definition of the PGFunction type. Does anyone have any idea of where I can find this definition, or of why it might be missing. fmgr.h

Re: [HACKERS] Roadmap for a Win32 port

2002-06-07 Thread Peter Eisentraut
Bruce Momjian writes: I know I have discouraged it because I think shell script language has a good toolset for those applications. I have fixed all the spacing issues. My point is that it is not, for the reasons that I listed. Handling spaces is a small part of one of the several

Re: [HACKERS] NO CREATE TABLE

2002-06-07 Thread Bruce Momjian
Marcia Abade wrote: Please, I saw some articles about de implementation off some security rules like NO CREATE TABLE and the possibility of the implementation in version 7.2 of PostgreSQL. Could you confirm this information? Is there this implementation in 7.2? If not, what coul I do to

[HACKERS] postgresql.conf - debug_level

2002-06-07 Thread Rod Taylor
After uncommenting this I receive errors about it not being a valid option. I assume this has been replaced by (server|client)_min_messages? In which case it should be removed from what initdb installs. -- Rod ---(end of broadcast)--- TIP 2:

[HACKERS] Timestamp/Interval proposals: Part 2

2002-06-07 Thread Josh Berkus
Developers, Here's part to of my proposal to enhance, improve, and fix Timestamp and Interval in PostgreSQL. Part I is included after Part II in case everyone has forgotten it. Please give me feedback on this. My interest is that I develop calendaring apps based on Postgresql, and the

[HACKERS] Internals question about buffers

2002-06-07 Thread Bruce Momjian
I received this question about buffer management. Can someone answer it? --- [EMAIL PROTECTED] wrote: Dear Mr. Momjian: First let me thank you for the great work you have done on PostgreSQL. This is a huge project,

Re: [HACKERS] ipv6

2002-06-07 Thread Bruce Momjian
Tom Lane wrote: Ola Sundell [EMAIL PROTECTED] writes: Whatever happened to that patch that Paul Vixie sent in, that was supposed to be applied? Why is it still in the TODO list? Because Paul hasn't fixed the outstanding problems with it: as submitted, it reverted the painfully-agreed-to

Re: [HACKERS] Missing types in C header files

2002-06-07 Thread Thomas Lockhart
Tony Griffiths wrote: Hi, I'm trying to start to program with the PostgreSQL's geometric primitive types, and have started to write some code using them (PostgreSQL version 7.1.3, installed from source). However when I include the file utils/geo_decls.h I get an error starting that the

Re: [HACKERS] How can we help?

2002-06-07 Thread Neil Conway
On Fri, 7 Jun 2002 17:43:03 -0600 Scott Shattuck [EMAIL PROTECTED] wrote: On the process side, is there an IRC or other chat-based system in place for the PG team to coordinate their efforts? There's #postgresql on efnet and irc.openprojects.net, but it's mostly used for user support. If we

Re: [HACKERS] Timestamp/Interval proposals: Part 2

2002-06-07 Thread Thomas Lockhart
Please give me feedback on this... There are a few problems currently with the Interval data type. The biggest is that the current rules give us no clear path for implementation of a full set of operators. The SQL92 standard is no help here; its implementation is unintuitive and extremely

Re: [HACKERS] [SQL] PostgreSQL on AIX

2002-06-07 Thread Bruce Momjian
D'Arcy J.M. Cain wrote: On June 5, 2002 12:33 pm, Bruce Momjian wrote: D'Arcy J.M. Cain wrote: On May 13, 2002 12:50 am, Rajesh Kumar Mallah. wrote: Catching up on an old mailbox, Bruce? :-) Now if only I could get IBM to understand that. They still claim that my problem is

Re: [HACKERS] [SQL] PostgreSQL on AIX

2002-06-07 Thread Bruce Momjian
Also, Tatsuo uses AIX a lot and knows all the issues. --- Travis Hoyt wrote: I've been using PosgreSQL 7.2 on AIX 4.3.3 with no probelms at all. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: [HACKERS] [SQL] PostgreSQL on AIX

2002-06-07 Thread Bruce Momjian
Zeugswetter Andreas SB SD wrote: Anyway, I am pretty sure that PostgreSQL is not the culprit here. As it happens this project is back on the table for me so it is interesting that your email popped up now. I just compiled the latest version of PostgreSQL on my AIX system and it

Re: [HACKERS] postgresql.conf - debug_level

2002-06-07 Thread Bruce Momjian
Rod Taylor wrote: After uncommenting this I receive errors about it not being a valid option. I assume this has been replaced by (server|client)_min_messages? In which case it should be removed from what initdb installs. Thanks. Fixed. -- Bruce Momjian|

Re: [HACKERS] Per tuple overhead, cmin, cmax, OID

2002-06-07 Thread Tom Lane
Uh guys ... what I *said* was: I think we are planning to go beta in late summer (end of August, say). Probably in July we'll start pressing people to finish up any major development items, or admit that they won't happen for 7.3. By which I meant that in July we should start hounding anyone

Re: [HACKERS] Schemas: status report, call for developers

2002-06-07 Thread Bruce Momjian
Tom Lane wrote: If you don't create schemas then you get backwards-compatible behavior (all the users end up sharing the public schema as their current schema). I am a little uncomfortable about this. It means that CREATE TABLE will create a table in 'public' if the user doesn't have a

Re: [HACKERS] Internals question about buffers

2002-06-07 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Is there a race condition in ReadBufferInternal() ? No. As the comments in bufmgr.c point out, this is not bufmgr.c's problem: * ReadBuffer -- returns a buffer containing the requested * block of the requested relation. If the blknum *

Re: [HACKERS] Schemas: status report, call for developers

2002-06-07 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: I am a little uncomfortable about this. It means that CREATE TABLE will create a table in 'public' if the user doesn't have a schema of their own, and in their private schema if it exists. I seems strange to have such a distinction based on whether a

Re: [INTERFACES] [HACKERS] Schemas: status report, call for developers

2002-06-07 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I am a little uncomfortable about this. It means that CREATE TABLE will create a table in 'public' if the user doesn't have a schema of their own, and in their private schema if it exists. I seems strange to have such a

Re: [HACKERS] How can we help?

2002-06-07 Thread Scott Shattuck
First of all thanks for the feedback! There's #postgresql on efnet and irc.openprojects.net, but it's mostly used for user support. The offer for development coordination channel(s) stands if other folks are interested. ...snip... I can't speak to the backup/recovery efforts -- since