Search Discussions

254 discussions - 1,366 posts

  • I have a query that converts a string to an array with the string_to_array function. Sometimes the input is an empty string (not a null, but a string of zero-length). I had expected the result to be ...
    Steve CrawfordSteve Crawford
    Mar 30, 2009 at 6:56 pm
    Apr 7, 2009 at 4:06 pm
  • I'm using postgresql 8.3.6 through JDBC, and trying to measure the maximum transaction rate on a given Linux box. I wrote a test program that: - Creates a table with two int columns and no indexes, - ...
    Jack OrensteinJack Orenstein
    Mar 6, 2009 at 4:58 pm
    Mar 30, 2009 at 1:15 pm
  • Hello, I'm currently developing a program for centralizing the vehicle fleet GPS information -http://openggd.sourceforge.net-, written in C++. The database should have these requirements: - The ...
    Juan PereiraJuan Pereira
    Mar 17, 2009 at 11:25 am
    Apr 22, 2009 at 3:27 am
  • Greetings! I just discovered the existence of a couple of functions I don't understand in one customer's PostgreSQL database: -- Function: c_mode() -- DROP FUNCTION c_mode(); CREATE OR REPLACE ...
    Rob RichardsonRob Richardson
    Mar 19, 2009 at 2:44 pm
    Mar 27, 2009 at 9:11 pm
  • I am wondering the feasibility of having PG continue to work even if non-essential indexes are gone or corrupt. I brought this basic concept up at some point in the past, but now I have a different ...
    Glen ParkerGlen Parker
    Mar 11, 2009 at 1:45 am
    Mar 21, 2009 at 6:53 am
  • Hi all A lot of time since the last debugging activity. I don't remember how to debug. I thought I had to set a breaking point in the function i want to debug, and then call that function. I'm doing ...
    Josep porresJosep porres
    Mar 23, 2009 at 10:34 am
    Mar 25, 2009 at 2:12 am
  • Hi, I'm new to both PostgreSQL and web-based application development; I read the FAQ at postgresql.org (perhaps this discussion group has another FAQ that I haven't found yet?) and didn't see this ...
    Mar 22, 2009 at 5:23 am
    Mar 25, 2009 at 8:23 pm
  • Hi everyone: I really wanted to let everyone know that I've created @PGSQL_Announce on Twitter and setup a cron job to parse the feed and post it to Twitter. It's been working for a little while now ...
    Douglas J HunleyDouglas J Hunley
    Mar 5, 2009 at 6:22 am
    Mar 6, 2009 at 5:13 pm
  • Hi, How much space does a pg_dump usually take? One of my databases is 600GB.... How much space do I need to dump this? Thanks
    Mar 31, 2009 at 1:57 pm
    May 14, 2009 at 6:29 am
  • I broached this topic last year[1], but the project got tabled until now; so I raise it again. We want to be able to search text (extracted from character-based PDF files) which will contain legal ...
    Kevin GrittnerKevin Grittner
    Mar 10, 2009 at 9:47 pm
    Apr 8, 2009 at 4:05 pm
  • Hi, I have a DB in utf-8 and postgres 8.3.x. How can I do an accent insensitive search (like ...) ? TIA
    Mar 18, 2009 at 4:39 pm
    Mar 30, 2009 at 9:03 am
  • What OS, pg version etc are you running? If windows, are you running any anti-virus software? A lot of anti-virus packages are dumb as a brick and lock files when checking them and cause these ...
    Scott MarloweScott Marlowe
    Mar 31, 2009 at 10:58 pm
    Apr 3, 2009 at 2:19 am
  • Hi, In the next project I'm going to have a number of colums in my tables, but I don't know how many, they change. They all use integers as datatype though.. One day, I get 2 new columns, a week ...
    A BA B
    Mar 30, 2009 at 3:39 pm
    Mar 31, 2009 at 5:39 pm
  • All, I'm trying to run two database clusters on a single machine, and am failing. I use initdb to create the two clusters... each has their own directory structure. I can start one server or the ...
    Eric SmithEric Smith
    Mar 28, 2009 at 10:27 pm
    Mar 31, 2009 at 3:12 am
  • My basic question is...are php4 and postgresql 8.3 compatible? I'm running Linux Redhat 3.4.6, php4.3.9, and postgresql 8.3. I know, some of those versions are old...its government, and I ...
    Mar 2, 2009 at 11:49 pm
    Mar 4, 2009 at 3:36 pm
  • Hello, I'm looking for some insight on an intermittent PostgreSQL performance problem that has been very troublesome. Using PG 8.3.5 on a server running CentOS 5 2.6.18-8.el5 (Dual Xeon 2.00 GHz, 4 ...
    Mike CharnokyMike Charnoky
    Mar 9, 2009 at 8:17 pm
    Mar 29, 2009 at 8:51 am
  • Hello all Is it possible to host postgreSQL on Amazon's cloud? What are the issues involved? With best regards. Sanjay.
    Sanjay AroraSanjay Arora
    Mar 3, 2009 at 4:53 am
    Mar 20, 2009 at 6:59 pm
  • Dear list members I have upgraded my PostgreSQL 8.2.6 to 8.3.6 and I am having trouble with calling "to_timestamp" function. Here is the query I use: SELECT a.* FROM tblevent a WHERE ...
    Nico GrubertNico Grubert
    Mar 5, 2009 at 6:13 pm
    Mar 6, 2009 at 4:04 pm
  • HI. I made a small alteration to a table (added a column). Now when I do: vacuum analyze TABLENAME or delete from TABLENAME where id = 99 Nothing happens! The carriage return means the my shell ...
    Phoenix KiulaPhoenix Kiula
    Mar 3, 2009 at 4:02 pm
    Mar 3, 2009 at 8:51 pm
  • Hi, I noticed that while pg_dump can output a custom format, effectively compressing the output, pg_dumpall doesn't. Is there a reason for this? And is there a way to get pg_dumpall to compress it's ...
    Thom BrownThom Brown
    Mar 5, 2009 at 10:53 am
    Jun 24, 2011 at 5:47 pm
  • According to the documentation it's not possible to log ship from a 64 bit server to a 32 bit server. I just want to confirm that this is the case before I waste a whole lot of time trying to set it ...
    Tim UckunTim Uckun
    Mar 26, 2009 at 12:58 am
    Mar 27, 2009 at 2:16 pm
  • Hi, I installed postgresql (for the first time) in my xubuntu. I created an user and now I would connect, from remote host, to the db with that user. How can I enable the remote access for the user ...
    Piotre UgrumovPiotre Ugrumov
    Mar 7, 2009 at 10:20 pm
    Mar 11, 2009 at 9:29 pm
  • Which one should one install? Is there any difference? They are both free right? And both has fulltext support, right? Jen
    Jennifer TreyJennifer Trey
    Mar 17, 2009 at 5:23 pm
    Mar 30, 2009 at 7:24 pm
  • Hi, I'm new to pgsql (but not databases in general) and I've run into a roadblock that I'm having difficulty figuring out how to get around. Any help would be greatly appreciated! I'm using the ...
    Carl SopchakCarl Sopchak
    Mar 7, 2009 at 3:46 pm
    Mar 8, 2009 at 11:40 pm
  • Dear all, I am trying to write a user-defined function in C++. Most examples are give in plain C. I would be very grafeful for a sample program/code-snippet in C++. Thank you very much, George. View ...
    George OakmanGeorge Oakman
    Mar 9, 2009 at 4:38 pm
    Aug 11, 2010 at 3:32 pm
  • Hi Been having interesting times with an IBM x3650 with 8 15k RPM 73GB drives in RAID 10 and a ServRAID 8K controller with Write-Back cache enabled (battery installed and working). Currently getting ...
    Chris EllisChris Ellis
    Mar 31, 2009 at 9:51 am
    Apr 1, 2009 at 8:04 pm
  • When I run the following query through psql, it executes successfully. However, when I run it through ODBC (via OpenOffice Base), I get the error SQL Status: HY000 Error code: 1000 syntax error, ...
    Carl SopchakCarl Sopchak
    Mar 15, 2009 at 12:40 am
    Mar 16, 2009 at 6:40 pm
  • Hi list, if I want to find all records from a table that don't have a matching record in another table there are at least two ways to do it: Using a left outer join or using a subselect. I always ...
    Christian SchröderChristian Schröder
    Mar 6, 2009 at 6:38 am
    Mar 9, 2009 at 1:50 pm
  • Hi - I'm trying to build 8.3.6 on a box recently upgraded from Sarge to Lenny and I get the following error during compile: make[4]: Entering directory ...
    Josh TrutwinJosh Trutwin
    Mar 10, 2009 at 4:23 am
    Oct 5, 2009 at 10:33 pm
  • Hi guys! This'll hopefully be an easy question for one of the perf guys like Tom.. I'm wondering what the performance advantage is to using a clustered index. Take the following example: I have a ...
    Mike ChristensenMike Christensen
    Mar 17, 2009 at 6:34 am
    Mar 22, 2009 at 11:15 am
  • Hi, I have table with several columns and need to perform fulltext search over volatile number of columns. I can't use multicolumn gist index or gin index over concatenated columns, so I've created ...
    Mar 19, 2009 at 11:58 pm
    Mar 21, 2009 at 8:40 am
  • I went to upgrade an installation and was stopped with (approximately) the following message after clicking Next on the step where I told it to use the same data directory: "The existing data ...
    Mar 24, 2009 at 12:54 pm
    Mar 25, 2009 at 2:02 am
  • Hi, I'm using Postgresql 8.3.6 under Freebsd 7.1. After a fresh restore of a customer dump (running version 8.2.7 at the moment), a rather big query executes in about 30 seconds. As soon as I run ...
    Philippe LangPhilippe Lang
    Mar 18, 2009 at 10:04 am
    Mar 18, 2009 at 8:01 pm
  • Hi All, I wanted to know if there is a way to upload kml/gpx data directly to the DB. So far, I have been using shp2pgsql to upload data from shape files. I don't want to convert it to shape and then ...
    Subha RamakrishnanSubha Ramakrishnan
    Mar 17, 2009 at 12:51 pm
    Mar 18, 2009 at 8:50 am
  • Hi I've had the server shut itself down when attempting to connect, even with PG Admin. Is there anything I can do to ensure that the pg server continues to run during a connection? Bob
    Bob PawleyBob Pawley
    Mar 11, 2009 at 3:35 pm
    Mar 11, 2009 at 7:41 pm
  • Hi, I've just upgrade postgresql from 7.4 to 8.3 on a machine running debian. And i ran in trouble. I've searched the internet but didn't find an answer to my solution. Is it possible to upgrade from ...
    Marc CuypersMarc Cuypers
    Mar 10, 2009 at 4:25 pm
    Mar 11, 2009 at 12:47 pm
  • Hi, I am working on packaging postgres database in our java based application.I downloaded postgresql-8.2.12-1-binaries-no-installer.zip from the postgres site and installed it on a windows 2003 ...
    CM JCM J
    Mar 31, 2009 at 10:28 am
    Apr 1, 2009 at 2:15 pm
  • Hello, I have a few questions related to the parallel query processing.Can you guys tell me how to implement parallel query processing in postgresql database. Thanks, Avin.
    Aravind chanduAravind chandu
    Mar 25, 2009 at 8:29 pm
    Mar 30, 2009 at 12:21 pm
  • What is the path format for the i (\i) command in the SQL shell? Thank you.
    Mar 27, 2009 at 2:28 pm
    Mar 28, 2009 at 12:46 am
  • I downloaded the 8.3 exe for Windows (XP) and started the installation. When it got near the end, a warning window opened stating "Problem running post-install step. Installation may not complete ...
    Mar 18, 2009 at 9:22 pm
    Mar 27, 2009 at 11:50 pm
  • Hi, Can someone explain why postgres complains in this case: create table t(d real, check(d =0.00603)); insert into t values (0.00603); ERROR: new row for relation "t" violates check constraint ...
    Jacek BeclaJacek Becla
    Mar 23, 2009 at 8:27 pm
    Mar 23, 2009 at 11:07 pm
  • Hello, I try to use the srf API and I have a link error. When I did : FuncCallContext *funcctx; ... if (SRF_IS_FIRSTCALL()){ funcctx = SRF_FIRSTCALL_INIT(); // If I remove this line, no link error ...
    Ben Ali RachidBen Ali Rachid
    Mar 20, 2009 at 2:19 pm
    Mar 22, 2009 at 7:19 pm
  • Hi, Can we use sql transactions(BEGIN, ROllBACK, COMMIT etc) in a postgresql function(user defined) which is written in PL/Perl? Thanks in advance -- With warm regards Jasid Z. A +91 9946109809
    Jasid ZAJasid ZA
    Mar 18, 2009 at 11:59 am
    Mar 18, 2009 at 3:54 pm
  • Hi, we are in the process of finding the best solution for Postgresql deployment with storage controller. I have some query, Please give some suggestion for the below 1) Can we get customer ...
    Nagalingam, KarthikeyanNagalingam, Karthikeyan
    Mar 16, 2009 at 12:47 pm
    Mar 17, 2009 at 5:46 am
  • Do I really need 4 indexes per column to handle the 4 combinations of {equality,like/regexp} x {unfolded,casefolded} in a UTF-8 encoded database? I have a column that I'd like to be able to search ...
    Reece HartReece Hart
    Mar 13, 2009 at 12:22 am
    Mar 13, 2009 at 6:08 pm
  • I am confronting a design decision involving null values and I cannot seem to discern which way to go. Therefore, I would like some commentary based on real world experience. The basic issue is ...
    James B. ByrneJames B. Byrne
    Mar 12, 2009 at 3:42 pm
    Mar 13, 2009 at 1:46 pm
  • So it looks like at one time we had a cookbook. But the links are dead now. Does anyone know what ever happened to that, or if it lives on somewhere else?
    Mar 5, 2009 at 4:53 am
    Mar 7, 2009 at 10:58 am
  • Hello, i received a copy of a postgresql data directory and i need to read it (and do a regular dump). the datadir version is 8.1 so i installed that version of the server. When trying to start the ...
    Eugenio ModestiEugenio Modesti
    Mar 28, 2009 at 1:46 pm
    Mar 29, 2009 at 5:10 pm
  • Hi, I'm experiencing a weird behavior when storing latin characters to a PostgreSQL server. The database is Latin1 encoded, and it is working since September 2008, it wasn't updated nor ...
    Leonardo M. RaméLeonardo M. Ramé
    Mar 25, 2009 at 8:21 pm
    Mar 26, 2009 at 3:34 pm
  • Using the following links to get to the PostgreSQL 8.3.7 (Windows) one-click installer: http://www.postgresql.org/download/windows http://www.enterprisedb.com/products/pgdownload.do#windows and then ...
    Richard BroersmaRichard Broersma
    Mar 25, 2009 at 5:46 pm
    Mar 25, 2009 at 8:21 pm
Group Navigation
period‹ prev | Mar 2009 | next ›
Group Overview
grouppgsql-general @

343 users for March 2009

Scott Marlowe: 101 posts Tom Lane: 94 posts John R Pierce: 36 posts Joshua D. Drake: 31 posts Raymond O'Donnell: 26 posts Adrian Klaver: 23 posts Sam Mason: 21 posts Dave Page: 18 posts Greg Stark: 18 posts Craig Ringer: 17 posts Richard Huxton: 17 posts Will Rutherdale (rutherw): 16 posts Alvaro Herrera: 15 posts Ivan Sergio Borgonovo: 15 posts Marco Colombo: 15 posts Greg Smith: 14 posts Glen Parker: 13 posts Grzegorz Jaśkiewicz: 13 posts Thomas Kellerer: 13 posts Thom Brown: 13 posts
show more