FAQ

Search Discussions

217 discussions - 1,114 posts

  • Hi, I had to implement a logging system for some DBs in work. It's generic and implemented using plperl. I've seen tons of mails on the list from newbies asking for something like this using plpgsql, ...
    Diego Augusto MolinaDiego Augusto Molina
    Sep 26, 2011 at 11:39 pm
    Oct 10, 2011 at 9:03 pm
  • Hi. I propose to add "accumulative" flag to a function definition. This flag would be set for function f(x) which is accumulative and immutable. This flag allows to use an index on x for clauses ...
    Pasman PasmańskiPasman Pasmański
    Sep 25, 2011 at 1:27 pm
    Sep 27, 2011 at 8:55 pm
  • Hi follk i trying to performe a conditional insert into a table, indeed, what i'm trying to do is not insert a record into the table if that record exist googleling i found something like insert into ...
    Pau Marc Muñoz TorresPau Marc Muñoz Torres
    Sep 5, 2011 at 9:39 am
    Sep 8, 2011 at 3:12 pm
  • Dear experts, I have the following query: select * from notafiscal where numeroctc like ‘POA%34345’; Prefix is normally 3 characters, suffix varyies. Is Postgresql 9.0.4 able to use an BTREE index on ...
    Edson Carlos Ericksson RichterEdson Carlos Ericksson Richter
    Sep 26, 2011 at 12:23 pm
    Sep 27, 2011 at 1:59 pm
  • Hi, I have one large table (about a million entries) with an indexed column containing codes like ABC3561A, ABC3563X, 72-451-823 etc. (lots of order numbers from different manufacturers) When I ask ...
    Hamann WHamann W
    Sep 21, 2011 at 4:00 pm
    Sep 26, 2011 at 5:02 pm
  • ~ I have been searching for a PostgreSQL-derived project with a "less-is-best" Philosophy. Even though I have read about quite a bit of PG forks out there, what I have in mind is more like a baseline ...
    Albretch MuellerAlbretch Mueller
    Sep 25, 2011 at 3:01 am
    Sep 26, 2011 at 5:55 am
  • The .sql file produced by pg_dump is properly terminated with '\.' as the last line, yet I continue to encounter this error: ERROR: invalid input syntax for type real: " " CONTEXT: COPY chemistry, ...
    Rich ShepardRich Shepard
    Sep 15, 2011 at 5:31 pm
    Sep 17, 2011 at 2:33 pm
  • I would like to change my server_encoding which is currently SQL_ASCII to UTF8. I have existing data that I would like to keep. From my understanding of the steps I need to: 1) alter the template1 ...
    Cody CaughlanCody Caughlan
    Sep 30, 2011 at 5:25 pm
    Oct 2, 2011 at 2:39 am
  • http://www.postgresql.org/docs/9.1/static/release-9-1.html contains the line: "Release Date: 2011-09-12" *bounces excitedly* Has the release candidate gone final today? -Toby
    Toby CorkindaleToby Corkindale
    Sep 12, 2011 at 8:29 am
    Sep 14, 2011 at 1:55 am
  • Hi, I am trying to migrate a very small MS SQL Server Database (with 200 records max, 20 tables, 10 stored procedures) to PostgreSQL. I tried browsing through internet to find technical steps but I ...
    Mamatha_kagathi_chanMamatha_kagathi_chan
    Sep 6, 2011 at 12:57 pm
    Dec 8, 2011 at 6:10 am
  • I saw a thread where somebody saw icacls.exe being called by the one-click installer. I'm having the same thing - the installer has been running for 45 minutes now and is basically going to have to ...
    Karl WrightKarl Wright
    Sep 30, 2011 at 1:34 pm
    Oct 21, 2011 at 5:57 am
  • My application uses a bytea column to store some fairly large binary values (hundreds of megabytes). Recently I've run into a problem as my values start to approach the 1GB limit on field size: When ...
    David NorthDavid North
    Sep 27, 2011 at 5:01 pm
    Oct 1, 2011 at 8:15 pm
  • Is there a way to get an md5 or other hash of an entire table? I want to be able to easily compare 2 tables in different databases. I thought about using dblink and the EXCEPT query, but then I need ...
    Sim ZacksSim Zacks
    Sep 1, 2011 at 8:48 am
    Sep 4, 2011 at 5:45 am
  • Using pg_dump from the command line with the exe included in windows 32 bit install in postgresql 9.1. pg_dump -U username -f somefile.sql.gz -Z 9 -i dbname outputs a file that is in plain text. In ...
    Roger NiederlandRoger Niederland
    Sep 23, 2011 at 6:04 am
    Sep 25, 2011 at 5:43 pm
  • Rather than writing an application right now to enter data into a table I thought of trying LibreOffice as a front end. But, it doesn't seem to work as OO.o did. This leads to two questions: 1) Can ...
    Rich ShepardRich Shepard
    Sep 26, 2011 at 6:46 pm
    Sep 30, 2011 at 2:13 pm
  • Hi folks, I'm planning to set up streaming replication from one master to one slave. I've read at http://www.postgresql.org/docs/9.1/static/warm-standby.html that the "hardware architecture" of both ...
    Hannes ErvenHannes Erven
    Sep 20, 2011 at 8:26 pm
    Sep 23, 2011 at 2:44 pm
  • So I used to think materialized views in Postgres would be an awesome feature. That is until I had to endure the hell hole which is Oracle's implementation.. what a complete joke.. did MS SQL's ...
    Mike ChristensenMike Christensen
    Sep 21, 2011 at 8:23 pm
    Sep 23, 2011 at 5:49 pm
  • hello all, i would like your advice in the following matter. If i am not wrong, by implementing a warm standby (pg 8.4) the wal archives are being sent to the fail over server and when the time comes ...
    MirrorXMirrorX
    Sep 5, 2011 at 1:55 pm
    Sep 19, 2011 at 5:11 am
  • Hi Tom, I have analyzed your reply thoroughly in my implementation, but unfortunately either I make something wrong with the configuration or it does not work like described in the doc. When I put ...
    AsiaAsia
    Sep 5, 2011 at 12:27 pm
    Sep 7, 2011 at 4:37 pm
  • Is is possible within a stored procedure to read all the tables in a schema into a list? From that list and for each table is it possible to find the foreign keys in that table? From that list of ...
    J.V.J.V.
    Sep 29, 2011 at 1:34 am
    Sep 30, 2011 at 11:46 pm
  • Hi I want to add information to multiple columns (20 – 40) by employing a loop. Each pass of the loop will populate one column with an array. I have tried and I have read that variables can not be ...
    Bob PawleyBob Pawley
    Sep 1, 2011 at 2:52 pm
    Sep 2, 2011 at 8:52 pm
  • Hello Everyone, We have had situations where-in "rsync" was executed without executing "pg_start_backup()" on the production data directory and on the next runs, "pg_start_backup()" has been executed ...
    Venkat BalajiVenkat Balaji
    Sep 26, 2011 at 11:49 am
    Oct 24, 2011 at 4:14 pm
  • I am baffled. Both PDT and WEST appear as valid timezone abbreviations, and each have unique values, but: test=# select timestamp with time zone '2011-09-29 18:00 PDT'; timestamptz ...
    Christophe PettusChristophe Pettus
    Sep 29, 2011 at 5:26 pm
    Sep 29, 2011 at 8:15 pm
  • Hi, I tried to install 9.1 on a Windows7 64bit machine but the installation hangs during the initdb process. Looking at the taskmanager I could see that the installer script was waiting for ...
    Thomas KellererThomas Kellerer
    Sep 12, 2011 at 3:12 pm
    Sep 27, 2011 at 4:30 pm
  • I have a simple query that's been running for a while, which is fine, but it seems to be running very slowly, which is a problem: mydb=# explain select user_id from den where user_id not in (select ...
    Yang ZhangYang Zhang
    Sep 15, 2011 at 7:54 am
    Sep 15, 2011 at 11:02 pm
  • Thanks Danny
    Abraham, DannyAbraham, Danny
    Sep 22, 2011 at 7:56 am
    Sep 22, 2011 at 10:34 pm
  • Hi, Some months ago, I ran some (probably naive) benchmarks looking at how pgbench performed on an identical system with differing filesystems. (on Linux). Since then the kernel-level version of ZFS ...
    Toby CorkindaleToby Corkindale
    Sep 14, 2011 at 1:15 am
    Sep 19, 2011 at 12:38 am
  • I run this SELECT statement on a table: select distinct(site_id) from chemistry order by site_id; and in the returned set I see: GW-21 GW-22 GW-22 + GW-24 I want to find that row returning 'GW-22 +' ...
    Rich ShepardRich Shepard
    Sep 14, 2011 at 4:35 pm
    Sep 14, 2011 at 8:10 pm
  • Hi: If I have a table that has 2 records which are identical with regard to all their column values, is there a way to delete one of them, leaving one remaining? Is there some unique record_id key of ...
    Gauthier, DaveGauthier, Dave
    Sep 6, 2011 at 5:39 pm
    Sep 7, 2011 at 12:07 am
  • take any table and run Query --------------------- select 1/3 from storage limit 1 Result --------------------- ?column? integer Expected Result --------------------- ?column? double precision ...
    Henry DrexlerHenry Drexler
    Sep 9, 2011 at 2:42 pm
    Nov 13, 2012 at 7:12 am
  • Hi, Where I work, we have a large deployment of software using PostgreSQL database. We have been stuck on version 7.4.16 for a while now. I am about to switch us to a 9.0.x. One problem I'm running ...
    Patrick keshishianPatrick keshishian
    Sep 20, 2011 at 12:10 am
    Sep 20, 2011 at 7:22 pm
  • Hello, I'm pretty much brand new to using postgres and the privilege structure is taking some getting used to, especially when coming from mysql. What I'm trying to accomplish is to have multiple ...
    Darin PerusichDarin Perusich
    Sep 15, 2011 at 9:10 pm
    Sep 16, 2011 at 4:46 pm
  • Hi all, One of my entities 'E' may be 'tagged' with an arbitrary set of 256 tags 'T'. A first approach could be to add a M:N relationship between 'E' and 'T'. A second way to do this could be to add ...
    Antonio VieiroAntonio Vieiro
    Sep 14, 2011 at 10:07 am
    Sep 15, 2011 at 2:15 pm
  • Could someone point me in the right direction.. Thanks - reid Given the example data, how do I write a query that will give me the resultset: 1 2011-01-01 2 2011-01-06 3 2011-01-05 4 2011-01-09 5 ...
    Reid ThompsonReid Thompson
    Sep 13, 2011 at 12:54 am
    Sep 14, 2011 at 2:52 am
  • We moved to PostgreSQL about 2 years ago and have been very happy with it overall. The only major issue that we've had is intermittent index corruption. This manifests itself as either "duplicate key ...
    Dylan AdamsDylan Adams
    Sep 12, 2011 at 2:05 pm
    Sep 12, 2011 at 10:27 pm
  • Hi, would it be possible to implement a *nowait *modifier to the *update*statement in order to tell it not to wait and raise an error -just like a select for update nowait would-, instead of ...
    Eduardo PiombinoEduardo Piombino
    Sep 8, 2011 at 9:02 am
    Sep 8, 2011 at 10:13 pm
  • Hello, I have two large tables in a database, one containing original data and the other one derived from the first table. The first table contains several columns and indexes, while the second table ...
    Rik BellensRik Bellens
    Sep 1, 2011 at 10:41 am
    Sep 1, 2011 at 5:00 pm
  • hello all, i have a centos 5.3 which has postgres 8.4.4 installed from the repos. I want to upgrade to 8.4.8 but when i try to install the .bin file of 8.4.8 then it's a new installation and when i ...
    MirrorXMirrorX
    Sep 20, 2011 at 2:30 pm
    Sep 26, 2011 at 3:28 pm
  • I am trying to connect to a workstation running postgres from another computer on the network. I have postgres installed on both machines. When I go to connect to the workstation, everything appears ...
    Jeff AdamsJeff Adams
    Sep 15, 2011 at 5:30 pm
    Sep 16, 2011 at 12:55 pm
  • So here's the thing. I got a message from one of the developers, that running 'create temporary sequence xyz;' hangs on the database. That seemed suspicious. I tried running any ddl command, and that ...
    Grzegorz JaśkiewiczGrzegorz Jaśkiewicz
    Sep 12, 2011 at 2:01 pm
    Sep 14, 2011 at 1:29 am
  • I'm doing an UPDATE something like this: UPDATE slots SET a = 'a' ,b = (SELECT uuid_generate_v1()) WHERE c = TRUE; Each updated row in slots is getting the same value for b. Is there a way of getting ...
    Rory Campbell-LangeRory Campbell-Lange
    Sep 1, 2011 at 11:20 pm
    Sep 6, 2011 at 2:18 pm
  • Respected All, In which case $PGDATA/base/database-oid/PG_VERSION file updates ? I have observed, PG_VERSION file is created at DB creation time and will never get updated. I mean file PG_VERSION ...
    RaghavendraRaghavendra
    Sep 24, 2011 at 7:34 pm
    Oct 7, 2011 at 2:05 pm
  • Dear all, I googled a lot and find data of all countries , cities , location etc from Geo Spatial websites but I am able to find the data that shows all *states & their respective capitals* in world. ...
    Adarsh SharmaAdarsh Sharma
    Sep 27, 2011 at 6:57 am
    Sep 28, 2011 at 8:31 am
  • body p { margin-bottom: 10pt; margin-top: 0pt; } Hi, everyone. I'm working with someone who has a database application currently running under PostgreSQL 8.3.� Among other things, there is a main ...
    Reuven M. LernerReuven M. Lerner
    Sep 22, 2011 at 12:36 pm
    Sep 25, 2011 at 9:53 am
  • Hi, I understand random() is a volatile function and runs multiple times for multiple rows returned by a SELECT, however is there a way of getting it to run multiple times *within* another function ...
    Oliver KohllOliver Kohll
    Sep 21, 2011 at 8:51 am
    Sep 22, 2011 at 11:43 am
  • I am occasionally getting this kind of error when attempting a SELECT statement. PGError: ERROR: missing chunk number 0 for toast value 27143 in pg_toast_2619 What does this mean? Is some sort of ...
    Tim UckunTim Uckun
    Sep 19, 2011 at 11:03 am
    Sep 20, 2011 at 12:07 am
  • Dear all, Today I need some part ( subset ) of some tables to another database to a remote server. I need to take backup of tables after satisfying a select query. Is there any option to specify ...
    Adarsh SharmaAdarsh Sharma
    Sep 12, 2011 at 5:02 am
    Sep 15, 2011 at 2:03 pm
  • Hi, What is the correct way to tell what mode a replicated Pg server is currently in, via a database connection? I can take a guess if it's the master or a slave by using the ...
    Toby CorkindaleToby Corkindale
    Sep 12, 2011 at 6:54 am
    Sep 12, 2011 at 8:34 am
  • I have a function wrapping a (fairly complex) query. The query itself runs in about a 1/3rd of a second. When running the query as a 'RETURN QUERY' function on Postgres 8.4, the function runs in over ...
    Rory Campbell-LangeRory Campbell-Lange
    Sep 5, 2011 at 9:08 pm
    Sep 6, 2011 at 3:11 pm
  • I just updated a table to have a larger column size as follows. alter table attributes_log alter column attribute_name type varchar(48); The size was previously 24. iddb= \d attributes Table ...
    Ron PetersonRon Peterson
    Sep 5, 2011 at 6:41 pm
    Sep 5, 2011 at 9:01 pm
Group Navigation
period‹ prev | Sep 2011 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions217
posts1,114
users238
websitepostgresql.org
irc#postgresql

238 users for September 2011

Tom Lane: 54 posts Merlin Moncure: 44 posts John R Pierce: 30 posts Rich Shepard: 29 posts Adrian Klaver: 27 posts Craig Ringer: 27 posts Pasman Pasmański: 27 posts Scott Marlowe: 27 posts Alban Hertroys: 20 posts Marti Raudsepp: 19 posts Edson Carlos Ericksson Richter: 18 posts Grzegorz Jaśkiewicz: 17 posts Guillaume Lelarge: 17 posts Venkat Balaji: 16 posts David Johnston: 15 posts Sim Zacks: 15 posts Albe Laurenz: 14 posts Toby Corkindale: 13 posts Andy Colson: 12 posts MirrorX: 12 posts
show more
Archives