FAQ

PostgreSQL > pgsql-general > September 2009

Search Discussions

257 discussions - 1,234 posts

  • Dear List, I am trying to implement the following: In a database I wish to implement a GENERIC datamodel, thus on a meta-level. All RELATIONS (part of a MODEL) will be a view on some base (being a ...
    InterRobInterRob
    Sep 24, 2009 at 4:28 pm
    Sep 29, 2009 at 4:34 am
  • I have a table with 5 million rows. 10 inserts and deletes are performed on this table every second. The table has indexes on the columns I use to query it, and the query is returning about a 1000 ...
    TomrevamTomrevam
    Sep 29, 2009 at 11:23 am
    Oct 4, 2009 at 3:56 pm
  • Hello, As blocksizes, random I/O and linear I/O are critical I/O performance parameters I had a look on PostgreSQL and a commercial software vendor. Therefore I enhanced the system tap script: ...
    Gerhard WiesingerGerhard Wiesinger
    Sep 27, 2009 at 4:06 pm
    Oct 10, 2009 at 2:11 am
  • Dear my friends.... I am still new in PostgreSQL. Usually I use MySQL on OpenSuSE. I just have installed postgres with: "zypper install postgresql-server". The installation looked OK. As ...
    Ricky Tompu BreakyRicky Tompu Breaky
    Sep 24, 2009 at 6:47 pm
    Sep 28, 2009 at 12:00 pm
  • Best Regards, Ed Koch Principal Addison Search 212-378-1634 1350 Broadway NY,NY suite 810, 10018 This message contains confidential information and is intended only for the individual named. If you ...
    Ed KochEd Koch
    Sep 15, 2009 at 9:14 pm
    Sep 16, 2009 at 5:46 pm
  • Hello, This concerns use of postgresql.key private key file on the client side. psql can't establish a connection. with an encrypted postgresql.key file. If I'm wrong here, the following is invalid ...
    Saleem EDAH-TALLYSaleem EDAH-TALLY
    Sep 13, 2009 at 10:36 am
    Sep 15, 2009 at 6:47 pm
  • Hi, I'm fairly new to postgres and am having trouble finding what I'm looking for. Is there a feature that allows bulk inserts into tables? My setup is Win XPe 2002 SP3 and PostgreSQL 8.3. I need to ...
    Dave HuberDave Huber
    Sep 28, 2009 at 3:38 pm
    Oct 10, 2009 at 10:42 am
  • Hy, i have some trouble with the new postgresql 8.4. we check out the compatibility between postgres 8.1 and 8.4 so we have the following error: invalid byte sequence for encoding "WIN1252": 0x00 can ...
    Daniel SchuchardtDaniel Schuchardt
    Sep 13, 2009 at 5:01 pm
    Feb 24, 2010 at 5:59 pm
  • The documentation of the COPY command does not state what character set(s) are recognized or written. I need to import and export UTF-8 data; how can I do that? -- Peter Headland Architect Actuate ...
    Peter HeadlandPeter Headland
    Sep 10, 2009 at 1:21 am
    Feb 23, 2010 at 9:39 pm
  • Hello, I think the limit of bgwriter_lru_maxpages of max. 1000 doesn't make any sense because in fact it limits performance of the database (version 8.3). On heavy write operations buffer cached must ...
    Gerhard WiesingerGerhard Wiesinger
    Sep 27, 2009 at 6:07 am
    Oct 5, 2009 at 8:40 pm
  • Hi All, We're having numerous problems with a PostgreSQL 8.3.7 database running on a virtual Linux server w/VMWare ESX. This is not by choice and I have been asking the operator of this equipment for ...
    Tom DuffeyTom Duffey
    Sep 21, 2009 at 5:21 pm
    Sep 22, 2009 at 10:50 pm
  • Hi - I'm seeing a behavior with updatable cursors that matches neither the behavior of a sensitive cursor nor an insensitive one. In summary, I'm running with serializable as the isolation level and ...
    Daniel FDaniel F
    Sep 30, 2009 at 5:36 pm
    Oct 2, 2009 at 6:02 pm
  • I recently upgraded PostgreSQL, and now this happens: # /etc/init.d/postgresql start An old version of the database format was found. You need to upgrade the data format before using PostgreSQL. See ...
    Kelly JonesKelly Jones
    Sep 29, 2009 at 4:18 pm
    Sep 29, 2009 at 6:08 pm
  • Hello, Research on the pg_bufferache showed that a lot of pages don't have any assigned relfilenodesin pg_class, even when they are dirty (in this case inserts are done). SELECT relname IS NULL AS ...
    Gerhard WiesingerGerhard Wiesinger
    Sep 26, 2009 at 5:54 pm
    Sep 27, 2009 at 3:19 am
  • Hi! I am looking at the PHP/MySQL Google Maps API store locator example here: http://code.google.com/apis/maps/articles/phpsqlsearch.html And I'm trying to get this to work with PostgreSQL instead of ...
    JonathanJonathan
    Sep 17, 2009 at 7:32 pm
    Sep 19, 2009 at 4:19 pm
  • We have a set of tables that we're partitioning by year and month - e.g. payments_parent, partitioned into payments_200901, payments200902, ... and inquiries_parent, partitioned into ...
    Reid ThompsonReid Thompson
    Sep 28, 2009 at 4:05 pm
    Sep 29, 2009 at 10:55 pm
  • Hi, We are developing a web application that will work on Postgresql. My doubt is about the hardware that I can use for postgresql. What HW is more important to postgresql performance? Assuming that ...
    PsicopunkPsicopunk
    Sep 11, 2009 at 10:31 am
    Sep 14, 2009 at 4:31 pm
  • Hi, our application is using Postgres in a rather unusuall way. It is used by a GUI application to store several hundred thousand 'parameters'. Basically it is used like a big INI file. There are ...
    V S PV S P
    Sep 2, 2009 at 5:19 pm
    Sep 7, 2009 at 11:39 am
  • Is there any way to limit a query to a certain amount of RAM and / or certain runtime? i.e. automatically kill it if it exceeds either boundary? We've finally narrowed down our system crashes and ...
    Alan McKayAlan McKay
    Sep 17, 2009 at 7:04 pm
    Sep 17, 2009 at 10:00 pm
  • Hi folks First time poster here so please extend grace if I don't initially provide what is needed to help. I am running postgresql 8.3.7 on debian lenny (postgresql-8.3_8.3.7-0lenny1_i386.deb). I ...
    Grant MaxwellGrant Maxwell
    Sep 10, 2009 at 2:46 pm
    Sep 14, 2009 at 12:24 am
  • I have compiled a 32 bit ( CC="gcc -arch i386" ) version of PG 8.4.0. I am finding the following in the pg logfile when I stop then start the postgresql server. LOG: received smart shutdown request ...
    Jerry LeVanJerry LeVan
    Sep 6, 2009 at 2:31 pm
    Sep 8, 2009 at 8:26 am
  • Hi all. We have included PostgreSQL 8.3(exe) installation in the installation process of our software, and we are experimenting some errors, mainly related with Windows Vista. The problem is that the ...
    Inigo BarandiaranInigo Barandiaran
    Sep 2, 2009 at 10:39 am
    Sep 3, 2009 at 4:14 pm
  • Hi, I have a question - is it possible to rename columns in rowset returned from plpgsql function delared as 'returns table(...)' ? It seems it's not possible, even using 'as "column_name"' in ...
    Krzysztof BarlikKrzysztof Barlik
    Sep 26, 2009 at 4:23 pm
    Oct 7, 2009 at 8:03 pm
  • Hi List, I tried already in the ODBC list, but without success... I have to develop a client/server application, heavily transaction oriented, that will serve around 100 users and database traffic ...
    Nico CallewaertNico Callewaert
    Sep 25, 2009 at 9:16 am
    Sep 30, 2009 at 8:42 am
  • Hi, I have a development DB and a production DB. I need a way to sync the changes I make to the stucture in the devel DB to the production DB. I found pgdiff but can't get it to work. I would like a ...
    JohnJohn
    Sep 28, 2009 at 3:49 pm
    Sep 29, 2009 at 7:29 am
  • Hi, I'm looking for a way to replicate am master database to multiple (100+) databases that are taken in to the field. Currently for each laptop we dump and load the tables. However,there is only a ...
    Bryan MontgomeryBryan Montgomery
    Sep 23, 2009 at 6:31 pm
    Sep 25, 2009 at 8:35 am
  • Hello! I'm having some trouble with the inet data type and its operators. Right now I'm relying on operations such as kll=# SELECT '10.0.0.0/24'::inet + (2^(32-24))::integer; ?column? ------------- ...
    Kristian LarssonKristian Larsson
    Sep 8, 2009 at 1:58 pm
    Sep 10, 2009 at 3:51 pm
  • Hello, Is it possible to join tables in the where clause of a statement? I ask because I have a situation where I only have access to the where clause of a select statement on a single table, yet I ...
    Scott FrankelScott Frankel
    Sep 8, 2009 at 10:33 pm
    Sep 9, 2009 at 11:42 am
  • Hello, I have created a fresh cluster with initdb -D /some/path/pgtest I can start postgres to run on unix domain socket serving this cluster with: postgres -D /some/path/pgtest -h '' -k ...
    Josef WolfJosef Wolf
    Sep 1, 2009 at 11:50 am
    Sep 6, 2009 at 2:34 pm
  • Hello, I've done a benchmark of recent versions of PostgreSQL's last five major releases to see, how performance has changed during the past years from version to version. You can find the article ...
    György VilmosGyörgy Vilmos
    Sep 29, 2009 at 7:36 am
    Oct 2, 2009 at 7:23 pm
  • I have database backup schema+data in text (non-compressed) format. Backup is created using "pg_dump -i -h ... -U ... -f dump.sql". I run it with "psql <dump.sql" but after restore all triggers are ...
    Joe KramerJoe Kramer
    Sep 23, 2009 at 2:28 am
    Sep 23, 2009 at 5:05 pm
  • Has somebody integrated Unicode normalization into Postgres? if not, I would have to implement my own function by using this CPAN module: http://search.cpan.org/~sadahiro/Unicode-Normalize-1.03/ . I ...
    Andreas KalschAndreas Kalsch
    Sep 16, 2009 at 5:52 pm
    Sep 17, 2009 at 12:58 pm
  • When I try and manually perform a checkpoint with version 8.3 on CentOS 5 I get this error: ERROR: could not link file "pg_xlog/000000010000000000000000" to "pg_xlog/000000010000000000000002" ...
    Cory IsaacsonCory Isaacson
    Sep 14, 2009 at 9:46 am
    Sep 14, 2009 at 4:37 pm
  • Hey folks, I've got Munin installed on all my systems, so was able to get some interesting data around the big crash we had last night. We'd thought it was simply a matter of our DB connections ...
    Alan McKayAlan McKay
    Sep 5, 2009 at 12:11 pm
    Sep 8, 2009 at 8:12 pm
  • Hi. How can I abort a query that I see is listed in select * from pg_stat_activity;
    A BA B
    Sep 4, 2009 at 5:37 am
    Jul 20, 2012 at 6:59 am
  • Hello Folks, So I have following problem as I logged in Windows 2003 with domain\user. I am basically trying to create installer for postgres. So I need to keep in mind that person who is going to ...
    Vikram PatilVikram Patil
    Sep 12, 2009 at 3:24 am
    Oct 11, 2010 at 11:30 pm
  • I am using psql to call an external sql file that executes a simple select count(*): ie: select into ct count(*) from table; I can't figure out how to make the ct variable available to the shell ...
    Alex GadeaAlex Gadea
    Sep 20, 2009 at 9:58 pm
    Sep 23, 2009 at 9:54 pm
  • I want to know is there any way can install postgis for postgresql so easily, just like one click bin on Ubuntu using command line? I know there is a tool called stack builder which work after ...
    Shane_chinaShane_china
    Sep 2, 2009 at 2:50 pm
    Sep 3, 2009 at 12:49 pm
  • Hi, I have multiple applications, i want to create separate schema for each of the application. I dont want to change search path, since have only one user. I went through couple of post's talking ...
    Himanshu GuptaHimanshu Gupta
    Sep 1, 2009 at 9:05 pm
    Sep 2, 2009 at 5:34 pm
  • Hello, if I use this statement: postgres=# select array[[2,3],[3,4]]; array --------------- {{2,3},{3,4}} - the result looks for me as an array of integer-arrays now I try: select array( select a ...
    Massa, Harald ArminMassa, Harald Armin
    Sep 2, 2009 at 8:34 am
    Sep 2, 2009 at 2:46 pm
  • Where can I add a integer counter to count the plans considered by planner. In my opinion, it is in the src/backend/optimizer/path directorty.
    纪晓曦纪晓曦
    Sep 30, 2009 at 9:08 am
    Oct 13, 2009 at 2:19 am
  • Hi! What I'm trying to do is to insert some data from a sql file into a postgres DB by calling the <sql ant task. My problem is that I can't get special characters (even if they can be represented by ...
    AgostonbejoAgostonbejo
    Sep 22, 2009 at 10:10 am
    Oct 5, 2009 at 11:12 am
  • Hello List, I've run into some weirdness in PSQL 8.3.8 (Ubuntu 8.04 LTS x86_64 package). When I update a row while using a function result that updates that very same row in the "WHERE" part of the ...
    Thomas JacobThomas Jacob
    Sep 30, 2009 at 1:47 pm
    Sep 30, 2009 at 4:31 pm
  • Hi, I'm trying to write an INSERT INTO statement that will use a DEFAULT value when an input parameter is null. Here's the function that fails to compile. I tried replacing Coalesce with a Case ...
    Postgres UserPostgres User
    Sep 29, 2009 at 6:25 am
    Sep 29, 2009 at 2:15 pm
  • Hi, Is it possible to create a function using 'SQL' as language which could return multiple rowsets, such as "SELECT * FROM TABLE1; SELECT * FROM TABLE2;" where both results are returned in the ...
    Thom BrownThom Brown
    Sep 28, 2009 at 4:50 pm
    Sep 29, 2009 at 12:49 pm
  • I have two tables that are georeferenced (although in this case I'm not using PostGIS) that I need to join. A ( lat | lon | depth | value) A is a special case because the lat / lon values are all at ...
    Christopher ConditChristopher Condit
    Sep 3, 2009 at 9:28 pm
    Sep 10, 2009 at 5:40 pm
  • Hi all, Running Postgres 8.4 on Ubuntu 9.04, installed via the clickonce installer. I'm getting a curious error when trying to create/add support for plperl to any database: ERROR: could not load ...
    Shakil ShaikhShakil Shaikh
    Sep 3, 2009 at 6:12 pm
    Sep 7, 2009 at 2:16 pm
  • Hi All, I have a trivial task. There is a table with messages queue, let's say "msg_queue". There are a few processes and each of them is taking one message from this table at a time to transmit into ...
    NickolayNickolay
    Sep 3, 2009 at 8:05 am
    Sep 5, 2009 at 8:14 pm
  • I am inserting 250 rows of data (~2kbytes/row) every 5 seconds into a table (the primary key is a big serial). I need to be able to limit the size of the table to prevent filling up the disk. Is ...
    Dave HuberDave Huber
    Sep 30, 2009 at 2:59 pm
    Oct 10, 2009 at 10:12 am
  • Hello, we are facing strange situation with exclusively locked table during normal lazy vacuum. There is one big table (66GB) that is heavily inserted and updated in our database. Suddenly (after ...
    Jaromír TalířJaromír Talíř
    Sep 23, 2009 at 10:12 pm
    Sep 29, 2009 at 12:55 pm
Sep 2009
123456
Group Navigation
period‹ prev | Sep 2009 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions257
posts1,234
users301
websitepostgresql.org
irc#postgresql

301 users for September 2009

Tom Lane: 107 posts Scott Marlowe: 62 posts Sam Mason: 54 posts Mmoncure: 27 posts John R Pierce: 24 posts Martin Gainty: 23 posts Alvaro Herrera: 19 posts David Fetter: 18 posts Devrim Gündüz: 16 posts Grzegorz Jaśkiewicz: 15 posts InterRob: 15 posts Pavel Stehule: 15 posts Richard Huxton: 15 posts Adrian Klaver: 14 posts Raymond O'Donnell: 14 posts 纪晓曦: 14 posts Alban Hertroys: 13 posts Andreas Kretschmer: 13 posts Bill Moran: 13 posts Ricky Tompu Breaky: 12 posts
show more
Archives