[HACKERS] Open Sourcing pgManage

2003-11-04 Thread Joshua D. Drake
donate it to the project as a whole. What are people's thoughts on this? Yes it has a Java requirement but hey that is a lot easier than a GTK requirement to fullfill. My thought is that it could be included as pgAccess used to be. Sincerely, Joshua D. Drake -- Command Prompt, Inc., home

Re: [HACKERS] Open Sourcing pgManage

2003-11-04 Thread Joshua D. Drake
Hello, If that is the case that is fine. I just wanted to throw it out there but doesn't that mean that psql would be separate as well? J Peter Eisentraut wrote: Joshua D. Drake writes: I thought that we might donate it to the project as a whole. What are people's thoughts

Re: [HACKERS] Open Sourcing pgManage

2003-11-04 Thread Joshua D. Drake
D'oh, just clued into the 'java' aspect ... Joshua, will this run as a JSP, remotely, through Jakarta-Tomcat? One of the limitations of pgAdmin, as far as I'm concerned, is the fact that you can run it remotely ... if you could run pgManage under something like Jakarta-Tomcat as a JSP, that

Re: [pgsql-www] [HACKERS] Changes to Contributor List

2003-11-05 Thread Joshua D. Drake
I think the Emeritus word might be too hard for non-native English speakers, and even for less educated English speakers. Isn't that an even better reason to use it? :) My personal opinion would be that they can use dictionary.com if they don't know what it means. Chris

Re: [HACKERS] [pgsql-advocacy] Changes to Contributor List

2003-11-06 Thread Joshua D. Drake
Hello, My feeling is that advocacy should be just that: Advocacy. It doesn't matter who the intended audience is in reality. However, it is also important to remember that technical experts typically don't need to be sold on PostgreSQL. PHBs on the other hand probably do and thus much of our

Re: [HACKERS] [pgsql-advocacy] Changes to Contributor List

2003-11-06 Thread Joshua D. Drake
Andrew Sullivan wrote: On Thu, Nov 06, 2003 at 09:08:57PM +0100, Peter Eisentraut wrote: I think that list is a pretty dumb idea in the first place. We have a list of developers with company names next to them. Let readers make their own recognition evaluation. Your assuming that

Re: [HACKERS] [CORE] 7.4RC2 regression failur and not running stats

2003-11-14 Thread Joshua D. Drake
I can fire up our solaris machine and let you have access to it if you want to do some destructive testing. Tom Lane wrote: Christopher Browne [EMAIL PROTECTED] writes: For what it's worth, I have been running regression on Solaris with numerous of the betas, and RC1 and [just now] RC2, with

Re: [HACKERS] [pgsql-advocacy] Not 7.5, but 8.0 ?

2003-11-17 Thread Joshua D. Drake
Hello, If Win32 actually makes it into 7.5 then yes I believe 8.0 would be appropriate. Sincerely, Joshua D. Drake On Mon, 17 Nov 2003, Josh Berkus wrote: Folks, Of course, while I was editing press releases at 2am, I started thinking about our next version. It seems certain

Re: [HACKERS] [pgsql-advocacy] Not 7.5, but 8.0 ?

2003-11-17 Thread Joshua D. Drake
As has been said before, many people think that a Windows port is the least interesting feature ever to happen to PostgreSQL, so you're going to Yes but these are people running Unix/Linux/BSD not Windows ;) have to come up with better reasons. Also note that most major number changes in

Re: [HACKERS] Release cycle length

2003-11-17 Thread Joshua D. Drake
Hello, Personally I am for long release cycles, at least for major releases. In fact as of 7.4 I think there should possibly be a slow down in releases with more incremental releases (minor releases) throughout the year. People are running their companies and lives off of PostgreSQL, they

Re: [HACKERS] Commercial binary support?

2003-11-19 Thread Joshua D. Drake
Hello, I think what the person is looking for is: COMPANY PostgreSQL for Red Hat Enterprise 3.0. They probably have some commercial mandate that says that they have to have a commercial company backing the product itself. This doesn't work for most PostgreSQL companies because they back the

Re: [HACKERS] Commercial binary support?

2003-11-19 Thread Joshua D. Drake
of all support companies. What in the world brought this on? I wasn't suggesting any of this. I was just trying to help clarify the guys statement. He couldn't have been talking about Red Hat for all I care. Sincerely, Joshua D. Drake Regards, Hans -- Command Prompt, Inc., home

Re: [HACKERS] RPM building fun

2003-11-19 Thread Joshua D. Drake
Is there some way to remove this piece of sh^H^Hlegacy from the configure script? Does anybody actually use info? All of GNU. Cheers, D -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting.

Re: [HACKERS] 4 Clause license?

2003-11-20 Thread Joshua D. Drake
Based on the below wouldn't they also have to go after Microsoft? Marc G. Fournier wrote: On Thu, 20 Nov 2003, Andrew Dunstan wrote: trollOf course, now that SCO is claiming ownership of BSD code . /troll Interesting thread that ... last I read on the FreeBSD lists was speculation

Re: [HACKERS] 4 Clause license?

2003-11-20 Thread Joshua D. Drake
Hello, My understanding is that they use the BSD stack (at least as the basis) for TCP/IP. Windows that is. J Marc G. Fournier wrote: On Thu, 20 Nov 2003, Joshua D. Drake wrote: Based on the below wouldn't they also have to go after Microsoft? Depends ... does MicroSoft use BSD TCP

Re: [HACKERS] Commercial binary support?

2003-11-22 Thread Joshua D. Drake
Does that mean I have supplied Logictree Systems PostgreSQL? PostgreSQL with Logictree Systems TSearch2? Actually to some degree, yes. Of course a lot would depend on the type of contract you have with them you may be responsible for that code. However, I would love to see those patches.

[HACKERS] Limiting factors of pg_largeobject

2003-11-26 Thread Joshua D. Drake
that is not typed to the underlying system (oid) 3. The ability to be indexed We may benefit. Am I on crack? Sincerely, Joshua D. Drake -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564

Re: [HACKERS] Limiting factors of pg_largeobject

2003-11-26 Thread Joshua D. Drake
Breaking all the client-visible LO APIs, for one thing ... Erck. 1. A larger identifier 2. An identifier that is not typed to the underlying system (oid) 3. The ability to be indexed We may benefit. Am I on crack? I don't see what you're getting at with #2 and #3 at all.

Re: [HACKERS] Limiting factors of pg_largeobject

2003-11-26 Thread Joshua D. Drake
pg_largeobject already has an index (which is used by all the LO operations). Again, don't see what the width of the object ID column has to do with it. I was more after the not having an OID than the width of the ID column. regards, tom lane ---(end of

Re: [HACKERS] Limiting factors of pg_largeobject

2003-11-26 Thread Joshua D. Drake
We're still at cross-purposes then. pg_largeobject doesn't have OIDs (in the sense of per-row OIDs). What I thought you were complaining about was the chosen datatype of the LO identifier column (loid), which happens to be OID. O.k. that was my main concern, which per your statement is

Re: [HACKERS] rebuilding rpm for RH9 error

2003-12-01 Thread Joshua D. Drake
I seen that the configure is done with: --with-krb5=/usr. make sure that you have krb5-devel installed. I also try to install the RPM already builded but I obtain: file /usr/include/sqltypes.h from install of postgresql-devel-7.4-0.5PGDG conflicts with file from package

Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-09 Thread Joshua D. Drake
Hello, All due respect but this seems like a completely insane idea. Sincerely, Joshua Drake Ivelin Ivanov 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

Re: [HACKERS] Proposed Query Planner TODO items

2003-12-19 Thread Joshua D. Drake
I'm not going to be able to set this up. I just had to put my server into cold storage due to dismantling my office, and running the TPC stuff on my laptop is a joke. I'll contact the OSDL folks to see if they can run it. We can... depending on what you need for a server. J --

Re: [HACKERS] Issue with Linux+Pentium SMP Context Switching

2003-12-20 Thread Joshua D. Drake
Two suggestions.. 1. Patch linux kernel for HT aware scheduler. 2. Try running Xeons in HTdisabled modes. See if that helps. I would say using 2.6 on it is recommended anyways.. If possible of course.. I would avoid 2.6 on a production machine. 2.6 breaks alot (not as in a bad

Re: [HACKERS] [pgsql-advocacy] PostgreSQL speakers needed for OSCON 2004

2003-12-21 Thread Joshua D. Drake
Would this be at all useful? Someone mentioned that the 'fees' were relatively high though ... that you lose a fair amount off the top *to* Sourceforge? If we were going to do this, I would suggest just going right through paypal. Marc G. Fournier

Re: [HACKERS] [pgsql-advocacy] PostgreSQL speakers needed for OSCON 2004

2003-12-22 Thread Joshua D. Drake
accepts electronic check but remember we are talking about donations here, not a for profit accepting credit cards. Sincerely, Joshua D. Drake have some of the better fees, and have yet to any major complaints about their services ... we haven't found any major complaints about our current one

Re: [HACKERS] PostgreSQL port to pure Java?

2003-12-23 Thread Joshua D. Drake
Jean-Michel POURE wrote: Le Mardi 09 Décembre 2003 16:15, Ivelin Ivanov a écrit : I think that a co-bundle between an open source J2EE container like JBoss and a scalable database like PostgreSQL will be a blast. Why not cut all trees on earth and replace them with plastic? Before that,

Re: [GENERAL][ADMIN][HACKERS]data fragmentation

2003-12-24 Thread Joshua D. Drake
Hello, An quicker option would be to use rsync (on a stopped database of course). You can rsync to a new directory (off the filesystem) and then reformat the data filesystem and move it back. J Somasekhar Bangalore wrote: Hi, I too had the same problem; There was one query which used to

Re: [HACKERS] connections problem

2003-12-26 Thread Joshua D. Drake
memory have you allocated? Sincerely, Joshua D. Drake im using debain with kernel 2.4.23-pre7, on P4 , (postgres 7.4.1) what can be wrong ? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe

Re: [HACKERS] connections problem

2003-12-26 Thread Joshua D. Drake
Hello, Perhaps you have too many open files? What else is running on this machine? Sincerely, Joshua D. Drake ivan wrote: max_connections=200 shared_buffers=2000 ram = 500M + 300M swap hdd = infinite On Fri, 26 Dec 2003, Joshua D. Drake wrote: hi i need to connect to by my database

Re: [HACKERS] Remote Procedures

2004-01-04 Thread Joshua D. Drake
. Sincerely, Joshua D. Drake Alex -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-222-2783 - [EMAIL PROTECTED] - http://www.commandprompt.com Editor-N-Chief - PostgreSQl.Org - http

Re: [HACKERS] Old binary packages.

2004-01-19 Thread Joshua D. Drake
Lamar Owen wrote: I am looking at the possibility of cleaning up the binary tree on the ftp site, and was wondering what the group thought about purging old binaries. What I was thinking would be to remove all but the last minor release of each major version. Thus, I would remove 7.4, but

Re: [HACKERS] Allow backend to output result sets in XML

2004-01-21 Thread Joshua D. Drake
Greg Stark wrote: Tom Lane [EMAIL PROTECTED] writes: Brian Moore [EMAIL PROTECTED] writes: i would like to begin work on the TODO item Allow backend to output result sets in XML I am not sure why it's phrased that way --- surely the code to hack

[HACKERS] pl/pgSQL versus pl/Python

2004-01-27 Thread Joshua D. Drake
Hello, With the new preload option is there any benefit/drawback to using pl/Python versus pl/pgSQL? And no... I don't care that pl/Python is now considered untrusted. Sincerely, Joshua D. Drake -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support

Re: [HACKERS] ALTER SEQUENCE: Missing feature?

2004-02-01 Thread Joshua D. Drake
such as ALTER that effect the SEQUENCE should use ALTER SEQUENCE. Sincerely, Joshua D. Drake Cheers, D -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - [EMAIL PROTECTED

Re: [HACKERS] Preventing duplicate vacuums?

2004-02-06 Thread Joshua D. Drake
this many times with customers as their traffic on the database grows. A simple check would be of great, great use. Sincerely, Joshua D. Drake ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Co

Re: [HACKERS] Cannot read block error.

2004-02-14 Thread Joshua D. Drake
Hello, When was the last time you ran a reindex? Or a vacuum / vacuum full? Sincerely, Joshua D. Drake On Sat, 14 Feb 2004, Jason Essington wrote: I am running PostgreSQL 7.3.3 on OS X Server 10.2 The database has been running just fine for quite some time now, but this morning it began

Re: [HACKERS] Cannot read block error.

2004-02-14 Thread Joshua D. Drake
may have a corrupt system index that needs to be reindexed. Sincerely, Johsua D. Drake On Sat, 14 Feb 2004, Jason Essington wrote: Both vacuum [full] and reindex fail with that same error. vacuum is run regularly via a cron job. -jason On Feb 14, 2004, at 2:29 PM, Joshua D. Drake wrote

Re: [HACKERS] friday 13 bug?

2004-02-14 Thread Joshua D. Drake
Hello, I personally ran into the exact same thing with another customer. They are running RedHat 8.0 with (2.4.20 at the time). We had to upgrade them to 2.4.23 and reboot. Worked like a charm. This was about two months ago. I swear it was almost the exact same error. Sincerely, Joshua D

Re: [HACKERS] log_line_info plan

2004-02-17 Thread Joshua D. Drake
Andrew Dunstan wrote: I am about to redo the patch that would allow tagging of log lines with info via a printf-style string. Current plans are to call the config parameter log_line_info and implement the following escapes: %U = user %D = database %T = timestamp %P = pid %L = session log line

Re: [HACKERS] Tablespaces

2004-02-26 Thread Joshua D. Drake
Is it possible to put WALs and CLOGs into different tablespaces? (maybe different RAID systems). Some companies want that ... You can do this now, but it would be nice to be able to have it actually configurable versus the hacked linked method. J -- Co-Founder Command Prompt, Inc.

Re: [pgsql-www] [HACKERS] The Name Game: postgresql.net vs.

2004-03-11 Thread Joshua D. Drake
and/or price ... Really? What about BMW, Volvo or Mercedes? Sincerely, Joshua D. Drake Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast

Re: [HACKERS] Log rotation

2004-03-15 Thread Joshua D. Drake
Andrew Sullivan wrote: On Sat, Mar 13, 2004 at 10:45:35AM -0500, Rod Taylor wrote: Not that I'm volunteering, but I think the biggest issue is many users simply don't know how to approach the problem. Some docs on using syslog, cron, etc. with PostgreSQL to accomplish maintenace jobs would

Re: [HACKERS] COPY formatting

2004-03-17 Thread Joshua D. Drake
That is why I suggested providing a pre-written/pre-compiled/installed function for CSV (call it CSV?). Advanced users could still write their own as people can write many other things if they know their ways. As someone who just went through a whole truckload of crap getting delimited

Re: [HACKERS] COPY formatting

2004-03-18 Thread Joshua D. Drake
specific type of import you are performing. Sincerely, Joshua D. Drake -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com Mammoth

[HACKERS] PostgreSQL ES3.0 problems?

2004-03-24 Thread Joshua D. Drake
corruption ;) Any thoughts? Sincerely, Joshua D. Drake -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com Mammoth PostgreSQL Replicator

[HACKERS] Timeline for 7.4.3?

2004-03-26 Thread Joshua D. Drake
Hey, We have many machines that run Solaris. I know that there are patches out there for some of the bugs in 7.4.2 for Solaris but I was wondering what the timeline for an official 7.4.3 was? Sincerely, Joshua D. Drake -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC

[HACKERS] PostgreSQL 7.4.2 and Cygwin a no go?

2004-04-15 Thread Joshua D. Drake
Hello, We are able to compile without issue but it won't start. The exact same config works perfectly with 7.3.6. Here is the output: $ /usr/local/pgsql/bin/postmaster -D data DEBUG: /usr/local/pgsql/bin/postmaster: PostmasterMain: initial environ dump: DEBUG:

Re: [HACKERS] pg_encoding not needed anymore

2004-04-20 Thread Joshua D. Drake
g a data store for many databases, not a single database. But I think it is far too sanctified by history to change now, just as Ken Thompson now wishes he had put an 'e' on the end of 'creat' but can't go back and fix it. Maybe we should think about a symlink/hardlink to use a better name.

Re: [HACKERS] contrib vs. gborg/pgfoundry for replication solutions

2004-04-21 Thread Joshua D. Drake
Hello, My personal opinion is that contrib should be removed entirely. Just have a contrib.txt that says all contrib modules are at pgfoundry or whatever. Sincerely, Joshua D. Drake Jan Wieck wrote: Taking into account that quite a few people have repeatedly stated that the components

Re: [HACKERS] contrib vs. gborg/pgfoundry for replication solutions

2004-04-21 Thread Joshua D. Drake
and required items for PostgreSQL. IMHO: PostgreSQL should include: PostgreSQL Psql All development headers C/C++ Libs Everything else should be on SourceForge or Gforge or whatever. The possible exception would be the pl stuff. Sincerely, Joshua D. Drake Marc G. Fournier

Re: [HACKERS] contrib vs. gborg/pgfoundry for replication solutions

2004-04-21 Thread Joshua D. Drake
Hello, Well perhaps we can have exceptions. TSearch would be a good exception as it really should be integrated into PostgreSQL anyway. There are very few of these that I think would be an issue. Sincerely, Joshua D. Drake Oleg Bartunov wrote: The problem with moving all contribs to gborg

Re: [HACKERS] contrib vs. gborg/pgfoundry for replication solutions

2004-04-21 Thread Joshua D. Drake
for redhat, debian or even SuSE you would type: apt-get install pg_autovacuum or with redhat you might also do yum install pg_autovacuum But that is packaging and that is up to the developers of the particular project. Joshua D. Drake My point is that all of this stuff shouldn't be in the core CVS

Re: [HACKERS] contrib vs. gborg/pgfoundry for replication solutions

2004-04-22 Thread Joshua D. Drake
e autoconf (although it is a good idea). You don't NEED PostgreSQL source etc... Sincerely, Joshua D. Drake Marc G. Fournier wrote: On Wed, 21 Apr 2004, Rod Taylor wrote: We have the current issue of people not knowing that projects like pgadmin exist or where to find the jd

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib,

2004-05-07 Thread Joshua D. Drake
. They are programmers trying to do it a better way. Providing plPerl or plPython etc... allows them to stay in a native and productive environment. Sincerely, Joshua D. Drake my two cents. Regards Gaetano Mendola ---(end of broadcast)--- TIP 5

Re: [HACKERS] [pgsql-advocacy] What can we learn from MySQL?

2004-04-30 Thread Joshua D. Drake
The difference is that you could now correct for Great Bridge's problems, which include but are not limited to: timing (4 years has changed a lot for commercial acceptance of open source), funding ($25m was too much), and strategy (this is not an quick attempt to copy Red Hat). I think such a

Re: [HACKERS] Plan for feature freeze?

2004-04-30 Thread Joshua D. Drake
... Sincerely, Joshua D. Drake Sincerely, Joshua D. Drake Bruce Momjian wrote: Marc G. Fournier wrote: On Fri, 30 Apr 2004, Bruce Momjian wrote: Marc G. Fournier wrote: No, I agree that that would be foolish

Re: [HACKERS] Plan for feature freeze?

2004-04-30 Thread Joshua D. Drake
not serious ... Why not? Seemed like a fairly good argument both yours and mine ;) Sincerely, Joshua D. Drake Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664

Re: [HACKERS] Plan for feature freeze?

2004-04-30 Thread Joshua D. Drake
push. Win32 -- if it won't make it, then 7.5 should push. PITR is nice but not as vital (IMHO) as the two above. Replication -- we have either via Replicator or Slony-I which is due in a month. Sincerely, Joshua D. Drake -- Tatsuo Ishii ---(end of broadcast

Re: [HACKERS] pg ANY/SOME ambiguity wrt sql standard?

2004-04-30 Thread Joshua D. Drake
I second this... the whole __ is hard to type and remember. Sincerely, Joshua D. Drake How about bool_or() and bool_and()? Or at least something based on OR and AND? I don't find ANY/ALL to be particularly mnemonic for this usage anyway. regards, tom lane --

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib,

2004-04-27 Thread Joshua D. Drake
to be comfortable with plPython or plPerl than plpgSQL. Sincerely, Joshua D. Drake cheers andrew ---(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] [pgsql-advocacy] What can we learn from MySQL?

2004-04-28 Thread Joshua D. Drake
D. Drake ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [HACKERS] PostgreSQL pre-fork speedup

2004-05-05 Thread Joshua D. Drake
The fact that windows has a heavy process / lightweight thread design means little to me, since I'll likely never deploy a production postgresql server on it that needs to handle any serious load. Yes but Solaris also has a heavy process / lightweight thread design. J

Re: [HACKERS] Call for 7.5 feature completion

2004-05-17 Thread Joshua D. Drake
in production shops) that we should make a longer development time for 7.5. Personally, Win32, subtransactions and PITR are what we are after. Second would be inclusion of plPHP and plPerlNG which are arguably the most widely used languages to connect to PostgreSQL. Sincerely, Joshua D. Drake

Re: [HACKERS] Call for 7.5 feature completion

2004-05-17 Thread Joshua D. Drake
. ^^^ Well that seems to be part of the problem. ext3 does not scale well at all under load. You should probably upgrade to a better FS (like XFS). I am not saying that your point isn't valid (it is) but upgrading to a better FS will help you. Sincerely, Joshua D. Drake

Re: [HACKERS] Call for 7.5 feature completion

2004-05-17 Thread Joshua D. Drake
??? Sincerely, Joshua D. Drake Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared

Re: [HACKERS] Call for 7.5 feature completion

2004-05-17 Thread Joshua D. Drake
The much I am for pulling stuff that does not belong into core, doing it just for the fun of cleaning up or trimming doesn't do. One of the major functions of CVS is that one can tag collections of revisions that together build a release, a known to be working snapshot of file revisions. If

Re: [HACKERS] Call for 7.5 feature completion

2004-05-17 Thread Joshua D. Drake
I assume your ecpg will be a patch to the existing ecpg rather than a new verion, right? Yes it is a patch against 7.4.2 J -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting.

Re: [HACKERS] Call for 7.5 feature completion

2004-05-17 Thread Joshua D. Drake
a README couldn't be included in the src/pl/plphp directory that says: look here for the latest release etc... Sincerely, Joshua D. Drake Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664

Re: [HACKERS] Call for 7.5 feature completion

2004-05-17 Thread Joshua D. Drake
So, yea, I am frustrated. I know these features are hard and complex, but I want them for PostgreSQL, and I want them as soon as possible. I guess what really bugs me is that we are so close to having these few remaining big features, and because they are so complex, they are taking a lot

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
believe they are valid arguments too and if we were to do it we would definately need to be selective about which features get back ported but forward movement can be in the present tree as well. Joshua D. Drake Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
Peter Eisentraut wrote: Joshua D. Drake wrote: Uhhh?? Are you ripping out all core pls then? plPerlNG is supposed to replace plPerl, I was talking with Bruce and he seemed to think that (as long as the code was good enough) that we could incorporate plPHP??? One reason

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
Bruce ;). Seriously though, we all have the roles that we play. I don't think redirecting specific resources to other resources will help beyond slowing up the original resources. Sincerely, Joshua D. Drake Marc G. Fournier Hub.Org Networking Services (http://www.hub.org

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
This is very much different, because the PHP distribution contains the PostgreSQL driver, whereas the other languages do not. So you would have PHP build depends on PostgreSQL Ahh I see your point, EXCEPT :) plPHP does not require PostgreSQL support to be built into PHP. Sincerely, Joshua D

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
PostgreSQL support. Also PHP does not compile the PostgreSQL support by default. This is no different that Perl, which also has a PostgreSQL driver but plPerl does not require DBD::Pg to compile. Sincerely, Joshua D. Drake Sincerely, Joshua D. Drake PostgreSQL build depends on PHP Not good

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
does PHP+PostgreSQL conflict with using plPHP... PHP doesn't even need to be installed for plPHP to work... You just need the source tree for building. So I am confused... Sincerely, Joshua D. Drake ---(end of broadcast)--- TIP 2: you can get off all

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
Peter Eisentraut wrote: Joshua D. Drake wrote: Of course not, but I still don't see your point. plPHP doesn't need PHP+PostgreSQL support. Nor does PHP+PostgreSQL conflict with using plPHP... PHP doesn't even need to be installed for plPHP to work... You just need the source tree for building

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
So you then have to build PHP twice, in an RPM build environment. You mean I can't just have the headers installed to build plPHP? So, follow the No you need to make sure that PHP is available as a shared lib. 1.) Build PostgreSQL 2.) Build PHP (with PostgreSQL client support) 3.) Build plPHP

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
So, why tie it into the PostgreSQL source tree? Won't it be popular enough to live on its own, that it has to be distributed as part of the core? Honestly, I don't know if it would be popular enough on its own. Now the plPerlNG that Andrew and us are working, yes but plPHP? It is nifty, it

Re: [HACKERS] Call for 7.5 feature completion

2004-05-18 Thread Joshua D. Drake
P. Python takes actual thought to produce something useful. Whether or not that is a bad thing is for another argument :) Sincerely, Joshua D. Drake -- Tatsuo Ishii ---(end of broadcast)--- TIP 6: Have you searched our list archives?

Re: [HACKERS] Call for 7.5 feature completion

2004-05-19 Thread Joshua D. Drake
it either. June 15th maybe. Sincerely, Joshua D. Drake ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] [GENERAL] Request from eWeek for 7.3 comments

2002-11-28 Thread Joshua D. Drake
applications to the database market. Sincerely, Joshua D. Drake Co-Founder Command Prompt, Inc. Co-Author Practical PostgreSQL Bruce Momjian wrote: I just spoke with Lisa Vaas from eWeek. She is writing an article on the upcoming PostgreSQL 7.3 release. (The release of 7.3 is scheduled for tomorrow

[HACKERS] PostgreSQL v7.3.2 Released -- Permission denied from pretty mucheverywhere

2003-02-06 Thread Joshua D. Drake
Hello folks, Been trying to test the latest source but the following places give permission dened when trying to download: ftp.postgresql.org ftp.us.postgresql.org ftp2.us.postgresql.org mirror.ac.uk Anybody got one that works? J Oliver Elphick wrote: On Wed, 2003-02-05 at

Re: [HACKERS] PostgreSQL v7.3.2 Released -- Permission denied from pretty much

2003-02-06 Thread Joshua D. Drake
Hello, Pardon me while I pull my book out of various dark places. It has been a very long week. I got it. Thanks. Sincerely, Joshua Drake Tom Lane wrote: Joshua D. Drake [EMAIL PROTECTED] writes: Been trying to test the latest source but the following places give permission dened

Re: [HACKERS] Postres dilemma

2004-06-06 Thread Joshua D. Drake
Hello, Perhaps you could provide some more detailed information? Example of queries? Type of hardware? Operating system? Why are you running a vacuum every 45 seconds? Increase your fsm_pages and run it every hour. Are you sure the vacuums are trampling eachother and thus getting more than one

[HACKERS] vacuumdb: vacuuming of database testdonors failed: ERROR: invalid memory alloc request size 3221225472

2004-06-07 Thread Joshua D. Drake
... Databaes is about 50 megs of mostly text. Less than 5 megs in large objects. Hardware/OS is: Dual Athlon MP 2800 3 Gig ECC Ram 3Ware Hardware Raid 7 SATA Drives in a RAID 10 (1 hot spare). Fedora Core 1 Any thoughts? Sincerely, Joshua D. Drake -- Command Prompt, Inc., home of Mammoth PostgreSQL - S

Re: [HACKERS] Frequently updated tables

2004-06-09 Thread Joshua D. Drake
, Joshua D. Drake -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Re: [HACKERS] Frequently updated tables

2004-06-09 Thread Joshua D. Drake
Sigh, because vacuums take away from performance. This is a known issue that has been pretty much resolved for 7.5. Vacuum in 7.5 does not take even close to as much IO resources. Imagine a table that has to be updated on the order of a few thousand times a minute. Think about the drop in

Re: [HACKERS] I just got it: PostgreSQL Application Server -- a

2004-06-13 Thread Joshua D. Drake
The "PostgreSQL Enhanced Server" (How's that name? Maybe we call it Zerver and use PEZ?) idea is how to take the excellent core of PostgreSQL and productize it in much the same way distributions take the Linux kernel and may a GNU/Linux system. It would seem to me that this is more

Re: [HACKERS] warning missing

2004-06-25 Thread Joshua D. Drake
Hello, You all are behind... Python is king. Sincerely, Joshua D. Drake Gaetano Mendola wrote: Thomas Hallgren wrote: Greg, You don't like Java/C#. I do. What appear here is that you hate C++. I'm a C++ developer since long time now, and I can not use JAVA and or C# just for a couple of reason: 1

Re: [HACKERS] xeon processors

2004-06-25 Thread Joshua D. Drake
Hello, I seem to recall that HyperThreading and PostgreSQL != good stuff... There was a whole bunch of stuff recently on this... google the archives. Sincerely, Joshua D. Drake Jaime Casanova wrote: Hi all, Can anyone tell me if postgresql has problems with xeon processors? If so, there is any

Re: [HACKERS] Win32 version question

2004-06-30 Thread Joshua D. Drake
So it can't be compiled by other compiler? Say Digital Mars or some Microsoft or Borland compiler? Nope. It needs the GNU tool set. -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 -

Re: [HACKERS] compile errors in new PL/Pler

2004-07-01 Thread Joshua D. Drake
version. Perl 5.00503 is ancient. Try upgrading to at least 5.6. Sincerely, Joshua D. Drake SPI.xs: In function `XS__spi_exec_query': SPI.xs:51: `aTHX_' undeclared (first use in this function) SPI.xs:51: (Each undeclared identifier is reported only once SPI.xs:51: for each function it appears

Re: [HACKERS] compile errors in new PL/Pler

2004-07-02 Thread Joshua D. Drake
of perl that the perl community itself suggests that you should upgrade. Perl 5.00503 is RedHat 6.2 genre... That is scary old. I believe even RedHat 7.3 came with Perl 5.6 and that is old as well. Sincerely, Joshua D. Drake Joe -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S

Re: [HACKERS] [Plperlng-devel] plperl security

2004-07-05 Thread Joshua D. Drake
Currently we have this in plperl.c: require Safe; I am thinking of submitting a patch to replace this with use Safe 2.09; to enforce use of a version without the known vulnerability. Any objections? I have none, except will 2.09 work with 5.00503? cheers andrew

Re: [Plperlng-devel] Re: [HACKERS] plperl security

2004-07-09 Thread Joshua D. Drake
Hello, I know there is a patch coming Monday with a great deal of bug fixes. J On Fri, 9 Jul 2004, Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: OK, I have a setup that instead of refusing to load trusted functions if the Safe version is not up to date, forces them to error

Re: [HACKERS] check point segments leakage ?

2004-07-20 Thread Joshua D. Drake
Hello, Perhaps you have an open transaction that isn't closing and thus the pg_xlog continues to grow? Sincerely, Joshua D. Drake Gaetano Mendola wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, today I add 4 new columns to a table with 4E+06 rows, I also update to an initial value

Re: [HACKERS] Anybody have an Oracle PL/SQL reference at hand?

2004-07-31 Thread Joshua D. Drake
NOT_LOGGED_IN PROGRAM_ERROR STORAGE_ERROR TIMEOUT_ON_RESOURCE TOO_MANY_ROWS TRANSACTION_BACKED_OUT VALUE_ERROR Sincerely, Joshua D. Drake Tom Lane wrote: Can anyone check how well the syntax of plpgsql EXCEPTION, as described at http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html

Re: [HACKERS] Version Numbering -- The great debate

2004-07-31 Thread Joshua D. Drake
ct that we finally have a port to the most used operating system (regardless if that is good or bad) in the world. Sincerely, Joshua D. Drake Tom Lane wrote: Josh Berkus [EMAIL PROTECTED] writes: Even if Savepoints don't make it, we'll still have: Savepoints are in, as is

Re: [HACKERS] pg_dump bug fixing

2004-08-02 Thread Joshua D. Drake
that is required to run that database. Including users. Joshua D. Drake -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com Mammoth PostgreSQL Replicator

  1   2   3   4   5   6   7   8   9   10   >