FAQ

Search Discussions

315 discussions - 1,670 posts

  • Isn't that true of just about any OSS project? Heck, Linux doesn't even have a website ;). MySQL is not an OSS project, it is an OSS product with a commercial company backing it. There is a big ...
    Joshua D. DrakeJoshua D. Drake
    Jan 14, 2004 at 11:13 pm
    Jan 25, 2004 at 12:39 am
  • For ease of configuration and other reasons, I would like for my single-user GUI app to be able to use postgresql in-process as a library accessing a database created in the users home directory. I ...
    Jeff BowdenJeff Bowden
    Jan 13, 2004 at 9:39 pm
    Jan 23, 2004 at 3:51 am
  • I'm currently one of the targets of SCO's linux licensing extortion business plan, and am contemplating switching to one of the BSD's to avoid any potential problems. I'm curious which BSD people ...
    Gavin M. RoyGavin M. Roy
    Jan 20, 2004 at 11:24 pm
    Jan 29, 2004 at 8:51 pm
  • Are there any drawbacks of using BYTEA for PK compared to using a primitive/atomic data types like INT/SERIAL? (like significant performance hit, peculiar FK behaviour, etc). I plan to use BYTEA for ...
    David GaramondDavid Garamond
    Jan 11, 2004 at 3:56 pm
    Jan 16, 2004 at 5:32 pm
  • I have events in the next few weeks in New York City, Copenhagen, Paris, and Atlanta. Check the News section on the web site for more information. I will also be in Amsterdam February 2-3, though I ...
    Bruce MomjianBruce Momjian
    Jan 23, 2004 at 3:48 am
    Jan 29, 2004 at 7:41 pm
  • I'm running Postgres 7.1.3, and just started having a problem where my dynamic site is going down (read-only DB, with no writes happening to the DB) regularly (every other day). I have no idea whay ...
    Aurangzeb M. AghaAurangzeb M. Agha
    Jan 9, 2004 at 8:31 pm
    Jan 20, 2004 at 4:49 am
  • Here's some of my current notions on pgsql performance tuning strictly as it relates to pgsql tuning parameters in the context of a dedicated linux or hpux server. I'm particularly focusing on the ...
    Ed L.Ed L.
    Jan 30, 2004 at 9:34 pm
    Feb 11, 2004 at 10:49 pm
  • Is support for tablespaces a priority feature for 7.5? I believe there has been significant development in this area and it seems that postgres' file structure opens it up nicely to support it. What ...
    Brian MaguireBrian Maguire
    Jan 21, 2004 at 4:51 pm
    Jan 22, 2004 at 7:31 pm
  • I'm trying to get a feel for what most people are doing or consider best practice. Given a mod_perl application talking to a PostgreSQL database on the same host, where different users are logging ...
    Keith G. MurphyKeith G. Murphy
    Jan 13, 2004 at 4:15 pm
    Jan 15, 2004 at 5:28 am
  • Hello, I am testing a web application (using the DBX PHP function to call a Postgresql backend). I have 375Mb RAM on my test home box. I ran ab (apache benchmark) to test the behaviour of the ...
    Alex MadonAlex Madon
    Jan 21, 2004 at 2:05 pm
    Jan 22, 2004 at 1:54 am
  • Hi, How come "X=null" is not the same as "X is null"? I got a few selects with queries like this: select * from foo where customer=#customer# or (#customer# is null and customer is null) Without the ...
    Baldur NorddahlBaldur Norddahl
    Jan 1, 2004 at 9:46 pm
    Jan 5, 2004 at 5:56 am
  • Happy new year to all pgsql fans ! Sorry for this trivial question but I couldn't find an answer in the archives : I use SERIAL type in tables for id columns in order to auto increment them. Is there ...
    Stephane PinelStephane Pinel
    Jan 1, 2004 at 3:20 pm
    Jan 5, 2004 at 5:20 am
  • Hello list This is my situation: My box: Pentium III, Red Hat 9.0 I was working fine with PostgreSQL 7.3.2. Recently I decided to upgrade it to PostgreSQL 7.4 installing the twelve rpms I downloaded ...
    Manuel TejadaManuel Tejada
    Jan 25, 2004 at 3:38 am
    Feb 2, 2004 at 6:06 pm
  • Hello everybody! Does someone know how to build hierarchical queries to the postgresql? I have a table with tree in it (id, parent) and need to find a way from any point of the tree to any other ...
    Anton NikiforovAnton Nikiforov
    Jan 9, 2004 at 7:05 pm
    Jan 13, 2004 at 7:55 am
  • Hi My box: RedHat 9.0, Pentium III Recently I upgraded from PostgreSQL 7.3.2 to PostgreSQL 7.4.1. The PostgreSQL 7.3.2's rpms were installed from RehHat CDs The PostgreSQL 7.4.1's rpms I used to ...
    Manuel TejadaManuel Tejada
    Jan 31, 2004 at 2:12 am
    Feb 9, 2004 at 2:39 am
  • The documentation doesn't have any examples of using an sql language function to do an insert, andI am at loss as to I am doing wrong here. The error I get trying to create the function is: ERROR: ...
    Chris OchsChris Ochs
    Jan 13, 2004 at 12:20 am
    Jan 13, 2004 at 6:54 pm
  • I'm trying to migrate from 7.2 to 7.4.1 via pg_dump/pg_restore and have encountered a couple of problems: 1) Index creation on a table fails: db=# CREATE UNIQUE INDEX person_info_username_ix ON ...
    Ben MarkleinBen Marklein
    Jan 14, 2004 at 11:28 pm
    Feb 17, 2004 at 2:57 pm
  • Hi, I use PostgreSQL 7.4 for storing huge amount of data. For example 7 million rows. But when I run the query "select count(*) from table;", it results after about 120 seconds. Is this result normal ...
    Sezai YILMAZSezai YILMAZ
    Jan 14, 2004 at 11:12 am
    Jan 14, 2004 at 1:52 pm
  • First I wish I knew how this was caused but here is our problem. Sometime in the recent past we got a duplicate table. Here is the result of a pg_dump with a pg_restore for just that table. -- -- TOC ...
    Jared CarrJared Carr
    Jan 19, 2004 at 4:32 pm
    Jan 21, 2004 at 7:06 pm
  • unsubscribe
    Geoffrey van DoorenGeoffrey van Dooren
    Jan 5, 2004 at 8:04 am
    Jan 17, 2004 at 1:59 pm
  • Hi All, I'd like to "compress" the following two filter expressions into one - assuming that it makes sense regarding query execution performance. ... where (adate LIKE "2004.01.10 __:30" or adate ...
    Együd CsabaEgyüd Csaba
    Jan 14, 2004 at 11:43 am
    Jan 15, 2004 at 4:29 pm
  • I am running 7.2.4 and when running a vacuum on my database I get NOTICE: Child itemid in update-chain marked as unused - can't continue repair_frag ERROR: No one parent tuple was found vacuumdb: ...
    Dave SmithDave Smith
    Jan 29, 2004 at 1:48 pm
    Sep 26, 2005 at 12:09 am
  • Hello all, I am trying to use DBI in perl to connect to my Postgres database. I am able to connect to the database but when any further queries are made using the database handle, I see the following ...
    Ritu KhetanRitu Khetan
    Jan 16, 2004 at 9:20 am
    Jan 27, 2004 at 3:11 pm
  • I have a large table (potentially tens or hundreds of millions of rows) and I need to extract some number of these rows, defined by an integer primary key. So, the obvious answer is select * from ...
    Steve AtkinsSteve Atkins
    Jan 28, 2004 at 7:39 pm
    Jan 30, 2004 at 2:18 pm
  • Hi All, After PostgreSQL freeze some times, I am moving from 7.3.4 to 7.4.1, trying to solve this problem. When the daemon get frozen, I can't even use psql to browse a database (as if the database ...
    MaRCeLO PeReiRAMaRCeLO PeReiRA
    Jan 28, 2004 at 5:53 pm
    Jan 29, 2004 at 11:32 am
  • Hi, docs say (19.2.1): When trust authentication is specified, PostgreSQL assumes that anyone who can connect to the server is authorized to access the database as whatever database user he specifies ...
    Henk van LingenHenk van Lingen
    Jan 22, 2004 at 2:33 pm
    Jan 26, 2004 at 5:35 am
  • After copied pg database from one PC to another -I could not find plpgsql function(s) in the copied database. -had to instal plpgsql language handler again -whilst tables and data moved fine The copy ...
    LndLnd
    Jan 21, 2004 at 10:29 pm
    Jan 22, 2004 at 7:12 pm
  • Hi, Assume I have a bank app.. When customer withdraws $10 from his accouint I have to do following -- update account_summary table [subtract $10 from his account] -- update account detail_table ...
    Thapliyal, DeepakThapliyal, Deepak
    Jan 13, 2004 at 5:48 pm
    Jan 15, 2004 at 6:05 am
  • Dear all, i have a problem with insertion data and running post insert trigger on it. Preambula: there is a table named raw: ipsrc | cidr ipdst | cidr bytes | bigint time | timestamp Triggers: ...
    Anton NikiforovAnton Nikiforov
    Jan 12, 2004 at 5:57 am
    Jan 13, 2004 at 3:52 pm
  • ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index We've been getting this error in our application every once in a while --- typically once an hour to once a day, ...
    Kragen SitakerKragen Sitaker
    Jan 9, 2004 at 8:08 pm
    Jan 10, 2004 at 4:05 am
  • PostgreSQL mavens, can I ask the database, in a normal database query command, or in other words, essentially using the same environment where I'd say... SELECT count(*) FROM mytable [WHERE ...
    BenBen
    Jan 30, 2004 at 9:20 pm
    Feb 3, 2004 at 11:29 pm
  • Is this good advice? IDENT Authentication failed for user "postgres" This error has everything to do with the way distros set up access rights for postgres. They are way too restrictive and leave you ...
    SusemailSusemail
    Jan 30, 2004 at 9:37 am
    Jan 31, 2004 at 1:04 am
  • Hello List, I have installed Postgresql 7.4 on a Suse 9.0 system using apt. I cannot do this: /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data Because there is no "/pgsql/bin/initdb" nor ...
    Jerome LylesJerome Lyles
    Jan 26, 2004 at 6:37 pm
    Jan 27, 2004 at 9:17 pm
  • I must have a fundamental misunderstanding about using schema. Before using schema, I usually have a file that has my database definition, and I can play that file back in to a new database to create ...
    Lee HarrLee Harr
    Jan 23, 2004 at 3:39 pm
    Jan 24, 2004 at 12:27 pm
  • Hello, Took an hour today and made the 7.3.4, 7.4.1 and Practical PostgreSQL documentation all searchable using OpenFTS and Tsearch2. You can take a look at: http://www.commandprompt.com/community/ ...
    Joshua D. DrakeJoshua D. Drake
    Jan 17, 2004 at 12:34 am
    Jan 19, 2004 at 8:31 pm
  • Hi, we are currently using another database product but besides some licensing issues we are finding more and more problems with the database. We are evaluating PostgreSQL and it looks quite handy. ...
    David TeranDavid Teran
    Jan 13, 2004 at 1:42 pm
    Jan 19, 2004 at 6:22 pm
  • Is it possible to use the dblink and dblink_exec features from inside pl/pgsql functions to mimic the behaviour of nested transactions by calling another function or executing some SQL via the dblink ...
    John Sidney-WoollettJohn Sidney-Woollett
    Jan 13, 2004 at 12:52 pm
    Jan 14, 2004 at 2:55 pm
  • I am getting this error postgres=# \i a.sql psql:a.sql:10: ERROR: parser: parse error at or near "return" at character 26 -- a.sql -- create function loadme() return text as ' Declare s_out text ; ...
    Thapliyal, DeepakThapliyal, Deepak
    Jan 13, 2004 at 12:41 am
    Jan 13, 2004 at 12:32 pm
  • Hi there, I'm pleased to present pilot version of http://www.pgsql.ru - search system on postgresql related resources. Currently, we have crawled 27 sites, new resources are welcome. It has ...
    Oleg BartunovOleg Bartunov
    Jan 5, 2004 at 2:49 pm
    Jan 12, 2004 at 9:37 pm
  • Hi, I recently upgraded to postgresql 7.4 and I am having a problem with postmaster using lots of memory for a query (keeps growing even up to 400MB+ till I stop postgresql ). I don't recall this ...
    Lincoln YeohLincoln Yeoh
    Jan 27, 2004 at 7:48 am
    Feb 4, 2004 at 7:50 am
  • Hi, I'm fairly new to this database, and have read much discussion on sub-queries. I've seen that they can be great for some queries, and downright slow for others. I have a table with two foreign ...
    Anony MousAnony Mous
    Jan 30, 2004 at 10:09 pm
    Jan 31, 2004 at 8:17 pm
  • G'day all ... With the growing # of subscribers to the lists, as well as growing list activity, ppl are reporting a slowdown in the speed that mail is being processed through from sender to recipient ...
    Marc G. FournierMarc G. Fournier
    Jan 27, 2004 at 7:32 pm
    Jan 28, 2004 at 11:38 am
  • I need this function : CheckDate('2002-02-29') return false CheckDate('2002-02-28') return true How to write ? Thanks for any advice .
    LitelWangLitelWang
    Jan 16, 2004 at 5:41 am
    Jan 20, 2004 at 1:48 pm
  • I installed 7.4 from the FreeBSD ports collection (I'm running 4.9-RELEASE). Did nothing special, just make && make install and all was well. I now have updated my ports collection via cvsup and see ...
    Bill Postgresql-usersBill Postgresql-users
    Jan 17, 2004 at 5:33 am
    Jan 19, 2004 at 11:24 pm
  • What's the best way to ease development of plpgsql. My largest issues with plpgsql pertains to the quoting of course. Bill McMilleon
    Bill McMilleonBill McMilleon
    Jan 16, 2004 at 10:32 pm
    Jan 19, 2004 at 10:39 pm
  • Hello! I have problem with my function and I can find what's wrong. WARNING: Error occurred while executing PL/pgSQL function fn_insert_entry_pending WARNING: line 26 at SQL statement ERROR: parser: ...
    Uroš GruberUroš Gruber
    Jan 15, 2004 at 2:26 pm
    Jan 16, 2004 at 10:52 pm
  • I write this to tell you why we won't use postgresql even though we wish we could at a large company. Don't get me wrong I love postgresql in many ways and for many reasons , but fact is fact. If you ...
    Bob HenkelBob Henkel
    Jan 9, 2004 at 7:49 pm
    Jan 15, 2004 at 7:52 am
  • I am running 7.2 and when doing a vacuum I am getting the following error.... ERROR: Cannot insert a duplicate key into unique index pg_statistic_relid_att_index Where do I start to fix this? -- Dave ...
    Dave SmithDave Smith
    Jan 12, 2004 at 6:49 pm
    Jan 13, 2004 at 4:44 am
  • Hi, I need to know if there is a way to defer or disable a unique index on a table during an update. One way would be to set indisunique to false, perform update and then set to true. But, this seems ...
    Oleg LebedevOleg Lebedev
    Jan 8, 2004 at 6:21 pm
    Jan 9, 2004 at 5:53 pm
  • Hi All, how can I improve the query performance in the following situation: I have a big (4.5+ million rows) table. One query takes approx. 9 sec to finish resulting ~10000 rows. But if I run ...
    Együd CsabaEgyüd Csaba
    Jan 6, 2004 at 7:44 pm
    Jan 7, 2004 at 7:38 pm
Group Navigation
period‹ prev | Jan 2004 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions315
posts1,670
users355
websitepostgresql.org
irc#postgresql

355 users for January 2004

Tom Lane: 190 posts Richard Huxton: 60 posts Joshua D. Drake: 48 posts Scott.marlowe: 44 posts Chris Travers: 43 posts Marc G. Fournier: 43 posts Bruce Momjian: 31 posts David Garamond: 27 posts Bruno Wolff III: 25 posts Martijn van Oosterhout: 24 posts Martín Marqués: 22 posts Chris Ochs: 21 posts John Sidney-Woollett: 21 posts Rick Gigger: 20 posts Doug McNaught: 18 posts Nigel J. Andrews: 17 posts Alvaro Herrera: 16 posts D. Dante Lorenso: 16 posts Michael Glaesemann: 16 posts Peter Eisentraut: 16 posts
show more
Archives