FAQ

Search Discussions

294 discussions - 1,223 posts

  • Just dropping a quick not for Tom Lane. I sent a personal message today, but I wasn't sure if you'd get it after I remembered all of the spam filters you've got set up. Sorry for the off topic post.
    DeJuan JacksonDeJuan Jackson
    Mar 5, 2004 at 12:49 am
    May 7, 2004 at 12:26 am
  • Hi, what is the recommended way to run multiple databases under postgres. In MySQL it is rather simple to give different users or websites their own database with all the access rights. Any ...
    AlexAlex
    Mar 28, 2004 at 5:36 am
    Jul 9, 2004 at 3:16 pm
  • Hi folks, I have a database using tsearch2 to index 300 000 documents. I've already have optimized the queries, and the database is vacuumed on a daily basis. The stat function tells me that my index ...
    Diogo BiazusDiogo Biazus
    Mar 30, 2004 at 9:56 pm
    Apr 1, 2004 at 5:52 pm
  • Dear Group, I would like to know if can have a time based trigger, for example a procedure that could be run everyday at say 10 in the night. Thanking you, Yours sincerely, Shan.
    Shanmugasundaram DoraisamyShanmugasundaram Doraisamy
    Mar 30, 2004 at 12:02 pm
    Apr 8, 2004 at 6:44 pm
  • That "consideration" is nonsense. Support for PHP and JSP both require separate language interpreters. Precisely _how_ those interpreters are linked to Apache differs, but the fact is, in either ...
    Chris BrowneChris Browne
    Mar 16, 2004 at 6:23 pm
    Mar 26, 2004 at 4:24 pm
  • Hello, I originally installed postgresql as root user and now I am setting up a development environment with cvs and a java ide and tomcat. I have everything with the exception of postgresql ...
    Phil CampaignePhil Campaigne
    Mar 1, 2004 at 11:26 pm
    Mar 5, 2004 at 9:47 pm
  • Right now, our production DB server is getting a bit more heavily loaded than we'd like, and we expect its usage to double in the next few months, so we're looking at where to put our money for a ...
    Steve WolfeSteve Wolfe
    Mar 9, 2004 at 12:02 am
    Mar 15, 2004 at 9:23 pm
  • FYI, It'd be nice if the error message from a REFERENCES constraint mentioned the column name into which the bad data was attempted to be inserted. In PostgreSQL 7.3: sandbox= insert into foo (id, b) ...
    Karl O. PincKarl O. Pinc
    Mar 3, 2004 at 11:04 pm
    Mar 5, 2004 at 5:31 pm
  • Hello, I have a single table that just went over 234GB in size with about 290M+ rows. I think that I'm starting to approach some limits since things have gotten quite a bit slower over the last ...
    Mooney, RyanMooney, Ryan
    Mar 31, 2004 at 1:48 am
    Apr 12, 2004 at 2:48 am
  • Hi all, I have checked out the REL7_4_2 version from the public CVS repository, and running "make check" fails with: [snip] /bin/sh ./pg_regress --temp-install --top-builddir=../../.. ...
    Csaba NagyCsaba Nagy
    Mar 11, 2004 at 10:45 am
    Mar 20, 2004 at 12:07 am
  • Hi, I am trying to do some reliability tests on postgre SQL. I have use-case where the power can go off abruptly. I initiated 10,000 insert operations and pulled out the cable in the middle. I had ...
    Satish satishSatish satish
    Mar 3, 2004 at 12:27 pm
    Mar 18, 2004 at 1:45 am
  • Hi. I want to install postgres 7.4.2 on solaris 9. I configure with: ./configure --enable-thread-safety and it works fine (no error). When I do "gmake", I get this error: thread.c: In function ...
    Carmen Gloria Sepulveda DedesCarmen Gloria Sepulveda Dedes
    Mar 19, 2004 at 3:11 pm
    Mar 29, 2004 at 6:54 pm
  • If I cancel a VACUUM FULL, is the work that was done up until that point thrown away? I have a table that needs vacuuming but I can't accept the downtime involved in vacuuming.
    Joseph ShraibmanJoseph Shraibman
    Mar 23, 2004 at 7:25 pm
    Mar 24, 2004 at 6:03 pm
  • I need help! I suppose that for query like : SELECT * FROM a, b, c WHERE a.id = b.id AND b.ref = c.id; the planner is free to join the given tables in any order to find the most efficent query plan. ...
    Paolo TavalazziPaolo Tavalazzi
    Mar 10, 2004 at 10:49 am
    Mar 13, 2004 at 4:39 am
  • I have a security model I have implemented in another (non-SQL) database environment that I would like to use in Postgresql. I have read the rules and set returning functions documentation but I ...
    John DeSoiJohn DeSoi
    Mar 31, 2004 at 5:32 pm
    Apr 2, 2004 at 8:23 pm
  • I know this is an old topic, but it's not easy to find a way around it, so when we migrate SQL from other database to PostgreSQL, it causes a huge headache. Here's an extremely simple example - The ...
    John LiuJohn Liu
    Mar 31, 2004 at 5:50 pm
    Apr 1, 2004 at 4:35 pm
  • My PostgreSQL server is not reachable at this moment. It look likes a crash from the postmaster proces. Since saturday 13-03-2004 at 20.09 (Dutch Time / UTC+1) the server is not working correctly. ...
    Edwin PauliEdwin Pauli
    Mar 14, 2004 at 12:34 am
    Mar 15, 2004 at 10:47 pm
  • Greetings, I need help in optimizing this query: select a.id, b.transaction from test as a left join pg_locks as b on a.xmax = b.transaction where b.transaction is null; im using the query in ...
    Dexter Tad-yDexter Tad-y
    Mar 10, 2004 at 12:58 pm
    Jun 11, 2004 at 5:34 pm
  • I have an ecpg program that runs perfectly on Linux (PostgreSQL 7.4.1). I recompile it on Solaris and when I try to run it the results are total gibberish. When I connect: EXEC SQL WHENEVER SQLERROR ...
    WespvpWespvp
    Mar 23, 2004 at 11:25 pm
    Jun 10, 2004 at 2:35 am
  • Hello, I'm rather confused about the logic of something in the rtree code, perhaps someone can provide some insight here. Without loss of generality I'll use intervals on R (real number line) below, ...
    BwhiteBwhite
    Mar 31, 2004 at 8:10 am
    Mar 31, 2004 at 9:36 pm
  • Hi all, I mostly just lurk on the list, but I need to vent. And I could use any advice/ experiences you'd be willing to share. For those of you that don't want to read my rant: What solutions are ...
    Rob HoopmanRob Hoopman
    Mar 23, 2004 at 9:23 pm
    Mar 30, 2004 at 2:50 am
  • PLEASE .... can we have the native Win32 port SOON. It will totally and utterly hurt Microsoft in a very important area to have this port. Why? Well, many of you will know that MS give away a ...
    Andrew MayoAndrew Mayo
    Mar 26, 2004 at 10:55 am
    Mar 27, 2004 at 6:48 pm
  • Hi, I'm running pg_dump 7.3.4. I have a nightly process that dumps a database via pg_dump, and then checks for the existence of the dumped file afterwards to confirm that the dump actually occurred. ...
    Peter LangPeter Lang
    Mar 24, 2004 at 7:06 pm
    Mar 26, 2004 at 11:13 pm
  • I upgraded my main production db from 7.3.4 last night to 7.4.1. I'm running into an issue where a big query that may take 30-40 seconds to reply is holding up all other backends from performing ...
    Gavin M. RoyGavin M. Roy
    Mar 6, 2004 at 9:13 pm
    Mar 9, 2004 at 7:42 pm
  • Hi all is it possible to get a count(1) statemment, for example here: select count(1) from results where fixture=4916 and winner=away group by winner; to return a 0 value instead of absolutely ...
    Zak McGregorZak McGregor
    Mar 1, 2004 at 12:12 am
    Mar 1, 2004 at 6:25 am
  • Version: PostgreSQL 7.4.1 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.3.1 (cygming special) postgresql.conf settings: tcpip_socket = true max_connections = 16 shared_buffers = 2048 # min 16, at ...
    Shelby CainShelby Cain
    Mar 25, 2004 at 2:55 pm
    Mar 25, 2004 at 6:49 pm
  • This question isn't specific to Postgres, but since I'm already on this list and there are knowledgeable people here I thought I'd ask. I'm currently working on a project that has a web application ...
    Matthew HixsonMatthew Hixson
    Mar 23, 2004 at 6:25 pm
    Mar 23, 2004 at 9:07 pm
  • Imagine an Orkut-like site. Suppose we have 'person' table of 100k people. About 75% of these people fill in their location (City/State/Country) information. We also have a 'city' table containing ...
    David GaramondDavid Garamond
    Mar 19, 2004 at 10:06 am
    Mar 20, 2004 at 12:16 am
  • After several fixes were backpatches to the 7_3_STABLE branch, we have now released a 7.3.6. As the list of Changes since 7.3.5 is quite small, they are included in this email: * Revert erroneous ...
    Marc G. FournierMarc G. Fournier
    Mar 3, 2004 at 2:14 pm
    Mar 3, 2004 at 4:29 pm
  • Hi, I'm using a 9500 line script to create an initial database. After applying a number of changes, I was repeatedly executing this script while hunting for typos. The script itself takes care of ...
    Frank van VugtFrank van Vugt
    Mar 9, 2004 at 10:40 pm
    Mar 20, 2004 at 3:14 am
  • Is it possible to have items sorted like: abc 1 abc 2 abc 10 abc 20 instead of: abc 1 abc 10 abc 2 abc 20 ? Thanks in advance, CSN
    CSNCSN
    Mar 14, 2004 at 8:53 pm
    Mar 15, 2004 at 8:12 pm
  • Is there a way to return an integer row number for a query? Note that there may be a large number of rows so I would rather not have joined selects... For a rather simple query: SELECT timestamp from ...
    Randall SkeltonRandall Skelton
    Mar 10, 2004 at 8:25 pm
    Mar 15, 2004 at 6:53 pm
  • Hi, Can someone please help me. My PostgreSQL queries are very slow, especially update statements. What can I do to improve the speed? I have already try VACUUM and ANALYZE. " From the command line I ...
    Bobbie van der WesthuizenBobbie van der Westhuizen
    Mar 10, 2004 at 7:26 am
    Mar 11, 2004 at 3:26 pm
  • Hello, I have a difficult-to-debug problem. I will try to keep this as brief as possible without leaving things out. In a certain situation my application fails with: ...
    Peter SchullerPeter Schuller
    Mar 10, 2004 at 9:07 am
    Mar 11, 2004 at 9:29 am
  • hello in a 'SELECT', does postgres read the 'WHERE' condition from left to right. for example 1) select ... where a and b; 2) select ... where b and a; 1 and 2 will use the same cpu time or not ? ...
    SferriolSferriol
    Mar 8, 2004 at 9:41 am
    Mar 8, 2004 at 3:23 pm
  • Hello, It may be a stupid question, but I'm looking to set a check clause in order to be sure that a INTERVAL field is 00:00:00 or higher, but NOT negatives values. How can I set that ? Thanks in ...
    Bruno BAGUETTEBruno BAGUETTE
    Mar 29, 2004 at 12:28 pm
    Mar 30, 2004 at 5:43 am
  • Is it true that the planner currently doesn't utilize index for BYTEA column in OR or IN clause? -- b is an indexed BYTEA column explain select * from t where b='foo'; -- index scan explain select * ...
    David GaramondDavid Garamond
    Mar 27, 2004 at 2:52 pm
    Mar 29, 2004 at 4:43 am
  • Dear Sir I am a developer of one commercial organization. We are going to develop some applications with PostgreSQL 7.3.3. I would like to know that is it necessary to pay any license charge on the ...
    Eric YumEric Yum
    Mar 25, 2004 at 6:30 am
    Mar 27, 2004 at 8:16 pm
  • (Resurrecting a subject I found searching the archives...) Newbie. We're investigating replacing our Oracle databases with PostgreSQL. Our largest database is currently 25 GB and growing. It contains ...
    Guy RouillierGuy Rouillier
    Mar 26, 2004 at 5:54 pm
    Mar 27, 2004 at 2:32 pm
  • I'm in a bit of a bad spot. We have a number of remotely deployed postgres servers. We are very happy with the depenability of postgres, but have recently run into a problem with pg_dump in SOME of ...
    Steve KrallSteve Krall
    Mar 19, 2004 at 12:37 am
    Mar 20, 2004 at 6:13 am
  • Dear All! I have a question about how the PostgreSQL will manage a huge number of raws. I have a projet where each half an hour 10 millions of records will be added to the database and they should be ...
    Anton NikiforovAnton Nikiforov
    Mar 18, 2004 at 8:39 am
    Mar 19, 2004 at 2:23 pm
  • Is there a way to make ORDER BY case insensitive? Thanks! Mark
    Mark LubrattMark Lubratt
    Mar 18, 2004 at 4:04 pm
    Mar 19, 2004 at 6:26 am
  • I have some information that that I need to keep synchronized which can be found in two different tables. (Yes, it's not fully normalized.) If I set up an on update trigger for table 'A' that updates ...
    Mike NolanMike Nolan
    Mar 16, 2004 at 12:01 am
    Mar 16, 2004 at 5:27 am
  • Hi everybody, currenty we use Suse Linux 9 and the rpms with 7.4.0 downloaded from ftp://ftp.gmd.de/mirrors2/suse/ftp.suse.com/people/max/postgresql-7.4/ . I don't know how to contact the person who ...
    Gellert, AndreGellert, Andre
    Mar 4, 2004 at 10:35 am
    Mar 5, 2004 at 4:23 pm
  • I've got a moderately complex function defined which i then want to be able to test the value of, as well as select the value: select id, vector_cosine(document,'[ qw( foo,bar,baz )]') as threshold ...
    Stephen HowardStephen Howard
    Mar 1, 2004 at 1:06 am
    Mar 1, 2004 at 8:28 pm
  • is it possible to have postgres return a "SELECT * FROM table ORDER BY table_column" query that is not case sensitive order? if i have these words in a column: Alex alex Barbara Cohen i will get them ...
    Alexander CohenAlexander Cohen
    Mar 31, 2004 at 3:32 pm
    Apr 2, 2004 at 1:06 pm
  • Hello: Am about to sign up for an on-line database course (introductory) Apparently, one must have on their PC for the course either Access postgre mysql Am really new at this. Access is a problem, ...
    Robert11Robert11
    Mar 19, 2004 at 4:54 pm
    Mar 29, 2004 at 2:58 pm
  • Hi, i'm upgrading our database from postgresql 7.2.3 to 7.4.2. The import went fine but i have some casting problems with plpgsql functions. I've create a test function with this code: create ...
    Denis GasparinDenis Gasparin
    Mar 17, 2004 at 3:54 pm
    Mar 23, 2004 at 7:35 pm
  • I have a "comment" field in a table that I want populated if another field has a certain value. Is it possible to set a check constraint for this? Example: Let's say we have fields Purchase_type ...
    Francisco ReyesFrancisco Reyes
    Mar 17, 2004 at 4:55 pm
    Mar 17, 2004 at 6:09 pm
  • I'm making a "relocatable" Postgres binary distribution for my clients. Everything goes into postgresql-7.4.1/ directory, including libraries and binaries. This will be installed by a non-privileged ...
    David GaramondDavid Garamond
    Mar 5, 2004 at 11:44 am
    Mar 6, 2004 at 5:31 am
Group Navigation
period‹ prev | Mar 2004 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions294
posts1,223
users312
websitepostgresql.org
irc#postgresql

312 users for March 2004

Tom Lane: 153 posts Richard Huxton: 38 posts Scott.marlowe: 37 posts Bruno Wolff III: 32 posts Bill Moran: 30 posts Bruce Momjian: 30 posts Marc G. Fournier: 29 posts David Garamond: 27 posts Karl O. Pinc: 19 posts Mike Nolan: 18 posts Stephan Szabo: 18 posts Jan Wieck: 14 posts Diogo Biazus: 12 posts Joe Conway: 12 posts Phil Campaigne: 11 posts Shelby Cain: 11 posts Andrew Sullivan: 10 posts Greg Stark: 10 posts Peter Eisentraut: 10 posts Wes Palmer: 10 posts
show more
Archives