Re: [HACKERS] UnixWare on Current CVS: Success!
--On Sunday, August 24, 2003 22:49:00 -0400 Bruce Momjian [EMAIL PROTECTED] wrote: OK, I now realized this code is shell script, not Makefile content. Code changed to: THREAD_CFLAGS = $THREAD_CFLAGS -D_REENTRANT Ok, but we are **STILL** broke for the --enable-thread-safety flag due to your commit requiring all 3 *_r (gethostbyname, strerror, and getpwuid) functions, even though all UnixWare has is the getpwuid_r function. Please either revert that requirement, or apply a patch to allow UnixWare to compile with --enable-thread-safety by making the change to src/port/thread.c to use a HAVE_GETPWUID_R flag, and arrange for configure to set that flag. Thanks, LER - -- Larry Rosenman wrote: Didn't seem to. Did you see my posts from fri/sat on -hackers? I included what DID work for me. LER --On Sunday, August 24, 2003 19:21:57 -0400 Bruce Momjian [EMAIL PROTECTED] wrote: Larry Rosenman wrote: On Aug 17 2003, [EMAIL PROTECTED] wrote: Did something changed on today's cvs. src/template/unixware is wrong on last line: THREAD_CFLAGS += -D_REENTRANT should be THREAD_CFLAGS=$THREAD_CFLAGS -D_REENTRANT No it shouldn't The original patch worked just fine... I'll look when I get back from Forum. I changed the define to be: THREAD_CFLAGS += -D_REENTRANT Do the quotations help? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] UnixWare on Current CVS: Success!
I am working my way through my email to that ***ISSUE*** (*** looks kind of silly, doesn't it). If you are putting those stars there because I am not working on that issue fast enough for you, well ... --- Larry Rosenman wrote: --On Sunday, August 24, 2003 22:49:00 -0400 Bruce Momjian [EMAIL PROTECTED] wrote: OK, I now realized this code is shell script, not Makefile content. Code changed to: THREAD_CFLAGS = $THREAD_CFLAGS -D_REENTRANT Ok, but we are **STILL** broke for the --enable-thread-safety flag due to your commit requiring all 3 *_r (gethostbyname, strerror, and getpwuid) functions, even though all UnixWare has is the getpwuid_r function. Please either revert that requirement, or apply a patch to allow UnixWare to compile with --enable-thread-safety by making the change to src/port/thread.c to use a HAVE_GETPWUID_R flag, and arrange for configure to set that flag. Thanks, LER - -- Larry Rosenman wrote: Didn't seem to. Did you see my posts from fri/sat on -hackers? I included what DID work for me. LER --On Sunday, August 24, 2003 19:21:57 -0400 Bruce Momjian [EMAIL PROTECTED] wrote: Larry Rosenman wrote: On Aug 17 2003, [EMAIL PROTECTED] wrote: Did something changed on today's cvs. src/template/unixware is wrong on last line: THREAD_CFLAGS += -D_REENTRANT should be THREAD_CFLAGS=$THREAD_CFLAGS -D_REENTRANT No it shouldn't The original patch worked just fine... I'll look when I get back from Forum. I changed the define to be: THREAD_CFLAGS += -D_REENTRANT Do the quotations help? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] UnixWare on Current CVS: Success!
--On Sunday, August 24, 2003 23:17:07 -0400 Bruce Momjian [EMAIL PROTECTED] wrote: I am working my way through my email to that ***ISSUE*** (*** looks kind of silly, doesn't it). If you are putting those stars there because I am not working on that issue fast enough for you, well ... I posted stuff on Friday/Saturday with no comment, as soon as I returned from Las Vegas. So, I'm a little cranky. Sorry. LER - -- Larry Rosenman wrote: --On Sunday, August 24, 2003 22:49:00 -0400 Bruce Momjian [EMAIL PROTECTED] wrote: OK, I now realized this code is shell script, not Makefile content. Code changed to: THREAD_CFLAGS = $THREAD_CFLAGS -D_REENTRANT Ok, but we are **STILL** broke for the --enable-thread-safety flag due to your commit requiring all 3 *_r (gethostbyname, strerror, and getpwuid) functions, even though all UnixWare has is the getpwuid_r function. Please either revert that requirement, or apply a patch to allow UnixWare to compile with --enable-thread-safety by making the change to src/port/thread.c to use a HAVE_GETPWUID_R flag, and arrange for configure to set that flag. Thanks, LER -- --- -- Larry Rosenman wrote: Didn't seem to. Did you see my posts from fri/sat on -hackers? I included what DID work for me. LER --On Sunday, August 24, 2003 19:21:57 -0400 Bruce Momjian [EMAIL PROTECTED] wrote: Larry Rosenman wrote: On Aug 17 2003, [EMAIL PROTECTED] wrote: Did something changed on today's cvs. src/template/unixware is wrong on last line: THREAD_CFLAGS += -D_REENTRANT should be THREAD_CFLAGS=$THREAD_CFLAGS -D_REENTRANT No it shouldn't The original patch worked just fine... I'll look when I get back from Forum. I changed the define to be: THREAD_CFLAGS += -D_REENTRANT Do the quotations help? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: Parsing speed (was Re: [HACKERS] pgstats_initstats() cost)
Tom Lane wrote: Christopher Kings-Lynne [EMAIL PROTECTED] writes: ... If that's what we think we want, we'd better put it on the wish-list for 7.5. If we had a Parse function, then we at phpPgAdmin could allow Reports to contain parameters, and detect as such, and then when they run their report, they can enter the values for that run. If you want to do that, then I think you need the whole nine yards including DescribeStatement support. Too late for 7.4, but let's make it a TODO for 7.5: * Add a libpq function to support Parse/DescribeStatement capability Added. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] UnixWare on Current CVS: Success!
OK, I now realized this code is shell script, not Makefile content. Code changed to: THREAD_CFLAGS = $THREAD_CFLAGS -D_REENTRANT --- Larry Rosenman wrote: Didn't seem to. Did you see my posts from fri/sat on -hackers? I included what DID work for me. LER --On Sunday, August 24, 2003 19:21:57 -0400 Bruce Momjian [EMAIL PROTECTED] wrote: Larry Rosenman wrote: On Aug 17 2003, [EMAIL PROTECTED] wrote: Did something changed on today's cvs. src/template/unixware is wrong on last line: THREAD_CFLAGS += -D_REENTRANT should be THREAD_CFLAGS=$THREAD_CFLAGS -D_REENTRANT No it shouldn't The original patch worked just fine... I'll look when I get back from Forum. I changed the define to be: THREAD_CFLAGS += -D_REENTRANT Do the quotations help? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] UnixWare on Current CVS: Success!
NP. We will get this fixed. I am still thinking about it, and will do something when I get to that email. I am trying to avoid having a template/* variable for each *_r function, but that may be required. The try for *_r library and continue if you can't find it just seems too risky. We might have to add those three variables and you set to yes/no in each template file for each platform. --- Larry Rosenman wrote: --On Sunday, August 24, 2003 23:17:07 -0400 Bruce Momjian [EMAIL PROTECTED] wrote: I am working my way through my email to that ***ISSUE*** (*** looks kind of silly, doesn't it). If you are putting those stars there because I am not working on that issue fast enough for you, well ... I posted stuff on Friday/Saturday with no comment, as soon as I returned from Las Vegas. So, I'm a little cranky. Sorry. LER - -- Larry Rosenman wrote: --On Sunday, August 24, 2003 22:49:00 -0400 Bruce Momjian [EMAIL PROTECTED] wrote: OK, I now realized this code is shell script, not Makefile content. Code changed to: THREAD_CFLAGS = $THREAD_CFLAGS -D_REENTRANT Ok, but we are **STILL** broke for the --enable-thread-safety flag due to your commit requiring all 3 *_r (gethostbyname, strerror, and getpwuid) functions, even though all UnixWare has is the getpwuid_r function. Please either revert that requirement, or apply a patch to allow UnixWare to compile with --enable-thread-safety by making the change to src/port/thread.c to use a HAVE_GETPWUID_R flag, and arrange for configure to set that flag. Thanks, LER -- --- -- Larry Rosenman wrote: Didn't seem to. Did you see my posts from fri/sat on -hackers? I included what DID work for me. LER --On Sunday, August 24, 2003 19:21:57 -0400 Bruce Momjian [EMAIL PROTECTED] wrote: Larry Rosenman wrote: On Aug 17 2003, [EMAIL PROTECTED] wrote: Did something changed on today's cvs. src/template/unixware is wrong on last line: THREAD_CFLAGS += -D_REENTRANT should be THREAD_CFLAGS=$THREAD_CFLAGS -D_REENTRANT No it shouldn't The original patch worked just fine... I'll look when I get back from Forum. I changed the define to be: THREAD_CFLAGS += -D_REENTRANT Do the quotations help? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 8: explain analyze is your friend -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] UnixWare on Current CVS: Success!
Didn't seem to. Did you see my posts from fri/sat on -hackers? I included what DID work for me. LER --On Sunday, August 24, 2003 19:21:57 -0400 Bruce Momjian [EMAIL PROTECTED] wrote: Larry Rosenman wrote: On Aug 17 2003, [EMAIL PROTECTED] wrote: Did something changed on today's cvs. src/template/unixware is wrong on last line: THREAD_CFLAGS += -D_REENTRANT should be THREAD_CFLAGS=$THREAD_CFLAGS -D_REENTRANT No it shouldn't The original patch worked just fine... I'll look when I get back from Forum. I changed the define to be: THREAD_CFLAGS += -D_REENTRANT Do the quotations help? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Single-file DBs WAS: Need concrete 'Why Postgres
This makes sense to me. I sense a TODO item :-) (My dim and possibly incorrect memory of administering Ingres around 10 years ago was that it supported both raw devices and file system based databases. We opted for a file system base, for reasons others have mentioned here, but I seem to recall we used a raw device for the transaction log for performance reasons. But, as the saying goes, that was a long time ago, and in another country.) andrew Tom wrote Andrew Dunstan [EMAIL PROTECTED] writes: Is anyone seriously suggesting that postgres should support either raw devices or use some sort of virtual file system? If not, this whole discussion is way off topic. I have zero interest in actually doing it. However, it'd be nice if the existing storage manager API were clean enough that our response to this type of question could be sure, go implement it, and when you're done let us know what performance improvement you see. We've allowed the smgr API to degenerate over the years. CREATE/DROP DATABASE both bypass it, and the support for alternate database locations messes up the API pretty thoroughly (not that there's anything clean about that feature at all), and I think there are some other issues with specific commands bypassing the smgr abstractions. I think it would be reasonable to fix this as part of the tablespaces work that people keep wanting to do. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] I am back
I have finished the training in Atlanta, and I am back on the job; going through email now. Seems I have events scheduled every month or every other month for the forseeable future. I have Mexico in September, Germany in November, and Denmark in January. I also have possible events for October and February. Each event is roughly one week. I have had luck in getting local folks to represent PostgreSQL at many local events, and our advocacy team is doing that too. However, it is often necessary for me to attend if they want a lot of PostgreSQL content or need a big name for the event. I have to decide if I should continue in that role for the project. I do think it is important for our visibility and for growing the community. Opinions? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] UnixWare on Current CVS: Success!
Larry Rosenman wrote: On Aug 17 2003, [EMAIL PROTECTED] wrote: Did something changed on today's cvs. src/template/unixware is wrong on last line: THREAD_CFLAGS += -D_REENTRANT should be THREAD_CFLAGS=$THREAD_CFLAGS -D_REENTRANT No it shouldn't The original patch worked just fine... I'll look when I get back from Forum. I changed the define to be: THREAD_CFLAGS += -D_REENTRANT Do the quotations help? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] I am back
On Sun, 24 Aug 2003, Bruce Momjian wrote: I have to decide if I should continue in that role for the project. I do think it is important for our visibility and for growing the community. That really should be up to you. Conferences are a great way to lift the project's profile, and PostgreSQL talks are very popular and well attended. However, as your email seems to suggest, they're pretty time consuming and generally pretty far away from home. I was definately feeling this last year. To that end, I've spoken to a hand full of people over the last few weeks and am trying to find time to put together notes/slides for some prepackaged talks which people can deliver to their local user groups/conferences. Thanks, Gavin ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[HACKERS] LOCK.tag(figuring out granularity of lock)
following is taken from postgresql-7.3.2/src/backend/storage/lmgr/readme: If we are setting a table level lock both the blockId and tupleId (in an item pointer this is called the position) are set to invalid, if it is a page level lock the blockId is valid, while the tupleId is still invalid. Finally if this is a tuple level lock (we currently never do this) then both the blockId and tupleId are set to valid specifications. is blockId same as tag.objId.blkno? what field in LOCK.tag is tupleId? thanks jenny _ Get MSN 8 and help protect your children with advanced parental controls. http://join.msn.com/?page=features/parental ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] I am back
Gavin Sherry wrote: On Sun, 24 Aug 2003, Bruce Momjian wrote: I have to decide if I should continue in that role for the project. I do think it is important for our visibility and for growing the community. That really should be up to you. Conferences are a great way to lift the project's profile, and PostgreSQL talks are very popular and well attended. However, as your email seems to suggest, they're pretty time consuming and generally pretty far away from home. I was definitely feeling this last year. I don't mind the trips. I usually look forward to it, then a few days before, I dread it because my life has to stop while I travel, then when I return I realize how valuable the trip was, and I catch up on my email. The only downside is my being away from email for a week every month. I read some email while I am away, but I don't have the time to read most of it because the trips are usually busy times for me. To that end, I've spoken to a hand full of people over the last few weeks and am trying to find time to put together notes/slides for some prepackaged talks which people can deliver to their local user groups/conferences. You can use my PostgreSQL: Past, Present, Future talk for that. What I usually do is to talk on the phone with the presenter beforehand and go over the slides and any questions they have, and they can make the presentation. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[HACKERS] NOTICE vs WARNING
Can someone explain in succinct and general terms what the difference between a NOTICE and a WARNING is? I'm currently examining the validity of notice and warning messages throughout the backend, but I find these categories to be applied inconsistently. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] PostgreSQL 7.4 Beta 1 + SSL + Cygwin
Thomas, On Sun, Aug 24, 2003 at 04:55:42PM -0400, Jason Tishler wrote: On Thu, Aug 21, 2003 at 11:10:05AM -0500, Thomas Swan wrote: On 8/8/2003 5:49 AM, Jason Tishler wrote: Is this just the --with-openssl option? Does it build cleanly under Cygwin? If so, would you like me to include this in the next Cygwin PostgreSQL release? 7.4beta1 would not compile under Cygwin with or without SSL. However, the CVS tip for 2003/08/20 did compile and run under Cygwin both with and without SSL. I had to adjust some path variables to include cygwin/usr/lib and cygwin/usr/lib/postgresql. postgresql was configured with ./configure --prefix=/usr --with-openssl make make install I used ipc-daemon2, and I had to use cygwin.dll v1.5.x. I will give CVS tip a ride and try to supply a patch. AFAICT, CVS updated on 2003/08/25 at approximately 2:00 PM ET, configured as: configure --enable-multibyte --with-python --with-perl --with-java --with-CXX --with-openssl ... builds cleanly under Cygwin 1.5.2-1 and cygipc 2.01-2. The above without SSL builds cleanly too. Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[HACKERS] SSL Connections
Hello: I'm developing a TLS library in C# for my PostgreSQL ADO.NET Data Provider, i can work well using the openssl test server, using: openssl s_server -accept 443 -key server.key -cert server.crt -tls1 -bugs But when i try to use it for connect to postgresql (7.4 on Windows+Cygwin) i get always this message in the postgresql log: LOG: could not initialize SSL connection: tls rsa encrypted value length is wrong Any idea of what can be the problem ?? ( i that it's anything related to the creation of the certificate but i don't know what :), can be better to ask this in the Openssl support list ??) -- Best regards Carlos Guzmán Álvarez Vigo-Spain ---(end of broadcast)--- TIP 8: explain analyze is your friend