FAQ

Search Discussions

223 discussions - 1,115 posts

  • I am brand new to PostgreSQL and coming from MySQL. My question is does anyone know after I install PostgreSQL on my Linux server, is there a script that secures the database like MySQL offers in ...
    Carlos MennensCarlos Mennens
    Sep 10, 2010 at 3:13 pm
    Oct 7, 2010 at 12:55 pm
  • Hi Since some days we are getting the above message. The system is a current CentOS 5.5, x86_64, Postgresql 8.4 as it comes with the packages postgresql84, postgresql84-libs etc. PostGIS is enabled, ...
    Peter HopfgartnerPeter Hopfgartner
    Sep 15, 2010 at 12:56 pm
    Sep 21, 2010 at 6:31 pm
  • Hi, Where does postgres keep the query result until it is returned? In the shared_buffers? Or in extra memory that was not previously allocated, or something else? What if the query result becomes ...
    Willy-Bas LoosWilly-Bas Loos
    Sep 17, 2010 at 1:00 pm
    Oct 1, 2010 at 8:47 am
  • Hi, I have downloaded slony-I(slony-I-2.0.2R-pg84.zip) from the site http://developer.pgadmin.org/~hiroshi/Slony-I/. But when I tried to create a new Replication cluster using PgAdmin(After doing all ...
    Vishnu S.Vishnu S.
    Sep 27, 2010 at 10:39 am
    Oct 14, 2010 at 7:35 pm
  • Hello, I'm interested in the "incrementally updated backups" scenario described in section 25.6 of the Postgres 9 documentation. I've configured streaming replication for my warm standby server. Step ...
    Gabe NellGabe Nell
    Sep 11, 2010 at 9:29 pm
    Sep 23, 2010 at 10:30 pm
  • I cannot install PostgreSQL 9.0 (x86-64) under Windows 7 (x86-64). The installer fails right after starting the installation process with the message: "An error occurred executing the Microsoft VC++ ...
    Dr. Peter VoigtDr. Peter Voigt
    Sep 28, 2010 at 11:19 pm
    Oct 7, 2010 at 9:11 am
  • Hi all. This is my case: -- begin snippet -- reset search_path; drop table if exists session cascade; create table session ( name text primary key, valu text not null ); create or replace function ...
    Vincenzo RomanoVincenzo Romano
    Sep 30, 2010 at 11:17 am
    Oct 1, 2010 at 9:21 am
  • I installed PostgreSql 9.0 Win 64 standard distro. Stack builder offered in end of installation does not contain postgresql.conf optimization wizard. How to optimize postgresql.conf for 64 bit ...
    AndrusAndrus
    Sep 29, 2010 at 10:12 am
    Oct 19, 2010 at 11:49 am
  • Hi All, We are starting a new project in my organization and need to have a database. I proposed that we use PostgreSQL. Because we already have the Oracle infrastructure in-house, I'm told that I ...
    Wang, Mary YWang, Mary Y
    Sep 24, 2010 at 3:06 pm
    Sep 25, 2010 at 7:02 am
  • I have been trying to install the Gevel module but am getting an error when running make on the gevel files download. The error is: /contrib/contrib-global.mk: No such file or directory. I have also ...
    Andrew HunterAndrew Hunter
    Sep 22, 2010 at 5:44 am
    Sep 28, 2010 at 3:52 pm
  • The what's new in 9.0 document on the wiki is great. Is there anything similar for 8.4 & 8.3 & so on? I haven't had time to take advantage of all new features for a while. (Always read the release ...
    Scott RibeScott Ribe
    Sep 22, 2010 at 11:28 pm
    Oct 12, 2010 at 4:49 am
  • I have a query that returns many columns but few rows. I would like to display output horizontally instead of vertically, i.e. rotating by 90 degress, so column headings appear in the left margin, ...
    Ben CarberyBen Carbery
    Sep 30, 2010 at 11:17 am
    Oct 10, 2010 at 10:38 pm
  • Hi there, I'm sitting for days now, and I can't get this to work: I want to insert binary data (bytea) into my postgres DB via the c++ libpq. What I have is a char* (actually a QByteArray) and I want ...
    GOO CreationsGOO Creations
    Sep 30, 2010 at 3:26 pm
    Oct 1, 2010 at 1:06 pm
  • Assume I want to install an instance of postgres such that it cannot interfere with another install, or even be visible to other apps. Is this all I need to do: - install pg somewhere within my own ...
    Scott RibeScott Ribe
    Sep 8, 2010 at 12:15 am
    Sep 9, 2010 at 12:03 am
  • Can anyone recommend a relatively simple merge replication package that would work well on windows and which relies on one of the current postgresql versions? 9 would be fine for my needs. I'm a ...
    NovnoviceNovnovice
    Sep 28, 2010 at 3:24 am
    Oct 4, 2010 at 1:57 pm
  • I have a query structured like this: SELECT stuff FROM (SELECT more stuff FROM table1 ORDER BY field1) AS q1 INNER JOIN table2 ON ( ... ) and have found that the INNER JOIN is ignoring the order set ...
    Kevin JardineKevin Jardine
    Sep 26, 2010 at 7:14 pm
    Sep 28, 2010 at 4:28 am
  • I can't get md5 authentication working with postgres 9rc1 and pgpool-II 3.0. I see references to "pool_passwd" in the pgpool documentation, but I see nothing indicating *where* this file should exist ...
    Bryan MurphyBryan Murphy
    Sep 14, 2010 at 9:52 pm
    Sep 22, 2010 at 2:06 am
  • Hey, a client of ours has been having some data corruption in their database. We got the data corruption fixed and we believe we've discovered the cause (they had a script killing any waiting queries ...
    Sam NelsonSam Nelson
    Sep 8, 2010 at 6:57 pm
    Sep 21, 2010 at 10:50 pm
  • Hi all, I've come across a puzzling situation with a table having a timestamp with time zone column. This column is full of values displaying exactly as '1999-12-31 19:00:00-05', but for some reason ...
    Josh KupershmidtJosh Kupershmidt
    Sep 3, 2010 at 6:54 pm
    Sep 3, 2010 at 8:14 pm
  • Hi everyone, I've run into a strange problem with system catalogs - we're collecting database stats periodically (every 10 minutes), and from time to time we get the following error: ...
    TvTv
    Sep 20, 2010 at 11:52 am
    Oct 7, 2010 at 3:40 pm
  • I'm testing pg_upgrade out and ran into a couple of problems. First when I did pg_upgrade --check I got the tsearch2 tables preventing the upgrade from happening: Database: testdatabase ...
    Brian HirtBrian Hirt
    Sep 27, 2010 at 5:39 pm
    Sep 29, 2010 at 2:41 am
  • Hello guys, I have a problem with my web application and postgres. I have several servlets on a page which results in severeal simultaneous data base calls kind of: SELECT d.id, d.aa, d.ab, ts.ac, ...
    Stefan WildStefan Wild
    Sep 7, 2010 at 9:11 pm
    Sep 21, 2010 at 6:53 pm
  • I have a table in my database and would like to modify the one column that is already configured to be the PRIMARY KEY but I forgot to set it for AUTO_INCREMENT. For some reason I can't find what the ...
    Carlos MennensCarlos Mennens
    Sep 20, 2010 at 1:58 pm
    Sep 20, 2010 at 8:00 pm
  • Could someone explain why the following doesn't work? test=# PREPARE meow(unknown) AS test-# SELECT $1 as meow; ERROR: could not determine data type of parameter $1 The problem is that using PDO in ...
    Thom BrownThom Brown
    Sep 29, 2010 at 6:09 pm
    Sep 30, 2010 at 2:47 pm
  • What is the best strategy for deleting orphaned records from a large table. The usual NOT IN is very slow so there must be a better way in postgres for dealing with these. I know it's best not to ...
    Tim UckunTim Uckun
    Sep 27, 2010 at 12:02 pm
    Sep 28, 2010 at 3:56 am
  • Hi, I have a copy of "/usr/local/pgsql/data" from old server. Is it possible to do a dump of the sql databases in this directory, so that I can easily migrate them to my current system? -Håvard Wahl ...
    KongsgarKongsgar
    Sep 23, 2010 at 8:56 pm
    Sep 27, 2010 at 3:35 am
  • Hi, I need to clean up a lot of contact data because of a merge of customer lists that used to be kept separate. I allready know that there are double entries within the lists and they do overlap, ...
    AndreasAndreas
    Sep 16, 2010 at 2:40 am
    Sep 23, 2010 at 3:38 pm
  • I'm working with some people who live and breath Excel. I need to be able to move data back and forth between formats which make sense for Excel and for PostgreSQL. In some cases, this is just to ...
    Aram FingalAram Fingal
    Sep 16, 2010 at 3:49 pm
    Sep 17, 2010 at 5:09 pm
  • Hi, Using the catalog tables, is there any way to correlate session id/user id to which object (i.e. tables, indexes etc) it access and much how disk reads or I/O wait has been done against the ...
    Adi hirschteinAdi hirschtein
    Sep 12, 2010 at 10:53 am
    Sep 14, 2010 at 4:55 pm
  • Coming from 25 years of programming applications based on dBASE and FoxPro tables, I have a question about how to deal with a programming task. I have a situation where I receive a file with ...
    TonyTony
    Sep 11, 2010 at 3:50 am
    Sep 11, 2010 at 7:34 pm
  • how can I do the following in plpgsql? insert multiple rows in a table get the ids (serial) into a temp table (not the client) for one row it will be like this insert into ...
    Bret GreenBret Green
    Sep 19, 2010 at 1:49 am
    Apr 7, 2011 at 1:48 pm
  • I installed the 64 bit PostgreSQL 9.0 on Windows Server 2008 and it seems to perform wonderfully. I moved 1.5 million records that are 3K wide from SQL*Server into PostgreSQL and rebuilt 6 indexes ...
    Dann CorbitDann Corbit
    Sep 30, 2010 at 10:35 pm
    Oct 2, 2010 at 7:27 am
  • I'm getting an error message that doesn't make sense to me. Using PostgreSQL 9.0.0 on CentOS 5.5. Given the following table and function definitions CREATE TABLE test3 ( test3_id serial NOT NULL, ...
    Eric McKeethEric McKeeth
    Sep 24, 2010 at 9:09 pm
    Sep 28, 2010 at 11:17 pm
  • Hello. If I have a table like this create table fleet ( ship_id integer, location point); and fill it with a lot of ships and their locations and then want to create an index on this to speed up ...
    A BA B
    Sep 23, 2010 at 10:46 am
    Sep 27, 2010 at 5:18 am
  • hey all, I think versioned pl/[pgsql|python|perl|bash|java] functions would be a great addition to 9.1. Imagine that instead of CREATE OR REPLACE FUNCTION you could do CREATE AND VERSION FUNCTION and ...
    Rhys A.D. StewartRhys A.D. Stewart
    Sep 21, 2010 at 8:06 pm
    Sep 22, 2010 at 12:14 pm
  • Hello everyone, I need to replace all occurrences of a certain character in a string. For that I'm using regexp_replace, but so far I only managed to replace the first character, here's an example: ...
    Luís de SousaLuís de Sousa
    Sep 14, 2010 at 10:47 am
    Sep 15, 2010 at 2:47 pm
  • Hi All I am using postgres-8.1.2. I am getting the following error while autovacuum. 2010-08-18 18:36:14 UTC LOG: autovacuum: processing database "template0" 2010-08-18 18:36:14 UTC ERROR: could not ...
    Tamanna madaanTamanna madaan
    Sep 14, 2010 at 9:09 pm
    Sep 15, 2010 at 10:30 am
  • Is the zero_damaged_pages feature expected to work in 8.3.11 ? I have a fair bit of evidence that it doesn't (you get nice messages in saying that the page is being zeroed, but the on-disk data does ...
    David BorehamDavid Boreham
    Sep 27, 2010 at 9:08 pm
    Feb 1, 2011 at 9:45 pm
  • Hi sorry if this has been asked already. Is there any mechanism to do connection pooling for libpqxx already? Or any new developments for this? Our one dbwriter service instance recieves requests ...
    Mark PaylagaMark Paylaga
    Sep 6, 2010 at 6:33 am
    Nov 23, 2010 at 2:16 pm
  • Hi, /delimiter/ The single character that separates columns within each row (line) of the file. The default is a tab character in text mode, a comma in CSV mode. Why limit this to a single character? ...
    ReyRey
    Sep 24, 2010 at 11:23 pm
    Oct 18, 2010 at 8:10 pm
  • Hi - I use Dave Page's one-click installers for Mac OS X: http://www.enterprisedb.com/products/pgdownload.do#osx I recently installed PostgreSQL 9.0.0 on Mac OS X 10.5.8. PL/perl will not load ...
    Larry LeszczynskiLarry Leszczynski
    Sep 27, 2010 at 10:41 pm
    Sep 29, 2010 at 8:47 am
  • Program written in C using Libpq, which receives large files (BYTEA) has a memory leak. I need to free ALL of the used memory after each sql query. after each call PQclear() I drop the buffer: conn- ...
    Polyakov VladimirPolyakov Vladimir
    Sep 24, 2010 at 11:51 am
    Sep 25, 2010 at 9:29 am
  • Hi list, In Oracle I can... create table a ( b varchar2(10 chars) ); ...and then, regardless of character encoding and how much space an ascii character vs a ö takes, 10 characters will fit there. If ...
    Marcus EngeneMarcus Engene
    Sep 21, 2010 at 9:49 am
    Sep 21, 2010 at 1:21 pm
  • Hi, I can't find in the Postgresql documentation the semantics that explains the following: colin@ruby:~/workspace/eyedb$ psql psql (8.4.4) Type "help" for help. colin= select to_date('731332', ...
    Colin 't HartColin 't Hart
    Sep 20, 2010 at 2:20 pm
    Sep 20, 2010 at 7:27 pm
  • I'm puzzled if this is by design or just overlooked... create table t(a int, b varchar); insert into t values(1,'x'); For basic query: select t from t result is of type t. If I query: select sq from ...
    Rikard PavelicRikard Pavelic
    Sep 18, 2010 at 2:09 am
    Sep 18, 2010 at 3:50 pm
  • Hi there, I have a somewhat peculiar problem. To begin with, here are links to my schema and rules: my_table and associated rules <http://postgresql.pastebin.com/0eCSuvkU and my_table_history ...
    Gissur ÞórhallssonGissur Þórhallsson
    Sep 15, 2010 at 3:40 pm
    Sep 16, 2010 at 11:44 pm
  • I have a query that joins 3 tables, TRAIN_MOD,TRAIN_COMP and TRAINING_COURSE, There could be many training_course records for each of the other tables. I want to get all records from the Train_mod ...
    Christine PennerChristine Penner
    Sep 16, 2010 at 4:17 pm
    Sep 16, 2010 at 10:03 pm
  • 8.3.4 on Linux Is there a way to regexp match on a null value? Or is it necessary to OR in a .... "or x is null"? Thanks in Advance !
    Gauthier, DaveGauthier, Dave
    Sep 10, 2010 at 4:10 pm
    Sep 10, 2010 at 8:30 pm
  • lets say I hve the following in the 'fruits' table: Round orange Sunkist orange navel orange strawberry blueberry sunkist orange apple how would I get something like the following: count as c | Fruit ...
    JackassplusJackassplus
    Sep 8, 2010 at 3:23 pm
    Sep 9, 2010 at 12:56 am
  • I have a two-user point-of-sale application on Windows XP PRO. The DB runs on the cash register. The second user is a manager's computer. They are connected through a wired router which is also ...
    Bayless KirtleyBayless Kirtley
    Sep 1, 2010 at 3:22 pm
    Sep 3, 2010 at 6:37 pm
Group Navigation
period‹ prev | Sep 2010 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions223
posts1,115
users268
websitepostgresql.org
irc#postgresql

268 users for September 2010

Tom Lane: 107 posts Craig Ringer: 34 posts Merlin Moncure: 31 posts Thom Brown: 28 posts Scott Marlowe: 27 posts Carlos Mennens: 23 posts John R Pierce: 21 posts Bruce Momjian: 18 posts Dave Page: 16 posts Devrim Gündüz: 16 posts Dmitriy Igrishin: 16 posts Alban Hertroys: 14 posts David Fetter: 14 posts Joshua D. Drake: 14 posts Raymond O'Donnell: 14 posts Sam Mason: 13 posts Arjen Nienhuis: 12 posts Grzegorz Jaśkiewicz: 12 posts Pavel Stehule: 12 posts Vincenzo Romano: 11 posts
show more
Archives