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

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

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

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 anyo

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

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 P

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

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 extrem

[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: you

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

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 th

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

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 pr

[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. Technical

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

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

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

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

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 d

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 proble

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.

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 PROTECTE

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

2002-06-07 Thread Peter Eisentraut
NunoACHenriques writes: > 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

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

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

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

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) http://sourceforge.net/project

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

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

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

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 l

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 comp

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 w

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 contrib/intarr

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

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 -

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

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

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

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