[HACKERS] Re: Re: Hey guys, check this out.
At 08:38 PM 15-04-2001 -0700, you wrote: On Sun, Apr 15, 2001 at 10:05:46PM -0400, Vince Vielhaber wrote: On Mon, 16 Apr 2001, Lincoln Yeoh wrote: Maybe you guys should get some Great Bridge marketing/PR person to handle stuff like this. After reading Ned's comments I figured that's how it got that way in the first place. But that's just speculation. You probably figured wrong. All those publications have editors who generally feel they're not doing their job if they don't introduce errors, usually without even talking to the reporter. That's probably how the "FreeBSD" reference got in there: somebody saw "Berkeley" and decided "FreeBSD" would look more "techie". It's stupid, but nothng to excoriate the reporter about. Sometime back we were announcing a product and practically wrote everything for the journalists and gave it to them so that they could just print it, and one newspaper still got LOTs of things wrong. In contrast another newspaper was much better tho - facts right. The standards haven't changed much, so I don't really bother reading the first newspaper for a lot of things. Whereas the 2nd one still seems to do ok for tech stuff. They're very rarely 100% correct. But they're primarily journalists, if they were even 99.99% correct about things they'd probably be releasing Postgresql 8 instead of you guys ;). I believe you should choose your battles. Sometimes it's just not worth fighting, not even worth commenting. Other times it's almost compulsory even though there's no obvious/direct _personal_ gain in it. Also look at the various stories and commentary floating about in the media about the recent US-China plane incident. And what really happened? I figure at least one of the planes should have a video recording of the incident. But we have everyone guessing what happened instead. Doh. Cheerio, Link. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[HACKERS] Too many open files in system
What does this error mean - and how can I avoid it in the future? postmaster: StreamConnection: accept: Too many open files in system Any help would be much appreciated! Ryan Mahoney ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] Re: Too many open files in system
[EMAIL PROTECTED] wrote: What does this error mean - and how can I avoid it in the future? postmaster: StreamConnection: accept: Too many open files in system Any help would be much appreciated! Ryan Mahoney It would be helpful if you could give more information, but if you are running Linux, you may need to bump up the maximum number of open files. cat /proc/sys/fs/file-nr Will spit out three numbers: is the maximum number of files you have opened. is the number of files which are currently open is the system configured maximum number of files. if is very close to than you should adjust the maximum number of files your system can use echo 16384 /proc/sys/fs/file-max where 16384 is the desired number. -- I'm not offering myself as an example; every life evolves by its own laws. http://www.mohawksoft.com ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] RE: [BUGS] Problem with 7.0.3 dump - 7.1b4 restore
I noticed that 7.1 has officially been released. Does anyone know the status of the bug I reported regarding encoding problems when dumping a 7.0 db an restoring on 7.1? Thanks, --Rainer ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] cvs postgres doesn't compile with libreadline 4.2
On Sat, 14 Apr 2001, Peter Eisentraut wrote: andrea gelmini writes: debian unstable, i386. upgrade libreadline 4.2 postgres doesn't compile. It seems there were some incompatible changes in readline 4.2. Use version 4.1 until we have a fix. The essence of the problem seems to be in the following lines of readline.h that comes with libreadline 4.2 (/usr/include/readline/readline.h): Line 415-429 #if 0 /* Backwards compatibility (compat.c). These will go away sometime. */ extern void free_undo_list __P((void)); extern int maybe_save_line __P((void)); extern int maybe_unsave_line __P((void)); extern int maybe_replace_line __P((void)); extern int ding __P((void)); extern int alphabetic __P((int)); extern int crlf __P((void)); extern char **completion_matches __P((char *, rl_compentry_func_t *)); extern char *username_completion_function __P((const char *, int)); extern char *filename_completion_function __P((const char *, int)); #endif And the fix to make it compile is the following: src/bin/psql/tab-complete.c Line 64: char *filename_completion_function(char *, int); should read char *rl_filename_completion_function(char *, int); Readline continued to work for me after having upgraded my Debian to the latest unstable release (which apparently contained alse libreadline 4.2) and patching the tab-complete.c file. Sorry for the "pseudodiff" but hopefully it gives a clue. Since I do not know much about libreadline and its history I hope someone else will tell how the actual patch should look like (so it would work with older versions). Juhan Ernits ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] Re: [PATCHES] Patch for PostgreSQL 7.0.3 to compile on Tru64 UNIX v5.0A with Compaq C T6.4-212 (dtk)
No, those don't do it. We need an actual NaN value. These are just flags, I think. gmake -C adt SUBSYS.o gmake[4]: Entering directory `/usr/users/dcarmich/postgresql-7.1/src/ backend/utils/adt' cc -std -O4 -Olimit 2000 -I../../../../src/include -c -o float.o float.c cc: Error: float.c, line 251: In this statement, the libraries on this platform do not yet support compile-time evaluation of the constant expression "0.0/0.0". (constfoldns) val = NAN; --^ Where does the "-O4" come from? That level of optimization probably is forcing the compile-time constant folding, which is causing trouble. Try backing off to "-O2" or turn off optimization all together and I'll bet it will compile. Another possibility is to go into the adt/ subdirectory, compile float.o by cutting and pasting the line above (substituting -O0 for -O4) and then go back up and resume the make from the top. - Thomas ---(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] Re: [PATCHES] Patch for PostgreSQL 7.0.3 to compile on Tru64 UNIX v5.0A with Compaq C T6.4-212 (dtk)
Thomas Lockhart [EMAIL PROTECTED] writes: cc -std -O4 -Olimit 2000 -I../../../../src/include -c -o float.o float.c cc: Error: float.c, line 251: In this statement, the libraries on this platform do not yet support compile-time evaluation of the constant expression "0.0/0.0". (constfoldns) Where does the "-O4" come from? That level of optimization probably is forcing the compile-time constant folding, which is causing trouble. Looks like it's coming from src/template/osf. If Douglas can confirm that a lower -O level makes the compiler complaint go away, then we need to change that template. BTW, the other arm of the osf template looks pretty bogus too: isn't it forcing no optimizations for gcc? I'd have expected CFLAGS=-O2 for gcc. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] 7.1 on 7.1
PostgreSQL 7.1 on Red Hat Linux 7.1[1]: All 76 tests passed. I'll submit it to the website soonish. [1] Available this morning, http://www.redhat.com/about/presscenter/2001/press_sevenone.html -- Trond Eivind Glomsrd Red Hat, Inc. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS] Re: 7.1 on 7.1
PostgreSQL 7.1 on Red Hat Linux 7.1[1]: All 76 tests passed. -- Trond Eivind Glomsrd Red Hat, Inc. It's about time RH saw the light and sync'd their release labeling with ours ;) - Thomas ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] 7.1 on 7.1
Trond Eivind Glomsrd wrote: PostgreSQL 7.1 on Red Hat Linux 7.1[1]: All 76 tests passed. I'll submit it to the website soonish. [1] Available this morning, http://www.redhat.com/about/presscenter/2001/press_sevenone.html And RPMs are also available for 7.1 on 7.1 in our RPM area. Red Hat 7.1 is _nice_. The PostgreSQL speed appears to be very good, compared to 6.2/7.0 with the 2.2 kernel. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS] integer arrays
I have looked and I have looked, it is not immediately clear to me how integer arrays are passed to C function. create table fubar (vars integer[]) ; select c_function(vars) from fubar; insert into fubar (vars) values ('{1,2,3,4,5,6}'); extern "C" c_function (varlena var) { int * pn = (int *)VARDATA(var); } Now, what should "pn" have in it? I don't see my values until later on in the array. I guess I am asking is what is the format of this type, and more importantly, where is it documented. I looked in catalog and pg_types but it wasn't clear it was defined there. -- I'm not offering myself as an example; every life evolves by its own laws. http://www.mohawksoft.com ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] integer arrays
mlw [EMAIL PROTECTED] writes: I have looked and I have looked, it is not immediately clear to me how integer arrays are passed to C function. See src/include/utils/array.h, also src/backend/utils/adt/arrayfuncs.c and src/backend/utils/adt/arrayutils.c. Beware: this code is pretty messy. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[HACKERS] No printable 7.1 docs?
On Sun, Apr 15, 2001 at 01:11:34PM -0400, Mitch Vincent wrote: The "Current Release Docs" on the PostgreSQL website still look 7.0.Xish.. I can't finh the 7.1 PS docs anywhere. The stuff in the doc directory on the FTP sites is from last year, and the docs in the tar files are all SGML and HTML. I could really use a printable copy, but last time I tried to generate it from the SGML, it was a nightmare (and afterward, I discovered that the release docs are apparently made by hand anyway). Am I missing something? -- Christopher Masto Senior Network Monkey NetMonger Communications [EMAIL PROTECTED][EMAIL PROTECTED]http://www.netmonger.net Free yourself, free your machine, free the daemon -- http://www.freebsd.org/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] No printable 7.1 docs?
They're not ready yet. Vince. On Mon, 16 Apr 2001, Christopher Masto wrote: On Sun, Apr 15, 2001 at 01:11:34PM -0400, Mitch Vincent wrote: The "Current Release Docs" on the PostgreSQL website still look 7.0.Xish.. I can't finh the 7.1 PS docs anywhere. The stuff in the doc directory on the FTP sites is from last year, and the docs in the tar files are all SGML and HTML. I could really use a printable copy, but last time I tried to generate it from the SGML, it was a nightmare (and afterward, I discovered that the release docs are apparently made by hand anyway). Am I missing something? -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] Re: No printable 7.1 docs?
They're not ready yet. Since they were deemed non-essential for this release, and since the release schedule is not built around their creation, I no longer feel obligated to have them finished on the release date. A nice change from the deadlines I've been working on for the last three years or so :) This is the first release with the "no hardcopy" policy, and user feedback is certainly desirable and appreciated. I hope to be able to find time to finish them soon; a couple are essentially done already, but the Reference Manual will be problematic as usual (the jade RTF output is not handled by M$Word, and exhibits the same symptoms as when read by Applixware). - Thomas ---(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] Truncation of object names
Call me thick as two planks, but when you guys constantly refer to 'schema support' in PostgreSQL, what exactly are you referring to? Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane Sent: Saturday, 14 April 2001 5:46 AM To: [EMAIL PROTECTED] Subject: Re: [HACKERS] Truncation of object names [EMAIL PROTECTED] (Nathan Myers) writes: On Fri, Apr 13, 2001 at 04:27:15PM -0400, Tom Lane wrote: Have you thought about simply increasing NAMEDATALEN in your installation? If you really are generating names that aren't unique in 31 characters, that seems like the way to go ... We discussed that, and will probably do it (too). One problem is that, having translated "foo.bar.baz" to "foo_bar_baz", you have a problem when you encounter "foo.bar_baz" in subsequent code. So it's not really so much that NAMEDATALEN is too short for your individual names, it's that you are concatenating names as a workaround for the lack of schema support. FWIW, I believe schemas are very high on the priority list for 7.2 ... regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] broken web server?
I know this isn't really hackers traffic, but... one of the servers in www.postgresql.org is http://postgresql.bbksys.com/ which is giving me 404 errors.. I've mailed webmaster@, but thought this should be mailed on anyway.. - brandon b. palmer, [EMAIL PROTECTED] pgp: www.crimelabs.net/bpalmer.pgp5 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
RE: [HACKERS] Truncation of object names
The ability to place database objects into a logical partitioning of data. For example, in Oracle, each user creates tables, views, sequences, synonyms, and snapshots in their own schema. So if I were to create a table called 'Employees', I could query it as: SELECT * FROM employees; But another user would have to query it as: SELECT * FROM mascarm.employees; A common case for this is to logically divide schema by departments. You could do that now in PostgreSQL in the form of multiple databases, but you couldn't query across them. For example, you might have an "Accounting" schema, and an "Inventory" schema. Occassionally, the accountants need to join tables from accounting w/inventory. The inventory people (or the dba) would then grant appropriate privileges for the accountants to do that, but the accounts would have to fully qualify their queries: SELECT * FROM inventory.orders; So, if you want a logical division that also contain some shared tables, views, or sequences (and hopefully snapshots, some day), in Oracle, you can create public synonyms for the shared objects: CREATE PUBLIC SYNONYM employees FOR mascarm.employees; Now, anyone can query this table as: SELECT * FROM employees; Its a namespace thing, basically. Hope that helps, Mike Mascari [EMAIL PROTECTED] -Original Message- From: Christopher Kings-Lynne [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 10:17 PM To: [EMAIL PROTECTED] Subject:RE: [HACKERS] Truncation of object names Call me thick as two planks, but when you guys constantly refer to 'schema support' in PostgreSQL, what exactly are you referring to? Chris ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[HACKERS] JDBC Select Performance
Hi, While doing some testing with Postgresql 7.1, I noticed some perculiar behaviour with the JDBC driver. Selecting a single record from a table is 5-10 times slower than doing an insert (even if the table only contains a single record, and the select query does not contain any join). On Oracle database, an insert is always slower than a select when running the same test. At the moment, I've narrowed down the time consuming section of the code to ExecSQL() method in the org.postgresql.Connection class. There seems to be a "while" loop over a "switch" statement which I yet need to figure out what it is doing. Anybody has any idea why this section of code is so slow? Note: I'm using Mandrake 7.2, IBM JDK 1.3 on 1Ghz Athlon with 256 RAM. The Postgresql 7.1 is compiled with multibyte character turned on. The Select statement itself takes 1-5 seconds which is almost 100 times slower than Oracle on the same PC. This is even without opening connection factored in. Thomas Hii _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
re: NetBSD Bad address failure (was Re: [HACKERS] Third call for platform testing)
yes, this is a bug in netbsd-current that was introduced with about 5 month ago with the new unified buffer cache system. it has been fixed. thanks. From: Chuck Silvers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: CVS commit: syssrc Date: Mon, 16 Apr 2001 17:37:44 +0300 (EEST) Module Name:syssrc Committed By: chs Date: Mon Apr 16 14:37:44 UTC 2001 Modified Files: syssrc/sys/nfs: nfs_bio.c Log Message: reads at or after EOF should "succeed". To generate a diff of this commit: cvs rdiff -r1.65 -r1.66 syssrc/sys/nfs/nfs_bio.c Please note that diffs are not public domain; they are subject to the copyright notices on the relevant files. ---(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
[HACKERS] RedHat/Postgres.pm Error
May I please ask you guys a question about Postgres.pm. Right now I'm working on a Red Hat 6.2, Apache 1.3.9 and Perl5. I've finally got Apache setup which was no easy task even with a $80.00 Mohawk GUI administration front end. But now I get the following from my perl/cgi program error: Can't locate loadable object for module Postgres in @INC (@INC contains: /usr/lib/perl5/5.00503/i386-linux /usr/lib/perl5/5.00503 /usr/lib/perl5/site_perl/5.005/i386-linux /usr/lib/perl5/site_perl/5.005 And the script_errors.log says: Can't locate Postgres.pm in @INC. I moved a Postgres.pm from Solaris to all 4 of this directories in @INC and it is still not "found." I did a word search at www.postgresql.org for Postgres.pm and found nothing. I did find in 1998 someone had exactly this problem with Postgres95 at: http://www.postgresql.org/mhonarc/pgsql-admin/1998-05/msg00063.html I loaded postgres using the download postgresql-7.0.3.tar.gz. Can anyone point me in the right direction? Infinite Thanks for your help and a super database product :o) Allan in Belgium ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [HACKERS] Re: No printable 7.1 docs?
On Tue, Apr 17, 2001 at 12:07:26AM +, Thomas Lockhart wrote: They're not ready yet. Since they were deemed non-essential for this release, and since the release schedule is not built around their creation, I no longer feel obligated to have them finished on the release date. A nice change from the deadlines I've been working on for the last three years or so :) This is the first release with the "no hardcopy" policy, and user feedback is certainly desirable and appreciated. My feedback at this time is mostly the desire to know a bit better what prevents the hardcopy docs from being built automatically. I am currently having some trouble compiling jadetex, so I can't take a look at the generated PDF yet, but I assume there's something wrong with it. That seems like a big deficiency in the doc tools, which suprises me, given that they're rather large projects that have been used by other large projects for quite a while. My interest is partly to be able to compile the docs on my own, and partly research - I'm involved in the development of an application that has some hefty documentation requirements, and I was hoping that SGML + free software would come to the rescue. If it's just a matter of time and effort, this may be an big enough area of overlap with work that I can spend Official Time and/or Official Money on it. -- Christopher Masto Senior Network Monkey NetMonger Communications [EMAIL PROTECTED][EMAIL PROTECTED]http://www.netmonger.net Free yourself, free your machine, free the daemon -- http://www.freebsd.org/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl