FAQ

PostgreSQL > pgsql-general > August 2006

Search Discussions

268 discussions - 1,481 posts

  • Hi! I was trying to solve a problem on an old system and realized that there might be some better approach for doing what I need. We have some documents that need to be ordered sequentially and ...
    Jorge GodoyJorge Godoy
    Aug 11, 2006 at 11:33 pm
    Aug 21, 2006 at 11:08 pm
  • Hi, I'm trying to connect to postgres database in a distributed environment, say from machine X to Machine Y (Machine Y has postgres DB) How should my connection string look like in a program in ...
    Harpreet DhaliwalHarpreet Dhaliwal
    Aug 9, 2006 at 3:02 pm
    Aug 19, 2006 at 2:34 pm
  • I noticed that Majordomo drops the second and subsequent lines of a Subject: line in message before dispatching for some reason. It has done this for some time; I noticed it some time ago in ...
    Alvaro HerreraAlvaro Herrera
    Aug 23, 2006 at 2:21 pm
    Sep 22, 2006 at 2:23 pm
  • please unsubscribe from this thank u
    Rama krishnaRama krishna
    Aug 30, 2006 at 3:09 pm
    Sep 21, 2006 at 9:24 am
  • Is there a trick to make this work a bit faster? We have a number of views that join tables, and we have queries that join those views. Some relatively large tables are involved. We added indexes ...
    Alban HertroysAlban Hertroys
    Aug 21, 2006 at 4:48 pm
    Aug 23, 2006 at 12:51 pm
  • Hi All I have a basic problem that I hope can be addressed. I need to insert data from one table into three other tables. I attempted the following format. CREATE OR REPLACE FUNCTION p_id_monitor() ...
    Bob PawleyBob Pawley
    Aug 18, 2006 at 4:29 pm
    Aug 26, 2006 at 8:55 pm
  • Hi, I'm using ECPG and trying to do follwoing insert in one of the talbes. insert into raw_email ( id , raw_email ) values ( 1 , :ch); ch is an array and defined as follows: EXEC SQL BEGIN DECLARE ...
    Jasbinder BaliJasbinder Bali
    Aug 16, 2006 at 3:56 am
    Aug 18, 2006 at 1:19 am
  • Hello, I have been looking at the migration of Gborg lately. It looks like the only two active projects on that site are Slony, and pljava. Libpqxx has recently moved to their own Trac site. I would ...
    Joshua D. DrakeJoshua D. Drake
    Aug 27, 2006 at 4:23 am
    Sep 3, 2006 at 5:23 pm
  • I have an application that does aggresive caching of data pulled from the database, it even keeps the objects cached between transactions. Normally this works very well and when the cache is warmed ...
    Flemming FrandsenFlemming Frandsen
    Aug 1, 2006 at 5:17 pm
    Aug 4, 2006 at 9:32 am
  • Hi, I have a function in which i dynamicall load my shared object and the function definition is as follows: ---------------------------------------------------- CREATE OR REPLACE FUNCTION ...
    Jasbinder BaliJasbinder Bali
    Aug 24, 2006 at 5:04 am
    Aug 29, 2006 at 5:38 pm
  • You mean for implementing stored procedures? I'd say that the answer varies depending on what the stored proc is for. - If it needs to do "text munging," then one of {Perl|Python|Tcl} seem ...
    Chris BrowneChris Browne
    Aug 2, 2006 at 3:05 am
    Aug 4, 2006 at 1:29 pm
  • I'm considering migrating our MySQL 4.1 database (barf!) to PostgreSQL 8 or MySQL 5. The guy who originally designed the system made all the number data FLOATs, even for currency items. ...
    Brandon AikenBrandon Aiken
    Aug 28, 2006 at 5:53 pm
    Sep 2, 2006 at 6:13 am
  • Hi, I'm running PostgreSQL version 8 on a dual 2.4GHz Xeon with 1GB of RAM and an IDE hard drive. My big table has around 9 million records. Is there a tuning parameter I can change to increase speed ...
    Tom LaudemanTom Laudeman
    Aug 9, 2006 at 1:36 pm
    Aug 11, 2006 at 4:40 pm
  • http://newsvac.newsforge.com/newsvac/06/08/28/1738259.shtml Don't know the validity of this dvd order test they did, but the article claims Postgresql only did 120 OPM. Seems a little fishy to me. -- ...
    Tony CadutoTony Caduto
    Aug 28, 2006 at 8:32 pm
    Aug 31, 2006 at 2:27 am
  • I am getting an error that I think I understand, but that I didn't think should happen. Below is the output from psql that I am getting to trigger this error. If the violation of the constraint ...
    Naz GassiepNaz Gassiep
    Aug 28, 2006 at 7:24 pm
    Aug 29, 2006 at 4:00 pm
  • I know that in pgsql.hackers they are discussing what to market the upcoming 8.2 release as. They mention updatable views, but realistically, PostgreSQL has had them via rules forever. I consider ...
    Karen HillKaren Hill
    Aug 24, 2006 at 6:03 pm
    Aug 25, 2006 at 11:45 pm
  • How can I migrate a PostgreSQL database to MySQL or MS Access? Are there any tools available? -- View this message in context: ...
    RPKRPK
    Aug 12, 2006 at 3:08 pm
    Aug 18, 2006 at 6:29 pm
  • Hi, I've got pg 8.1.4 from the binary Windows installer. Windows 2000 / German Now I entered "\d" into psql on the text-console and got this: db_test=# \d ERROR: invalid byte sequence for encoding ...
    AndreasAndreas
    Aug 23, 2006 at 8:57 pm
    Sep 2, 2006 at 10:55 pm
  • I have a .pgc file and i have the following code snippet in it: PG_FUNCTION_INFO_V1 (test); Datum test (PG_FUNCTION_ARGS) { EXEC SQL BEGIN DECLARE SECTION; int id = PG_GETARG_INT(0); char ...
    Jasbinder BaliJasbinder Bali
    Aug 30, 2006 at 4:25 am
    Aug 30, 2006 at 10:21 am
  • Postgres version: 8.1.3 I have a code similar to this pseudo-code: try { create temp table temp_report ...; ... do some processing using this table... drop table temp_report; commit; } catch all ...
    Csaba NagyCsaba Nagy
    Aug 31, 2006 at 2:59 pm
    Sep 1, 2006 at 6:51 pm
  • I thought some people in this group may find this letter from one of NetBSD's founders very interesting. http://mail-index.netbsd.org/netbsd-users/2006/08/30/0016.html It is current, to the point and ...
    Joshua D. DrakeJoshua D. Drake
    Aug 31, 2006 at 4:11 pm
    Aug 31, 2006 at 7:35 pm
  • Hi! I am about to install PostgreSQL on a minimal Linux system, where root is the only user that is allowed to exist. I would prefer to use a binary installer. Is it possible to install PostgreSQL ...
    Fredrik IsraelssonFredrik Israelsson
    Aug 30, 2006 at 7:46 am
    Aug 30, 2006 at 6:51 pm
  • Hi, I'm trying to use SPI for database connectivity at the server side. My database is intialized at /usr/local/pgsql/hps spi.h is at the follwoing location /usr/include/pgsql/server/executor. I have ...
    Harpreet DhaliwalHarpreet Dhaliwal
    Aug 30, 2006 at 6:16 am
    Aug 30, 2006 at 8:32 am
  • Hi, I am getting strange results from the sum function as follows: corp=# select amount from acc_trans where trans_id=19721 and chart_id=10019; amount --------- 4.88 117.1 -121.98 (3 rows) corp=# ...
    Andrew BaergAndrew Baerg
    Aug 29, 2006 at 5:17 pm
    Aug 30, 2006 at 12:37 am
  • Hello all. I am trying to build postgres from the source on a WINXP system. I am using MSVC++.Net and I use the link with it to get to the command prompt. After I do that I run vcvars32.bat and the ...
    DEVDEV
    Aug 9, 2006 at 4:59 pm
    Aug 9, 2006 at 11:12 pm
  • Hi list, Information first: gds2=# select version(); version ---------------------------------------------------------------------------------------------------------- PostgreSQL 8.1.4 on ...
    Don IsgittDon Isgitt
    Aug 22, 2006 at 9:36 pm
    Aug 23, 2006 at 8:31 pm
  • Hello everyone How to use the full text index feature to search a lot of text on PostgreSQL 8.x? thank you~!
    aBBIShaBBISh
    Aug 11, 2006 at 3:56 am
    Aug 14, 2006 at 12:23 am
  • Hi, I need your help/suggestions with a problem I am facing related to autovacuum. I am using PostgreSQL 8.1.2 through a JDBC connection. The connection is long lived (established when the ...
    Sundar NarayanaswamySundar Narayanaswamy
    Aug 1, 2006 at 3:03 pm
    Aug 8, 2006 at 3:18 am
  • Hi all, Is there a way to speed up the query to my 'grand total' logfile, constructed as a UNION of smaller (specialised) logfiles? Access to log1/log2 is quick (If I'm reading ANALYSE log correctly, ...
    Rafal PietrakRafal Pietrak
    Aug 28, 2006 at 8:23 am
    Aug 28, 2006 at 10:17 pm
  • I've seen that some other people have had ERROR could not open relation with OID ### The suggested cause was somebody trying to drop a table in the middle of VACUUM. In my case, the error seems to be ...
    Silvela, Jaime \(Exchange\)Silvela, Jaime \(Exchange\)
    Aug 23, 2006 at 5:54 pm
    Aug 23, 2006 at 11:42 pm
  • I am having problems with my libpq programs crashing. This seems to be a version incompatibility and I want to find out how to best proceed. My main database is running Fedora Core 5 with the ...
    Bryan WhiteBryan White
    Aug 22, 2006 at 4:53 pm
    Aug 23, 2006 at 3:38 pm
  • In addition to making sure databases are vacuumed regularly, it is worth running REINDEX on tables that see a lot of updates (or insert/deletes). Running REINDEX on a regular basis will keep the ...
    John Sidney-WoollettJohn Sidney-Woollett
    Aug 3, 2006 at 10:42 pm
    Aug 19, 2006 at 10:04 am
  • I'm setting up PITR for a client and have a few questions. I have done some googling for real world archive_command examples and haven't really found anything. The example in the PGSQL Docs are ...
    Matthew T. O'ConnorMatthew T. O'Connor
    Aug 3, 2006 at 9:30 pm
    Aug 19, 2006 at 3:48 am
  • Hello everyone, First of all, thank you for integrating XPath in Postgresql. But, as you will see, this is a desperate cry for help: 1. the actual context: Postgresql 8.1.4, Fedora Core 5 DATABASE ...
    Marian POPESCUMarian POPESCU
    Aug 7, 2006 at 3:20 pm
    Aug 8, 2006 at 9:21 am
  • Last week I upgraded to postgresql 8.1.4 (YEAH!) In my database I have a view which concatenates three varchar fields to a new field. With postgresql 7.2.3 the field resulting from the concatenation ...
    MargaretgillonMargaretgillon
    Aug 7, 2006 at 6:20 pm
    Aug 7, 2006 at 7:36 pm
  • Hi everyone, i have a table with around 57 million tuples, with the following columns: pid(varchar), crit(varchar), val1(varchar), val2(varchar). Example: pid crit val1 val2 p1 c1 x y p1 c2 x z p1 c3 ...
    Christian RengstlChristian Rengstl
    Aug 3, 2006 at 8:13 am
    Aug 3, 2006 at 10:30 am
  • I have been having performance problems with my DB so this morning I added some config to log queries that take more than 250ms. The result is surprising because some queries will take as long as 10 ...
    Matthew SchumacherMatthew Schumacher
    Aug 31, 2006 at 4:23 pm
    Sep 8, 2006 at 4:07 pm
  • Hello all, I want to use Tsearch2 for a current project I have but I can't seem to find a way to implement it on hebrew content. I found that there is an hebrew Ispell project and apparently I can ...
    Yonatan Ben-NesYonatan Ben-Nes
    Aug 30, 2006 at 4:45 pm
    Sep 7, 2006 at 9:11 am
  • This is a question on speeding up some type of queries. I have a very big table that catalogs measurements of some objects over time. Measurements can be of several (~10) types. It keeps the ...
    Silvela, Jaime \(Exchange\)Silvela, Jaime \(Exchange\)
    Aug 25, 2006 at 10:35 pm
    Aug 29, 2006 at 1:30 pm
  • Hi, I'm trying the following CREATE LANGUAGE plperl before executing my functions written in perl but get the follwing error ERROR: could not access file "$libdir/plperl": No such file or directory ...
    Harpreet DhaliwalHarpreet Dhaliwal
    Aug 28, 2006 at 5:27 am
    Aug 28, 2006 at 5:27 pm
  • Hi all, Using postgresql 8.1.4.... I have a table with an column: entry_date | timestamp with time zone| not null And when I try to create an index on it like so: create index entry_date_idx on ...
    Arturo PérezArturo Pérez
    Aug 21, 2006 at 9:26 pm
    Aug 23, 2006 at 1:55 pm
  • I recently tried to do something like the following BEGIN READONLY; ... CREATE TEMPORARY TABLE ABC AS SELECT ... ... COMMIT; and it failed because CREATE is not allowed within a read-only ...
    Carl R. BruneCarl R. Brune
    Aug 8, 2006 at 6:26 pm
    Aug 12, 2006 at 3:10 pm
  • Hi! I have a corrupt database that runs on Postgres 7.1.2. I was able to repair the database where I can now connect to the database and do queries. I have a migration plan to transfer my database to ...
    Jonathan VallarJonathan Vallar
    Aug 3, 2006 at 9:59 am
    Aug 9, 2006 at 12:07 am
  • I'm doing some massive (internal company) applications using PHP, which query extensive PostgreSQL tables. This is fine, but obviously it often requires multiple web pages to get something done. ...
    Paul M FosterPaul M Foster
    Aug 5, 2006 at 11:13 pm
    Aug 7, 2006 at 8:05 pm
  • Hi All, I'd like to cast a small 'feature request' here for discussion/ evaluation. The case is the following: When working on a new database application I quite frequently: ...
    Rafal PietrakRafal Pietrak
    Aug 3, 2006 at 4:29 pm
    Aug 4, 2006 at 7:23 pm
  • http://news.zdnet.com/2100-3513_22-6100795.html -- Tony Caduto AM Software Design http://www.amsoftwaredesign.com Home of PG Lightning Admin for Postgresql Your best bet for Postgresql Administration
    Tony CadutoTony Caduto
    Aug 3, 2006 at 7:18 pm
    Aug 4, 2006 at 2:42 pm
  • Yesterday a consultant upgraded me from 7.3.4 to 8.1.4 on a RedHat 9 server. To make sure everything was okay we left the server so that both versions of Postgresql load. 7.3.4 loads on the default ...
    MargaretgillonMargaretgillon
    Aug 2, 2006 at 8:47 pm
    Aug 3, 2006 at 3:01 pm
  • I need to be able to have postmaster (8.1.2) listen on more than one port, eg, 5432 and some other port, such as 5431. There does not appear to be a way to configure that. You can configure multiple ...
    Michael NolanMichael Nolan
    Aug 30, 2006 at 7:43 pm
    Aug 31, 2006 at 3:57 pm
  • Personal Hello all! I'm trying to install postgresql and I'm getting the following error; error: failed dependencies: libc.so.6(GLIBC_2.3) is needed by postgresql-8.1.4-3PGDG libcrypto.so.4 is needed ...
    Dennis ReavesDennis Reaves
    Aug 30, 2006 at 9:50 pm
    Aug 31, 2006 at 1:52 am
  • I installed and started PostgreSQL and it worked fine for days. Then I restarted my computer and now I can't start PostgreSQL ('pg_ctl -D pgdata -l pgdata/psql.log start'). Here's what's in my log: ...
    CSNCSN
    Aug 29, 2006 at 1:36 am
    Aug 29, 2006 at 11:40 pm
Aug 2006
123456
Group Navigation
period‹ prev | Aug 2006 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions268
posts1,481
users327
websitepostgresql.org
irc#postgresql

327 users for August 2006

Tom Lane: 134 posts Michael Fuhr: 73 posts Martijn van Oosterhout: 56 posts Joshua D. Drake: 44 posts Harpreet Dhaliwal: 41 posts Jasbinder Bali: 35 posts Alvaro Herrera: 32 posts Jeff Davis: 28 posts Merlin Moncure: 28 posts Ron Johnson: 24 posts Scott Marlowe: 22 posts Bruce Momjian: 21 posts Alban Hertroys: 18 posts Jorge Godoy: 18 posts Roman Neuhauser: 17 posts Peter Eisentraut: 15 posts Silvela, Jaime \(Exchange\): 14 posts Bob Pawley: 13 posts Chris smith: 13 posts Harald Armin Massa: 13 posts
show more
Archives