FAQ

Search Discussions

158 discussions - 940 posts

  • No, it is not. Afilias did not buy UltraDNS. Neustar, who run .biz and .us, bought Ultra. Afilias does not use any Ultra servers in its systems, and hasn't since before I quit working for Afilias ...
    Andrew SullivanAndrew Sullivan
    Sep 1, 2012 at 3:54 am
    Sep 6, 2012 at 12:30 pm
  • It would be nice if PostgreSQL supported column aliases in WHERE clauses, eg: SELECT left(value, 1) AS first_letter FROM some_table WHERE first_letter 'a'; Is this the proper mailing list for such ...
    Daniel Serodio (lists)Daniel Serodio (lists)
    Sep 17, 2012 at 9:19 pm
    Sep 23, 2012 at 1:19 pm
  • Hi, My application have few binary fields that accept files. Most of them are XML files archived for reference only. I would like to know if there is any plan to implement compressed fields (just a ...
    Edson RichterEdson Richter
    Sep 10, 2012 at 6:13 pm
    Sep 17, 2012 at 2:10 pm
  • hi all How could i use crostab to display variable number of columns. in the output There could be variable number of columns Regards Punnoose -- View this message in context ...
    PunnoosePunnoose
    Sep 4, 2012 at 3:40 pm
    Sep 5, 2012 at 12:22 am
  • Hello the list, recently I'm cooking a database for an application, that I feel is best implemented with tables containing arrays. I have found some related info here ...
    Rafal PietrakRafal Pietrak
    Sep 17, 2012 at 8:46 am
    Sep 24, 2012 at 6:21 am
  • Hi, I have attempted to upgrade my Postgres installation this morning from 9.0.1 to 9.2.0 and it failed with an out of memory problem using pg_dumpall to dump the first database. So after backing out ...
    Carrington, Matthew (Produban)Carrington, Matthew (Produban)
    Sep 20, 2012 at 6:46 am
    Oct 1, 2012 at 6:53 pm
  • I am running Postgres 8.4.1 on Windows XP Professional Service Pack 3. My database is UTF8. I use psql -f to load files containing DDL and DML commands. I discovered a long time ago that psql does ...
    Alan MillingtonAlan Millington
    Sep 20, 2012 at 2:56 pm
    Sep 23, 2012 at 7:31 am
  • Hello, Tell me please, whether there is an official C++ API for postgresql? Thanks, -- Regards, niXman Dual-target(32 & 64 bit) MinGW compilers for 32 and 64 bit Windows ...
    niXmanniXman
    Sep 17, 2012 at 6:58 pm
    Sep 17, 2012 at 11:30 pm
  • Hi: The size of our database is growing rather rapidly. We're concerned about how well Postgres will scale for OLAP-style queries over terabytes of data. Googling around doesn't yield great results ...
    Ryan KellyRyan Kelly
    Sep 26, 2012 at 11:50 am
    Sep 28, 2012 at 2:18 am
  • Hi, I'm using and Amazon ec2 instance with the following spec and the application that I'm running uses a postgres DB 9.1. The app has 3 main cron jobs. *Ubuntu 12, High-Memory Extra Large Instance ...
    Shiran KleidermanShiran Kleiderman
    Sep 24, 2012 at 6:45 am
    Oct 15, 2012 at 3:27 am
  • Hi all, I would first like to thank everyone involved for all of the hard work that goes into the postgres and the RPMs.I have a small request: In the service script that gets installed to ...
    Kenaniah CernyKenaniah Cerny
    Sep 12, 2012 at 6:41 am
    Sep 12, 2012 at 10:46 pm
  • Hi all, somebody please explain what is packaging policy of plpython. Now I see plpython2u packaged in Fedora and RHEL repositories and plpython3u in Windows installer by EnterpriseDB. Why there is ...
    Gražvydas ValeikaGražvydas Valeika
    Sep 7, 2012 at 7:41 pm
    Sep 8, 2012 at 7:03 pm
  • Hi. We use LISTEN/NOTIFY quite a bit but today something unusual (bad) happened. Number of processes waiting for a lock just started to go up up up. I finally found the object being locked was ...
    Aleksey TsalolikhinAleksey Tsalolikhin
    Sep 5, 2012 at 1:22 am
    Sep 5, 2012 at 6:45 pm
  • Hi, I am trying to loop through the records in a table and update a column. I can do this with a case statement but I would like to simplify this to a simple loop statement. I can´t seem to work out ...
    Robert BuckleyRobert Buckley
    Sep 3, 2012 at 3:30 pm
    Sep 3, 2012 at 6:42 pm
  • I have a database export done via copy. It's all the tables, contraints, blah blah. I know (a couple of years ago) that I just used the defaults. REALLY fast btw, I remember. All the table create ...
    Dennis GearonDennis Gearon
    Sep 27, 2012 at 2:41 am
    Sep 29, 2012 at 12:01 pm
  • I have searched and searched and just cannot find the maximum lengths for input variables in a function i.e. CREATE FUNCTION test(input1 char(5), input2 varchar(50)) RETURNS void AS $$RAISE ...
    Jam3Jam3
    Sep 5, 2012 at 3:40 pm
    Sep 5, 2012 at 9:41 pm
  • Hi everyone, I have a problem that I've been struggling with for quite some time. Every once in a while I will get a connection that goes to idle in transaction on an in-house programmed application ...
    Scot KreienkampScot Kreienkamp
    Sep 25, 2012 at 7:23 pm
    Sep 27, 2012 at 10:21 am
  • Why do I have holes in my pages? Postgres 8.4.12 "select ctid from big_table" on my master shows that pages have "holes" in them. Here is example for page 431665: (431665,2) (431665,5) (431665,8) ...
    Aleksey TsalolikhinAleksey Tsalolikhin
    Sep 20, 2012 at 7:21 pm
    Sep 22, 2012 at 12:48 am
  • Hi All,I am new to postgresql. I want to send email by using pl pgsql. I want to know how to set up the configurations for mail server.Can any one help me in solving this?. <span ...
    PavithraPavithra
    Sep 20, 2012 at 12:07 pm
    Sep 20, 2012 at 1:53 pm
  • Is there something that can be done smarter with this error message? pg_dump: dumping contents of table pages pg_dump: [tar archiver] archive member too large for tar format pg_dump: *** aborted ...
    Mike ChristensenMike Christensen
    Sep 11, 2012 at 12:28 am
    Sep 17, 2012 at 1:31 pm
  • I have some code which creates a function in Postgres, taken from http://wiki.postgresql.org/wiki/Array_agg . DROP AGGREGATE IF EXISTS array_agg(anyelement); CREATE AGGREGATE array_agg(anyelement) ( ...
    Robert JamesRobert James
    Sep 24, 2012 at 1:32 pm
    Sep 29, 2012 at 12:31 pm
  • Hi, I compiled PostgreSql 9.1 from sources in a OpenSuse 10.1 PowerPC machine. While trying to test one application, I've got errors just before connecting to the database, and found my app is ...
    Leonardo M. RaméLeonardo M. Ramé
    Sep 26, 2012 at 11:46 pm
    Sep 27, 2012 at 2:31 pm
  • Hello and namaste I am in a project that uses PostGresSql v9.0. We are developing an application in CSharp to parse the PG server activity log installed on Windows 2003/XP or higher. Our application ...
    Arvind SinghArvind Singh
    Sep 10, 2012 at 6:19 am
    Sep 21, 2012 at 10:17 am
  • I'm looking for an article that explains the difference between these constructs IN POSTGRESQL (the rules seem to differ from one DB to another) : SELECT A.* FROM A JOIN B ON a.id=b.id AND ...
    Jean-Christophe BoggioJean-Christophe Boggio
    Sep 19, 2012 at 12:21 am
    Sep 20, 2012 at 12:02 am
  • Hello, I have a column defined as test bigint[] I would like to add a constraint on this column: the values stored must be between 0 and 1023 inclusive I know how to add a constraint on a column ...
    VdgVdg
    Sep 8, 2012 at 2:27 pm
    Sep 9, 2012 at 5:31 pm
  • Dear list, _*Scenario:*_ I'm using PostgreSQL 9.1 on Linux x64 running over CentOS 5. Everything is fine, but now I do have 4 separate databases running on different servers, and every server has ...
    Edson RichterEdson Richter
    Sep 5, 2012 at 6:30 pm
    Sep 7, 2012 at 7:36 pm
  • I have a table which currently has about 500 million rows. For the most part, the situation is going to be that I will import a few hundred million more rows from text files once every few months but ...
    Aram FingalAram Fingal
    Sep 6, 2012 at 9:22 pm
    Sep 7, 2012 at 7:06 pm
  • We have tables which we archive and shorten every day. That is - the main table that has daily inserts and updates is kept small, and there is a parallel table with all the old data up to a year ...
    Herouth MaozHerouth Maoz
    Sep 9, 2012 at 9:25 am
    Sep 19, 2012 at 11:26 am
  • Hi all, Using centos 5.x I'm trying to upgrade (without having to dump/restore a 1.5TB db) from 9.0 to 9.2 using pg_upgrade, but am having a few issues. 1. I ran into the (usual?) issue with ld ...
    Henry C.Henry C.
    Sep 12, 2012 at 6:13 pm
    Sep 13, 2012 at 10:20 pm
  • I want to have a pivot like function in which i should have variable number of columns.i went for crosstab but it doesnot support variable number of columns.Can any body suggest an alternative.like ...
    PunnoosePunnoose
    Sep 6, 2012 at 5:14 am
    Sep 7, 2012 at 8:11 pm
  • Guessing this form effectively evaluates to WHEN sum(foo) = NULL instead of IS NULL and thus the wrong answer: Yes. That said you might want to try SUM(COALESCE(foo, 0)) or SUM(case when foo is null ...
    David JohnstonDavid Johnston
    Sep 1, 2012 at 12:39 am
    Sep 2, 2012 at 11:41 am
  • Hi All, I am a beginner in Postgresql and Databases. I have a requirement that reclaiming disk space by deleting the rows in a selected time span. I went through the documents and articles to know ...
    Yelai, Ramkumar IN BLR STSYelai, Ramkumar IN BLR STS
    Sep 13, 2012 at 1:34 pm
    Sep 28, 2012 at 8:08 am
  • Hey Everyone, I seem to be getting an inaccurate cost from explain. Here are two examples for one query with two different query plans: exchange_prod=# set enable_nestloop = on; SET exchange_prod=# ...
    Robert SosinskiRobert Sosinski
    Sep 26, 2012 at 6:38 pm
    Sep 27, 2012 at 10:48 am
  • Good afternoon, When accessing PostgreSQL via psql, is it possible to make use of a custom prompt? I would like something like postgres=# instead of just postgres=#. My search was fruitless (see next ...
    CraigCraig
    Sep 24, 2012 at 6:20 pm
    Sep 25, 2012 at 2:50 pm
  • Hello, I have two postgresql servers 9.1.5 and 8.4.8 running on ubuntu machine, both are fresh installs and both has the same configuration files and databases. I am running queries sequentially on ...
    Salah jubehSalah jubeh
    Sep 21, 2012 at 2:32 pm
    Sep 24, 2012 at 12:53 pm
  • I'm testing my second PostgreSQL install on Xunutu 12.04 after a disk crash. Everything went well using command line where i was able, after config and setup, to log into a db using : $ psql <IPV4 or ...
    Yvon ThoravalYvon Thoraval
    Sep 17, 2012 at 6:15 am
    Sep 23, 2012 at 2:03 am
  • Has there been any discussion regarding adding a time-limited version of NOWAIT, say: "WAITONLY 50" (milliseconds), when dealing the explicit LOCK TABLE or the SELECT.FOR(SHARE|UPDATE) commands? ...
    David JohnstonDavid Johnston
    Sep 22, 2012 at 2:44 am
    Sep 22, 2012 at 8:34 am
  • Is there a place to download pgAdmin 1.16 for openSuse (or a repository I can add?) All I can find is packages for 1.14, however this version is unable to connect to Postgres 9.2 databases. Thanks! ...
    Mike ChristensenMike Christensen
    Sep 11, 2012 at 4:43 am
    Sep 13, 2012 at 3:31 pm
  • Hi I currently run a modest streaming replication target on a cheap, single disk ASUS media center; replicating a 100GB PG database. I want to add RAID via a consumer grade NAS device. As far as I ...
    Andrew BarnhamAndrew Barnham
    Sep 6, 2012 at 10:23 pm
    Sep 8, 2012 at 10:04 am
  • Hi, Is it possible to use the output of explain as text values? This won't work: explain select * from (values (1),(2),(3)) foo(x) where x 2 What i really want is to explain analyze a dynamic query ...
    Willy-Bas LoosWilly-Bas Loos
    Sep 6, 2012 at 5:18 pm
    Sep 7, 2012 at 9:10 am
  • Dear all, I have issue with the red portion function below; This IF last_id IS NULL THEN suppose to test if last_id is NULL, that is the select query did not found it then execute the rest of the red ...
    SUNDAY A. OLUTAYOSUNDAY A. OLUTAYO
    Sep 26, 2012 at 5:59 pm
    Sep 27, 2012 at 4:10 pm
  • Below test results into Loop: 1.create test table CREATE TABLE TEST_TABLE (NAME VARCHAR2, AGE INT); 2.create trigger function CREATE OR REPLACE FUNCTION TRIG_FUNC () RETURNS TRIGGER AS $$ DECLARE ...
    Amit KapilaAmit Kapila
    Sep 24, 2012 at 2:04 pm
    Sep 26, 2012 at 6:11 am
  • Hi, I have upgraded postgresql 8.4.13 to 9.2.0.1 O/S Ubuntu, restarted postgresql, it displayed my postgresql is 9.2 but when I log into postgresql, show version, it is still 8.4.13, see a) and b) ...
    AcAc
    Sep 23, 2012 at 11:47 am
    Sep 24, 2012 at 10:01 am
  • Hello, Is there a way to construct write an expression that constructs a record with with named columns. Specificially without the need for a corresponding named type. That is postgres=# select ...
    Benedikt GrundmannBenedikt Grundmann
    Sep 20, 2012 at 6:36 pm
    Sep 21, 2012 at 7:42 pm
  • Release 9.2 should increase count(*) performance. Is this wiki page still valid? http://wiki.postgresql.org/wiki/Slow_Counting Please update the content. Thank you, Thomas Güttler -- Thomas Guettler, ...
    Thomas GuettlerThomas Guettler
    Sep 17, 2012 at 8:07 am
    Sep 20, 2012 at 1:09 pm
  • Hey Everyone, We currently have a 9.1.5 postgres cluster running using streaming replication. We have 3 nodes right now 2 - local that are setup with pacemaker for a HA master/slave set failover ...
    Mike RoestMike Roest
    Sep 19, 2012 at 3:59 pm
    Sep 19, 2012 at 7:51 pm
  • Hello. I want to change one table already created. Where the comand? thank you.
    Guilherme RodriguesGuilherme Rodrigues
    Sep 18, 2012 at 8:56 pm
    Sep 19, 2012 at 11:56 am
  • I need to determine relationships between several tables. Is there a free tool to extract these from catalog tables? Is there an SQL that also does this? Thanks Alex Sent from my smartphone
    Alexander GataricAlexander Gataric
    Sep 13, 2012 at 4:51 pm
    Sep 14, 2012 at 9:11 am
  • I have several versions of PostgreSQL already installed on this machine. We need to test compatibility with PostgreSQL database systems with our products. I tried to install 9.2 64 bit using the one ...
    Dann CorbitDann Corbit
    Sep 12, 2012 at 8:24 pm
    Sep 13, 2012 at 7:13 pm
  • we're still having issues with PG on AIX 6.1, our configurations have no ipv6 as our WAN is purely ipv4, but if we use listen_addresses='*', we consistently get an error... LOG: could not bind IPv6 ...
    John R PierceJohn R Pierce
    Sep 11, 2012 at 4:09 pm
    Sep 11, 2012 at 8:22 pm
Group Navigation
period‹ prev | Sep 2012 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions158
posts940
users219
websitepostgresql.org
irc#postgresql

219 users for September 2012

Tom Lane: 50 posts Edson Richter: 34 posts Albe Laurenz: 33 posts John R Pierce: 33 posts David Johnston: 28 posts Adrian Klaver: 24 posts Chris Travers: 24 posts Scott Marlowe: 24 posts Craig Ringer: 22 posts Mike Christensen: 22 posts Jeff Janes: 18 posts Kevin Grittner: 18 posts Merlin Moncure: 14 posts Raymond O'Donnell: 14 posts Sébastien Lorion: 14 posts Aleksey Tsalolikhin: 12 posts Jasen Betts: 12 posts Rafal Pietrak: 12 posts Chris Angelico: 11 posts Devrim Gündüz: 11 posts
show more
Archives