FAQ

Search Discussions

307 discussions - 1,358 posts

  • It appears from checking the output of exponentiation of one numeric to another, the output is actually in floating point. Is this normal and / or expected? Now, given that create table test2 (i1 ...
    Scott MarloweScott Marlowe
    May 18, 2005 at 9:17 pm
    Jun 6, 2005 at 4:00 pm
  • Greetings, We are working on speeding up the queries by creating indexes. We have queries with searching criteria such as "select ... where *col1='...'*". This is a simple query with only "=" ...
    Ying LuYing Lu
    May 9, 2005 at 1:40 pm
    May 27, 2005 at 10:07 pm
  • Hello, I'm seeking for an advise to solve the issue that we hit recently (cost me sleepless night after production server upgrade). The actual environment is Apache+mod_perl, Postgresql 8.0.2. After ...
    VladVlad
    May 2, 2005 at 1:25 am
    May 3, 2005 at 12:25 pm
  • A few months ago, a question by Scott Frankel produced a suggestion from Greg Patnude which I found very exciting that had to do with using pg table inheritance to maintain an audit or row change ...
    Berend ToberBerend Tober
    May 19, 2005 at 2:37 pm
    May 30, 2005 at 9:08 pm
  • http://www.microolap.com/products/database/mydbacentral/ I was hoping to find a GUI Rapid Application development for Postgresql similar to the above. The above is the only thing I could find, but it ...
    Typing80wpmTyping80wpm
    May 5, 2005 at 9:17 pm
    May 15, 2005 at 7:54 pm
  • Hi all, maybe it's a very silly question, but why does Postgres perform an update on the table even if no data changes? I recognized this recently doing a rewrite of my rules because they took to ...
    Sebastian BöckSebastian Böck
    May 24, 2005 at 3:05 pm
    May 25, 2005 at 4:16 pm
  • I would like to write a trigger or function that spawns a forked process so that the transaction is considered 'complete' to the client, but continues to perform more work. I've been looking for ...
    Christopher MurtaghChristopher Murtagh
    May 9, 2005 at 7:25 pm
    May 11, 2005 at 6:45 pm
  • Hi, Apologies if this has been discussed before, but I was wondering if there have been any efforts in the past to provide a deep integration of PostgreSQL with Apache. What I mean by deep ...
    Robin BoerdijkRobin Boerdijk
    May 3, 2005 at 12:53 pm
    May 4, 2005 at 4:26 pm
  • Hi list, I'm running postgresql 8.0.1 on FreeBSD 4.11-STABLE, the machine is and AMD Sempron 2.2, 1GB Ram.. I use postgresql as database for dspam, an spam classification program. This database have ...
    Alexandre BiancalanaAlexandre Biancalana
    May 3, 2005 at 1:40 pm
    Jun 2, 2005 at 4:26 pm
  • 8.0.3 does not build for me on Mac OS X 10.4. Anyone else seeing this error, and will it be fixed in the next release? Thanks, -M@ gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith - ...
    Matthew HixsonMatthew Hixson
    May 19, 2005 at 1:28 am
    May 20, 2005 at 5:11 am
  • Hi, I would like to know if PostgreSQL has a similar database object to the Oracle synonym. Thanks a lot. Jayme Jeffman Filho GSEE-PUCRS +55 (51) 9112 3422
    Jayme Jeffman FilhoJayme Jeffman Filho
    May 16, 2005 at 6:11 pm
    May 29, 2005 at 1:10 am
  • Hi ALL, we have a site that uses postgres as a backend for a forum. this forum does a lot of deletes, selects and inserts. just recently for some reason postgres eats a lot of processing power.. here ...
    JMJM
    May 9, 2005 at 2:03 pm
    May 25, 2005 at 5:40 am
  • As a long-time user of Postgres, (First started using it at 7.0) I'm reading recently that Firebird has been taking off as a database. Perhaps this is not the best place to ask this, but is there any ...
    Benjamin SmithBenjamin Smith
    May 4, 2005 at 6:48 pm
    May 6, 2005 at 6:01 am
  • I have a web application backed by a PostgreSQL 7.4.6 database. It's an application with a fairly standard login process verified against the database. I'd like to use pg_dump to grab a live backup ...
    Thomas F. O'ConnellThomas F. O'Connell
    May 23, 2005 at 7:55 pm
    May 24, 2005 at 1:41 pm
  • Hi all, I've been chasing down a bug and from what I have learned it may be because of how postgreSQL (8.0.2 on Fedora Core 4 test 2) handles invalid unicode. I've been given some ideas on how to try ...
    Madison KellyMadison Kelly
    May 8, 2005 at 12:23 am
    May 9, 2005 at 3:37 am
  • Vlads thread on Slony against PGcluster made me go back to take another look at Slony. I'd tried to get it going back in February when I needed to build some replicated databases. Slony was my first ...
    Peter WilsonPeter Wilson
    May 5, 2005 at 2:33 pm
    May 6, 2005 at 6:11 pm
  • Hello, Sorry for the cross post. I am working on a requirements and recommendation document for a division of the State of Hawaii Attorney General's office. We are proposing that Postgres be used for ...
    Mark SteckelMark Steckel
    May 19, 2005 at 2:24 am
    May 23, 2005 at 5:11 pm
  • If I store images as blobs in pgsql, will they be loaded into the db shared memory cache as they are retrieved? What are the tradeoffs of storing images as bytea vs blobs? Thanks. Ed
    Ed L.Ed L.
    May 18, 2005 at 8:11 pm
    May 20, 2005 at 3:31 am
  • Hi, I was asking this question some time ago and was under impression that this will be fixed in 8.x. In general problem is, CREATE TEMP TABLE AS SELECT does not report any rows to the engine, seems ...
    MlikharevMlikharev
    May 17, 2005 at 12:18 am
    Jun 9, 2005 at 9:28 pm
  • Hi, Does anyone know if there is a publicly available release schedule for upcoming versions of PostgreSQL along with proposed new functionality? In a month or so I'm going to start on updating an ...
    James CroftJames Croft
    May 24, 2005 at 1:37 pm
    Jun 1, 2005 at 12:42 pm
  • Postgres Newsgroup, My company has been looking for a good database modelling tool for postgres and have yet to find something that completely satisfies our needs. We are currently using a product ...
    Mark BorinsMark Borins
    May 9, 2005 at 9:35 pm
    May 12, 2005 at 7:56 pm
  • I would like to store the complete database into a WORM device (Write Once Read Many). I would like to access this database directly from the WORM device and perform read only SQL statements against ...
    GgoshenGgoshen
    May 11, 2005 at 6:27 pm
    May 11, 2005 at 10:26 pm
  • Hello, in need to increase reliability of the service (and perhaps eventually offload main DB server) we are looking to setup replication for the database server. I found two solutions: Slony ( ...
    VladVlad
    May 5, 2005 at 12:50 am
    May 6, 2005 at 12:10 pm
  • I'm probably asking a FAQ, but a few google searches didn't seem to point me in the right place. Is there a simple way with PostgreSQL to assign relative ranks to the result of a query ORDER BY? That ...
    Randal L. SchwartzRandal L. Schwartz
    May 4, 2005 at 12:30 am
    May 4, 2005 at 1:45 pm
  • Hi, as the subject says I need some advice on setting up connection handling to PG in a webserver environment. It's a typical dual Xeon FreeBSD box running Apache2 with mod_php5 and PG 8. About 20 ...
    Hannes DorbathHannes Dorbath
    May 2, 2005 at 12:41 pm
    May 2, 2005 at 5:24 pm
  • Hi All, Has anybody tried using gnuplot to plot results from queries; there are some suggestions given in PostgreSQL Developer's Handbook but i have not any luck so far! Any pointers as how to send ...
    Hrishikesh DeshmukhHrishikesh Deshmukh
    May 9, 2005 at 2:51 pm
    May 9, 2005 at 11:27 pm
  • Hello list, I need to track down the missing check numbers in a serie, table contains a column for check numbers and series like this: dbalm=# select doc_numero,doc_ckseriesfk from bdocs where ...
    JosueJosue
    May 31, 2005 at 3:08 pm
    Jun 1, 2005 at 3:23 pm
  • Is it possible to connect a DB in Postgresql to a DB in MySQL! I know its a crazy idea! H
    Hrishikesh DeshmukhHrishikesh Deshmukh
    May 26, 2005 at 9:04 pm
    May 27, 2005 at 2:14 pm
  • Hi Folks, I hope that you are well. Don't mean to rush anybody but just curious as to when the RPMS and SRPMS for 8.0.3 will show up ? Thanks ! Cheers, Aly. -- Aly Dharshi aly.dharshi@telus.net "A ...
    Aly DharshiAly Dharshi
    May 13, 2005 at 2:25 am
    May 24, 2005 at 7:10 pm
  • Hi Gurus, When I try to create a table by a script I get a error as follows, ##################################################### [postgres@demo pgsql]$ psql -d postgres -e -f ...
    Wen GuangchengWen Guangcheng
    May 17, 2005 at 6:48 am
    May 17, 2005 at 8:40 am
  • Hi I am fairly new to Postgres and am struggling to understand one concept. If I wish to use pl/pgsql, must it be in a function? An example of where I would not want it to be in a function is: I have ...
    Craig BrydenCraig Bryden
    May 2, 2005 at 11:18 am
    May 3, 2005 at 9:59 am
  • At the BSDCan tutorial last week on jails (and several other times) there was discussion regarding Postgres's use of system V style shared memory, and an unfortunate side effect of making jail() less ...
    ListerLister
    May 19, 2005 at 2:47 pm
    Jun 1, 2005 at 8:37 am
  • Hi everybody, is it possible to add some inheritance lively, without doing a dump/restore ? Some bits of information to explain why I'd like to do that : I've got those big tables, without correct ...
    David PradierDavid Pradier
    May 31, 2005 at 8:10 am
    May 31, 2005 at 1:45 pm
  • Hi All, I have a huge database working on a debian linux machine, this machine is going to get a hard drive wipe and new OS. I have another debian linux machine (exact hardware + software). Is there ...
    Hrishikesh DeshmukhHrishikesh Deshmukh
    May 27, 2005 at 4:10 pm
    May 30, 2005 at 9:15 am
  • Hello Folks, I hope that you are well. I tried compiling Postgres 8.0.3 on Solaris 10 and encountered the following problem, has anybody else had problems. I know that I have gcc3 installed and ...
    Aly DharshiAly Dharshi
    May 25, 2005 at 8:11 pm
    May 26, 2005 at 5:26 pm
  • hi, is it possible to schedule the execution of an sql stored procedure in postgress on linux? thanks Hugo
    HugoHugo
    May 18, 2005 at 3:24 pm
    May 19, 2005 at 1:20 am
  • Hi All, How can one use a table created for saving the results for a query be used in WHERE for subsequent query!!! Step 1) create table temp as select gene from dataTable1 intersect select gene from ...
    Hrishikesh DeshmukhHrishikesh Deshmukh
    May 9, 2005 at 7:48 pm
    May 13, 2005 at 7:12 pm
  • In order to address several security issues identified over the past two weeks, as well as one "low probability" race condition, we are releasing new version of PostgreSQL as far back as the 7.2.x ...
    Marc G. FournierMarc G. Fournier
    May 10, 2005 at 7:51 pm
    May 13, 2005 at 4:49 pm
  • Hi, I've been testing Delphi 2005 with Postgresql 7.4.5, through ZEOS Lib 6.5.1, and I have a question: How do you implement an optimistic locking strategy with these tools? With an Access front-end, ...
    Philippe LangPhilippe Lang
    May 12, 2005 at 8:41 am
    May 13, 2005 at 2:15 pm
  • Newbie - please help me choose a direction. I want to know what would be the best front-end app/language to use for postgresql for exact form replication and ease of use. PHP, Python, Java, Rekall ...
    Kurt GibsonKurt Gibson
    May 12, 2005 at 11:07 pm
    May 13, 2005 at 9:14 am
  • Is there any solution to this other than adding memory, or am I mis-understanding the error? pg_dump: ERROR: Memory exhausted in AllocSetAlloc(875574064) pg_dump: lost synchronization with server, ...
    Reid ThompsonReid Thompson
    May 12, 2005 at 5:56 pm
    May 13, 2005 at 1:47 am
  • Does anybody else think it would be cool if you could use a shorthand expression for creating an index on a foreign key? I think it's fair to say that in the majority of cases, if you're using a ...
    Brendan JurdBrendan Jurd
    May 8, 2005 at 4:05 pm
    May 10, 2005 at 6:13 pm
  • Hi I have the following functions , the functions are created but when it is invoked it errors out / SampleDB=# create or replace function getmatch(anyarray) returns anyarray as $$ SampleDB$# declare ...
    VidyaVidya
    May 9, 2005 at 12:20 pm
    May 10, 2005 at 9:50 am
  • Folks, if you go to the root of your postgresql distro and type ./configure --version what version of AutoConf was used? thanks! --Ross
    Mohan, RossMohan, Ross
    May 27, 2005 at 10:23 pm
    May 29, 2005 at 7:50 pm
  • Something that we end up doing sometimes in our failover testing is removing slony replication from an "active" (data provider) server. Because this involves removing triggers from tables, we end up ...
    David ParkerDavid Parker
    May 26, 2005 at 7:04 pm
    May 28, 2005 at 12:08 am
  • I've painted myself into a little corner here: I pg_dumped a 7.4.3 database, created a database of the same name on a 7.3.4 server, psql'd into the new database, and \i'd the dump file. The database ...
    BvbBvb
    May 25, 2005 at 8:12 pm
    May 26, 2005 at 2:43 pm
  • I have the created a C-Language function (code is below). Now, I wonder: How do I handle exceptions, for example if malloc cannot assign the necessary memory? Do "palloc" and "pfree" handle such a ...
    Felix E. KleeFelix E. Klee
    May 21, 2005 at 9:40 am
    May 23, 2005 at 3:54 pm
  • Hi All, If someone can email Postgresql 7.4.7 docs(PDF). It will be a big help. I am unable to get pdf docs for this version on debian system. Please help. Thanks, Hrishi
    Hrishikesh DeshmukhHrishikesh Deshmukh
    May 19, 2005 at 2:38 pm
    May 23, 2005 at 11:22 am
  • Hi Is possible use SELECT NUM_ROWS, a, b, c FROM blabla WHERE x =id; I mean it's much more faster than SELECT a, b, c FROM blabla WHERE x =id; and then SELECT count(*) FROM blabla WHERE x =id; John
    Jan SunavecJan Sunavec
    May 18, 2005 at 7:07 am
    May 19, 2005 at 4:03 pm
  • Hi, I have a web application (PHP) which runs on its own box, and connects to a database on a second box. The database box is behind the firewall and only accepts connections from the web server. I ...
    Adam WitneyAdam Witney
    May 16, 2005 at 6:45 pm
    May 18, 2005 at 4:23 pm
Group Navigation
period‹ prev | May 2005 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions307
posts1,358
users360
websitepostgresql.org
irc#postgresql

360 users for May 2005

Tom Lane: 125 posts Scott Marlowe: 64 posts Richard Huxton: 43 posts Joshua D. Drake: 24 posts Dann Corbit: 19 posts Jim C. Nasby: 19 posts Martijn van Oosterhout: 19 posts Zlatko Matić: 19 posts Hrishikesh Deshmukh: 18 posts Bruce Momjian: 16 posts Himanshu Baweja: 15 posts Neil Conway: 15 posts Vlad: 15 posts CSN: 14 posts Douglas McNaught: 14 posts Michael Fuhr: 14 posts Tony Caduto: 14 posts Bruno Wolff III: 13 posts Patrick Fiche: 11 posts Sean Davis: 11 posts
show more
Archives