FAQ

PostgreSQL > pgsql-general > April 2004

Search Discussions

267 discussions - 1,188 posts

  • When I try to run thread_test.c from the CVS tip, it hangs in an infinite CPU loop on both linux (RedHat AS 3.0, gcc 3.2.3) and Mac OS X 10.3.3 (gcc 3.3). I've also tried down to gcc 2.96 on Mac OS ...
    Wes PalmerWes Palmer
    Apr 3, 2004 at 9:32 pm
    Apr 27, 2004 at 12:49 pm
  • I need to perform modulo operations on extremely large numbers. The % operator is giving me number out of range errors and the mod(x, y) function simply seems to return the wrong results. Also, my ...
    Chadwick BoggsChadwick Boggs
    Apr 26, 2004 at 2:18 pm
    Apr 29, 2004 at 9:36 pm
  • Hmm ... seems like the big question is not "where to keep them" but "who's gonna maintain them" ... without active maintenance they're just dead bits wherever they're stored, because MySQL and ...
    Tom LaneTom Lane
    Apr 14, 2004 at 4:41 am
    Apr 19, 2004 at 6:05 pm
  • Hi, I am a new user of PostgreSQL and there are some questions about its performance in a scenario with a high requisition rate Lets picture an imaginary scenario: In my system (Debian Linux), there ...
    Kilmer C. de SouzaKilmer C. de Souza
    Apr 28, 2004 at 6:14 pm
    Apr 30, 2004 at 1:20 am
  • Hello, I am working on web portal. There are some ads. We have about 200 000 ads. Every ad have own directory called ID, where is 5 subdirectories with various sizes of 5 images. Filesystem is too ...
    Michal HlavacMichal Hlavac
    Apr 13, 2004 at 8:44 am
    Apr 15, 2004 at 11:40 pm
  • Why must a cursor be defined in an open transaction? Obviously there's a good reason, but I can't figure it out. On a high level, what would be involved in allowing a cursor to outlive the ...
    Eric RidgeEric Ridge
    Apr 5, 2004 at 8:56 pm
    Apr 8, 2004 at 1:46 am
  • Has anyone created something like that for Postgresql? It would be really handy to encrypt credit card numbers and other information so it stays secure. If no one has created anything such as this, I ...
    Mike CoxMike Cox
    Apr 9, 2004 at 8:40 pm
    May 12, 2004 at 7:00 am
  • Hi everyone, I have a PostgreSQL 7.4 database running, which was initdb-ed using standard (SQL_ASCII) encoding, with -lc-collate=C option set. Everything is running fine, but I just discovered ...
    Priem, AlexanderPriem, Alexander
    Apr 21, 2004 at 12:37 pm
    Apr 22, 2004 at 1:23 pm
  • Is there a feature similar to this currently in Postgres, or will there be? Sometimes (like in a shared hosting environment), we cannot have the luxury of hot-swapped RAID or expensive SAN, and it's ...
    David GaramondDavid Garamond
    Apr 26, 2004 at 3:13 pm
    May 26, 2004 at 3:24 pm
  • Hello, postgresql 7.3.4 on Debian or the redhat packaged 7.3.4-8 on RHEL AS3 - same issue, so I somewhat cut out RH is playing things on me. Tested on two different PCs, too (say, one debian, one ...
    Philipp BuehlerPhilipp Buehler
    Apr 21, 2004 at 5:51 pm
    Apr 27, 2004 at 1:48 am
  • Hello everyone, i just upgraded my old postgres-database from version 7.1 to 7.4.2. i dumped out my 7.1 database (with pg_dump from 7.1) as an sql-file with copy-commands and to one file using ...
    Development - multi.art.studioDevelopment - multi.art.studio
    Apr 13, 2004 at 10:13 am
    Apr 25, 2004 at 8:29 pm
  • I have a strange error. when I do a ps aux I get: postgres 15018 0.0 0.6 9192 7396 ? S 09:20 0:00 /usr/bin/perl /www/nexum/cgi-bin/accounting/posting/automatic_posting postgres 15019 0.0 0.3 25696 ...
    Jon PastoreJon Pastore
    Apr 22, 2004 at 1:11 am
    Apr 30, 2004 at 3:34 am
  • Dear All, What's the best way to store jpgs in postgresql to use in a web page? I tried to use large objects, but how would you extract them from a table to be viewed in a web-page without having to ...
    C GC G
    Apr 5, 2004 at 4:20 pm
    Apr 9, 2004 at 4:49 pm
  • Dear peoples, Periodically we are getting runaway postgres processes on our Linux (2.4.21-0.13 on Dell servers), using 7.4 and GIS (0.8 USE_GEOS=1 USE_PROJ=1 USE_STATS=1). All of the queries come in ...
    Gregory S. WilliamsonGregory S. Williamson
    Apr 29, 2004 at 7:54 pm
    May 6, 2004 at 1:37 pm
  • Hi, We've got some clients that are concerned about running Postgresql 7.3.4 on a Win2k Server box, alongside MS SQL Server. I've been running pg on my XP machines for a long time now (with cygwin) ...
    Anony MousAnony Mous
    Apr 22, 2004 at 6:04 am
    Apr 23, 2004 at 4:41 pm
  • Hi I am running Mandrake 10 and would like to get sql-ledger to access the database. I can get in to the database with a local user at the command prompt and Web Admin. sql-ledger returns ident ...
    Shanta McBainShanta McBain
    Apr 21, 2004 at 7:26 pm
    Apr 22, 2004 at 7:15 pm
  • I am working on a design where a location for something can have: Fully qualified address with even building names, room numbers, and booth numbers. **-OR-** GPS location **-OR-** Both Other than ...
    Dennis GearonDennis Gearon
    Apr 30, 2004 at 11:34 pm
    May 3, 2004 at 11:47 am
  • Hi, I just see that Mysql will propose at the end of the month a full synchronous replication system with auto-recovery. http://www.mysql.com/products/cluster/ We need to see when stable version ...
    Pailloncy Jean-GérardPailloncy Jean-Gérard
    Apr 20, 2004 at 9:26 am
    Apr 26, 2004 at 6:23 pm
  • Hi, Im passing this in the commmand line to start up the PostgreSQL server: ./pg_ctl start -w -D /Volumes/GROUCH\ 2/Database3 but its always giving me this error: ./postmaster: invalid argument: ...
    Alexander CohenAlexander Cohen
    Apr 8, 2004 at 4:40 pm
    Apr 12, 2004 at 6:49 am
  • Hello, I have to design a table wich will store some action reports. Each report have an ID like this 1/2004, 2/2004, ... and each years, they restart to 1 (1/2004, 1/2005, 1/2006,...). So, I was ...
    Bruno BaguetteBruno Baguette
    Apr 26, 2004 at 9:19 am
    Apr 26, 2004 at 4:58 pm
  • I am using PostgreSQL 7.4.1 on RedHat 7.2. The query I am executing is something like (I replaced all the return values with 'count'): db= explain select count(*) from messages m join (select * from ...
    WespvpWespvp
    Apr 1, 2004 at 4:53 pm
    Apr 6, 2004 at 12:56 pm
  • Hi All, Our application is using the Postgres 7.3.4-RH database that is packaged with the AS3.0 for CCM. There is a variable type called refcursor that is being used by CAR Functions in Postgres ...
    Sumita BiswasSumita Biswas
    Apr 23, 2004 at 6:27 pm
    May 17, 2004 at 2:10 am
  • Hello everyone, I try to see if i can make a recursive function with a trigger set on INSERT and doing an insert under my trigger function. So i wrote a test function : CREATE OR REPLACE FUNCTION ...
    Froggy / Froggy Corp.Froggy / Froggy Corp.
    Apr 20, 2004 at 11:03 pm
    Apr 28, 2004 at 9:10 am
  • Does anyone know what the effect of --lc-collate=C --encoding=UNICODE will be for sorts (and indexes?) when a multibyte unicode character is encountered? Is --lc-collate=C --encoding=UNICODE even ...
    John Sidney-WoollettJohn Sidney-Woollett
    Apr 22, 2004 at 11:27 am
    Apr 23, 2004 at 10:06 am
  • Hello, I'm getting the following error when I try to update or insert into a table. This just started happening today. The table has been working fine up to now. The table has 27,000 rows and 24 ...
    John HagstrandJohn Hagstrand
    Apr 7, 2004 at 9:46 pm
    Apr 15, 2004 at 3:53 am
  • Hi, Our database contains Hindi as well as English characters. We have specified the encoding to be unicode during initdb as well as createdb commands. Unfortunately sorting of the Hindi fields is ...
    Hitesh BagadiyaHitesh Bagadiya
    Apr 9, 2004 at 8:05 am
    Apr 12, 2004 at 4:17 am
  • Hi, Thought perhaps some other eyes than mine can tell if I'm doing something wrong here or if there's a bug somewhere. I've never passed a ROWTYPE varaible to a function but I don't see where the ...
    Karl O. PincKarl O. Pinc
    Apr 29, 2004 at 9:43 pm
    Apr 30, 2004 at 7:36 pm
  • Dear All, I have a database which stores traffic data and to update the traffic for the particular IP i have to select this ip from the table for this period and if it is already in the database i ...
    Anton NikiforovAnton Nikiforov
    Apr 23, 2004 at 1:50 pm
    Apr 23, 2004 at 10:40 pm
  • In the docs it says "Plan-reading is an art that deserves an extensive tutorial, which this is not". Is there one? I've gone beyond simple queries (which are performing well) to the more difficult ...
    Klint GoreKlint Gore
    Apr 19, 2004 at 6:27 am
    Apr 21, 2004 at 2:36 pm
  • Hi all, I want to write a function in pgsql that given a number like 7 turns that into a date, 7 weeks in the past. I have a table that is essentially logging some information and want to write a ...
    Hadley WillanHadley Willan
    Apr 18, 2004 at 9:02 pm
    Apr 19, 2004 at 11:40 am
  • I have a query that works in 7.3.6 but not in 7.4.2 unless I turn off enable_hashjoin. I'm joining a table of network interfaces and a table of networks so I can find additional info about a ...
    Michael FuhrMichael Fuhr
    Apr 13, 2004 at 6:35 pm
    May 20, 2004 at 2:33 am
  • Hello, I'm having a problem with timestamps in postgresql. I run the following query to pull dates in this format: WEEK/MONTH/YEAR However the data says that April 28th 2004 was in week 4 of April ...
    Campano, TroyCampano, Troy
    Apr 29, 2004 at 6:43 pm
    Apr 30, 2004 at 8:58 pm
  • Dear All, I have a question about using partial indexes. Lets say i have a table containing data types (table_datatype) and the table containing data entrys (table_data). While inserting into data ...
    Anton NikiforovAnton Nikiforov
    Apr 29, 2004 at 7:36 am
    Apr 29, 2004 at 1:53 pm
  • My background is Windows and I just switched, yesterday to, Suse Linux Professional 9.0. And I have a class project due Monday, which is on why select postgresql as your DBMS. I am trying to install ...
    Stephen SalbodStephen Salbod
    Apr 21, 2004 at 1:20 am
    Apr 27, 2004 at 6:15 pm
  • Hello, I am trying to select distinct dates and order them in the reverse chronological order. Although the column type is TIMESTAMP, in this case I want only YYYY, MM, and DD back. I am using the ...
    OtisUsenetOtisUsenet
    Apr 21, 2004 at 9:43 am
    Apr 26, 2004 at 9:30 pm
  • I have a problem with postgresql tables. periodicaly, I would say frequently about 5-10 time per hour i have such errors in my server log file: 2004-04-14 12:23:32 [73692] ERROR: cache lookup of ...
    Juris KruminsJuris Krumins
    Apr 14, 2004 at 9:33 am
    Apr 26, 2004 at 9:32 am
  • Is it possible to to the following I have tables which are updated via webpage (perl) with fields of type int and date (all nullable). If the values are blank the entire insert fails, with a wrong ...
    MikeMike
    Apr 23, 2004 at 10:38 am
    Apr 23, 2004 at 11:39 pm
  • <rant Please can someone explain why Postgres cannot recognize that objects (referenced by pl/pgsql functions) whose OID no longer exists could in fact be found (as new objects) if the function was ...
    John Sidney-WoollettJohn Sidney-Woollett
    Apr 22, 2004 at 1:18 pm
    Apr 22, 2004 at 9:34 pm
  • Hi I'm trying to restore tsearch2 featuring database like discribed in the 'tsearch-V2-intro' document. (http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html) In point ...
    Fischer UlrichFischer Ulrich
    Apr 22, 2004 at 8:59 am
    Apr 22, 2004 at 3:33 pm
  • Hi I'm building a web app where changes to customer orders are logged in the following table, and I worried about the time that it will take to locate records that need further processing/actioning. ...
    John Sidney-WoollettJohn Sidney-Woollett
    Apr 16, 2004 at 2:01 pm
    Apr 20, 2004 at 4:25 am
  • Hello, I have a PL/PGSQL stored procedure that makes me mad currently... (The stored procedure is a procedure that simulates a materialized view) It complains about a parse error when I call that ...
    Bruno BAGUETTEBruno BAGUETTE
    Apr 16, 2004 at 9:32 am
    Apr 17, 2004 at 6:14 pm
  • Hi! Suppose I have "pg_dump -s" of two pg installs, one is "dev", another is "production". Their schemas don't differ too much, and I want to get a "diff -u"-like schema diff so I can quickly add ...
    Igor ShevchenkoIgor Shevchenko
    Apr 12, 2004 at 6:35 pm
    Apr 14, 2004 at 5:00 pm
  • Hello, How to make sure COPY TO writes the table lines to the file in the same order they were inserted? I'm producing html pages in pl/pgsql and using COPY TO to write then to file. Occasionaly, ...
    Clodoaldo Pinto NetoClodoaldo Pinto Neto
    Apr 10, 2004 at 5:54 pm
    Apr 13, 2004 at 8:25 pm
  • Hi: In postgres documentation its written that if we execute query as PERFORM query inside our stored procedure; then the special variable FOUND is set to true if the query produced at least one row, ...
    Rajat KatyalRajat Katyal
    Apr 6, 2004 at 8:43 am
    Apr 7, 2004 at 8:28 am
  • Hello, In the init-script contained in the RPMs downloadable from the PostgreSQL site (I checked the one for Fedora), an explicit locale is set before running initdb. - And the explicit locale is not ...
    Troels ArvinTroels Arvin
    Apr 4, 2004 at 8:47 pm
    Apr 5, 2004 at 6:46 pm
  • I have created a web app that stores and displays all the messages from my database maintenance jobs that run each night. The web app uses Java servlets and has PostgreSQL 7.0 as the back end. When ...
    Howard, Steven (US - Tulsa)Howard, Steven (US - Tulsa)
    Apr 29, 2004 at 1:34 pm
    Apr 29, 2004 at 2:28 pm
  • I'm trying to set up some basic rules to log inserts, updates, and deletes to tables in an inheritance hierarchy (by inserting records into a log table), and I've got a couple of questions. (1) Is it ...
    Timothy PerrigoTimothy Perrigo
    Apr 26, 2004 at 7:12 pm
    Apr 27, 2004 at 3:18 pm
  • The following function returns this error: pg_query(): Query failed: ERROR: permission denied for relation customers CONTEXT: PL/pgSQL function "newprofile" line 8 at SQL statement What is wrong ...
    Tumurbaatar S.Tumurbaatar S.
    Apr 22, 2004 at 9:29 am
    Apr 26, 2004 at 9:53 am
  • I'm hoping there's someone here with experience in building the Visual Explain tool from Red Hat. I downloaded it and the J2 SDK, but when I attempt to follow the build instructions, I get messages ...
    Jeff BoesJeff Boes
    Apr 21, 2004 at 12:57 am
    Apr 22, 2004 at 8:58 pm
  • Hi! How do i convert a result to upper/lowercase? I'ld like to do the following: SELECT UPPER(lang) from languages; and get for example "uk" as "UK", "dk" AS "DK" and so on… Sincerely Victor
    Victor Spång ArthurssonVictor Spång Arthursson
    Apr 13, 2004 at 12:17 pm
    Apr 21, 2004 at 10:17 am
Apr 2004
123456
Group Navigation
period‹ prev | Apr 2004 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions267
posts1,188
users314
websitepostgresql.org
irc#postgresql

314 users for April 2004

Tom Lane: 131 posts Bruce Momjian: 48 posts Bruno Wolff III: 34 posts Richard Huxton: 28 posts Wespvp: 23 posts Scott.marlowe: 23 posts Alvaro Herrera: 19 posts Jim Seymour: 19 posts John Sidney-Woollett: 18 posts Andrew Sullivan: 14 posts Jan Wieck: 14 posts Marc G. Fournier: 14 posts Dann Corbit: 13 posts Peter Eisentraut: 13 posts Stephan Szabo: 13 posts Development - multi.art.studio: 12 posts Greg Stark: 12 posts Joshua D. Drake: 12 posts Manfred Koizar: 12 posts Mike Nolan: 12 posts
show more
Archives