Re: [GENERAL] Int8 problem
"admin" <[EMAIL PROTECTED]> writes: > But on the alpha i got no error message no worning and inserts a wrong > number if the number is bigger than 10^13 . 10^13? But values > 2^31 work? Man, that's really weird ... I was expecting a failure at 2^31 if int8 wasn't compiled correctly. I can't think what might fail at 10^13. Ideas anyone? It might help to see an exact table of equivalences, ie, so much in, so much out. regards, tom lane
Re: [GENERAL] Int8 problem
Hi, I have intalled Postgres 7.0.2 recently on 3 normal PC with RedHat and Slackware to try its behavior but its working good. int8 thakes number much bigger then 10^13. And if the number is to big (about 10^19 ) it generate an error message (ERROR: int8 value out of range: ...) and don't insert it into the table. But on the alpha i got no error message no worning and inserts a wrong number if the number is bigger than 10^13 . regard Hanos Felix - Original Message - From: "Jerome Raupach" <[EMAIL PROTECTED]> To: "admin" <[EMAIL PROTECTED]> Sent: 26 septembrie 2000 14:48 Subject: Re: [GENERAL] Int8 problem > your number is truncated to the biggest int8 ( 2*10^10, I think). > try with 'numeric'. > > Jerome. > > > admin wrote: > > > > Hi > > I have intalled Postgres 7.0.2 on a Compaq Alpha with DigitalUnix. > > If I insert a bigger number like 10^13 in an int8 type field i'm getting no > > error messages, no warnings, but if I check the value inserted i receive > > totaly wrong number like 2543 > > If you have any suggestions please let me know. > > > > Thank any way.
Re: [GENERAL] Int8 problem
- Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "admin" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: 26 septembrie 2000 16:31 Subject: Re: [GENERAL] Int8 problem I send you the outputs maybe you will find an answer. Thanks. Hanos Felix > "admin" <[EMAIL PROTECTED]> writes: > > I have intalled Postgres 7.0.2 on a Compaq Alpha with DigitalUnix. > > If I insert a bigger number like 10^13 in an int8 type field i'm getting no > > error messages, no warnings, but if I check the value inserted i receive > > totaly wrong number like 2543 > > Hm. It sounds like configure failed to find any compiler support for > 8-byte ints, so it gave up and compiled int8 as int4. But an Alpha > ought to have 8-byte ints. May we see the output files from configure > (config.status, config.log)? > > regards, tom lane config.log config.status
[GENERAL] Re: web programming
>One of our competitors sunk well over a million bucks into Sun/Oracle > hardware, and thought they'd be "cutting-edge" by doing all of their > back-end programming in Java. The end result is that our $20,000 cluster > using Linux, Postgres, and Perl out-performs their setup by a very > significant factor, and also has a greater potential for scalability. It's > also a lot easier for us to find programmers than they can, and we turn out > new products faster than they do. I really appreciate Perl CGI because it's an amazingly fast development environment, much faster than any Java-based system I've seen. Just edit the script and test; there's no compiling, no copying or restarting of servers. mod_perl isn't quite as good, since you have to restart Apache, but Apache restarts instantly, so that's not a really serious concern. Java's compilation time and the regular need to restart the Java environment really slow down development work. (I've yet to find a servlet system whose "automatic reload" feature truly works as advertised.) I've also noticed that people who don't know Perl really tend to underestimate how many really good Perl developers there are. - Tim
[GENERAL] Replication server
Just received the email on Replication server. Based on the threads this last week, the sooner it's out there the better.. Fantastic, yah yah yah!!! -- Dale Walker [EMAIL PROTECTED] Independent Computer Retailers (ICR) http://www.icr.com.au ICRnet http://www.icr.net.au
[GENERAL] Introducing the PostgreSQL, Inc. Replication Server
Wolfville, Nova Scotia PostgreSQL, Inc. For Release 9 p.m. EDTPO Box 1648 Tuesday, September 26th, 2000 Wolfville, Nova Scotia Canada, B0P 1X0 Phone 902 542 0713 Toll Free 1 877 542 0713 Fax 902 542 5386 Introducing the PostgreSQL, Inc. Replication Server "When we announced our ongoing development of the PostgreSQL Enterprise Replication Server (eRServer) last month I had no idea how great the interest and demand for this would be." states CEO Geoff Davidson. "We have received dozens of inquiries from customers, competitors, and development companies asking for more information. Today I'm very pleased to announce that the first prerelease version of eRServer has been delivered for testing." "At the moment we are limiting our test groups to our existing Platinum Partners and those clients whose requirements include these features." advises Jeff MacDonald, VP of Support Services. "We expect to have the source code tested and ready to contribute to the open source community before the middle of October. Until that time we are considering requests from a number of development companies and venture capital groups to join us in this process." Davidson explains, "These initial Replication functions are important to almost every commercial user of PostgreSQL. While we've fully funded all of this development ourselves, we will be immediately donating these capabilities to the open source PostgreSQL Global Development Project as part of our ongoing commitment to the PostgreSQL community." This initial release of eRServer is intended to support companies and individuals in development of applications that require the following functions and capabilities: * Server to Client Replication * Data Merge [PostgreSQL to PostgreSQL] * Data Converge [ODBC/other to PostgreSQL] * Mirroring & Disaster Recovery * Test Regions for development & scenario activities * Full & Differential Replication [backup / update] * Data Hierarchy Replication [need to know distributions] Jeff MacDonald Marc FournierThomas Lockhart * 1 877 542 0713 * 1 877 542 0713 * [EMAIL PROTECTED] * [EMAIL PROTECTED] * [EMAIL PROTECTED] Geoff Davidson eRServer Info: * 1 416 410 4124 ext. 1 www.eRServer.com * [EMAIL PROTECTED] For a copy of this document in PDF format go to: http://www.pgsql.com/press/Pgsql_Inc_Press-5.pdf
[GENERAL] \l+ dumps core
I installed the postgresql-7.0.2-2 RPM downloaded from postgres.org, but \l+ always dumps core: % psql Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit jamesc=# select version(); version - PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66 (1 row) jamesc=# \l+ List of databases Database | Owner | Encoding | Description ---+--+---+- jamesc| jamesc | SQL_ASCII | template1 | postgres | SQL_ASCII | (2 rows) zsh: segmentation fault (core dumped) psql %
[GENERAL] Informix split in two
Seems Informix is having more troubles. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ... The attached document is in both web page and text formats. View the one which looks best. Title: News & Features Story | Informix Splits Into 2 Separate Companies Search Advanced Search | Contacts News & Features | Resources/Research | Careers | Communities | Subscriptions | Media Center Headlines | Biz Stories | Tech Stories | Emerging Companies | QuickStudy | Columnists | This Week in Print | CW Minute News & Features NEWS Latest Headlines • Browse by Date • Browse by Topic Business Headlines Tech Headlines This Week in Print CW Audio Minute FEATURES Field Report Emerging Companies Quickstudies Executive Technology OPINIONS CW Columnists Forums Shark Tank PUBLICATIONS Supplements White Papers Surveys & Reports Informix Splits Into 2 Separate Companies By DAN VERTON (September 25, 2000) Hit by weak sales that are expected to result in a third-quarter loss, Menlo Park, Calif.-based Informix Corp. last week announced that it's splitting into two separate operating companies - one focused on its flagship databases and the other on Web publishing, e-commerce and business intelligence software that will work with multiple databases. The breakup follows Informix's March acquisition of Ardent Software Inc., a data warehousing vendor in Westboro, Mass. The as-yet-unnamed business intelligence and e-commerce venture will be headquartered at Ardent's facility, while the database company - to be called Informix Software - will be based in Silicon Valley. Informix previously said it would have 3,900 to 4,000 employees after last month's layoffs and the planned hirings of some new sales and support workers. Last week, the company said the two separate companies will have a combined workforce of about 3,400 people. In addition, the company warned that it expects to report a third-quarter operating loss of $15 million to $24 million, which will be widened by restructuring charges and other one-time expenses totaling as much as $90 million. Meanwhile, the Informix Software database operation will try to breathe new life into the company's core database technology. The database company, which expects revenue of $780 million to $800 million this year and will start out with 2,300 employees, is expected to be run by Jim Foy, another former Ardent executive who was named a senior vice president at Informix last month. In an attempt to revitalize its database sales, Foy said, Informix has a new technical architecture on the drawing board, after having recently completed a detailed analysis of its existing technology. One More Chance Consulting firm AMR Research Inc. in Boston described Informix's breakup move as "a last-ditch effort to reinvigorate" the company's database business. The move may have come too late to help Informix take back much database market share from Oracle Corp. and other rivals, AMR said. But, the company added, the new management team from the Ardent side of the company "is showing it can make tough decisions and is ready to fight." Other recent stories by Dan Verton Sendfeedback
[GENERAL] Increasing max size of tuples?
Can the max size of the tuples be enlarged, currently they are 8128 bytes ( I believe). Is there a macro or option that can be set to increase this? I have a table with quite a few constraints (and the field names are large also), and the tuple size is being exceeded, and the table can't be created. Wade Oberpriller StorageTek [EMAIL PROTECTED]
Re: [GENERAL] web programming
On Tue, Sep 26, 2000 at 09:17:43AM -0400, Adam Lang wrote: > As far as perl goes, I know some web develoeprs for a consulting firm that > use Solaris and they are pretty tight in the industry. Their advice to me > was that if I already don't know Perl, don't learn it. They said to take > the Java route. They also were fond of PHP. In a nutshell, they said Java > will phase out most large perl implementations (new clients tend to be > developed in java, old code is redone, etc.) The place I worked at over the summer did something similar. They have a large existing infrastructure written in Perl/CGI + Apache, with the odd thing using a Postgres backend. This was all running on a big Sun E450 (obviously running Solaris). When I started working, they had been moving things over to Java Servlets - using JServ. They were also getting much better hardware. However, the Servlets seemed really unstable. JServ would die for no apparent reason. It seemed like a lot of the staff felt that perhaps moving to Java was a mistake. Whether their problems were the fault of JServ, Java, or incompetent programmers/admins, I don't know. (BTW, Postgres was rock stable. We never had any problems with it). So I really haven't had enough experience with Java Servlets, since Perl is more than sufficient and I know it works well. I personally do my web programming in mod_perl, usually with DBI and Apache::DBI. I love Perl, and I've had very few problems. I agree with someone who mentioned mod_perl is tough to get into - it takes a while to get up to speed. As for PHP being embedded into HTML, the same thing is possible with Perl - but you also get TMTOWTDI. The following all embed Perl in HTML, to some degree: HTML::Template HTML::Embperl HTML::Mason (as someone mentioned) ePerl And probably a few others I haven't heard of. You're free to pick and choose whichever suites you best. I'd recommend Perl, but it's really just a matter of personal taste. Have fun, Neil -- Neil Conway <[EMAIL PROTECTED]> Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc Encrypted mail welcomed Hard work never hurt anyone - but why take chances? PGP signature
Re: [GENERAL] FreeBSD Softupdates??
* Bruce Momjian <[EMAIL PROTECTED]> [000926 13:55] wrote: > > Alfred Perlstein wrote: > > > > > [snipped thread] > > > > OK, if I'm reading it right, the general concensus seems to be - it'll > > work, but there is a possibility of data loss in event of system > > crashalthough everything should be OK 99.9% of the time. > > > > yep, this is about what I thought.. I wanted to get a feel for > > practicality though. > > > > Thanks for all your input guys, I'll stick to my standard filesystem for > > now.. > > No, softupdates to not affect recovery. Standard PostgreSQL flushes all > stuff to disk on transaction commit, and this it not affected by the > file system softupdate status. This is only true if the user isn't running postgresql async. So softupdates should be ok as long as postgresql is issueing fsyncs, if you're running postgresql in async mode, then it's probably better not to use softupdates. Also, since running postgresql in sync mode will basically cause the negation of most softupdate benifits with the exception of tempfiles, doesn't postgresql differenciate between system files and tempfiles? -- -Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]] "I have the heart of a child; I keep it in a jar on my desk."
Re: [GENERAL] FreeBSD Softupdates??
Soft updates make file creation/destruction faster. My BSDI system uses it, and it is clearly faster for interactive use. I never tested PostgreSQL. > Bruce Momjian wrote: > > > > > > No, softupdates to not affect recovery. Standard PostgreSQL flushes all > > stuff to disk on transaction commit, and this it not affected by the > > file system softupdate status. > > > > AAahhh... > > yes I see (light goes on in head), this was sort of aluded to in on of > the responses, but it didn't click. > > Therefore, there would be little practical benefit?? > > I'll try a long series of insert/select/updates and compare. > > > -- > Dale Walker [EMAIL PROTECTED] > Independent Computer Retailers (ICR) http://www.icr.com.au > ICRnet http://www.icr.net.au > -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
Re: [GENERAL] FreeBSD Softupdates??
Bruce Momjian wrote: > > > No, softupdates to not affect recovery. Standard PostgreSQL flushes all > stuff to disk on transaction commit, and this it not affected by the > file system softupdate status. > AAahhh... yes I see (light goes on in head), this was sort of aluded to in on of the responses, but it didn't click. Therefore, there would be little practical benefit?? I'll try a long series of insert/select/updates and compare. -- Dale Walker [EMAIL PROTECTED] Independent Computer Retailers (ICR) http://www.icr.com.au ICRnet http://www.icr.net.au
Re: [GENERAL] web programming
At 09:28 AM 9/26/00 -0400, you wrote: >On Tue, 26 Sep 2000, J. Atwood wrote: > > > Zope. http://www.zope.org > > > > Been using PostgreSQL behind Zope for a couple of sites for over 8 > > months now and it has been a pleasure. > > > > Cheers, > > J I also use Zope and PostGres intensively over 9 month on a production system. It works really nice together. The PyGreSQLDA is not thread safe, so you to be a little careful, but the new PoPyDA fixed all this and works really nice. (I have not tried PoPy on production yet.) Regards, Stephan -- Stephan Richter CBU - Physics and Chemistry Student Web2k - Web Design/Development & Technical Project Management
Re: [GENERAL] update inside transaction violates unique constraint?
On Tue, Sep 26, 2000 at 04:43:02PM -0400, Andrew Sullivan wrote: > Have I done something wrong here, or have I stumbled on a bug? > Shouldn't this cause an error and a rollback? Sorry, forgot to include the usual stuff : PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.95.2 This is the Debian package. -- Andrew Sullivan Computer Services <[EMAIL PROTECTED]>Burlington Public Library +1 905 639 3611 x158 2331 New Street Burlington, Ontario, Canada L7R 1J4
Re: [GENERAL] FreeBSD Softupdates??
> Alfred Perlstein wrote: > > > [snipped thread] > > OK, if I'm reading it right, the general concensus seems to be - it'll > work, but there is a possibility of data loss in event of system > crashalthough everything should be OK 99.9% of the time. > > yep, this is about what I thought.. I wanted to get a feel for > practicality though. > > Thanks for all your input guys, I'll stick to my standard filesystem for > now.. No, softupdates to not affect recovery. Standard PostgreSQL flushes all stuff to disk on transaction commit, and this it not affected by the file system softupdate status. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026
[GENERAL] Encrypting fields with a one-way hash
Hi, I'm new to PostgreSQL, but have installed it on a RedHat 6.2 box. We are currently trying to migrate our existing MySQL applications to PostgreSQL, but the differences in syntax are presenting a few problems. My main stumbling block is the apparent lack of a function to form a hash (or other one-way encrypt) of a password to enter as a field in the database. The old SQL looks something like: > INSERT INTO Users (Name, Password) VALUES ('John Smith', PASSWORD('mypassword')) This works because "PASSWORD" is an internal function in MySQL. Is there a similar function in PostgreSQL, or some other way of achieving the same effect? The data itself is not being moved over, so there is no need for the same algorithm to be used. Thanks for any and all help, ** Alexi Margo Internet Systems Manager Wildwood Technology Ltd http://www.wwood.co.uk/ t +44-(0)20 8426 f +44-(0)20 8426 5050 ** This message is intended only for the use of the person(s) ("the Intended Recipient") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. Accordingly any dissemination, distribution, copying or other use of this message or any of its content by any person other than the Intended Recipient may constitute a breach of civil or criminal law and is strictly prohibited. If you are not the Intended Recipient please contact the sender as soon as possible.
Re: [GENERAL] web programming
On Tue, 26 Sep 2000, J. Atwood wrote: > Zope. http://www.zope.org > > Been using PostgreSQL behind Zope for a couple of sites for over 8 > months now and it has been a pleasure. > > Cheers, > J Hi J and Michelle. I'm curious to try this also - I have a friend who has done alot of work with Zope/Pg and so I have been looking over his shoulder for awhile...I'd like to have a go myself. I have written a slew of applications for my company's Intranet in perl/CGI/DBI. This is also a high octane solution. Of course I am a perl fanatic (it's like C for those of us with severe time constraints and limited abilities ;-) My src is public domain but not yet ready for prime time (too few comments and too many mistakes, sloppy coding). I would send a sample tho if you (Michelle) were interested. Ciao, Tom > At 9:15 PM -0400 9/25/2000, Michelle Murrain wrote: > >Hi folks, > > > >I thought (now that I've solved my DBD::Pg problem) that I'd ask a > >fairly generic opinion question. I've been working with postgres and > >php now for about 4 years, quite heavily in the last year. I'm sold > >on postgres, and will continue to use it unless I have compelling > >reasons not to. But I'm debating about continuing development using > >php. > > > >1) I'm getting better and better at perl - and it's a much more > >mature language than php. > > > >2) I've been learning a bit about jsp and java servlets - and that's > >intriguing me a lot. > > > >So what's your favorite web programming language to use with > >postgres, and why? Are there speed/performance issues I should think > >about? I'm also beginning to get into XML, so there is another set > >of things to think about. > > > >Thanks! > > > >Michelle > >--- > >Michelle Murrain, Ph.D. > >President, Norwottuck Technology Resources > >[EMAIL PROTECTED] www.norwottuck.com > SVCMC - Center for Behavioral Health Thomas Good tomg@ { admin | q8 } .nrnet.org IS Coordinator / DBA Phone: 718-354-5528 Fax: 718-354-5056 Powered by: PostgreSQL s l a c k w a r e FreeBSD: RDBMS |-- linux The Power To Serve
Re: [GENERAL] Users
Well, I only want them to access it through a front end. No one is actually going to be running straight out queries, creating tables, etc. Adam Lang Systems Engineer Rutgers Casualty Insurance Company - Original Message - From: "Danny" <[EMAIL PROTECTED]> To: "Adam Lang" <[EMAIL PROTECTED]>; "PGSQL General" <[EMAIL PROTECTED]> Sent: Tuesday, September 26, 2000 8:21 AM Subject: Re: [GENERAL] Users > > If you want users to access your database remotely. Goto www.phpwizard.net > or www.phpwizards.net and look for a product call "myPostgresql " (I believe) > which iprovides a web based interface for Postgresql > > And ithe program is Free, no licence ietc etc. > > On Tue, 26 Sep 2000, Adam Lang wrote: > > To be a user to interact with postgres, do you have to be a user on the > > system it is installed at? > > > > i.e. Jane works from home and uses a program that access the database > > remotely. Does Jane need to be a user on the database server as well as a > > user in postgresql? > > > > Adam Lang > > Systems Engineer > > Rutgers Casualty Insurance Company
Re: [GENERAL] web programming
I use PHP with my Postgresql and haven't hit a limitation yet. As far as perl goes, I know some web develoeprs for a consulting firm that use Solaris and they are pretty tight in the industry. Their advice to me was that if I already don't know Perl, don't learn it. They said to take the Java route. They also were fond of PHP. In a nutshell, they said Java will phase out most large perl implementations (new clients tend to be developed in java, old code is redone, etc.) As for me, I was thinking about trying java server pages, just for the fact that you can technically use Java for every level of development. Adam Lang Systems Engineer Rutgers Casualty Insurance Company - Original Message - From: "Michelle Murrain" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 25, 2000 9:15 PM Subject: [GENERAL] web programming > Hi folks, > > I thought (now that I've solved my DBD::Pg problem) that I'd ask a > fairly generic opinion question. I've been working with postgres and > php now for about 4 years, quite heavily in the last year. I'm sold > on postgres, and will continue to use it unless I have compelling > reasons not to. But I'm debating about continuing development using > php. > > 1) I'm getting better and better at perl - and it's a much more > mature language than php. > > 2) I've been learning a bit about jsp and java servlets - and that's > intriguing me a lot. > > So what's your favorite web programming language to use with > postgres, and why? Are there speed/performance issues I should think > about? I'm also beginning to get into XML, so there is another set of > things to think about. > > Thanks! > > Michelle > --- > Michelle Murrain, Ph.D. > President, Norwottuck Technology Resources > [EMAIL PROTECTED] www.norwottuck.com
Re: [GENERAL] web programming
Zope. http://www.zope.org Been using PostgreSQL behind Zope for a couple of sites for over 8 months now and it has been a pleasure. Cheers, J At 9:15 PM -0400 9/25/2000, Michelle Murrain wrote: >Hi folks, > >I thought (now that I've solved my DBD::Pg problem) that I'd ask a >fairly generic opinion question. I've been working with postgres and >php now for about 4 years, quite heavily in the last year. I'm sold >on postgres, and will continue to use it unless I have compelling >reasons not to. But I'm debating about continuing development using >php. > >1) I'm getting better and better at perl - and it's a much more >mature language than php. > >2) I've been learning a bit about jsp and java servlets - and that's >intriguing me a lot. > >So what's your favorite web programming language to use with >postgres, and why? Are there speed/performance issues I should think >about? I'm also beginning to get into XML, so there is another set >of things to think about. > >Thanks! > >Michelle >--- >Michelle Murrain, Ph.D. >President, Norwottuck Technology Resources >[EMAIL PROTECTED] www.norwottuck.com
Re: [GENERAL] web programming
I've been using PostgreSQL with Lutris Enhydra for my web apps and am quite happy with the combination. Enhydra is open source and Java-based. One of its centerpiece components is XMLC -- an XML compiler. For more info on Enhydra itself, see: http://www.enhydra.org/software/enhydra For a quick tutorial to get it up and running with PostgreSQL see: http://www.enhydra.org/software/documentation/enhydra/NewApp-DODS-Tutorial-PGSQL.html When the time comes to revamp the perl/CGI apps I developed before Enhydra I'll very likely port them over as well. HTH, Jim -- Michelle Murrain wrote: > > Hi folks, > > I thought (now that I've solved my DBD::Pg problem) that I'd ask a > fairly generic opinion question. I've been working with postgres and > php now for about 4 years, quite heavily in the last year. I'm sold > on postgres, and will continue to use it unless I have compelling > reasons not to. But I'm debating about continuing development using > php. > > 1) I'm getting better and better at perl - and it's a much more > mature language than php. > > 2) I've been learning a bit about jsp and java servlets - and that's > intriguing me a lot. > > So what's your favorite web programming language to use with > postgres, and why? Are there speed/performance issues I should think > about? I'm also beginning to get into XML, so there is another set of > things to think about. > > Thanks! > > Michelle > --- > Michelle Murrain, Ph.D. > President, Norwottuck Technology Resources > [EMAIL PROTECTED] www.norwottuck.com
Re: [GENERAL] web programming
On Mon, Sep 25, 2000 at 09:15:53PM -0400, Michelle Murrain wrote: > 1) I'm getting better and better at perl - and it's a much more > mature language than php. I've used perl just as a sysadmin till now, but I'm learning DBI/mod_perl at the moment. I found that they are very powerfull tools; the DBI is quite easy but mod_perl not, you have to read lots of docs and do some practise. The fact that php is an embedded language may be things easy at the beginning, but mod_perl give you a better control over the Apache. (But in fact I know just some basics about PHP). > So what's your favorite web programming language to use with > postgres, and why? Are there speed/performance issues I should think mod_perl is known to be very fast, in fact it do not need to parse file to find the code, by the way when a script has been compiled it is kept in memory. On the other hand it needs lot of memory. > about? I'm also beginning to get into XML, so there is another set of > things to think about. There are CPAN modules to parse then as input, and, while XML is all text pile is very easy to create and manipulate with perl. -- Ciao, Maurizio.
Re: [GENERAL] FreeBSD Softupdates??
On Tue, Sep 26, 2000 at 03:20:31AM -0700, Alfred Perlstein wrote: > It can cause problems because softupdates makes meta data changes > (in this case file creation/removal) asyncronously, the same actually > happens with most other logging filesystems that don't support > transactions. I've been running FreeBSD 4.1 with soft updates on my development box for a while now without any problems at all. Although it's not production so there's not a lot of load on PgSQL. I don't know if it hurts or hampers performance. HTH, Neil -- Neil Conway <[EMAIL PROTECTED]> Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc Encrypted mail welcomed I am not interested in the past. I am interested in the future for that is where I intend to spend the rest of my life. -- Charles F. Ketterring PGP signature
[GENERAL] Int8 problem
Hi I have intalled Postgres 7.0.2 on a Compaq Alpha with DigitalUnix. If I insert a bigger number like 10^13 in an int8 type field i'm getting no error messages, no warnings, but if I check the value inserted i receive totaly wrong number like 2543 If you have any suggestions please let me know. Thank any way.
[GENERAL] PGresult deleted after PQfinish(PGconn)
I am trying to create a class for my application that handles postgres access via the C interfaces. My question is the following: Will be PGresult also deleted when I close a connection with PQfinish(PGconn), or am I supposed to delete the handle on PGresult by myself after closing connection to Postgresql. Thanks in advance José Manuel Lorenzo López -- ** ** José Manuel Lorenzo López** ** ** ** ICA Informationssysteme Consulting & Anwendungsgesellschaft mbH ** ** Dept. SAP Basis R/3 VBue** ** ** ** e-mail to: [EMAIL PROTECTED]** **
Re: [GENERAL] one more word about rules
ID shouldn't contain any additional informations (like order). It's ID. Use another field for sorting. At 16:33 22.9.2000 , Abe Asghar wrote: >Hi everyone, > >I have built a database that uses int4 as the unique identifier for a news >database. > >Therefore an article has a identifier 1, the next one has 2 etc. > >Then I order them when they are displayed on the web reversely so that the >last article added is at the top of the list. > >I now face a major problem. If we need to back dackdate an article - I >can't. This is because the all the indexes are taken up ie 1, 2, 3..75 >odd records. If I want to add one between 50 and 51 ie 50.5, I cannot >because the field is an int4. > >One idea I had to get around this was to create a new table with this column >as a float and read and write all therecords in with a PHP script. > >Is there an easier way such as converting the column data type from a int4 >to a float. > >Thanks in advance. >Abe.
Re: [GENERAL] FreeBSD Softupdates??
* Dale Walker <[EMAIL PROTECTED]> [000926 01:02] wrote: > > Just a quick q. > > Does anyone know what effects FreeBSD's 'softupdates' would have > on the /usr/local/pgsql/data filesystem. > > Would this help performance, or would it be a shot in the foot?? It can cause problems because softupdates makes meta data changes (in this case file creation/removal) asyncronously, the same actually happens with most other logging filesystems that don't support transactions. Since afaik postgresql doesn't use lots and lots of tempfiles you may want to play it safe and not use softupdates. -- -Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]] "I have the heart of a child; I keep it in a jar on my desk."
[GENERAL] FreeBSD Softupdates??
Just a quick q. Does anyone know what effects FreeBSD's 'softupdates' would have on the /usr/local/pgsql/data filesystem. Would this help performance, or would it be a shot in the foot?? -- Dale Walker [EMAIL PROTECTED] Independent Computer Retailers (ICR) http://www.icr.com.au ICRnet http://www.icr.net.au
[GENERAL] Incremental backup of logfile
Hello, it is possible to save the transaction log of PostgreSQL? I would like to store daily logs and sync a second server with this daily log (it is enough for this purpose). Kind regards Andreas.