FAQ

PostgreSQL > pgsql-general > July 2002

Search Discussions

439 discussions - 1,868 posts

  • Hey, Oreilly and Assoc is interviewing me and they asked me two questions I don't have the answers to: When is 7.3 set to land? When is 8.0 set to land? I said, when there done, but they want a ...
    Joshua D. DrakeJoshua D. Drake
    Jul 3, 2002 at 11:07 pm
    Jul 15, 2002 at 1:26 pm
  • We are trying to throw a lot of memory at PostgreSQL to try to boost performance. In an attempt to put our entire database into memory, I want to allocate 2 to 3 GB out of 4 GB on a dual processor ...
    Martin DillardMartin Dillard
    Jul 10, 2002 at 5:45 pm
    Jul 28, 2002 at 5:31 pm
  • I have a table of about 5000 records that I noticed was taking a very long time to do simple selects from. I looked at explain analyze and got the following: rms=# explain analyze select count(*) ...
    Robert TreatRobert Treat
    Jul 15, 2002 at 8:22 pm
    Jul 17, 2002 at 8:03 pm
  • Hello, I am back from vacation and still experiencing strange behaviour of my database: Dumping all to /var/lib/pgsql/backup/db-backup-20020709.out.... connected to template1... dumping database ...
    Henrik SteffenHenrik Steffen
    Jul 9, 2002 at 3:30 pm
    Jul 14, 2002 at 4:26 pm
  • Thanks to all the people that responed. Summaries and notes:- VACUUM The consensus seems to be that old copies are not removed until a Vacuum is performed. When a Vacuum is performed then only ...
    Anthony BerglasAnthony Berglas
    Jul 19, 2002 at 4:33 am
    Aug 30, 2002 at 6:22 am
  • Which is better, PostgreSQL or MySQL? Both are excellent products with unique strengths, and the choice is often a matter of personal preference. Read on for a useful comparison of these two open ...
    BuilderBuilder
    Jul 11, 2002 at 3:26 am
    Aug 2, 2002 at 7:19 pm
  • Don't know about that, but for what it's worth, a TESS trademark search indicates that the phrase "SQL Server" is a registered trademark of... Sybase(!). I'm surprised it was allowed to be ...
    Robert L MathewsRobert L Mathews
    Jul 8, 2002 at 5:46 am
    Jul 12, 2002 at 7:55 am
  • We are currently designing a system for a client, where the database will hold mission-critical information, dealing with money. Needless to say the requirement on the database are very high, ...
    Rune TeigenRune Teigen
    Jul 12, 2002 at 11:57 am
    Jul 17, 2002 at 2:17 pm
  • A bit late, but here is the explain analyse data for the problem where a complex DB was able to produce very quick results with low load with postgres 7.2 but takes many many times longer with ...
    Sam LiddicottSam Liddicott
    Jul 8, 2002 at 10:31 am
    Jul 15, 2002 at 12:47 pm
  • Is it just me, or are the mail list archives still generating HTML that's missing close table tags, so the pages cannot be viewed on Linux Netscape 4.78? cjs -- Curt Sampson <cjs@cynic.net +81 90 ...
    Curt SampsonCurt Sampson
    Jul 16, 2002 at 7:05 am
    Jul 27, 2002 at 9:47 am
  • I know that the question of forcing PostgreSQL to use an index during search ops is an FAQ and have worked with each of the suggested solutions to no avail. From the nature of those questions, it ...
    Stephen BirchStephen Birch
    Jul 16, 2002 at 4:31 pm
    Jul 23, 2002 at 10:20 pm
  • Hey, I was running a script which does some INSERTS and UPDATE some table. I found that there is no need for COMMIT; After each statement the TABLE is immediately commited. Other session via psql can ...
    StefanStefan
    Jul 19, 2002 at 11:19 am
    Jul 19, 2002 at 10:25 pm
  • Hello all, It might be not a correct place to post this. I am creating a table from psql. Everything is fine except I got some troubles when trying to create the same table but in a different way and ...
    StefanStefan
    Jul 19, 2002 at 6:44 am
    Jul 19, 2002 at 8:16 pm
  • Yo! Browsing through the online docs, I see the special columns documented in http://www.postgresql.org/idocs/index.php?sql-syntax-columns.html . But I'm missing discussion about significance of the ...
    Adrian 'Dagurashibanipal' von BidderAdrian 'Dagurashibanipal' von Bidder
    Jul 16, 2002 at 2:23 pm
    Jul 19, 2002 at 1:07 pm
  • Hi, I am looking into how I should backup my PostgreSQL database. Is there a way to do incremental backup? I think incremental back seems to be a better solution in the long run, because it is more ...
    Sanjeev RathoreSanjeev Rathore
    Jul 7, 2002 at 2:25 am
    Jul 8, 2002 at 5:59 pm
  • Hi there, If you'd have to suggest which type of database one migh use, how would you reflect the differences between them to show up pros and cons ? Any URL to help me to clarify this situation ? ...
    Fabiàn R.BreschiFabiàn R.Breschi
    Jul 31, 2002 at 5:04 pm
    Aug 7, 2002 at 3:37 pm
  • hello, I just managed to get a simple database running with postgresql. Now I would like to write some CGI scripts in perl that will be able to use it. What perl module should I use for this? I have ...
    JgdonJgdon
    Jul 27, 2002 at 6:07 pm
    Aug 3, 2002 at 10:15 am
  • Hi I would like to know if there is some way how to disable case sensitivity in PostgreSQL server. With some varaiable or some setting in configuration file or how? So after this would be the same ...
    IgorIgor
    Jul 9, 2002 at 11:13 pm
    Jul 19, 2002 at 12:42 pm
  • Hello, Without getting into a huge debate over which implementation is better. I can suffice to say that we have seen significant demand for this solution without the obnoxiousness of ssh. SSH is ...
    Joshua D. DrakeJoshua D. Drake
    Jul 15, 2002 at 8:44 pm
    Aug 3, 2002 at 5:38 pm
  • I am writing a stock system, and am looking for either a confirmation of my plan or a "No, don't do that!" before I get in too deep.. I have a table, called stock_transactions. It has primary key and ...
    Rob Brown-BaylissRob Brown-Bayliss
    Jul 29, 2002 at 9:48 pm
    Jul 31, 2002 at 9:25 pm
  • Is there way to track each sql statement and the user for the server? Thanks, -- Laurette Cisneros The Database Group (510) 420-3137 NextBus Information Systems, Inc. www.nextbus.com ...
    Laurette CisnerosLaurette Cisneros
    Jul 26, 2002 at 10:27 pm
    Jul 30, 2002 at 6:47 pm
  • I'm using PostgreSQL (via pyPgSQL) to deal with a database of tasks. I want to have processes be able to "check out" a task, but I'm seeing some kind of odd results. If I try to force two processes ...
    Sean ReifschneiderSean Reifschneider
    Jul 14, 2002 at 12:33 am
    Jul 19, 2002 at 8:50 am
  • Hi, after some fooling around I figured out that a function body can't be larger than the defined postgres' block size, which defaults to 8192 byte. The same time I read enlarging the default block ...
    Ralph GraulichRalph Graulich
    Jul 16, 2002 at 5:43 pm
    Jul 16, 2002 at 11:33 pm
  • I have a dual cpu box with 2GB RAM dedicated to running Postgres. Last week, I upgraded FreeBSD from 4.4-STABLE to 4.6-RELEASE-p1. When I went to restart postgres, it complained that it could not ...
    Vivek KheraVivek Khera
    Jul 10, 2002 at 6:15 pm
    Jul 13, 2002 at 10:20 am
  • Hi, can somebody give me a hint on how to contact the guys at pgsql.com regarding the eRserver software? They don't seem to check their info@ accounts listed on their websites. Thanks Greetings, ...
    Björn MetzdorfBjörn Metzdorf
    Jul 25, 2002 at 9:07 am
    Jul 25, 2002 at 4:27 pm
  • Can anyone recommend a free GUI DB design tool for Windows I could use to model my database design? (something similar to the design tool in MS access). I don't need it to actually connect to a DB or ...
    Jean-Christian ImbeaultJean-Christian Imbeault
    Jul 10, 2002 at 3:08 am
    Jul 10, 2002 at 4:10 pm
  • Hello! I tried the regression tests for contrib/tsearch as suggested, and this leads to exactly the same symptoms as described with the real-life test. The last entry of regression.diffs reads: ...
    Markus WollnyMarkus Wollny
    Jul 29, 2002 at 1:38 pm
    Jul 30, 2002 at 2:14 pm
  • Hi, using: - postgres 7.2.1 (with pl_funcs.c patch) - linux kernel 2.4.17 on intel 32 dual CPU While attempting to port an existing application things started to fail randomly, like 'relation xyz not ...
    Ralph GraulichRalph Graulich
    Jul 21, 2002 at 1:00 pm
    Jul 22, 2002 at 5:04 pm
  • On the FAQ we have: CHAR() is best when storing strings that are usually the same length. VARCHAR() is best when storing variable-length strings, but you want to limit how long a string can be. TEXT ...
    Francisco ReyesFrancisco Reyes
    Jul 4, 2002 at 6:19 pm
    Jul 21, 2002 at 9:57 am
  • Lazy programmer is looking for implementation of the following datatypes: * phone (or fax) numbers (with format checking) like +33 1 39 30 83 46 * email addresses (with format checking and ideally a ...
    Stephane BortzmeyerStephane Bortzmeyer
    Jul 19, 2002 at 11:52 am
    Jul 19, 2002 at 4:39 pm
  • Hello all: I want to do some profiling of a large application I run under postgres. Ideally I'd like to capture just the queries that are submitted to the database. It would be rather annoying to ...
    Steve LaneSteve Lane
    Jul 17, 2002 at 3:40 am
    Jul 19, 2002 at 8:21 am
  • Hi, is there a flag to set which determines if queries run successful with a case sensitive or case insensitive WHERE clause: For example: if I have a name1 colum with a value 'Test' I would like to ...
    Andreas SchlegelAndreas Schlegel
    Jul 10, 2002 at 12:02 pm
    Jul 11, 2002 at 8:33 am
  • Hello! Sorry I took so long - I attached the schema as asked. Actually it seems to be very often the case, that certain operations suck up more than 25% of available memory and processing capacities. ...
    Markus WollnyMarkus Wollny
    Jul 2, 2002 at 2:10 pm
    Jul 4, 2002 at 7:46 am
  • Hi! Just one questions: Our Company is searching for a good SQL-Database, which will be using very extensivly in the future. PostgreSQL really looks good (low/no cost/ many features), but do big ...
    Christian LübeckChristian Lübeck
    Jul 18, 2002 at 5:49 pm
    Jul 21, 2002 at 6:23 am
  • hi, I am using Postgresql-7.1.3 with RedHat Linux-7.1 and JDBC. I am having an indexed table with nearly 3,000 records for a month. My machine is with 256 MB RAM, 600 MHz. I am having a report from ...
    Thirumoorthy BhuvneswariThirumoorthy Bhuvneswari
    Jul 8, 2002 at 12:28 pm
    Jul 12, 2002 at 10:48 am
  • Hello, I have a database model where a many to many relation is used, so i need to create a table with two primary key. Don't know how to solve this in postgress, can't find it in the tutorials, so ...
    Angela LuyfAngela Luyf
    Jul 4, 2002 at 1:54 pm
    Jul 8, 2002 at 5:22 am
  • Hi all, I am trying to run the regression tests under PG 7.2.1 RedHat 7.3- I have installed PG from rpms , so from package, not source code. Right now I have no idea if I need the source code of PG ...
    StefanStefan
    Jul 23, 2002 at 9:41 am
    Jul 26, 2002 at 5:00 am
  • Hi all, I read Postgresql limits at postgresql.org: Maximum size for a database unlimited (60GB databases exist) Maximum size for a table 64 TB on all operating systems Maximum size for a row ...
    Paulo Henrique Baptista de OliveiraPaulo Henrique Baptista de Oliveira
    Jul 15, 2002 at 3:05 pm
    Jul 18, 2002 at 2:27 am
  • Hello. I am trying to figure out how to import xml documents into a postgres database. I am running PostgreSql 7.1.3 on Red Hat 7.2 at the moment. I have several dynamic xml documents that I want ...
    Nathan HillNathan Hill
    Jul 10, 2002 at 5:58 pm
    Jul 11, 2002 at 3:05 pm
  • Using pg 7.1.2, I can enter the following statement successfully: # alter table manufacturer add column dummy integer not null default 1; However, under 7.2.1, the same statement gets me -- ERROR: ...
    Ad wolfAd wolf
    Jul 7, 2002 at 12:35 am
    Jul 9, 2002 at 8:10 pm
  • Hi all, I'm trying to install Postgres 7.2.1-5 RPM onto my linux 7.1 system. Accordingly, I seem to need three files... libcrypto.so.2 libreadline.so.4 libssl.so.2 How can I obtain these files?? I've ...
    Rflm101Rflm101
    Jul 5, 2002 at 2:56 pm
    Jul 9, 2002 at 6:28 pm
  • Hello! We've still not been successful in our attempts to migrate from oracle to PostgreSQL - and we've got ODBC under suspicion to cause a servere bottleneck. Here's our setup: Database: SuSE Linux ...
    Markus WollnyMarkus Wollny
    Jul 5, 2002 at 6:55 pm
    Jul 9, 2002 at 1:52 am
  • This is no doubt asked frequently, but I have exactly two days experience with PostgreSQL, and am hot on a project for which I need a more-or-less immediate answer. Most of my previous DB experience ...
    Lynn David NewtonLynn David Newton
    Jul 2, 2002 at 8:06 pm
    Jul 5, 2002 at 10:33 am
  • Hi, We're running PostgreSQL 7.1.3 (I know, I know) on Solaris 7 on two Sun E4500s with 8 CPUs and 16 Gig of RAM. We have noticed that one of the machines is considerably slower than the other. We ...
    Andrew SullivanAndrew Sullivan
    Jul 11, 2002 at 4:30 pm
    Aug 27, 2002 at 6:04 pm
  • Hey all, I'm thinkin' maybe I should post this in a shell scripting group but thought someone here may be able to help me out... I'm lookin' to run a shell script through the crontab on a nightly ...
    RatlheadRatlhead
    Jul 20, 2002 at 9:35 am
    Jul 29, 2002 at 8:44 am
  • Hi ! I've tried cast to convert char to inet, but that is no good waw :((. Does anybody know how to do that ? Thank you in advance. Best regards Michal
    Michal OMichal O
    Jul 23, 2002 at 11:36 am
    Jul 25, 2002 at 3:35 pm
  • i have 2 postgresql boxes, one live and one for dev. the dev box has postgresql 7.2 compiled from source and ps auxf gets me a postmaster process and then the db parameters (-i -B 512 etc). the live ...
    Steve BrettSteve Brett
    Jul 17, 2002 at 3:50 pm
    Jul 24, 2002 at 8:24 am
  • I'm not much practical with Linux but reading the characteristics of PostGreSql I find it very interesting. Why does not exist one official version for windows? -- Andrea Chiadò Piat Bit Informatica ...
    Andrea Chiado' PiatAndrea Chiado' Piat
    Jul 22, 2002 at 9:45 am
    Jul 22, 2002 at 5:14 pm
  • We have a website using postgresql and php, hosted in a shared server. The settings for the maximum connections allowed is 32. I have used the persistent connection function pg_pconnect for all the ...
    Siva KumarSiva Kumar
    Jul 18, 2002 at 1:36 pm
    Jul 19, 2002 at 2:34 pm
  • Ok, I have an oddball question. But let me give you a little background. As a broadcast engineer, I often need to compute the distance to a groundwave contour for an AM radio station. The code to do ...
    Lamar OwenLamar Owen
    Jul 16, 2002 at 11:32 pm
    Jul 18, 2002 at 5:05 am
Jul 2002
12345…9
Group Navigation
period‹ prev | Jul 2002 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions439
posts1,868
users423
websitepostgresql.org
irc#postgresql

423 users for July 2002

Tom Lane: 157 posts Bruce Momjian: 89 posts Andrew Sullivan: 76 posts Curt Sampson: 62 posts Stephan Szabo: 41 posts Neil Conway: 37 posts Martijn van Oosterhout: 30 posts Elielson Fontanezi: 29 posts Marc G. Fournier: 28 posts Stephane Bortzmeyer: 25 posts Chris Albertson: 24 posts Henrik Steffen: 24 posts Stefan: 23 posts Bruno Wolff III: 22 posts Ralph Graulich: 22 posts Jan Wieck: 20 posts Joe Conway: 19 posts Oliver Elphick: 19 posts Thomas Lockhart: 18 posts Justin Clift: 17 posts
show more
Archives