Search Discussions

314 discussions - 1,601 posts

  • Hi all, I am still trying to roll my own auto vacuum thingy. The goal is to vacuum on demand in one step just like the old days, but not hit the tables that never change (we have a lot). The idea now ...
    Glen ParkerGlen Parker
    Dec 18, 2006 at 9:32 pm
    Jan 23, 2007 at 7:28 am
  • A web application will store hundreds of thousands images. The images meta data will be stored in postgresql but I'm in doubt about where to store the images themselves, if in the database as byte ...
    Dec 31, 2006 at 9:16 pm
    Jan 8, 2007 at 11:19 pm
  • Just wondering.....how do list member represent gender when storing details of people in a database? I've done it two ways: * A bool column, with the understanding that true/false represents one ...
    Raymond O'DonnellRaymond O'Donnell
    Dec 8, 2006 at 3:23 pm
    Dec 8, 2006 at 11:21 pm
  • Hello, search.postgresql.org is now served directly from PostgreSQL 8.2 , Tsearch2 and GIN. We have been testing thoroughly for the last couple of weeks but of course... it is now open to the general ...
    Joshua D. DrakeJoshua D. Drake
    Dec 18, 2006 at 11:46 pm
    Dec 20, 2006 at 12:56 pm
  • I'm particularly curious about this feature. Does this mean that PostgreSQL 8.2 can perform a REINDEX without blocking the relevant table from writes? If so, the 8.2 docs are a bit out of date: ...
    Bill MoranBill Moran
    Dec 5, 2006 at 9:06 pm
    Dec 13, 2006 at 5:01 pm
  • I just installed PostgreSQL 8.1 and PG Admin 1.6.1 . These versions have a sequential column, that is not part of the table, identifying the rows. Is there any method of accessing those numbers and ...
    Bob PawleyBob Pawley
    Dec 4, 2006 at 5:33 pm
    Dec 13, 2006 at 2:54 pm
  • http://developers.slashdot.org/article.pl?sid=06/12/13/1515217&from=rss "MySQL quietly deprecated support for most Linux distributions on October 16, when its 'MySQL Network' support plan was ...
    David GoodenoughDavid Goodenough
    Dec 13, 2006 at 4:50 pm
    Dec 14, 2006 at 9:20 am
  • I'm breaking up a database into several sets of data with similar layout. (we currently have multiple customers using a single database and tableset, we're splitting it out to give us more "wiggle ...
    Benjamin SmithBenjamin Smith
    Dec 21, 2006 at 7:10 pm
    Dec 24, 2006 at 5:29 pm
  • Hi everyone, First, this group has been good to me, and I thank you guys for the valuable help I've found here. I come seeking help with another problem. I am not even sure my problem lies in ...
    Dec 13, 2006 at 9:49 pm
    Dec 29, 2006 at 11:22 pm
  • Can a pgsql 8.1 database be restored from the raw file? For one database I have only the files found in the base folder, example C:\PostgreSQL \data\base\16404, there are many files called 1247, ...
    Dec 1, 2006 at 12:15 am
    Dec 12, 2006 at 5:25 pm
  • I've spent a couple of hours on this and would like to ask for an assist at this point. I need to install python support on windows. The postgresql install is the windows 8.2.0-1 binary, and pl/pgsql ...
    Dec 31, 2006 at 10:09 pm
    Mar 31, 2008 at 2:25 pm
  • Couple of months ago, when I started looking at replication, and clustering I saw this as a fairly basic question, but the more I got into it the more I realized there's clustering, clustering and ...
    Dec 23, 2006 at 9:59 am
    Dec 27, 2006 at 12:34 am
  • I didn't see this on the to-do list. Would there be any interest in making rules with multiple sql statements acid compliant? Regards, Richard Broersma Jr.
    Richard Broersma JrRichard Broersma Jr
    Dec 18, 2006 at 9:20 pm
    Dec 19, 2006 at 7:10 pm
  • Hi all If I have a running transaction in database1 and try to vacuum database2 but the dead tuples in database2 cannot be removed. INFO: vacuuming "public.dummy1" INFO: "dummy1": found 0 removable, ...
    Cornelia BoenigkCornelia Boenigk
    Dec 6, 2006 at 11:29 pm
    Dec 7, 2006 at 11:05 pm
  • Greetings, Ive got a java application I am reading data from a flat file and inserting it into a table. The first 2 million rows (each file contained about 1 million lines) went pretty fast. Less ...
    James NeffJames Neff
    Dec 29, 2006 at 5:38 pm
    Dec 31, 2006 at 5:08 pm
  • Hi everyone, Looking for a small bit of advice... I have a script that updates several tables with large amounts of data. Before running the updates, it drops all indexes for optimal performance. ...
    Dec 7, 2006 at 4:38 pm
    Dec 13, 2006 at 11:12 pm
  • PostgreSQL 8.1 running on Win XP. PGAdmin Version 1.6.2 When I backup my database on one computer using PG Admin 3 then attempt to open the file on a second computer - PG Admin does NOT recognize the ...
    Bob PawleyBob Pawley
    Dec 28, 2006 at 6:59 pm
    Jan 4, 2007 at 9:19 am
  • I really like TOAD for building Oracle queries. Is there a TOAD-like, FOSS query builder for PostgreSQL?
    Dec 8, 2006 at 7:28 pm
    Dec 13, 2006 at 11:04 am
  • I have a table that has roughly 200,000 entries and many columns. The query is very simple: SELECT Field1, Field2, Field3... FieldN FROM TargetTable; TargetTable has an index that is Field1. The ...
    Wei WengWei Weng
    Dec 5, 2006 at 8:54 pm
    Dec 7, 2006 at 8:47 am
  • I asked about this on IRC and the helpful people online at the time didn't seem to have an explanation. Works --------------------- select * from income_tax_rate_us order by state is null; Works ...
    Mike BenoitMike Benoit
    Dec 27, 2006 at 1:05 am
    Jan 12, 2007 at 7:34 pm
  • The pagila database has generic trigger function called last_updated() (shown below) which is used to update timestamp columns in various tables. The reason I can't use the function 'as is' for my ...
    Dec 30, 2006 at 6:33 pm
    Jan 4, 2007 at 7:33 am
  • I have OS X tiger with all the updates: uname -r 8.8.0 Here is what I get when I try to initdb on a freshly compiled 8.2: selecting default max_connections ... 10 selecting default ...
    Karen HillKaren Hill
    Dec 28, 2006 at 7:03 am
    Jan 2, 2007 at 6:45 pm
  • Hi. With this table (about 800 000 rows): =# \d n_traffic Table "public.n_traffic" Column | Type | Modifiers --------------+-----------------------------+------------------------------ login_id | ...
    Dec 12, 2006 at 7:28 am
    Dec 13, 2006 at 1:59 pm
  • Hello, I'm having a major Vacuuming problem. I used to do a full vacuum every morning on my postgres database to clean up empty space on a table but because of it's size, the locking of the database ...
    Schwenker, StephenSchwenker, Stephen
    Dec 4, 2006 at 3:56 pm
    Dec 6, 2006 at 10:23 pm
  • Hi all, I just started to write my first stored procedure in plpgsql and installed a trigger for it. The two Tables are: CREATE TABLE ltlocation ( "id" integer DEFAULT ...
    Lars HeidiekerLars Heidieker
    Dec 14, 2006 at 9:08 pm
    Dec 20, 2006 at 12:24 pm
  • I am stuck, I am getting two different times from the database depending on the timezone of the system I am querying from. The story is this: I have a table name request. It has a column create_dt of ...
    Randy ShelleyRandy Shelley
    Dec 12, 2006 at 5:54 pm
    Dec 15, 2006 at 10:54 pm
  • I'm using an ancient version of postgresql (7.3 - don't ask) and I'm experiencing a problem where many inserts into an empty table slow down over time, even if I analyze in the middle of the ...
    Dec 13, 2006 at 9:11 pm
    Dec 15, 2006 at 10:05 am
  • It seems to me that if I dump and restore a database as a new db I need to manually issue ALTER DATABASE dbname SET search_path=schema1, schema2; to get back the search_path of the original db. I s ...
    Dec 11, 2006 at 3:35 pm
    Dec 12, 2006 at 9:39 pm
  • The following appeared this afternoon on the DbMail list. As someone replied the MySql used is old, and the newer one is faster, but then 8.2 is faster than the older Postgresql versions. This was ...
    David GoodenoughDavid Goodenough
    Dec 7, 2006 at 4:19 pm
    Dec 8, 2006 at 11:50 pm
  • This should be simple but I am missing something. I am trying to extract all records entered after a given date. The table has a field date_entered which is a timestamp. In this particular case I am ...
    Belinda M. GiardineBelinda M. Giardine
    Dec 12, 2006 at 4:39 pm
    Feb 4, 2007 at 12:03 am
  • I haven't used the command lines previously having relied on PG Admin. In the instructions - "Starting postmaster Nothing can happen to a database unless the postmaster process is running. As the ...
    Bob PawleyBob Pawley
    Dec 20, 2006 at 7:00 pm
    Dec 20, 2006 at 8:49 pm
  • Hi I have managed to turn my host software into an executable. It runs well using my installed database and server. What files in PostgreSQL do I need to include to have the host software, the ...
    Bob PawleyBob Pawley
    Dec 18, 2006 at 6:28 pm
    Dec 19, 2006 at 8:07 pm
  • H.J. SandersH.J. Sanders
    Dec 8, 2006 at 3:37 pm
    Dec 11, 2006 at 1:19 pm
  • Hi, I'm trying to install PostgreSQL 8.2.0 ony my development box using rpm on CentOS 4.4. Currently I'm stuck at installing compat-postgresql-libs with the following error: libc.so.6(GLIBC_2.4) is ...
    Leonard SoetedjoLeonard Soetedjo
    Dec 6, 2006 at 8:44 am
    Dec 6, 2006 at 5:33 pm
  • Is there any feasible way to achieve geographical redundancy of postgresql database? Say you have a website which uses PG on the backend to read/write data and you want to have the website running on ...
    Dec 27, 2006 at 7:41 am
    Jan 3, 2007 at 8:32 am
  • Hello, I've been using PostgreSQL for a few years and mostly love it. Aside from a few (perceived, anyway) annoying limitations in PL/PGSQL (which I almost exclusively am using for db interaction), ...
    Postgresql OrgPostgresql Org
    Dec 22, 2006 at 8:29 pm
    Jan 1, 2007 at 9:29 pm
  • grant all privileges on database test to auser As far as I can tell this does nothing. Intuitively this command suggests that the auser would be able to access and modify the database test in anyway. ...
    Dec 13, 2006 at 8:20 pm
    Dec 21, 2006 at 5:54 pm
  • Hi I'm using postgresql version 1.4.3. Trying to connect to it throught perl code. Just wondering if DBI would be the best tool to use to accomplish this task. Which version of DBI should I be using. ...
    Jasbinder Singh BaliJasbinder Singh Bali
    Dec 1, 2006 at 7:50 pm
    Dec 7, 2006 at 3:57 pm
  • Hi Again, I posted earlier about a problem installing 8.1.5 on Windows XP Home. THat message was delayed, so it likely will not show up. THe problem is occuring on execution of initdb. I skipped the ...
    Dec 1, 2006 at 4:01 am
    Dec 2, 2006 at 1:17 pm
  • Hello, After a huge amount of trying out (I'm new at running webservers, I had a lot of problems installing apache too) I finally was able to install postpresql 8.2 (latest version) on my computer. ...
    Joost KuckartzJoost Kuckartz
    Dec 19, 2006 at 8:47 pm
    Dec 23, 2006 at 1:01 pm
  • Hello, I just installed Postgres 8.2 and was trying to add the xml2 contrib module. I went to the folder that contained the contribs and attempted to run gmake. I got this error... [root@d0002gdb01 ...
    Paul SilveiraPaul Silveira
    Dec 19, 2006 at 11:06 pm
    Dec 23, 2006 at 1:35 am
  • http://projects.commandprompt.com/public/pgsql/changeset/25387 Though I'm probably start going on Oleg's nerves.. :/ I'm still trying to get compound word support for my dictionaries back, while ...
    Hannes DorbathHannes Dorbath
    Dec 21, 2006 at 5:13 pm
    Dec 22, 2006 at 10:41 am
  • I've been struggling with pam_ldap and a windows 2003 active directory server, trying to get postgres to authenticate against it. I'm wondering what the best way to get postgres to authenticate ...
    Dec 19, 2006 at 2:23 am
    Dec 19, 2006 at 9:53 pm
  • Hello list, I'm working on a project which tries to run postgre as a embedded database. I'm know looking at start up scripts and initdb scripts. What are the necessary files for running initdb and ...
    Henrik ZagerholmHenrik Zagerholm
    Dec 15, 2006 at 10:41 am
    Dec 15, 2006 at 4:59 pm
  • Hello friends, we have some strange problem, postmaster (pg 8.1 /win32) suddenly shutdown because of "no reason". The interesting thing is that this occurs always at almost same time (between 0.00 ...
    Dec 14, 2006 at 5:35 pm
    Dec 15, 2006 at 9:53 am
  • Hi, May be someone could help me with this: For some time now, I exercise the use of VIEWs to expose just the features of TABLES a particular user is supposed to see/have. I can see that with a VIEW, ...
    Rafal PietrakRafal Pietrak
    Dec 13, 2006 at 8:49 am
    Dec 14, 2006 at 1:59 pm
  • Don't really know where to ask this...the general mailing list sounds like the closest. Let's say I have three tables: owner, factory and product with a 1:N relationship at each step. Assuming that a ...
    Tomi N/ATomi N/A
    Dec 12, 2006 at 4:47 pm
    Dec 14, 2006 at 3:22 am
  • Hi! Is there any plan to add implicit declaration of returning parameters for functions? Something like: create function list(in a int) returns setof implicit record as $$ if a=1 then select * from ...
    Rikard PavelicRikard Pavelic
    Dec 12, 2006 at 9:35 am
    Dec 12, 2006 at 3:51 pm
  • I am trying to install Postgre 8.2.0 on my mc FC4 first i installed the libs next when i tried installing: postgresql-8.2.0-2PGDG.i686.rpm it gave me this error: error: Failed dependencies: ...
    Dec 11, 2006 at 10:32 am
    Dec 11, 2006 at 2:43 pm
  • I have a question regarding a strange behaviour (for me, maybe that this is desidered feature) of LOCK on tables. I am using postgres 8.2 I have a servlet that uses connection pools. The servlet do ...
    Edoardo PanfiliEdoardo Panfili
    Dec 8, 2006 at 3:41 pm
    Dec 8, 2006 at 7:58 pm
Group Navigation
period‹ prev | Dec 2006 | next ›
Group Overview
grouppgsql-general @

351 users for December 2006

Tom Lane: 123 posts Richard Huxton: 50 posts Martijn van Oosterhout: 46 posts Shoaib Mir: 38 posts Joshua D. Drake: 34 posts Bob Pawley: 33 posts Scott Marlowe: 32 posts Richard Broersma Jr: 30 posts Alvaro Herrera: 29 posts Jeff Davis: 25 posts Glen Parker: 23 posts Ron Johnson: 23 posts Magnus Hagander: 21 posts Ragnar: 20 posts Hannes Dorbath: 19 posts Brandon Aiken: 17 posts Bill Moran: 16 posts Bruce Momjian: 16 posts Marc Evans: 15 posts Matthew T. O'Connor: 15 posts
show more