Re: [HACKERS] cvsweb
.--[ Tom Lane wrote (2001/10/02 at 09:47:41) ]-- | | Vince Vielhaber <[EMAIL PROTECTED]> writes: | > cvsweb is now working! It's available from the developer's site: | > http://developer.postgresql.org/ | | Thankyouthankyouthankyouthankyou ... I hadn't realized how much I'd come | to depend on that service, until I didn't have it for awhile ... manual | use of "cvs log" and "cvs diff" is a poor substitute. | | regards, tom lane | `- Oops my original try at this only went to Tom ( sorry for the duplicate Tom ). It appears the cvs log functionality is working just fine, however you can't actually view the source of the file by clicking on the revision number. Clicking on: http://developer.postgresql.org/cvsweb.cgi/src/bin/psql/command.c?rev=1.58&content-type=text/x-cvsweb-markup To view src/bin/psql/command.c gives me the following error: Error: Unexpected output from cvs co: cvs [checkout aborted]: /cvsroot/pgsql/CVSROOT: No such file or directory Check whether the directory /cvsroot/pgsql/CVSROOT exists and the script has write-access to the CVSROOT/history file if it exists. The script needs to place lock files in the directory the file is in as well. - Frank Wiles <[EMAIL PROTECTED]> http://frank.wiles.org - ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] @(#)Mordred Labs advisory 0x0004: Multiple buffer overflows inPostgreSQL. (fwd)
.--[ Dann Corbit wrote (2002/08/20 at 14:05:37) ]-- | | ... [large snip] ... | | Well, of course, a well mannered team member would report the bugs | through one of the normal channels. | On the other hand, a malicious tester who finds these problems performs | two valuable services: | 1. Through great effort, he has found a problem that needs to be | addressed or serious consequences will result. | | ... [small snip] ... | `- Reading the TODO list is "great effort"? What puzzles me most is that you speak as if you have personal knowledge of how much effort it took. ----- Frank Wiles <[EMAIL PROTECTED]> http://frank.wiles.org - ---(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] Something I don't understand with the use of schemas
On Mon, 12 Dec 2005 14:05:03 -0600 "Jim C. Nasby" <[EMAIL PROTECTED]> wrote: > I think it would be a huge benefit to have something equivalent to > sudo for psql (though maybe it could be generalized more). Having to > change to a different connection/authorization anytime you need to do > something requiring superuser is a real pita, and encourages things > like making yourself a superuser. Me too. I think this would be a great feature. ----- Frank Wiles <[EMAIL PROTECTED]> http://www.wiles.org - ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] PostgreSQL port to pure Java?
On Tue, 9 Dec 2003 07:15:41 -0800 (PST) Ivelin Ivanov <[EMAIL PROTECTED]> wrote: > > Has this subject been discussed before? > I did not find any references to it in the archives. > > I think that a co-bundle between an open source J2EE > container like JBoss and a scalable database like > PostgreSQL will be a blast. > > There are several well performing comercial Java dbs > out there and there is Hypersonic which is free and > fast, but supports only READ_UNCOMMITED and is build > to grow up to ~200MB. This would be a huge undertaking, rewriting PostgreSQL entirely in Java. Not to mention it would kill PostgreSQL's current speedy performance! - Frank Wiles <[EMAIL PROTECTED]> http://frank.wiles.org - ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgsql-www] [HACKERS] The Name Game: postgresql.net vs.
On Fri, 12 Mar 2004 13:36:47 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > the projects site will not be under postgresql.org ... > > postgresql.net is available for it, but not postgresql.org ... we > > are keeping that domain"clean" for any future stuff we want to do > > with the core project ... > > I agree we don't want .postgresql.org, as that is likely to > risk name conflicts. However, that objection doesn't apply to > .projects.postgresql.org, or variants of that. So far the > only objection I've heard to that sort of setup is "the domain name is > too long", and as others have pointed out, it's a weak objection. > > Since we do already own pgfoundry.org, could we satisfy everybody by > dual-naming the project sites? That is, have both > .pgfoundry.org > .pgfoundry.postgresql.org > point to the same place? My first vote would have been for postgresql.net, but I think .projects.postgresql.org makes the most sense. If I wasn't "in the know" I wouldn't associate .pgfoundry.(pgfoundry|postgresql).org with a PostgreSQL related projects by looking at the URL only. As for the "length" of the URL, I think any developer or user of PostgreSQL is knowledgeable enough to take advantage of browser bookmarks. :) I'm definitely against using 'pgfoundry.org' as I believe sub-projects should all fall under the currently used postgresql.org domain. Another thing to think about is search engine placement. Most search engines give higher listings to keywords that are in the domain name. While people will search for 'postgres' and/or 'postgresql' no one is going to come up with 'pgfoundry' on their own. - Frank Wiles <[EMAIL PROTECTED]> http://frank.wiles.org - ---(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] linked list rewrite
On Tue, 23 Mar 2004 08:39:21 -0800 Sailesh Krishnamurthy <[EMAIL PROTECTED]> wrote: > Which brings me to another question .. has anybody considered using > subversion instead of CVS ? I for one would love to see more Open Source projects like PostgreSQL move to using subversion instead of CVS. I've been using it for awhile now on my little projects and it's a joy to work with. --------- Frank Wiles <[EMAIL PROTECTED]> http://frank.wiles.org - ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: subversion vs cvs (Was: Re: [HACKERS] linked list rewrite)
On Tue, 23 Mar 2004 23:03:03 -0400 (AST) "Marc G. Fournier" <[EMAIL PROTECTED]> wrote: > On Tue, 23 Mar 2004, Sailesh Krishnamurthy wrote: > > > Which brings me to another question .. has anybody considered using > > subversion instead of CVS ? > > Why? not that I'm for a chance from something that isn't broken, but > what advantages does subversion give us over what we already have? Subversion has lots of "little" benefits, but nothing that would be a major incentive to switch. The biggest benefits I can think of of the top of my head are: * Commits are actually atomic * protocol sends diffs in both directions which speeds up everything * branching and tagging are cheap constant time operations * the time it takes to make changes is based on the size of the change, not the size of the project * whole directories are versioned not just files. So for example if you for some reason wanted to rename src/backend/bootstrap.c to src/backend/bootup.c you wouldn't lose your revision history information. Same thing goes for complete reorganizations of the file layouts. * You can checkout "parts" of a project so if you need to fix a bug in 7.3.6's src/backend/ you only have to transfer that portion to you. * cvs diff ( well svn diff ) can be done offline. Same with 'status' which shows you your local modifications and 'revert' which reverts your changes back to your last checkout/update/etc. * Revisions numbers are repository wide instead of by file. You can refer to revision #14328 on hackers and everyone knows exactly what you are talking about and can switch their working copies to it easily ( svn switch -r 14328 ). It's sort of like having a tag for every commit made to the repository. It does have some downsides that I have found, most notibly that the size of your sources you have in your working copy are essentially doubled. There is a copy in your .svn directory that allows the offline status, diff, and revert commands to work. - Frank Wiles <[EMAIL PROTECTED]> http://frank.wiles.org - ---(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] Converting postgresql.conf parameters to kilobytes
On Wed, 02 Jun 2004 11:05:43 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > Shridhar Daithankar <[EMAIL PROTECTED]> writes: > >> I remain unalterably opposed to the notion of measuring > >shared_buffers> in KB, but if you think you can get such a thing in > >over my objections, > > > Are you OK with MBs? I am fine with anything. > > No, I'm not. shared_buffers should be measured in buffers (ie, > pages). Anything else is obscurantism. Not to mention highly likely > to confuse people who are used to how it's been set in the past. This may be an unreasonable suggestion, but how about allowing both? I've seen several configuration systems do the following: shared_buffers = 1 ( shared_buffers in pages ) shared_buffers = 100M ( 100 MBs of shared_buffers ) shared_buffers = 2048K ( 2MBs of shared_buffers ) Using something like this would leave the old functionality in tact, allow users to use what they like, and shouldn't introduce that much complexity into the code. - Frank Wiles <[EMAIL PROTECTED]> http://frank.wiles.org - ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] Converting postgresql.conf parameters to kilobytes
On Fri, 4 Jun 2004 13:10:02 +0300 Marko Karppinen <[EMAIL PROTECTED]> wrote: > Frank Wiles wrote: > > shared_buffers = 1 ( shared_buffers in pages ) > > shared_buffers = 100M ( 100 MBs of shared_buffers ) > > shared_buffers = 2048K ( 2MBs of shared_buffers ) > > I don't know if this is pedantic or just obsessive-compulsive, > but I think it should be MB and KB (or more properly, kB) > instead of just M and K, to distinguish from kilopages > or megapages. I can't see why anyone would have a problem with that. That extra keystroke isn't going to give anyone carpal tunnel! :) - Frank Wiles <[EMAIL PROTECTED]> http://frank.wiles.org - ---(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] BLOBs and a virtual file system
On Wed, 23 Jun 2004 15:07:42 -0400 Peter Martini <[EMAIL PROTECTED]> wrote: > I'm not sure what you mean by breaking blobs transactional integrity. > Do you mean by allowing filesystem type access, the blobs won't be > properly locked and updated during a transaction? If so, that's > exactly what I'm trying to achieve - a compromise between forcing the > files to be stored solely in the database (maintaining integrity but > sacrificing functionality) or referencing their names to gain > functionality, but at a greater cost. > More to the point, wouldn't file locking mechanisms, and the > possibility of limiting file visibility through the virtual > filesystem, allow transactional integrity to be maintained? If not, > could you explain where the problem is so I can look further into it? I believe the problem is that the blob could be in several different states inside of several different transactions. How do you determine which you show in the filesystem? Even if the file system is read only you still have this problem of "which" of the many possible BLOBs to reveal. - Frank Wiles <[EMAIL PROTECTED]> http://frank.wiles.org - ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] implementation guide
On Mon, 30 Aug 2004 19:09:34 -0500 "Ramy M. Hassan" <[EMAIL PROTECTED]> wrote: > Hi all, > > Is there any updated implementation guide for postgresql 7.x ? I've > been using the postgres95 guide at > http://pluto.iis.nsk.su/postgres95/impl-guide/ > > but it is incomplete and also it does not reflect the current state of > the code. I can see many structures were modified since postgres95. You'll want to take a look at: http://developer.postgresql.org/ There are lots of docs there on the internals, etc. - Frank Wiles <[EMAIL PROTECTED]> http://www.wiles.org - ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] cant execute yyparse() within postgresql
On Tue, 21 Dec 2004 10:50:25 -0800 (PST) Sibtay Abbas <[EMAIL PROTECTED]> wrote: > i never happen to read this rule when i signed up to > this mailing list...so if you ve made up a rule by > urself for this mailing list just do us a favor by > officially announcing it > > i think anyone who has knowledge of adding new > languages to postgresql will understand what pl call > handler means. > > i ve been getting alot of help from this mailing list > and i thank all the ppl who helped me. > > Peter's attitude was rude and i complain against it > and i ask the mailing list maintainers to follow up on > this. I don't believe Peter was trying to be rude. And while it isn't a "rule" per se, the more information you can provide in a question the more you increase your chances of someone having an answer for you. Something along the lines of "I'm trying to add a new language to postgresql and I need to be able to X from within Y" etc, etc, etc. will go a lot futher than "I can't X from within Y". - Frank Wiles <[EMAIL PROTECTED]> http://www.wiles.org - ---(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] Want to add to contrib.... xmldbx
On 30 Jan 2006 11:35:13 -0500 Robert Treat <[EMAIL PROTECTED]> wrote: > > >>> CPAN modules, Ruby gems, PgFoundry ingots? :) > > >>> > > >> > > >> Tusks? (Extensions of the elephant.) > > >> > > >> > > >> > > > > > > Trunks? > > > > Dung? > > > > gives a whole new meaning to the term "package delivery" What about calling it "Peanuts" since I hear elephants like those? - Frank Wiles <[EMAIL PROTECTED]> http://www.wiles.org - ---(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
[HACKERS] TODO list problem or am I way off base?
Hey Guys, Sorry if this should go to another list, but I was looking over the TODO list for something small I could cut my teeth on and noticed you have the following listed in the TODO in the 'Source Code' section: * Add --port flag to regression tests And based on what I can tell the shell script src/test/regress/pg_regress.sh already has the ability to define the port with --port. It sets the PGPORT environment variable. ----- Frank Wiles <[EMAIL PROTECTED]> http://frank.wiles.org - ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] Speeding up operations
On Wed, 13 Aug 2003 10:53:39 +0530 "Rahul_Iyer" <[EMAIL PROTECTED]> wrote: > hi... > im on a project using Postgres. The project involves, at times, upto > 5,000,000 inserts. I was checking the performance of Postgres for 5M > inserts into a 2 column table (one col=integer, 2nd col=character). I > used the Prepare... and execute method, so i basically had 5M execute > statements and 1 prepare statement. Postgres took 144min for this... > is there any way to improve this performance? if so, how? btw, im > using it on a SPARC/Solaris 2.6. > thanx in adv > rahul > > P.S: Kindly point me towards any relevant documentation as well. If this is a one time insert you'll want to remove any indexes and rebuild them after the inserts are done. Also you'll want to look into the COPY command here: http://www.postgresql.org/docs/7.3/static/sql-copy.html Loading the data from file like this is probably going to be much faster than from a script and/or program. - Frank Wiles <[EMAIL PROTECTED]> http://frank.wiles.org - ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] Can't CREATE INDEX on a schema?
On Wed, 15 Oct 2003 14:54:43 -0300 (ADT) "Marc G. Fournier" <[EMAIL PROTECTED]> wrote: > > or am I doing it wrong? > > ams=# create index company_1.traffic_ip on company_1.traffic > using btree ( ip_id ) ; ERROR: parser: parse error at or near "." at > character 27 > > > ---(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 > It works if you leave the period out of the index name. Not sure why it errors, but if you replace the period with an underscore it'll create. - Frank Wiles <[EMAIL PROTECTED]> http://frank.wiles.org - ---(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] .NET driver
On Thu, 02 Aug 2007 18:19:36 -0400 Andrew Dunstan <[EMAIL PROTECTED]> wrote: > Brar Piening wrote: > > Robert Treat schrieb: > >> That would be nice. Of course none of this seems relevant to > >> hackers, so I'd > > Your'e right - of course. > > > > But sometimes I wish 'hackers' would care a little more about their > > interfaces as the best backend can't be good without good > > interfaces and some of the PostgreSQL-interfaces don't reach the > > standard they are reaching for other databases. > > As a windows-user I still can't drag and drop a Dataset in VS.Net > > with Npgsql and I still have to build a single-threaded perl if i > > want to use DBD::Pg (I know about DBD::PgPP). > > > > > This latter is simply not true. > > ActiveState Perl is threaded and DBD::Pg works just fine with it. In > fact, you don't need to build your own - just get the one from > pgfoundry: And I've been using a threaded Perl on Linux/BSD systems for years. In fact, unless someone recompiles Perl every Fedora and RHEL system out there using Perl/DBI is doing it with a Perl compiled with thread support. --- Frank Wiles, Revolution Systems, LLC. Personal : [EMAIL PROTECTED] http://www.wiles.org Work : [EMAIL PROTECTED] http://www.revsys.com ---(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