Re: [HACKERS] Rust bindings to pgtypes lib
I agree with Michael Meskes that duplicating the code is probably not a good idea. Now I see other rust crates just depend on the right libraries to be installed by the developer, so I'll punt the problem until it bites me for real. This confuses me, though > Indeed. I'm quite strongly against exposing / using pgtypeslib in more > places. If anything it should be phased out. Because that code is > definitely not always kept up2date, and it's a lot of work to do so. If > anything the code should be rewritten to *not* require so much > duplication, then we could talk Is this a widespread opinion? If so, perhaps it would be an idea to mention that somewhere in the docs. Just reading them, it would seem to be a nice interface to a library that can do datetime and arbitrary numeric calculation for you. Both areas are very hard to get right. No problem on my part. The target of my small project was to learn some rust by throing myself at it. And I learned more than expected, so the outcome is already fine. If the resulting project also could be of use to me and anybody else, it would just be an extra win. -- Med venlig hilsen Kaare Rasmussen, Jasonic Jasonic: Nordre Fasanvej 12, 2000 Frederiksberg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] Rust bindings to pgtypes lib
Hi For learning purposes (and because I probably need it) , I've started to make Rust bindings to the pgtypes Library. One problem I'm thinking about right now is how to know if, and where, the library and the include files are installed. One way to avoid that problem is to include the source of pgtypeslib in my project, and let the rust build system take care of it *. But is this possible, or feasible? I see that the makefile refers to Makefile.global, and also includes stuff from ecpg, aat least. I don't want to include the whole pg source tree, just the nice, safe, little corner that would be used for this purpose. How much of the source tree would I have to carve out? Or from another perspective; how do other language (if any) solve this? * Not sure it can, but other rust crates seem to do it that way, e.g. https:// github.com/alexcrichton/bzip2-rs -- Med venlig hilsen Kaare Rasmussen, Jasonic Jasonic: Nordre Fasanvej 12, 2000 Frederiksberg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] jsonb array-style subscripting
On 2015-08-17 22:33, Josh Berkus wrote: So, both perl and python do not allow "deep nesting" of assignments. For example: d = { "a" : { } } d["a"]["a1"]["a2"] = 42 Traceback (most recent call last): File "", line 1, in KeyError: 'a1' Not sure I understand what you mean. In Perl you'd do $ perl -e '%d = (a => {}); $d{a}{a1}{a2} = 42; print $d{a}{a1}{a2}' 42 which looks pretty much like what's proposed. /kaare -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] hstore ng index for <@ ?
Hi In many ways the new hstore (and perhaps json) format looks very exciting. But will there ever be (GIN/GIST) index support for <@ ? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Fast insertion indexes: why no developments
On 2013-10-30 12:08, Simon Riggs wrote: effort to replicate what you have already achieved? Who would pay? The NSA, obviously ;-) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Perl 5.18 breaks pl/perl regression tests?
On 2013-06-03 06:55, Michael Paquier wrote: Just by having a look at the release notes of Perl, there are still nothing describing changes between 1.6.3 and 1.8.0: http://perldoc.perl.org/index-history.html That page is not updated, it seems. In this list https://metacpan.org/module/RJBS/perl-5.18.0/pod/perldelta.pod is mentioned "Line numbers at the end of a string eval are no longer off by one. [perl #114658]" -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Unexpected plperl difference between 8.4 and 9.1
On 2012-08-20 18:36, Tom Lane wrote: Alvaro Herrera writes: Excerpts from Alex Hunsaker's message of lun ago 20 12:03:11 -0400 2012: Hrm seems to work for me. What version of perl is this? $ perl -V Summary of my perl5 (revision 5 version 16 subversion 0) configuration: I can reproduce the failure with 5.14.2 Smells like a Perl bug to me. Has anybody attempted to reproduce this just in Perl itself, not PL/Perl? regards, tom lane I can't reproduce it in perl, but it's in PL/perl from 9.2 beta built with perl 5.14.2. Currently I don't have another perl with libperl installed. This produces the error: CREATE OR REPLACE FUNCTION test1() RETURNS SETOF NUMERIC AS $BODY$ use strict; use warnings; for (0..9) { my $rand = rand(); $rand =~ m/(.*)/; return_next($1); } return; $BODY$ LANGUAGE plperl; Adding 'elog(NOTICE, "rand:$rand, :$1");' after the capture maked the error go away. Do does changining the return_next statemtnt to 'my $retvalue=$1;return_next($retvalue);' -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] What Would You Like To Do?
On 2011-09-14 17:27, David E. Wheeler wrote: On Sep 14, 2011, at 5:49 AM, Kaare Rasmussen wrote: [brief]: http://postgresopen.org/2011/schedule/presentations/83/ You list Job scheduling as one item here, but not here Here's my preliminary list: Could you expand your idea about this here? It was something suggested to me on IRC a few months ago, but I don't know who would do it. Also, I think that pgAgent might actually offer the functionality. http://www.pgadmin.org/docs/1.4/pgagent.html I would vote for inclusion of such a feature in PostgreSQL. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] What Would You Like To Do?
Hi [brief]: http://postgresopen.org/2011/schedule/presentations/83/ You list Job scheduling as one item here, but not here Here's my preliminary list: Could you expand your idea about this here? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] Listen/Notify in 9.0
Hi As I understand the changes to the notification system in 9.0, apart from being able to carry a payload, it will guarantee the order of delivery, and also it will keep the notification and notify any listener, even if the listener didn't register at the time of notification. Is this correct? What happens if the listener process dies, for how long time will it take up ressources? What happens if the listener process never picks up the notification, same question? What happens if the same process makes the same LISTEN request again. Will it take up more ressources? -- Med venlig hilsen Kaare Rasmussen, Jasonic Jasonic Telefon: +45 3816 2582 Nordre Fasanvej 12 2000 Frederiksberg Email: ka...@jasonic.dk -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] pg_upgrade project status
Hi > I have had a very brief look at this. Translation to perl doesn't look > difficult. I'll see what I can do during the next week or so. Perhaps I can lend you a hand if you need help with this. -- Med venlig hilsen Kaare Rasmussen, Jasonic Jasonic Telefon: +45 3816 2582 Nordre Fasanvej 12 2000 Frederiksberg Email: ka...@jasonic.dk -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] UUID - Data type inefficient
> You are out to lunch and you dragged me with you. Did we have beer at > least? :-) A bit, and you had a byte of bread. -- Med venlig hilsen Kaare Rasmussen, Jasonic Jasonic Telefon: +45 3816 2582 Nordre Fasanvej 12 2000 Frederiksberg Email: [EMAIL PROTECTED] -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] Re: [ANNOUNCE] == PostgreSQL Weekly News - June 01 2008 ==
David Fetter writes: Alter the xxx_pattern_ops opclasses to use the regular equality operator of the associated datatype as their equality member. This means that these opclasses can now support plain equality comparisons along with LIKE tests, thus avoiding the need for an extra index in some applications. This is interesting, as it will save me a couple of very big indexes. I didn't see that coming, but thanks. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] Questions about indexes with text_pattern_ops
Hi The database is initialized with utf8, so in order for LIKE to use the index on a text field, I used text_pattern_ops when I created it. So far so good. It's in the documentation, but there's no explanation of why this index will only work for LIKE searches. How come that I have to have two different indexes if I want to give Postgres the ability to choose index scan over seq scan on LIKE and non-LIKE searches? Is it a performance issue? Also, when I tried to create the index as a partial one (avoiding the 95% entries with empty strings), Postgresql chooses to use seq scan. This sounds counter intuitive to me. CREATE INDEX new_index ON a (b text_pattern_ops) WHERE b <> ''; This is 8.2.6. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] Release 8.2.0 done, 8.3 development starts
I'm not sure, but as far as I remember, it will be a short release cycle for 8.3 in order to finish some big items that couldn't be ready in time for 8.2. But which items are more or less expected for 8.3? I recall - Hierarchical Queries - On disk bitmap index - Clustered/replication solutions being discussed. What are on people's minds? -- Med venlig hilsen Kaare Rasmussen, Jasonic Jasonic Telefon: +45 3816 2582 Nordre Fasanvej 12 2000 Frederiksberg Email: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] An Idea for planner hints
> SELECT * FROM foo, bar WHERE pg_selectivity(foo.a = bar.a, 0.1); ISTM that you introduced the Oracle silliness again, putting the hint into the query. My suggestion would be to tell about it separately. Something like CREATE HINT FOR JOIN foo, bar ON foo.a=bar.b AS ; This way hints can be added and removed without ever touching the existing queries. -- Med venlig hilsen Kaare Rasmussen, Jasonic Jasonic Telefon: +45 3816 2582 Nordre Fasanvej 12 2000 Frederiksberg Email: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] Three weeks left until feature freeze
> There should be a Procedural Language section on pgfoundry for all of the > PLs, IMHO, and a README in contrib within core that points to it > (README.procedural_languages, if nothing else) ... I thought that the general consensus was that only plpgsql ought to be in core, the rest should be independent projects. It would be nice to have an easy way to retrieve and install the desired PL's but that's more of a packaging issue. -- Med venlig hilsen Kaare Rasmussen, Jasonic Jasonic Telefon: +45 3816 2582 Nordre Fasanvej 12 2000 Frederiksberg Email: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] [ANNOUNCE] PostgreSQL Weekly News - November 13 2005
David Fetter writes in PostgreSQL Weekly News - November 13 2005: Teodor Sigaev has been making lots of improvements to tsearch2, a full-text search engine. I can't find them. Am I blind? Can someone help? ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] Enums again
Just don't use enums - they're awful. In general? So, instead of using enums for order states or originating system, I'll user numbers or text? Or implement lookup tables ? ---(end of broadcast)--- TIP 1: 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] Enums again
I've been going through the thread that Andrew Dunstan started with his enumkit. Maybe I missed it, but I didn't see any conclusion. If I want to design an Open Source system now that may be in beta in three to six months and I'd like to use enums, is this a good place to look? I guess I'm wondering about the kit going into PgFoundry, being accepted in the main branch or being dropped. And the timeframe for all that. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] Testing of MVCC
> Yes it can, but are you going to restrict building or running > regressions to only thos platforms that have our required modules > installed? That might be thought a tad unfriendly. You could include DBD::Pg with the distribution and run it locally. Perhaps even DBI, leaving Perl the only unknown. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] The Contrib Roundup (long)
> Either you're misunderstanding what "reindex database" does (it reindexes > only the system catalogs), or you're misunderstanding what reindexdb does OK, I was taking the face value here. I consider this a bug, or at least a badly thought out name. I can't understand that someone approved 'reindex database' to mean 'reindex the system tables of a database'. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] The Contrib Roundup (long)
> But not as easy as: > psql -c "reindex database {database}" {database} Well it was just to show that there really is no need for a program just for this functionality. ---(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] The Contrib Roundup (long)
> actually I think part of the point of this was to give a command line > version of the reindex command, like we have for vaccum. If that still > matters, then it should probably stay. Actually it should probably be > converted to C and moved to /src/bin. > Wouldn't something like echo 'REINDEX DATABASE {database};' | psql {database} be easier? Of course it would need a working shell, but even Windows can do this, I believe. ---(end of broadcast)--- TIP 8: explain analyze is your friend
[HACKERS] Ingres dump files to PostgreSQL
Hi I have a dump from an Ingres database, one file per table it seems. I went looking on www.postgresql.org for documentation for people who want to move to PostgreSQL from other databases, but I couldn't find any such thing. So, does a convert utility from ingres dump files to PostgreSQL already exist? It's not a big problem for me; I can write a perl program to do the stuff. i just started wondering about it, giving their common ancestry. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Feature freeze date for 8.1
> This has very little to do with "Feature freeze date for 8.1"... And btw I lost track of the thread. was any actual feature freeze date for 8.1 approved? ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] I am in Copenhagen
> I am in Copenhagen and am speaking tomorrow and will return on Sunday. I would have loved to hear your three hour speech about PostgreSQL administration, but unfortunately they put my own presentation at the exact same time, those LinuxForum 2005 bastards! -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Nordre Fasanvej 12 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 12.00-16.00 Web: www.suse.dk ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] SSL Support
Hi > I think verification of the server certificates is not supported either. > SSL only serves for encryption, not authentication or integrity checking > (which is probably a stupid idea). I have this feeling that SSL in PostgreSQL isn't category 1 supported if you can put it that way. Maybe I'm wrong? Another way to ensure encrypted (and authenticated, I believe) connections is to use stunnel with PostgreSQL. I'm not sure which solution is the best. SSL in PostgreSQL is integrated. Stunnel has the advantage of being more generic. having tried none, I don't know about performance. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Nordre Fasanvej 12 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 12.00-16.00 Web: www.suse.dk ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] LinuxTag wrapup
> That's right, and initially they will only serve MySQL, but it will be > extendable to support any db system. It will be GPL (or licenseable, but > since it's a tool and not a platform IMHO GPL is ok). > If things work out as they seem, I'd contribute the pgsql stuff. That would be great news indeed. Currently there is a lack of an Open Source heavy duty database design tool. If it can be compared to Erwin, it will be a big win - if it can do both reverse and forward engineering of databases. Do you know if it will support triggers, FK's, functions, schemas, etc ? ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] Ingres to be released as open source
> Like the article says, I wonder if these is any synergy between the > products. ie. Can we grab features from their codebase? Wouldn't there be a license problem ? Yes, Ingres may be able to pull features from PostgreSQL, but maybe it doesn't work the other way. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 12.00-16.00 Web: www.suse.dk ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] Plan for feature freeze?
> So you are floating the entire thing. I am tired of discussing this. > You call the freeze and when it is a disaster, you can take the credit. People seem to _think_ that they can be ready by June 1st. To allow for unknown problems, why not set a freeze date at June 15? By May 15 this date can be evaluated again. But at this point there should be stronger arguments to push the freeze date. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 12.00-16.00 Web: www.suse.dk ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] Collaboration Tool Proposal
> http://gforge.org/ is not a hosting site, that is why you only found 4 Well that's what you get when you write messages at 2:30 AM. Should know better. But on this topic, does a site based on GForge similar to Sourceforge exist ? -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 12.00-16.00 Web: www.suse.dk ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Collaboration Tool Proposal
> Why GForge? GForge seems to be technically OK. But what about the future outlook. The home page lists 5 projects, whereof the 4 are tests. Are you sure they will not fold in a month or two, will they be reliable, responsive and real nice (the three r's) ? -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 12.00-16.00 Web: www.suse.dk ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] FE/BE Protocol - Specific version
> > If my memory serves me well, Oracle has a number of system triggers. On > > database startup and shutdown and perhaps also on connection start and > > stop. > > > > Sometimes they're very handy. > > Is this a TODO? Is there an API that would make sense for us? I believe it would make sense. But I'm not up to the task to implement it. Maybe if someone is looking into triggers anyway in another context... -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 12.00-16.00 Web: www.suse.dk ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] FE/BE Protocol - Specific version
> It would be nice if we could configure a function to run on connection > start. We have the ability to SET values per db or user, but not to If my memory serves me well, Oracle has a number of system triggers. On database startup and shutdown and perhaps also on connection start and stop. Sometimes they're very handy. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 12.00-16.00 Web: www.suse.dk ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Criteria for contrib/ versus gborg?
> pro contrib/: You have four pro arguments, two of which are for marketing and the other two are for lazyness :-) > pro gborg: As you note, you will be more independent on gborg, so why not? Maybe a wish for some official mention of this - and other important - gborg project in the documentation ? -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 12.00-16.00 Web: www.suse.dk ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Two weeks to feature freeze
> Change that into "* Remove bugs from source code" and get a patent on > it. Should be a nobrainer (as in those guy's have no brains) considering > that NetFlix even got a patent on DVD subscription rentals: And for all the nice royalty money*, think about what can be done to PostgreSQL. Maybe even a test suite :-) * Or maybe the best step is to sue IBM or Microsoft. Then again, maybe not. Do they care about bug removal? ;-) -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 12.00-16.00 Web: www.suse.dk ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] Two weeks to feature freeze
> > That seems too vague for TODO. We might as well add "Make PostgreSQL > > faster". :-) > 'K, can you add that one too? :) How about "* Remove all bugs from the source". Can you put that in TODO ? :-) -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 12.00-16.00 Web: www.suse.dk ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] Changing the default configuration (was Re: [pgsql-advocacy]
> What if we supplied several sample .conf files, and let the user choose > which to copy into the database directory? We could have a "high read Exactly my first thought when reading the proposal for a setting suited for performance tests. > performance" profile, and a "transaction database" profile, and a > "workstation" profile, and a "low impact" profile. We could even supply a And a .benchmark profile :-) > Perl script that would adjust SHMMAX and SHMMALL on platforms where this > can be done from the command line. Or maybe configuration could be adjusted with ./configure if SHMMAX can be determined at that point? -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 12.00-16.00 Web: www.suse.dk ---(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] Windows Build System - who cares?
> IMHO, replication, performance improvements, cross-db queries, etc is > much better use of time than Windows port. Because you don't use Windows. On a personal level, I couldn't agree more. But I have been in a project where they chose MySQL because it had to run on Windows. I would like to be able to propose a free alternative. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 12.00-16.00 Web: www.suse.dk ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Threads
> Umm. No. User or system level threads, the statement is true. If a > thread kills over, the process goes with it. Furthermore, on Win32 Hm. This is a database system. If one of the backend processes dies unexpectedly, I'm not sure I would trust the consistency and state of the others. Or maybe I'm just being chicken. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 12.00-16.00 Web: www.suse.dk ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] 7.4 Wishlist
> And that's all ;) > > Hannu Krosing - and what will you do after January? ;-) Just kidding. I hope you have a big fat bank account if you want to finish all that! -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 12.00-16.00 Web: www.suse.dk ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] One 7.3 item left
> Schema handling - ready? interfaces? client apps? What is the state of the Perl interface? Will it work when 7.3 is released Will it work, but no schema support Will it pop up later on CPAN -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 12.00-16.00 Web: www.suse.dk ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] I am done
> Are you guys competing for the modesty award? ;-) > I heard Stallman is trying to win it this year. :-) Hah, that's a good one. For doing what - telling you not to call it GNU/Linux, only Linux/GNU ? :-) -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 11.00-17.00 Web: www.suse.dk ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Wanted: pgdiff ($$$)
> You might want to check out the perl model Alzabo, I think it's capable of > doing this. It does not (yet) support foreign keys, alas. But if anybody likes to code this, maybe they could work together with the Alzabo developer. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 11.00-17.00 Web: www.suse.dk ---(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] Open 7.3 items
>> Schema handling - ready? interfaces? client apps? > status for JDBC or ODBC; any comments? The other interface libraries > probably don't care. What about DBD::Pg? -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 12.00-18.00Web: www.suse.dk 2000 FrederiksbergLørdag 12.00-16.00 Email:[EMAIL PROTECTED] ---(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] Democracy and organisation : let's make a revolution
Two points to this discussion. I hate to admit this, but to some people, a Windows version is important. Yesterday I learned that one product developed here will have a MySQL implementation because marketing wants a free implementation. The biggest advantage seems to be that it's working on Windows. And the project leader knows of nothing but Windows :-( Next group to impress is Database Designers. I've been looking for a design tool for some time, but there's no Open Source equivalent to ErWin. And ErWin can't create and reverse engineer PostgreSQL databases. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Web: www.suse.dk 2000 FrederiksbergLørdag 11.00-17.00 Email: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Use of /etc/services?
> Is any OS actually shipping us in /etc/services? It's right here in SuSE Linux 8.0. It was not in 7.3, so maybe it's officially included from now on. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] v7.2.1 Released: Critical Bug Fix
> cash I/O improvements (Tom) If it will change the I/O cash flow to more I than O, it will definitely be a success... :-) -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Web: www.suse.dk 2000 FrederiksbergLørdag 11.00-17.00 Email: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Re: Interesting Atricle
> > Thought some people might find this article interesting. > > http://www.zend.com/zend/art/databases.php > The only interesting thing I noticed is how fast it crashes my > Netscape-4.76 browser ;) Use Konqueror :-) I can't tell if the results are biased, but it puts PostgreSQL way ahead of MySQL and Interchange in performance (if more than a couple of simultaneous users) and most other features. Only bad words are about lack of LO support. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Web: www.suse.dk 2000 FrederiksbergLørdag 11.00-17.00 Email: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[HACKERS] Feedback
Just thought that I'd tell you. I've been waiting (very patiently, I think) for a long time for outre joins, views w/ joins and not the least, functions that can handle NULL's in an orderly way. A little anxious I started implementing these elements in my projects, removing the workarounds and patches I've put in there, and - well, they just all work like a charm!! This is great. Working with Windows products, I'm more used to being disappointed whenever people promise that this or that function will be in the next release. But this time, with PostgreSQL, not :-) -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Web: www.suse.dk 2000 FrederiksbergLørdag 11.00-17.00 Email: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Plans for solving the VACUUM problem
> Second: if VACUUM can run in the background, then there's no reason not > to run it fairly frequently. In fact, it could become an automatically > scheduled activity like CHECKPOINT is now, or perhaps even a continuously > running daemon (which was the original conception of it at Berkeley, BTW). Maybe it's obvious, but I'd like to mention that you need some way of setting priority. If it's a daemon, or a process, you an nice it. If not, you need to implement something by yourself. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Web: www.suse.dk 2000 FrederiksbergLørdag 11.00-17.00 Email: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS] Search
In developers corner, search returns this: #!/usr/bin/perl print "Content-type: text/html\r\n\r\n"; print "\r\n\r\n"; -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Web: www.suse.dk 2000 FrederiksbergLørdag 11.00-17.00 Email: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] Re: New Linux xfs/reiser file systems
> Sure, we can do that now. What do we do when these are the default file > systems for Linux? We can tell them to create other types of file What is a 'default file system' ? I know that untill now, everybody is using ext2. But that's only because there hasn't been anything comparable. Now we se ReiserFS, and my SuSE installation offers the choice. In the future, I believe that people can choose from ext2, ReiserFS,xfs, ext3 and maybe more. > systems, but that is a pretty big hurdle. I wonder if it would be > easier to get reiser/xfs to make some modifications. No, I don't think it's a big hurdle. If you just want to play with PostgreSQL, you wont care. If you're serious, you'll repartition. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Web: www.suse.dk 2000 FrederiksbergLørdag 11.00-17.00 Email: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [HACKERS] Re: New Linux xfs/reiser file systems
> > kernel to do it for us. Reimplementing a filesystem doesn't strike me > > as a profitable use of our time.) > Ditto. The database is complicated enough. Maybe some kind of recommendation would be a good thing. That is, if the PostgreSQL community has enough knowledge. A section in the docs that discusses various file systems, so people can make an intelligent choice. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Web: www.suse.dk 2000 FrederiksbergLørdag 11.00-17.00 Email: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] SAP DB Featuers
I found it myself: SQL Features - SQL 92 entry level with several extensions - Oracle 7 compatibility mode Key benefits - Referential integrity (to be defined in CREATE TABLE or ALTER Table statement) - Stored procedures - After statement trigger (INSERT/UPDATE/DELETE) - Updateable views, although not every view is updateable - Datatype BOOLEAN - A number of functions including functions for date values - Maximum length of object names is 32 characters - Subtransactions - Sequences (number generator) - Roles (compositions of user authorizations that can be granted/revoked as a whole) - Subselects that can be specified in the FROM clause of a query - Outer joins - Scrollable cursor -Temporary tables that will be destroyed if the application ends the session These tables can be created within a stored procedure and selected from outside this procedure. They are updateable, although there is no implicit update of the rows that created the temporary table. -Explicit and implicit locking on row level NOT supported features: - Collations - Result sets that are created within a stored procedure and fetched outside. This feature is planned to be offered in one of the coming releases. Meanwhile, use temporary tables. - Multi version concurrency for OLTP It is available with the object extension of SAPDB only. - Hot stand by This feature is planned to be offered in one of the coming releases. Enterprise Features - The Microsoft cluster server is supported. For other systems scripts have to be written according to the failover solution of the system. - Online backup - Online expansion of the database - No explicit reorganization - Supported backup tools: -- ADSM + adint2 Networker Netvault, HiBack (soon) Backint for Oracle Tools supporting this interface are: ARCserve, Backup Express, dbBRZ for R/3, DBVAULT, DoroStore, EASY_BASE, EMC, EPOCH, FDR/UPSTREAM, HIBACK, HSMS-CL Backint, NetBackup, NetVault, NetWorker, Omniback, Seagate Backup, SESAM, Solstice Backup, Sys-Save, TIME NAVIGATOR for R/3, Tivoli Programming Interfaces - ODBC - C/C++ Precompiler (Embedded SQL) - JDBC - Perl DBI - Python - PHP -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 11.00-17.00 Web: www.suse.dk ---(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] SAPDB Open Souce
> I downloaded it. The directories are two characters in length, the > files are numbers, and it is a mixture of C++, Python, and Pascal. Need > I say more. :-) Yes! You, or better someone who knows SAP DB could tell if it's "probably the most complete free database system available right now, with much more features than interbase, mysql or postgresql" as this guy Hemos says on Slashdot. I remember the same being said about Interbase when it was OSS'ed, but I still stick to PostgreSQL. But knowledge doesn't hurt, and as someone pointed out, you can't tell the quality of the software from the names of your source code. But it sure makes it a lot more difficult to understand what's going on, I'll grant you that :-) -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 11.00-17.00 Web: www.suse.dk ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] PL/SQL and null
I think I remember something about PL/SQL having trouble when passing null to a function. But searchinf for pl/sql and null doesn't bring any informative links. I can go through the steps of a function one by one in psql and everything works fine. But when I call the function with nulls for some of the parameters, it doesn't work. What puzzles me more is that I tried to pass 0 (zero) instead and then let the function subsitute it with null (simple IF param = 0 then v_param := null thing). Still no luck. I'm using 7.0.3. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 11.00-17.00 Web: www.suse.dk ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] Re: Week number
> traditional notion (at least in the US; I suspect this is true in most > European countries at least) of Sunday being "the first day of week". I believe that in most European countries, Monday is the first day of the week. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 11.00-17.00 Web: www.suse.dk ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[HACKERS] Internationalized dates (was Internationalized error messages)
Now you're talking about i18n, maybe someone could think about input and output of dates in local language. As fas as I can tell, PostgreSQL will only use English for dates, eg January, February and weekdays, Monday, Tuesday etc. Not the local name. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 11.00-17.00 Web: www.suse.dk ---(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] Monitor status
> There is also a component of netsaint (www.netsaint.org) that will > check PostgreSQL postmasters. I hope to add to that the ability to Thanks. I've also seen a lot of announcements of OpenNMS at freshmeat. All I know is that it's Java based, and as fas as I can tell will work without agents. Can any of these operate in a mixed Linux / Win2000 environment (I'd like to have one tool only for NMS. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 11.00-17.00 Web: www.suse.dk
[HACKERS] Monitor status
Hi I've tried to search the site, but no usable pages turned up. My question is about monitoring PostgreSQL and if it turns out to be "down" to notify a person to take action. I'm surprised that I couldn't find anything about it. Does anyone have an advice ? Anything that will fit into ordinary NMS. Maybe SNMP will not fit, but then some kind of "database ping", or equal. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECTED] 2000 FrederiksbergLørdag 11.00-17.00 Web: www.suse.dk
[HACKERS] PostgreSQL web page
I wonder why http://www.postgresql.org is not updated with news. The latest "Latest News" is from Nov 16. I have to go to http://www.pgsql.com to find some interesting news later than that: 2000-12-22 PostgreSQL, Inc. Releases Open Source Replication & Database and2000-12-12 2000 Linux Journal Editor's Choice Award for Best Database In fact I was looking for the Replication server. No mention seems to be available on postgresql.org. Also the mailing list archive for pgsql-sql is not listed here: http://www.postgresql.org/devel-corner/index.html - but you can see it if you write the correct URL yourself. -- Kaare Rasmussen --Linux, spil,--Tlf:3816 2582 Kaki Data tshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Email: [EMAIL PROTECTED] 2000 Frederiksberg Lørdag 11.00-17.00 Web: www.suse.dk