FAQ

Search Discussions

330 discussions - 1,786 posts

  • Hi ... I'm trying to convince my boss to use posgresql (I need RI, transactions and views), but he keeps comparing the project to mysql. Until now, I found the answers to he's questions on the ...
    Bo LorentsenBo Lorentsen
    Aug 19, 2003 at 11:32 am
    Sep 5, 2003 at 2:55 am
  • I don't feel very confident when it comes to software licenses. But there are some cases I would like to make myself clear. What I am particulary interested in is when does GPL license become ...
    KaarelKaarel
    Aug 31, 2003 at 6:30 pm
    Sep 26, 2003 at 5:02 pm
  • Currently I'm running PostgreSQL 7.2.3 and having a problem sorting. I've got two colums of data, one Int4 one Varchar. When I sort ASC on the varchar I get some strange results. Here a section of ...
    Tim EdwardsTim Edwards
    Aug 12, 2003 at 9:58 pm
    Aug 19, 2003 at 3:53 pm
  • What's the big deal with importing text files? I have a 70 MB file to import and it's been one problem after another. I used the copy command and it appears that it's just not possible. I finally ...
    ExpectExpect
    Aug 13, 2003 at 9:14 pm
    Aug 15, 2003 at 6:26 pm
  • Hello, As a recent flurry of activity has commenced within Command Prompt we have released upon this rather unround earth, plPHP. Yes it is trigger safe, yes you can write UDF's in PostgreSQL with ...
    Joshua D. DrakeJoshua D. Drake
    Aug 2, 2003 at 12:14 am
    Aug 6, 2003 at 4:03 pm
  • One of our sysads sent this link ... wondering if there is any comment on it from the world of actual users of linux and a database. ...
    Gregory S. WilliamsonGregory S. Williamson
    Aug 25, 2003 at 9:28 pm
    Oct 7, 2003 at 4:06 am
  • I'm assuming this has been beaten to death, but I'm looking for some companies offering commercial support contracts in SF bay area. The link for commercial support from the FAQ is broken, and my 3/4 ...
    Dustin SallingsDustin Sallings
    Aug 11, 2003 at 1:31 am
    Aug 16, 2003 at 4:27 pm
  • Hi .. Well after discussing how bugs are handled in PG, and the development culture in both MySQL and Postgresql, my boss agress that it may be a good aletenertive til MySQL 4.x (InnoDB), but ... He ...
    Bo LorentsenBo Lorentsen
    Aug 30, 2003 at 11:59 am
    Sep 3, 2003 at 2:37 pm
  • Hello, Is possible merge two arrays like array[1,2,3] + array[4,5,6] = array[1,2,3,4,5,6] select array_append(array[1,2,3], array[2,3]); ERROR: function array_append(integer[], integer[]) does not ...
    Pavel StehulePavel Stehule
    Aug 15, 2003 at 9:41 am
    Aug 17, 2003 at 5:49 am
  • Hi, May be my question is stupid ... but I'm a little suprised : SELECT id_letter as letter from my_table; letter ----- B C a A SELECT id_letter as letter from my_table order by letter; letter ----- ...
    Hervé PiedvacheHervé Piedvache
    Aug 18, 2003 at 8:20 am
    Aug 19, 2003 at 5:41 pm
  • Hello everyone, This is not a troll and I certainly don't want to start a holy war but wouldn't it be a good idea to move the postgresql lists from the mailing list approach to usenet? IMHO it's more ...
    Jules AlbertsJules Alberts
    Aug 19, 2003 at 8:07 am
    Aug 27, 2003 at 11:34 am
  • Hi, For my supprise I found that functions have 32 parameter limit. Where to find more info about this limitation or similar limitations ? I need at least 50, 100 would be ok. Real life function ...
    IvarIvar
    Aug 27, 2003 at 4:56 pm
    Aug 29, 2003 at 10:41 am
  • I want to be able to generate SQL statements that will go through a list of data, effectively row by row, enquire on the database if this exists in the selected table- If it exists, then the colums ...
    Philip BoonzaaierPhilip Boonzaaier
    Aug 19, 2003 at 2:25 pm
    Aug 26, 2003 at 6:20 pm
  • Ran sets of 150 pgbench runs, with clients (1, 2, 4, 8, 16) and transactions (5 each at 125, 250, 500, 1000, 2000, 4000), then parsed and plotted with gnuplot. Breaks between number of clients are at ...
    P.J. \"Josh\" RoveroP.J. \"Josh\" Rovero
    Aug 19, 2003 at 4:47 pm
    Aug 28, 2003 at 7:08 am
  • To all French speakers on the list, I am pleased to announce the start of a PostgreSQL general mailing list in French. Its name is pgsql-fr-generale. I hope many of you will join it so that we can ...
    Francois SuterFrancois Suter
    Aug 19, 2003 at 8:01 am
    Aug 20, 2003 at 7:27 pm
  • Hmm, will oid's not change so that they are unique regardless, or will oid be removed. This is just not a general solution to this problem, and will need awareness of the id type in the application ...
    Bo LorentsenBo Lorentsen
    Aug 28, 2003 at 12:54 pm
    Sep 1, 2003 at 5:12 pm
  • Hi-- I had been thinking of the issues of multimaster replication and how to do highly available, loadballanced clustering with PostgreSQL. Here is my outline, and I am looking for comments on the ...
    Chris TraversChris Travers
    Aug 24, 2003 at 4:27 am
    Aug 29, 2003 at 3:20 am
  • Hi, I have some experience in MS Access 97 and 2000 and did write some application with them. Now, I want to learn PostgreSQL. I installed it on a RH8.0 server. Which books would you guys recommand? ...
    G LamG Lam
    Aug 21, 2003 at 3:20 am
    Aug 28, 2003 at 11:35 pm
  • Greetings, I'm getting a big performance problem and I would like to ask you what would be the reason, but first I need to explain how it happens. Let's suppose I can't use sequences (it seams ...
    Vilson fariasVilson farias
    Aug 18, 2003 at 2:27 pm
    Aug 19, 2003 at 5:14 pm
  • Hi, i've a speed problem withe the following statement: SELECT DISTINCT pz.l1_id, pz.l2_id, pz.l3_id, pz.l4_id FROM ot_adresse AS a, ot_produkt AS p LEFT OUTER JOIN ot_kat_prod AS pz ON ( p.p_id = ...
    Thomas BeutinThomas Beutin
    Aug 28, 2003 at 2:55 pm
    Aug 29, 2003 at 2:52 pm
  • Is there a SQL command I can issue which will list all the TABLES within a database ? Pete
    Peter MoscattPeter Moscatt
    Aug 27, 2003 at 10:37 am
    Aug 29, 2003 at 9:06 am
  • I installed RedHat 9.0 and found that PostGreSql was installed with the OS. I started the service, tried to create a database. I cannot access/create a database from root or any of the other accounts ...
    MichaelMichael
    Aug 12, 2003 at 10:51 pm
    Aug 16, 2003 at 11:00 pm
  • I decided to try pg_autovacuum and am having a problem. It never analyzes or vacuums. I looked at the code and had it display printf("%s,%s,%s\n",PQgetvalue(res, j, PQfnumber(res, ...
    Adam KavanAdam Kavan
    Aug 29, 2003 at 9:21 pm
    Sep 4, 2003 at 6:35 pm
  • I notice in 7.3.3 the planner can't tell when a LIKE has no wildcards and is in reality an '='. Is this an easy change to make?
    Joseph ShraibmanJoseph Shraibman
    Aug 3, 2003 at 8:16 pm
    Aug 5, 2003 at 3:22 pm
  • Hi, I've got a serious problem. After a horrible filesystem crash the only thing left of my database are some files in /lost+found (with changed names!). Is there a way to recover the data from those ...
    Christian von KietzellChristian von Kietzell
    Aug 20, 2003 at 8:02 pm
    Sep 2, 2003 at 10:10 am
  • Hi. I'm having some trouble on the use of indexes. The querys below are exactly the same but refer to different months. One case uses indexes, the other doesn't. Is there anything I can do? ...
    Pedro AlvesPedro Alves
    Aug 25, 2003 at 2:53 pm
    Aug 26, 2003 at 3:43 pm
  • This may have been better posted in the advocacy list but I am not a subscriber. We recently purchased Dreamweaver MX and I was a little surprised to find that one of its pre-defined scripting ...
    Glen EustaceGlen Eustace
    Aug 15, 2003 at 10:22 pm
    Sep 17, 2003 at 3:35 pm
  • Hi, After a very recent postgresql update, the postmaster failed to start because of this: Now I know nl_NL@euro.UTF-8 is an incorrect locale, I fixed that some time ago, but because postgresql kept ...
    Sander SmeenkSander Smeenk
    Aug 29, 2003 at 9:58 am
    Sep 3, 2003 at 9:00 pm
  • I've had some fun in the past where I've had to grant a lot of tables and other similar system commands. Unfortunatly, you can't use queries to fill in fields for you. Anyway, I've implemented a ...
    Martijn van OosterhoutMartijn van Oosterhout
    Aug 17, 2003 at 3:55 pm
    Aug 25, 2003 at 8:49 am
  • Hi, I have a table with two column, date and data I would like to do a set of queries to generate statistics on the data, such as count(data) for month blocks and year blocks. What is the best way to ...
    MatMat
    Aug 19, 2003 at 7:35 am
    Aug 20, 2003 at 8:45 pm
  • Hi, I would like to know whether postgresql run on Solaris on Sparc machine? How can I download if available? Best Regards Joseph
    Keow Yeong Huat JosephKeow Yeong Huat Joseph
    Aug 22, 2003 at 7:12 am
    Aug 29, 2003 at 4:32 pm
  • <OT about the worm Jeessh, a lot of people have my email address. I have received about 500 copies of the worm in the last 24 hours. My mail spool at work was sooooo full I couldn't get out or relay ...
    Dennis GearonDennis Gearon
    Aug 22, 2003 at 9:13 pm
    Aug 28, 2003 at 2:22 pm
  • I am rather new to PostgreSQL.What I am looking for ist this: An example database that demonstrates the usage of all the core PostgreSQL features. It is one thing to read extensive documentation, but ...
    Erwin BrandstetterErwin Brandstetter
    Aug 18, 2003 at 2:20 pm
    Aug 22, 2003 at 4:55 am
  • I'm running 7.4Beta1 with pg_autovacuum. In one of my operations which is executed frequently, a REINDEX is done after a COPY. Well, VACUUM's are being executed by pg_autovacuum, and my app is ...
    Robert CreagerRobert Creager
    Aug 10, 2003 at 8:50 pm
    Aug 13, 2003 at 3:21 pm
  • Question, I have a table (1) with 2 col (a & b) where b can sometimes be null. I need a query that if B is null I get back the contents of A.. but if B is not null I do a join on it and table (2) col ...
    Williams, Travis L, NEOWilliams, Travis L, NEO
    Aug 28, 2003 at 9:55 pm
    Aug 29, 2003 at 4:54 pm
  • Marc, I'd be interested in seeing the updated stats for this bought of virus transmission we're going through. Yesterday you had almost 1 for 1 valid email. By then I think I was getting about 3-4 ...
    Nigel J. AndrewsNigel J. Andrews
    Aug 20, 2003 at 7:19 am
    Aug 20, 2003 at 9:45 pm
  • Is it possible to write functions for PL/C that have variable argument lists? I.E. UPPER( arg ) UPPER( arg, encoding_list ) LOWER( arg ) LOWER( arg, encoding_list ) SUBSTR( arg, arg, arg ) SUBSTR( ...
    Dennis GearonDennis Gearon
    Aug 11, 2003 at 4:01 pm
    Aug 12, 2003 at 9:51 pm
  • We are moving an application from Oracle 8i to Postgres and I've run into a problem attempting to duplicate a feature we currently use. In Oracle you can divide a table into partitions. We use this ...
    Roger HandRoger Hand
    Aug 1, 2003 at 8:45 pm
    Aug 5, 2003 at 4:30 pm
  • I have been request to create a relational database map that can be place on the wall in my office. Generally I done these in the past by just manually typing the information into Access and then ...
    Tim EdwardsTim Edwards
    Aug 14, 2003 at 7:51 pm
    Sep 17, 2003 at 3:30 pm
  • Hi, I have some problems with creating a query that will replace values in one table from another one. Table 1: userName : refCode1 : refCode2 ------------------------------ alex : 12 : 24 Table 2: ...
    AlexAlex
    Aug 28, 2003 at 3:29 am
    Sep 1, 2003 at 2:58 am
  • Hello All! Im suffering an appearantly common problem with psql, although I haven't been able to locate the proper solution. Using phpPgAdmin I've created a relation (note: this relation is grossly ...
    Sune NielsenSune Nielsen
    Aug 28, 2003 at 12:54 pm
    Aug 29, 2003 at 4:01 am
  • Hi, when I run a SELECT INTO and the result is 0 or zero row, then I still get a positive result if using IF FOUND THEN.... Is there a problem or do we need to use ROW_COUNT instead ? Alex
    AlexAlex
    Aug 28, 2003 at 12:46 am
    Aug 29, 2003 at 3:42 am
  • I have two tables in two databases (Pg 7.2.1 - yes I need to upgrade but there are several other dependencies I have to resolve first) and I need to update one database's tables so they can be merged ...
    Roderick A. AndersonRoderick A. Anderson
    Aug 11, 2003 at 6:55 pm
    Aug 14, 2003 at 4:59 pm
  • Just a quick note to everyone that v7.4 is now official in Beta Freeze, with the first Bundle available for download, testing and bug reports ... The Bundle is available on all FTP mirrors (in both ...
    The Hermit HackerThe Hermit Hacker
    Aug 6, 2003 at 12:01 am
    Aug 6, 2003 at 5:46 pm
  • After installing PostgreSQL 7.4 beta 1 from source, I decided to install the /contrib module tsearch2. I cd to the tsearch2 directory and typed "make", however I get an error that yy_current_buffer ...
    Jeff DavisJeff Davis
    Aug 14, 2003 at 6:53 am
    Sep 14, 2003 at 6:53 pm
  • Heh...well, first let me say: 1) Our database is highly normalized. 2) All joins in the query are performed across indeces. 3) It IS a huge query. There is a reason to the madness. Namely, this query ...
    Clay LutherClay Luther
    Aug 28, 2003 at 10:00 pm
    Aug 29, 2003 at 1:34 pm
  • Hi, I'll try to switch from Oracle to postgres for some small applications. Is it possible to build functions like Oracle's nvl or decode with pgplsql? How can I make a function like nvl that works ...
    Christian TraberChristian Traber
    Aug 27, 2003 at 7:58 am
    Aug 28, 2003 at 2:54 am
  • Hi, I have The following situation: CREATE TABLE data1 ( id SERIAL PRIMARY KEY, data INTEGER ); CREATE TABLE data2 ( id SERIAL PRIMARY KEY, data INTEGER ); CREATE TABLE data3 ( id SERIAL PRIMARY KEY, ...
    Andreas FrommAndreas Fromm
    Aug 26, 2003 at 2:17 pm
    Aug 27, 2003 at 4:26 pm
  • My understanding is that the entire set of localization parameters needs to be decided upon when the initdb is done and can never be changed later. Is that right? I have a multi-lingual web site, I ...
    Greg StarkGreg Stark
    Aug 20, 2003 at 7:40 pm
    Aug 22, 2003 at 4:33 pm
  • Here's what I have (simplified) SELECT t1.fid, t1.t1_data, t2.vid, t2.t2_data, t3.t3_data FROM t1, t2, t3 WHERE t1.fid = X AND t2.vid = Y AND t3.fid = t1.fid AND t3.vid = t2.vid Now, I discover that ...
    TerryTerry
    Aug 18, 2003 at 11:59 pm
    Aug 22, 2003 at 1:29 am
Group Navigation
period‹ prev | Aug 2003 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions330
posts1,786
users347
websitepostgresql.org
irc#postgresql

347 users for August 2003

Tom Lane: 166 posts Ron Johnson: 78 posts Dennis Gearon: 53 posts Shridhar Daithankar: 52 posts Bruno Wolff III: 47 posts Bruce Momjian: 42 posts Scott.marlowe: 40 posts Stephan Szabo: 40 posts Martijn van Oosterhout: 38 posts Dennis Gearon: 27 posts Expect: 27 posts Jan Wieck: 25 posts Alvaro Herrera Munoz: 24 posts The Hermit Hacker: 22 posts Joe Conway: 20 posts Joshua Drake: 20 posts Jason Godden: 19 posts Vivek Khera: 18 posts Andrew Sullivan: 17 posts Mat: 16 posts
show more
Archives