FAQ

PostgreSQL > pgsql-general > June 2012

Search Discussions

149 discussions - 733 posts

  • Hi all I've been working in psql a lot recently, and have started to wonder why statements with syntax errors or other problems that render them unexecutable terminate the transaction. I understand ...
    Craig RingerCraig Ringer
    Jun 19, 2012 at 2:33 am
    Jun 25, 2012 at 1:48 am
  • I need to create c language in the postgresql database. I only know to create as follows. Create language c ; Is there anything else I need to do before I create the C language? Thanks. Regards ...
    Leaf_yxjLeaf_yxj
    Jun 12, 2012 at 4:54 pm
    Jun 20, 2012 at 5:55 pm
  • Hi, I am running PostgreSQL 9.1 currently and I want to run 9.2beta2 simultaneously with it.Is it possible? I downloaded the 9.2beta2 sources,untared them and ran ./configure,make and make install ...
    Atri SharmaAtri Sharma
    Jun 29, 2012 at 8:17 am
    Jun 29, 2012 at 2:04 pm
  • I am doing Oracle to PostgreSQL migration activity as part of Procedure Migration in Oracle there are *OUT parameters which return records(using bulk collect) of custom type.* *like function returing ...
    UtsavUtsav
    Jun 14, 2012 at 6:11 am
    Jun 27, 2012 at 5:39 pm
  • Hello ppl, I read in internet and in this mailing list, when some one asking about load balance, most of the answers is: pgpool. I want to asking how stable is pgpool ? How much query can handle ? ...
    CondorCondor
    Jun 7, 2012 at 2:26 pm
    Jun 13, 2012 at 5:50 am
  • Hi there, I guess this is a typical user error. I searched around to find the solution, but in vain. I just upgraded to Lion, and used Kyngchaos libraries for installation of Postgres. Try to get ...
    Stefan SchwarzerStefan Schwarzer
    Jun 14, 2012 at 1:30 pm
    Jun 25, 2012 at 1:52 pm
  • We have an old postgres installation (8.3) running on windows 2003 The server run perfect for many years but today it crash L We have a very old backup so I'll try desperate to repair. If I can't ...
    Anibal David AcostaAnibal David Acosta
    Jun 25, 2012 at 2:54 am
    Jun 25, 2012 at 1:36 pm
  • Hi all I'm curious how is wildcards at both ends implemented, e.g. LIKE '%str%' How efficient is it if that's the only search criteria against a large table? how much does indexing the column help ...
    Sam Z JSam Z J
    Jun 20, 2012 at 5:10 pm
    Jun 24, 2012 at 2:04 am
  • Hi, Is the following postgres function correct? CREATE OR REPLACE FUNCTION "MyFun"("IdArgs" INTEGER) RETURNS SETOF "B" AS $BODY$ CREATE VIEW "A" AS SELECT * FROM "B" WHERE "Id" = $1; SELECT * FROM ...
    Divyaprakash YDivyaprakash Y
    Jun 13, 2012 at 5:32 am
    Jun 13, 2012 at 5:41 pm
  • Howdy, When calculating Replication lag, I know that we have to compare the pg_current_xlog_location to pg_last_xlog_receive_location, etc. but what I'm trying to figure out is what are the units ...
    David KerrDavid Kerr
    Jun 25, 2012 at 8:17 pm
    Jun 26, 2012 at 4:20 pm
  • Hello, I new on this mailing list and I need a little bit help for an idea to create different accesses to a database with Postgres 9.1. I'm using this PG version at the time and I have created a ...
    Kraus PhilippKraus Philipp
    Jun 5, 2012 at 11:13 pm
    Jun 7, 2012 at 8:18 pm
  • Hi all, Just a note that the 32 and 64-bit installers fail on windows 7 64-bit with the error 'An error occurred executing the Microsoft VC++ runtime installer.'. The beta-1 32-bit installer works ...
    Marc WatsonMarc Watson
    Jun 7, 2012 at 2:00 pm
    Aug 15, 2012 at 5:47 pm
  • Hi In first sorry for my english :) I have got a problem with notify/listener. I do a function which returns a trigger. Everything is ok but when i want send in a second parameter a variable NOTIFY ...
    Adasko98Adasko98
    Jun 29, 2012 at 8:01 am
    Jul 3, 2012 at 12:44 pm
  • Hello and thank you for reading my post. My problem is that I do not manage to start a PostgreSQL cluster as a Windows service. The OS is WinXP. - I've created a PostgreSQL cluster "a_pgcluster" with ...
    Léa MassiotLéa Massiot
    Jun 15, 2012 at 1:26 pm
    Jun 29, 2012 at 9:47 am
  • Hi there, I upgraded my machine from Snow Leopard to Lion, and ran, as usual, into some Postgres update problems. I used Kyngchaos libraries for all frameworks and Postgres. Now, I'd like to install ...
    Stefan SchwarzerStefan Schwarzer
    Jun 12, 2012 at 12:21 pm
    Jun 22, 2012 at 7:20 am
  • Hi All, When I'm developing against a PostgreSQL database I often drop and re-create it and I often find that the drop fails, because it's "in use by other users". This is really annoying, especially ...
    Evan MartinEvan Martin
    Jun 19, 2012 at 9:40 am
    Jun 21, 2012 at 2:50 pm
  • Hi folks, I've got an issue I'm not sure I might have a misunderstanding. When calling select sum(pg_database_size(datid)) as total_size from pg_stat_database the result is much bigger than running a ...
    Frank LanitzFrank Lanitz
    Jun 6, 2012 at 2:34 pm
    Jun 7, 2012 at 8:02 pm
  • I've a plan that will need a complex database infra-structure using PostgreSQL 9.1. I've seen similar setups using MS SQL Server and other databases, but all of them support cross database queries ...
    Edson RichterEdson Richter
    Jun 30, 2012 at 2:26 pm
    Jul 1, 2012 at 11:01 pm
  • Hi All my configuration: (-) postgres 9.1 (-) windows 2003 (-) 4 Xeon CPUs (-) 16GB of RAM I'm getting a lot of errors in my postgres log file: ------------------------------- 2012-06-19 09:31:06 ...
    PandorinoPandorino
    Jun 19, 2012 at 7:58 am
    Jun 26, 2012 at 1:37 am
  • Hello, I read through the Postgres doc and many Google results, but it seems still unclear to me how to include additional packages into my postgres database. I see that there are a few installed ...
    Stefan SchwarzerStefan Schwarzer
    Jun 18, 2012 at 2:29 pm
    Jun 21, 2012 at 7:42 am
  • I've read the documentation for extensions and how their data is not normally dumped by pg_dump and how to configure the table so it should dump its data ...
    Keith FiskeKeith Fiske
    Jun 8, 2012 at 4:12 pm
    Jun 12, 2012 at 12:52 am
  • How to return single row or results from code block executed using ADO.NET ExecuteQuery() method. I tried DO $$ declare i integer :=0; begin select i+1 as res1, i+2 as res2; END$$; but got error ...
    AndrusAndrus
    Jun 30, 2012 at 10:18 am
    Jul 1, 2012 at 3:12 am
  • Is anyone aware of other non-trigger-based, fine-grained replication tools for PostgreSQL along the lines of the XReader <http://wiki.postgresql.org/wiki/XReader or pgreplay ...
    Paul JonesPaul Jones
    Jun 18, 2012 at 9:49 pm
    Jun 19, 2012 at 5:10 pm
  • Hi In 9.1.3, this is fast, handled with a tid scan using the physical address: SELECT ... FROM ... WHERE ctid = ...; This is slow, handled with a seq scan (as are various rephrasing with <, <=, ...
    Thomas MunroThomas Munro
    Jun 8, 2012 at 9:28 pm
    Jun 13, 2012 at 9:00 pm
  • Hey! I have a simple setup with one master and one backup server. I have an issue where I have performed a backup and copied it to the data directory for the slave, written a recovery.conf and copied ...
    Alex GoodAlex Good
    Jun 12, 2012 at 4:34 pm
    Jun 13, 2012 at 10:17 am
  • Hi, I have a database in SQL_ASCII Encoding format from Postgresql-7.4.19. I have migrated to Postgresql-8.4.9 and to UTF-8 and want to restore this database in UTF-8 encoding. I am facing problem in ...
    Manoj AgarwalManoj Agarwal
    Jun 6, 2012 at 11:29 am
    Jun 8, 2012 at 9:30 am
  • Hi - I'm trying to increase my general knowledge about how indexes work in databases. Though my questions are probably general and implemented in a similar way across major relational DBs, I'm also ...
    Mike ChristensenMike Christensen
    Jun 5, 2012 at 10:24 pm
    Jun 6, 2012 at 2:06 pm
  • I want to combine columns in two tables and use the exported resulting table for statistical analyses. The SQL script is: INSERT INTO waterchem (site, sampdate, param, quant, ceneq1, low, high, ...
    Rich ShepardRich Shepard
    Jun 5, 2012 at 10:51 pm
    Jun 6, 2012 at 5:20 am
  • Hello, So we've been reviewing our processes and working on improving them. One area we've been lacking is a procedure to version control our database functions, table changes, static data etc. I'm ...
    Bryan MontgomeryBryan Montgomery
    Jun 1, 2012 at 3:29 pm
    Jun 4, 2012 at 9:19 am
  • Hello, is there any possibility to convert special columns during an CSV import via COPY? For example: HELLO;WORLD;9999;011001 9999 should be converted to a character field 011001 to the date 10th ...
    Patrick SchneiderPatrick Schneider
    Jun 29, 2012 at 7:54 am
    Jul 1, 2012 at 8:01 am
  • Hi, I have met some strange situation... Could someone explain difference between LEFT and RIGHT JOIN? I thought it is just from whitch side we are looking in JOIN columns part... but it seems that ...
    Misa SimicMisa Simic
    Jun 29, 2012 at 9:36 pm
    Jun 29, 2012 at 10:37 pm
  • Hi, I have to create a script which imports csv data into postgresql ...and have a few questions about the best way to do it. The csv data is automatically created from an external database so I have ...
    Robert BuckleyRobert Buckley
    Jun 28, 2012 at 11:53 am
    Jun 29, 2012 at 3:02 am
  • I am sure this is intended behavior but it seems odd (and inconvenient) to me. create database tim_test_copy template tim_test ERROR: source database "tim_test" is being accessed by other users ...
    Tim UckunTim Uckun
    Jun 28, 2012 at 3:11 am
    Jun 28, 2012 at 4:22 pm
  • Good morning, Is there a simply method in psql to format a string? For example, adding a space to every three consecutive letters: abcdefgh - *** *** *** Thanks a lot! Emi
    Emi LuEmi Lu
    Jun 20, 2012 at 2:43 pm
    Jun 20, 2012 at 8:16 pm
  • My customer has 3 computers. The PostgreSQL service could be running on either of two of them. There is currently no way in our system to determine which one it is running on. The third computer ...
    Rob RichardsonRob Richardson
    Jun 14, 2012 at 4:29 am
    Jun 20, 2012 at 6:58 am
  • hi there, I am trying to import large data files into pg. for now i used the. xarg linux command to spawn the file line for line and set and use the maximum available connections. we use pg pool as ...
    HbHb
    Jun 16, 2012 at 3:05 pm
    Jun 16, 2012 at 6:16 pm
  • I'm trying to upgrade Postgres 9.0 to 9.1 with pg_upgrade. Both versions are installed from the PGDG Yum repo: -bash-4.1$ /usr/pgsql-9.0/bin/postgres -V postgres (PostgreSQL) 9.0.8 -bash-4.1$ ...
    Evan D. HoffmanEvan D. Hoffman
    Jun 13, 2012 at 3:19 pm
    Jun 16, 2012 at 12:02 am
  • Hi. I had this piece of SQL, which ran fine on my 9.1 installation: INSERT INTO foo SELECT ..., CASE WHEN NOT allow_output_screen THEN array['O_SCREEN'] ELSE array[]::varchar[] END ELSE ...
    Ken TanzerKen Tanzer
    Jun 14, 2012 at 7:47 pm
    Jun 15, 2012 at 4:29 pm
  • Hello fello PostgreSQL users, with PHP 5.3.3 and PostgreSQL 8.4.11 (and a pgbouncer, but I've tried without it too) I'm trying to execute several SQL queries with 2 temp tables (listed below) and ...
    Alexander FarberAlexander Farber
    Jun 13, 2012 at 1:12 pm
    Jun 15, 2012 at 2:41 pm
  • Hi, I have a column declared as array of text. I can get a single backslash into one of the array elements by update ... set mycol[1] = E'blah \\here' If I try to update the whole array update .. ...
    Hamann WHamann W
    Jun 14, 2012 at 8:17 am
    Jun 14, 2012 at 12:49 pm
  • Dear all I have to import and watch/edit data stored in an .backup-file. This is a backup-file, stored by an other firm. My problem is, I am new at Postgres and it is the first time I have to work ...
    Gipsy-king1Gipsy-king1
    Jun 11, 2012 at 8:42 am
    Jun 13, 2012 at 5:16 am
  • One table, waterchem, with primary key 'site' has columns easting and northing with no values in them. A second table, sites, with primary key 'name' has values for easting and northing for each ...
    Rich ShepardRich Shepard
    Jun 12, 2012 at 10:17 pm
    Jun 13, 2012 at 2:28 am
  • Hi All, We are having a problem with our streaming replication read only node. It has crashed a few times with a couple of different reasons, mostly "segmentation fault". The latest log are listed ...
    Benson JinBenson Jin
    Jun 11, 2012 at 3:35 am
    Jun 12, 2012 at 7:40 am
  • I have a postgres server I need to move onto a new OS (RHEL6) on a new VM and am looking for advice on how to partition the disks to gain some performance improvement. In the current environment I am ...
    Ben CarberyBen Carbery
    Jun 6, 2012 at 5:07 am
    Jun 11, 2012 at 2:41 am
  • Hi there. I am new to Postgresql but very familiar with RDBMS. We are running 8.4 on windows serer 2008 r2. I was updating a record through pgAdmin and was being an a$$ and pressed the run button ...
    DinsdaleDinsdale
    Jun 7, 2012 at 2:17 pm
    Jun 7, 2012 at 9:47 pm
  • Hi All, I am sure this question has been asked before, however, I failed to find any related topics in the internet. We have a database about 100GB in size. It was started back in 7.x days and has ...
    Benson JinBenson Jin
    Jun 6, 2012 at 4:20 pm
    Jun 7, 2012 at 8:15 pm
  • we are doing mgration activity form oracle to postgresql 9.1 How to convert this type : ORACLE : CREATE OR REPLACE TYPE "NUMBER_ARRAY" IS TABLE OF NUMBER please let me know how we can achive this in ...
    UtsavUtsav
    Jun 1, 2012 at 3:48 pm
    Jun 5, 2012 at 6:52 pm
  • Hi, Below link is not accessible under section 15.7.7.6 "Using Dtrace for Tracing PostgreSQL". Documentation Link: http://www.postgresql.org/docs/9.1/static/installation-platform-notes.html Not ...
    RaghavendraRaghavendra
    Jun 17, 2012 at 7:00 am
    Sep 2, 2012 at 1:16 pm
  • Hello I am using PostgreSQL 9.0.6 64 bit on Windows 2003 64bit. When i view Postgresql status, there are some autovaccum alway run. Ex VACUUM ANALYZE pg_catalog.pg_attribute. Is it problem of ...
    TuanhoanganhTuanhoanganh
    Jun 28, 2012 at 2:41 pm
    Jun 30, 2012 at 9:42 am
  • hi we are running out of database connections. we are using pg 9.0.6 on linux centos 5.7 64bit. we are not using any go-between connection pools such as pgbouncer or pgpool - connections occur ...
    Mark RostronMark Rostron
    Jun 19, 2012 at 4:29 pm
    Jun 25, 2012 at 11:08 pm
Jun 2012
123
Group Navigation
period‹ prev | Jun 2012 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions149
posts733
users211
websitepostgresql.org
irc#postgresql

211 users for June 2012

Tom Lane: 42 posts Craig Ringer: 32 posts Adrian Klaver: 19 posts Merlin Moncure: 19 posts Stefan Schwarzer: 19 posts John R Pierce: 18 posts Albe Laurenz: 17 posts Raghavendra: 17 posts Chris Travers: 16 posts Edson Richter: 16 posts Alban Hertroys: 15 posts Utsav: 13 posts David Johnston: 12 posts Jasen Betts: 12 posts Yxj: 11 posts Atri Sharma: 10 posts Steve Crawford: 10 posts Condor: 8 posts Jeff Davis: 8 posts Misa Simic: 8 posts
show more
Archives