FAQ

Search Discussions

310 discussions - 1,390 posts

  • I just noticed that SRA has English language certification now, available at a nationwide testing center. That's cool. Only the "Silver" is in English so far, the Gold looks more interesting. There ...
    Ian HardingIan Harding
    Jun 10, 2005 at 7:57 pm
    Jun 25, 2005 at 3:56 am
  • Hi, I am using Postgres-.8.0.1. I am creating a function with 'pltclu' language. I have already created database with 'pltclu' language. But on creation this function I am getting this error and ...
    Dinesh PandeyDinesh Pandey
    Jun 10, 2005 at 7:16 am
    Jun 14, 2005 at 6:52 am
  • I see there's a pgsql-cygwin list and a pgsql-hackers-win32 list, but no pgsql-win32 list. I browsed through the pgsql-novice and pgsql-general archives and only saw a few Windows-related posts. ...
    JoeJoe
    Jun 24, 2005 at 5:43 am
    Jun 28, 2005 at 5:09 pm
  • Hi- Any general tips on using version control (CVS, SVN) while doing database design? My thought was to do a text-mode dump (including populated code tables) from PGAdmin. How do people do this? -- ...
    Peter FeinPeter Fein
    Jun 9, 2005 at 8:25 pm
    Jun 12, 2005 at 8:02 pm
  • I work for a college and we use PG currently as our main backend. We are currently developing with Java. We are considering moving away from postgres for the reasons I am going to list below. I would ...
    Jason TesserJason Tesser
    Jun 30, 2005 at 12:40 pm
    Jul 1, 2005 at 2:41 pm
  • Hi, I¡¯m using postgreSQL with SSL these days. The version I¡¯m using is 8.0.3. I found that it¡¯s impossible to use an encrypted key file. When you use a protected server.key file, you will be ...
    Dong changyuDong changyu
    Jun 8, 2005 at 1:09 pm
    Jun 9, 2005 at 2:46 pm
  • On a particular system, loading 1 million rows (100 bytes, nothing fancy) into PostgreSQL one transaction at a time takes about 90 minutes. Doing the same in MySQL/InnoDB takes about 3 minutes. ...
    Peter EisentrautPeter Eisentraut
    Jun 2, 2005 at 10:36 pm
    Jun 4, 2005 at 5:27 pm
  • Hi, we plan to make available our database from the internet (direct tcp/ip based connections). We want to make it as secure as possible. There are a few users who could access the database, but we ...
    Együd CsabaEgyüd Csaba
    Jun 17, 2005 at 12:49 pm
    Jun 22, 2005 at 8:53 am
  • Greetings! At some point, I'm not even sure when, I apparently had a bad upgrade on one of my production databases. I'm in a situation now where I've got my back up against a wall and not sure what ...
    Gerald D. AndersonGerald D. Anderson
    Jun 1, 2005 at 3:24 pm
    Jun 4, 2005 at 5:37 pm
  • Start- Control Panel- Scheduled Tasks
    Harvey, Allan ACHarvey, Allan AC
    Jun 27, 2005 at 12:51 am
    Jun 30, 2005 at 1:53 pm
  • Hello, how can I write a function that return two or more elements? I try to return a record but after I don't know how to assign returned value to a variable. For example, CREATE OR REPLACE FUNCTION ...
    Rodríguez Rodríguez, PereRodríguez Rodríguez, Pere
    Jun 6, 2005 at 2:48 pm
    Jun 15, 2005 at 8:23 pm
  • Dear Postgresql experts, I'm trying to work out why my system spends so much time autovacuuming. It looks like pg_autovacuum wakes up every few minutes and does a query on some system tables, and ...
    Phil EndecottPhil Endecott
    Jun 5, 2005 at 10:47 pm
    Jun 15, 2005 at 9:44 am
  • Folks - hi Is it possible to determine when a row was inserted into a table using the system catalogs or such. I have the situation where I need to find out when a user was added to a user table - ...
    Eisenhut, GlennEisenhut, Glenn
    Jun 2, 2005 at 5:21 am
    Jun 5, 2005 at 1:20 am
  • I've recently been trying to implement some i18n functionality as simply as possible into my application. I have a lot of lookup values and such in the DB that need to be translated, and I would ...
    Steve - DNDSteve - DND
    Jun 30, 2005 at 11:16 pm
    Jul 7, 2005 at 4:37 pm
  • Joe Maldonado and I have a vexing problem with PostgreSQL 7.4.5 (we are using the PGDG RPMs on a RedHat 9 system). He posted about this briefly with the subject "info on strange error messages on ...
    Jeff GoldJeff Gold
    Jun 23, 2005 at 6:45 pm
    Jun 28, 2005 at 5:18 am
  • FreeBSD 5.4-Release PostgreSQL 8.0.3 I noticed that the nightly cron consisting of a vacuumdb was failing due to "unable to allocate memory". I do have maintenance_mem set at 512MB, and the ...
    Sven WillenbergerSven Willenberger
    Jun 29, 2005 at 1:00 pm
    Jun 30, 2005 at 3:46 am
  • If I have a table of items with latitude and longitude coordinates, is it possible to find all other items that are within, say, 50 miles of an item, using the geometric functions ...
    CSNCSN
    Jun 26, 2005 at 11:40 pm
    Jun 28, 2005 at 2:34 pm
  • I am experiencing a problem with dumping one specific database on a cluster. All 143 other databases dump without giving errors. The server runs PostgreSQL 7.3.2 on OpenBSD (I know :). pg_dump is ...
    Jochem van DietenJochem van Dieten
    Jun 6, 2005 at 2:04 pm
    Jun 7, 2005 at 3:22 pm
  • I need to use large objects BUT I am having problemns... I instaled PostgreSQL 8.0.3 windows version with lo module. first, I created the table below: CREATE TABLE test ( description varchar(20), ...
    GruposGrupos
    Jun 6, 2005 at 11:58 am
    Jun 6, 2005 at 9:23 pm
  • Hi. I am looking for a way to write a SELECT that finds connectivity components of a graph or at least for one that given two nodes determines if there is a path between them. It seems that this is ...
    Joachim ZobelJoachim Zobel
    Jun 2, 2005 at 7:24 pm
    Jun 5, 2005 at 9:35 pm
  • We have a system set up whereby postfix and maildrop gather user info from a pg database (7.4.2 on FreeBSD 5.2.1) to do local mail acceptance and delivery. I have configured max connections at 512 ...
    Sven WillenbergerSven Willenberger
    Jun 21, 2005 at 6:59 pm
    Jun 27, 2005 at 1:56 pm
  • Hello list, I have a setup with multiple databases running on one Postgres. Say, db1, db2 and db3. I have two problems with this setup, the first is how to restore one of the databases and leave the ...
    Jacob AtzenJacob Atzen
    Jun 17, 2005 at 11:53 am
    Jun 20, 2005 at 8:56 am
  • Greetings! Is there an issue when a large number of INHERITS tables exist for planning? We have 2 base tables, and use INHERITS to partition the data. When we get around 2000-2200 sub-tables (approx ...
    Edmund DenglerEdmund Dengler
    Jun 10, 2005 at 1:30 am
    Jun 16, 2005 at 12:36 pm
  • Hi- I wanted to use a partially unique index (dependent on a flag) on a TEXT column, but the index row size was too big for btrees. See the thread "index row size 2728 exceeds btree maximum, 2713" ...
    Peter FeinPeter Fein
    Jun 13, 2005 at 10:50 pm
    Jun 14, 2005 at 9:28 pm
  • Dear All, Beside the documentation, which pg book would you recommend? Which one is your personal favorite pg book? Regards Gevik.
    Gevik babakhaniGevik babakhani
    Jun 3, 2005 at 7:05 pm
    Jun 8, 2005 at 2:24 am
  • Hi All, First I apologize for the length of this email im just afraid that my problem is quite complicated for explination & also about my english which is not my native language.... sorry :) I'm ...
    Ben-Nes YonatanBen-Nes Yonatan
    Jun 27, 2005 at 7:13 pm
    Jul 4, 2005 at 1:27 pm
  • Simple question I'm sure, but how can I get the transaction ID that a query is currently running in? I can find all kinds of documentation talking about transaction ids, but nothing about how to get ...
    Steve - DNDSteve - DND
    Jun 14, 2005 at 11:33 pm
    Jun 15, 2005 at 4:59 pm
  • TABLE -----------+-----------------------+----------- Column | Type -----------+-----------------------+----------- scan_id | bigint host_ip | character varying(15) port_num | integer plugin_id | ...
    Dinesh PandeyDinesh Pandey
    Jun 2, 2005 at 7:10 am
    Jun 2, 2005 at 12:36 pm
  • I am new to Postgre, and am still learning some of the basics... please bare with me. I need to know how to access a sequence from within a function. Let me know whats wrong with the following... ...
    Clark AllanClark Allan
    Jun 30, 2005 at 7:32 pm
    Jul 5, 2005 at 11:05 pm
  • Dear All, I have a number of complex views for which the typical use is to select exactly one row by id, e.g. "select * from V where id=nnn". Some of these selects run orders of magnitude faster than ...
    Phil EndecottPhil Endecott
    Jun 9, 2005 at 2:16 pm
    Jun 24, 2005 at 6:55 am
  • I have a database running 8.0.1 One of the tables uses a plpgsql function as a check constraint. There is data in the table that passed the constraint. The problem comes when trying to restore the ...
    Lee HarrLee Harr
    Jun 20, 2005 at 1:19 am
    Jun 23, 2005 at 5:31 pm
  • Someone flipped a breaker switch, and evidently triggered corruption in one of our major clusters: $ cat server_log.Mon postmaster successfully started 2005-06-06 14:31:11.950 [20124] LOG: database ...
    Ed L.Ed L.
    Jun 6, 2005 at 8:16 pm
    Jun 7, 2005 at 8:57 pm
  • Hi, All , I am newbie to postgres database. How to take pg_dump from production database and restore into development server using pg_restore.. From documentation, I find that I have to use pg_dump ...
    Ketan shahKetan shah
    Jun 29, 2005 at 2:48 pm
    Jul 1, 2005 at 7:57 am
  • I am getting the following error when i try to install the postgres 8.03 . It seems to be problem with the installing postgres libs. Plesae advice me to fix this problem. warning: ...
    Prasad DuggineniPrasad Duggineni
    Jun 15, 2005 at 3:08 pm
    Jun 22, 2005 at 3:10 pm
  • Hi. I know that superusers are allowed to do everything on the database, but I consider this as dangerous. I want to have some user group with rights of creating new users and giving them some ...
    Zlatko MatićZlatko Matić
    Jun 15, 2005 at 3:25 pm
    Jun 22, 2005 at 10:08 am
  • hey all, I'm trying to convince some people here to adopt either mysql or postgresql as a relational database here.. However, we can't start from a clean slate; we have a very mature oracle database ...
    Edward PeschkoEdward Peschko
    Jun 6, 2005 at 8:00 pm
    Jun 13, 2005 at 11:14 pm
  • Hello ! I have an Access database using linked tables on PG 8.0.3 (on Windows 2003 server). I use pgODBC 8.00.01.01. Some tables appear like deleted ! In Access I see : Categ : Table vt_cat vt_libcat ...
    Ets ROLLANDEts ROLLAND
    Jun 9, 2005 at 11:20 am
    Jun 13, 2005 at 10:33 pm
  • Hi, Should it be possible to create a compressed backup of a version 8.0.1 database running on linux and restore that backup on version 8.0.3 running on XP? I ask this because it does not seem to ...
    Howard ColeHoward Cole
    Jun 8, 2005 at 10:10 am
    Jun 10, 2005 at 12:14 pm
  • Hello, I'm writing a large store procedures (more than 700 lines) and I have much problems to debug it. How can I debug it easily? I use pgAdmin, is there another editor (free software) that permit ...
    Rodríguez Rodríguez, PereRodríguez Rodríguez, Pere
    Jun 2, 2005 at 7:59 am
    Jun 6, 2005 at 7:52 am
  • I'm looking for a way to enable a function to commit a unit of work that does not affect the caller's transaction. I'm coming from the Oracle world where I've used the "autonomous_transaction" pragma ...
    Matt MillerMatt Miller
    Jun 1, 2005 at 3:38 pm
    Jun 3, 2005 at 11:23 pm
  • To me it seems that the definer of this table missed the concept index ... or the concept database One usually looks up data using a key, but if the whole row is the key, what data shall be looked ...
    Robert KöpferlRobert Köpferl
    Jun 2, 2005 at 12:09 pm
    Jun 3, 2005 at 7:25 am
  • Hi there, I have the following problem: I'm developing some forms for data entry for some clinical studies, with data stored on a PostgreSQL database. The study is based in a questionnaire, with ...
    Jose Gonzalez GomezJose Gonzalez Gomez
    Jun 17, 2005 at 12:35 pm
    Jun 29, 2005 at 12:37 pm
  • During a vacuum, I ran into this error: vacuumdb: vacuuming of database "friend" failed: ERROR: invalid page header in block 41661 of relation "friend_pkey" I've read the posts on this newsgroup and ...
    Akash GargAkash Garg
    Jun 23, 2005 at 6:08 am
    Jun 23, 2005 at 6:53 pm
  • OK, so I'm trying to make a rule with 1 action. The docs, not so helpfully, only seem to show a single action rule (at least in the rules section, not sure about elsewhere) The syntax diagram: CREATE ...
    Scott MarloweScott Marlowe
    Jun 22, 2005 at 11:31 pm
    Jun 23, 2005 at 2:24 pm
  • I've been backing up my databases by piping pg_dump into gzip and burning the resulting files to a DVD-R. Unfortunately, FreeBSD has problems dealing with very large files ( 1GB?) on DVD media. One ...
    Andrew L. GouldAndrew L. Gould
    Jun 21, 2005 at 2:28 am
    Jun 21, 2005 at 1:56 pm
  • Hi! At the moment on my Linux box I have process 'postmaster' eats all CPU. It corresponds with connection closed day before - not sure if it was normal disconnect. strace shows the process ...
    Ilja GolshteinIlja Golshtein
    Jun 16, 2005 at 11:48 am
    Jun 17, 2005 at 12:42 pm
  • Greetings! We have a table with more than 250 million rows. I am trying to delete the first 100,000 rows (based on a bigint primary key), and I had to cancel after 4 hours of the system not actually ...
    Edmund DenglerEdmund Dengler
    Jun 10, 2005 at 2:37 pm
    Jun 10, 2005 at 4:30 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0004_6C328523.4625085B Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit Dear Valued Member, According to ...
    WebmasterWebmaster
    Jun 8, 2005 at 9:53 pm
    Jun 10, 2005 at 6:07 am
  • What are the opinions on a separate list just for pl/pgsql? Seems pl/pgsql deserves her own area. Just wondering if this would make sense, and if it did can we have a separate list?
    BobBob
    Jun 7, 2005 at 8:16 pm
    Jun 8, 2005 at 2:49 am
  • Hello list, We have Fedora Core 4 Test 3 installed on a development box and just recently installed Postgresql 8.0.3. Sometimes, when starting postgresql with the /etc/rc.d/init.d/postgresql script, ...
    Dianne YumulDianne Yumul
    Jun 6, 2005 at 10:30 pm
    Jun 7, 2005 at 8:44 pm
Group Navigation
period‹ prev | Jun 2005 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions310
posts1,390
users329
websitepostgresql.org
irc#postgresql

329 users for June 2005

Tom Lane: 140 posts Richard Huxton: 65 posts Zlatko Matić: 36 posts Michael Fuhr: 35 posts Douglas McNaught: 32 posts Bruno Wolff III: 31 posts Scott Marlowe: 27 posts Alvaro Herrera: 23 posts Sean Davis: 23 posts Matt Miller: 18 posts Magnus Hagander: 17 posts Joshua D. Drake: 16 posts Bruce Momjian: 15 posts Peter Fein: 15 posts Michael Glaesemann: 14 posts Sven Willenberger: 14 posts Tino Wildenhain: 14 posts Együd Csaba: 13 posts Chris Browne: 12 posts Dinesh Pandey: 12 posts
show more
Archives