[HACKERS] SQL99 feature list
I've just updated features.sgml to have a list of supported features followed by a list of unsupported ones. There are some items in the unsupported list which look easy to do. I've got patches for a MATCH SIMPLE clause on referential integrity declarations, and am developing patches for CREATE CAST, DROP CAST, and probably a few more items which could be simple parser additions or changes. Look at http://developer.postgresql.org/docs/postgres/features.html for the most recent version (it is not there yet but I'd expect it to be there soon). I'd like to look at supporting the various shorthand literal notations like B'0101', X'ABCD', and N'national' in a better way in the lexer to make sure that the information gets to the parser more robustly. Right now, N'national' is not supported at all and the other two forms are supported by transforming the input locally in the lexer which seems to work but does not extend to the NATIONAL CHARACTER case. Comments and suggestions are welcome. Y'all may want to look at features.sgml to find projects if you are looking for something to do; there are several items which look to be relatively easy to accomplish and others at various levels of difficulty... - Thomas ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] [COMMITTERS] pgsql/src/backend/parser gram.y
Althought that is in the contrib/bind directory. Searching again... Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Christopher Kings-Lynne Sent: Wednesday, 19 June 2002 2:41 PM To: Bruce Momjian; Hackers Subject: Re: [HACKERS] [COMMITTERS] pgsql/src/backend/parser gram.y OK, the offending code is this: case AF_INET6: sin6 = (struct sockaddr_in6 *) addr; for (s = h-h_addr_list; *s != NULL; s++) { if (!memcmp(sin6-sin6_addr.s6_addr8, *s, h-h_length)) return 0; } break; It seems that this is how sin6_addr's type is defined: struct in6_addr { u_int8_ts6_addr[16]; }; so it's s6_addr, NOT s6_addr8. Is it still the same type? Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Christopher Kings-Lynne Sent: Wednesday, 19 June 2002 2:30 PM To: Bruce Momjian Cc: Thomas Lockhart; Bruce Momjian - CVS; [EMAIL PROTECTED] Subject: Re: [COMMITTERS] pgsql/src/backend/parser gram.y Can you give me a hint where to look? I've looked at the code and throught he man pages and can't find the actual structure documented. It's version 4.4 of FreeBSD, and it has ipv6 compiled in (ifconfig -a proves that). I'm searching /usr/src right now... Chris -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 19 June 2002 2:16 PM To: Christopher Kings-Lynne Cc: Thomas Lockhart; Bruce Momjian - CVS; [EMAIL PROTECTED] Subject: Re: [COMMITTERS] pgsql/src/backend/parser gram.y Christopher Kings-Lynne wrote: CVS HEAD does not compile on FreeBSD/Alpha: ./configure --prefix=/home/chriskl/local --enable-integer-datetimes --enable -debug --enable-depend --enable-cassert --with-pam --with-CXX --with-openssl Gives: gmake[3]: Entering directory `/home/chriskl/pgsql-head/src/interfaces/libpq' gcc -pipe -O -g -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -DPI C -I. -I../../../src/include -DFRONTEND -DSYSCONFDIR='/home/chriskl/local/ etc/postgresql' -c -o fe-secure.o fe-secure.c -MMD fe-secure.c: In function `verify_peer': fe-secure.c:417: structure has no member named `s6_addr8' gmake[3]: *** [fe-secure.o] Error 1 gmake[3]: Leaving directory `/home/chriskl/pgsql-head/src/interfaces/libpq' gmake[2]: *** [all] Error 2 gmake[2]: Leaving directory `/home/chriskl/pgsql-head/src/interfaces' gmake[1]: *** [all] Error 2 gmake[1]: Leaving directory `/home/chriskl/pgsql-head/src' gmake: *** [all] Error 2 Of course, it compiles if you disable SSL. :-) Can you look at that line and see if there is something in your OS that matches it? I have KAME here and I thought FreeBSD would have that too. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS] Problem with SSL and IPv6
Bear, there is some IPv6 stuff in fe-secure.c. Is this intended? We don't support IPv6 in the backend yet, do we. We are having portability problems with that 'case' statement and I am considering removing it. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] ECPG won't compile anymore
On Tue, Jun 18, 2002 at 01:57:37PM -0400, Tom Lane wrote: That would be trouble, but considering that we are not even thinking of going beta before late August, is it really a realistic risk? bison Yes. After all it's much easier to sync the two if I get smaller changes. seems to be making releases quite frequently lately. They were at 1.30 back in November, according to my archives, so that's 19 releases in the last 8 months. True. But most of them are not for releases. I have no idea which vesion number will be the one they release. Up to 1.35 they released frequently, but then it stopped and 1.49 is quite far from 1.35. Michael -- Michael Meskes [EMAIL PROTECTED] Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL! ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] ECPG won't compile anymore
On Tue, Jun 18, 2002 at 02:12:45PM -0400, Bruce Momjian wrote: Are we the only ones up against this problem? Hard to imagine we are No, there are more, that's why bison is worked on. Michael -- Michael Meskes [EMAIL PROTECTED] Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL! ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] ecpg and bison again
On Tue, Jun 18, 2002 at 04:41:57PM -0400, Tom Lane wrote: Michael Meskes [EMAIL PROTECTED] writes: How about we add the preproc.c file generated by bison 1.49 to cvs? Could that create problems elsewhere? Yes. It's a bad idea to put derived files in CVS. For one thing, CVS will not guarantee that their timestamps are right compared to the master file. Actually I thought about changing the makefile as well, so preproc.c does not look like a derived file anymore. Michael -- Michael Meskes [EMAIL PROTECTED] Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL! ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly