Search Discussions

228 discussions - 1,202 posts

  • Hi Everyone: Tomorrow, I will need to present to a group of managers (who know nothing about DBs) why I chose to use PG over MySQL in a project, MySQL being the more popular DB choice with other ...
    Gauthier, DaveGauthier, Dave
    Dec 16, 2009 at 9:02 pm
    Dec 22, 2009 at 12:57 am
  • Hello, I am the project manager of Bacula. One of the database backends that Bacula uses is PostgreSQL. This email is to notify you that a change you made to setting database character codes has ...
    Kern SibbaldKern Sibbald
    Dec 2, 2009 at 1:52 pm
    Dec 4, 2009 at 5:45 pm
  • Hello all, Over the past 6 months or so I have posted to the list a couple times looking for information regarding recovering databases from corruption. At the time the incidents of corruption among ...
    Michael ClarkMichael Clark
    Dec 15, 2009 at 11:34 pm
    Feb 25, 2010 at 2:31 am
  • Based on research done as part of this thread, it seems plpgsql has similar risks to recursive queries, so the idea of installing plpgsql by default now makes more sense. The attached patch installs ...
    Bruce MomjianBruce Momjian
    Dec 4, 2009 at 12:04 am
    Dec 17, 2009 at 11:40 pm
  • Trying to install postgis on LINUX machine, need to find the geos- config file, as seems it is no where to be found after download of postgis in the ./configure step, is there anyone that can give me ...
    Dec 29, 2009 at 2:42 am
    Dec 30, 2009 at 8:28 am
  • Hello, I am running PostgreSQL 8.4.2. For the testcase I have a database, a user, and two schemas within the database. Two tables in those two different schemas have the same name, but only on of ...
    Ralph GraulichRalph Graulich
    Dec 19, 2009 at 8:43 pm
    Dec 22, 2009 at 1:13 pm
  • I've been trying to track down a performance issue I have. In simple terms, my select performance is very good (generally either CPU limited, or disk limited, depending upon the query), and small ...
    Stephen TylerStephen Tyler
    Dec 9, 2009 at 12:29 am
    Dec 11, 2009 at 2:38 am
  • Hi, I am experiencing some strange behavior when executing a not too complicated pl/perl function. The Function is not too complicated. It does... 1. Selects about 20 Records from Table A ( - loops ...
    Alex -Alex -
    Dec 18, 2009 at 8:11 pm
    Dec 21, 2009 at 9:38 am
  • Hello, this fails with "duplicate key value": CREATE TABLE x ( i INT NOT NULL UNIQUE ); INSERT INTO x (i) VALUES (1), (2), (3); UPDATE x SET i = i + 1; are there any plans to make this work? -- Roman ...
    Neuhauser+pgsql-general#postgresql OrgNeuhauser+pgsql-general#postgresql Org
    Dec 31, 2009 at 1:45 pm
    Jan 9, 2010 at 4:39 pm
  • Hi all, I have a project where I need to be able to capture every query from a production system into a file such that I can "replay" them on a staging system. Does such a thing already exist or ...
    Chris ErnstChris Ernst
    Dec 18, 2009 at 9:25 pm
    Dec 21, 2009 at 11:24 pm
  • Hi all, We're using PostgreSQL 8.4 ... We do our nightly database backups with pg_dump. I was doing a test restore and I encountered some data during the reload that was in a table against the ...
    Dec 9, 2009 at 7:37 pm
    Dec 18, 2009 at 5:24 pm
  • I've some tables that are just cache. I'd like to just dump the table schema without dumping the table contend. I think I could do it in 2 steps but I'd like to avoid it. Is there a way? thanks -- ...
    Ivan Sergio BorgonovoIvan Sergio Borgonovo
    Dec 28, 2009 at 6:42 pm
    Jan 2, 2010 at 10:44 am
  • An easy question for some I hope. I have a DB from 8.2 days that when I now dump and try to take into the 8.3.7, it gives me errors about utf-8 stuff. I tried searching this list's archives but could ...
    Phoenix KiulaPhoenix Kiula
    Dec 14, 2009 at 11:03 am
    Dec 18, 2009 at 1:46 pm
  • Database contains CHAR(7) type column which must be NOT NULL and must be in the format mm.yyyy where: mm - month number, always two digits in range 01 .. 12 . - separator must be point always. yyyy - ...
    Dec 22, 2009 at 8:04 pm
    Dec 25, 2009 at 12:59 am
  • Hi, this is a bit of a noob question. I am using PGSql to perform some large analyses, with the clients being a sequentially run set of perl scripts (one to set up and populate tables and then down ...
    Dan KortschakDan Kortschak
    Dec 7, 2009 at 9:06 pm
    Dec 9, 2009 at 8:19 am
  • I am trying to create a static, universal (x86 and ppc at least - 64 bit architectures are optional) build of the PostgreSQL libraries on a Mac OS X 10.6 machine. The command line I am using is as ...
    Israel BrewsterIsrael Brewster
    Dec 2, 2009 at 12:49 am
    Dec 3, 2009 at 9:16 pm
  • This is sort of a PostgreSQL question/sort of a general SQL question, so I apologize if this isn't the best place to ask. At any rate, I know in PostgreSQL you can issue a command like 'SELECT ...
    Israel BrewsterIsrael Brewster
    Dec 24, 2009 at 9:45 pm
    Dec 29, 2009 at 5:20 pm
  • How to use column values set in update in subsequent set clauses and in subqueries in subsequent row updates? I tried set transaction isolation level read uncommitted; create temp table test1 ( a ...
    Dec 19, 2009 at 7:32 pm
    Dec 28, 2009 at 3:39 pm
  • Hi All. I have a program which import some 6000-10000 records in Postgres database. However the import of data is successful but the postgres.exe almost takes up entire memory and CPU. I could see in ...
    A BhattacharyaA Bhattacharya
    Dec 11, 2009 at 6:56 am
    Dec 12, 2009 at 2:18 am
  • Hi, I have a table like this: CREATE TABLE test ( type text NOT NULL, ident text[] NOT NULL, ... ); ALTER TABLE ONLY test ADD CONSTRAINT test_pkey PRIMARY KEY (type, ident); and I would like to query ...
    Denes DanielDenes Daniel
    Dec 4, 2009 at 5:58 pm
    Dec 10, 2009 at 11:47 am
  • Hi, I need to create a trigger on a table used by our sofware, the problem is, when I issue a "create trigger...." on this table, it takes forever. It doesn't matter if I use pgAdmin, or psql. The ...
    "Leonardo M." Ramé"Leonardo M." Ramé
    Dec 29, 2009 at 4:04 pm
    Dec 29, 2009 at 9:05 pm
  • Hi Not sure what I am doing wrong. I am not getting all the required rpms for the Postgres version 8.4.2. ============= http://rpm.pbone.net/ Your query postgresql-devel-8.4.2 did not match any entry ...
    Phoenix KiulaPhoenix Kiula
    Dec 22, 2009 at 1:22 pm
    Dec 23, 2009 at 11:24 am
  • Hi! I have a software that uses Postgresql. This program (and website) developed and working on Window (XP/2003), with native charset (win1250). Prior week we got a special request to install this ...
    Dec 18, 2009 at 12:30 pm
    Dec 22, 2009 at 9:59 am
  • I have an index scan on a custom function that is returning a wildly incorrect row estimate that is throwing off the rest of the query planning. The result of the function is roughly unique - there ...
    Michael ForkMichael Fork
    Dec 29, 2009 at 5:15 pm
    Dec 30, 2009 at 5:29 am
  • Is there a command or reliable method of finding the location of the PostgreSQL bin path? I'm currently using "SHOW hba_file;" which gives me the data path. For default installs I can find the bin ...
    Rob JaegerRob Jaeger
    Dec 25, 2009 at 5:02 pm
    Dec 28, 2009 at 12:31 am
  • Does it write data to data files to make buffer "clean"?if it does ,but I can not find open files from the result of lsof -p PID.
    Dec 22, 2009 at 10:41 am
    Dec 24, 2009 at 12:06 pm
  • Hi, I need to know if there is something like Oracle Forms in the Open Source world that works with PostgreSQL. If do you know something, please let me know. Best Regards, André.
    Andre LopesAndre Lopes
    Dec 20, 2009 at 9:13 pm
    Dec 21, 2009 at 5:55 pm
  • I have a big table that is used for datalogging. I'm designing graphing interface that will visualise the data. When the user is looking at a small daterange I want the database to be queried for all ...
    Dec 4, 2009 at 5:32 am
    Dec 21, 2009 at 3:52 pm
  • Hi all. I'm planning to implement table partitioning as "suggested" (among other sources) in the official documentation. I'm using v8.4.2 at the moment. My case is far from the general one as: 1. ...
    Vincenzo RomanoVincenzo Romano
    Dec 17, 2009 at 12:10 pm
    Dec 18, 2009 at 7:46 am
  • When I cast an integer to numeric using :: notation it ignores the scale and precision that I specify, but when I use the cast function it uses the scale and precision that I specify. Sim select ...
    Sim ZacksSim Zacks
    Dec 3, 2009 at 10:03 am
    Dec 6, 2009 at 3:10 pm
  • I am getting many entries in my log of this type: 2009-12-01 00:13:19 GMTLOG: unexpected EOF on client connection 2009-12-01 00:13:19 GMTLOG could not receive data from client: No connection could be ...
    Howard ColeHoward Cole
    Dec 1, 2009 at 3:50 pm
    Dec 4, 2009 at 2:05 pm
  • Dear sir, I work as a new DBA in postgresql, please recommend some good books, website for tutorial. thanks Shu Hotmail: Powerful Free email with security by Microsoft. ...
    Shu HoShu Ho
    Dec 31, 2009 at 11:11 pm
    Jan 7, 2010 at 6:59 pm
  • When making a backup of my database I run out of space. I tell it to put the backup file on my K: drive, which has tons of free space, but during the backup postgresql creates a temporary folder on ...
    Farhan MalikFarhan Malik
    Dec 25, 2009 at 2:27 pm
    Dec 26, 2009 at 2:29 am
  • I just ran something like: ============================================= UPDATE my_table SET colname = NULL WHERE colname ~ '^\s*$' ============================================= I got the following ...
    Patrick M. RutkowskiPatrick M. Rutkowski
    Dec 23, 2009 at 8:12 pm
    Dec 24, 2009 at 11:59 am
  • On behalf of the core team, I'm pleased to announce that the PostgreSQL Project has expanded it's team of "committers", those people who are able to make direct changes to the PostgreSQL source code ...
    Dave PageDave Page
    Dec 7, 2009 at 10:49 am
    Dec 21, 2009 at 9:04 pm
  • Hi, I'm trying to write a very simple function statement to select a single integer field from a table and save it into an int array. For some reason I can't seem to find the correct syntax: CREATE ...
    Postgres UserPostgres User
    Dec 19, 2009 at 1:14 am
    Dec 21, 2009 at 3:29 pm
  • Hi, I am regularly altering tables, adding columns setting default values etc. This very often takes a very long time and is very disk intensive, and this gets pretty annoying. Things are hampered by ...
    Antonio Goméz SotoAntonio Goméz Soto
    Dec 17, 2009 at 10:14 pm
    Dec 20, 2009 at 9:02 pm
  • Hi As Pg doesn't presently support client push for notifications arising from LISTEN/NOTIFY, I'm wondering if anybody here has done any research into the cheapest statement to issue to check for such ...
    Craig RingerCraig Ringer
    Dec 10, 2009 at 1:23 pm
    Dec 19, 2009 at 7:25 am
  • I'm new to both pgsql and SQL in general pas really simple stuff, so i would like to know how to; Given a table with a column that can have one of NULL, (char) N, (char) A, and (char) L. Is there a ...
    Dec 8, 2009 at 7:06 pm
    Dec 16, 2009 at 6:33 pm
  • I installed postgresql by pacman (i'm using an ArchLinux Distr) the default encoding of template1 is SQL_ASCII, i want to change this one with UTF8 encoding i try to use ALTER DATABASE but this ...
    Dec 12, 2009 at 1:36 pm
    Dec 13, 2009 at 3:07 pm
  • Hi, I use OpenOffice Base as the front end tool to connect a postgreSQL server. It works great. But when I am trying to create a table by copying data from OpenOffice Calc and then pasting to my ...
    Le-shin WuLe-shin Wu
    Dec 1, 2009 at 3:21 pm
    Dec 2, 2009 at 8:04 pm
  • You've installed Postgres Plus Standard Server, not the PostgreSQL one-click installer. The easiest way to just get libpq and the supporting libraries would be from the tarball distros: ...
    Dave PageDave Page
    Dec 1, 2009 at 9:01 am
    Dec 2, 2009 at 10:39 am
  • FOSDEM (http://www.fosdem.org/2010/) is a major Free and Open Source event held annually in Brussels, Belgium, and attended by around 4000 people. As in recent years, the PostgreSQL project will have ...
    Dave PageDave Page
    Dec 5, 2009 at 4:16 pm
    Dec 21, 2009 at 8:44 am
  • Hi,guys.I am a student who want to study PostgreSQL.I encountered the following errors which I don't know how to fix while I using eclipse to built pgsql: " ../src/port/getaddrinfo.c:360: error: ...
    Dec 13, 2009 at 7:52 am
    Dec 16, 2009 at 10:53 pm
  • Does anyone know of a replication solution that can handle large objects? Preferrably on a per database rather than per cluster basis. Incidentally - out of interest - why doesn't Slony handle large ...
    Howard ColeHoward Cole
    Dec 2, 2009 at 2:22 pm
    Dec 12, 2009 at 10:21 am
  • Hi, We have started using PostGreSQL for more than 3 months and it looks awesome. Currently, we have been suing superuser by default as login account. Now, the users are getting increased and we want ...
    Dipti shahDipti shah
    Dec 10, 2009 at 7:30 am
    Dec 10, 2009 at 4:27 pm
  • Hello all, I'm trying to do a crosstab from data that row names are times. These times are timestamps and i want to use they truncating to minutes this works for me: select distinct ...
    José María Terry JiménezJosé María Terry Jiménez
    Dec 5, 2009 at 8:55 pm
    Dec 6, 2009 at 4:34 pm
  • Hi, I'm trying to create a rule to be applied on update to a view that consists of two joined tables. Table 'shoes' below is left-joined with table 'shoelaces' in the view 'footwear'. I'd like to ...
    Dec 31, 2009 at 1:39 am
    Jan 9, 2010 at 6:21 am
  • Hi folks Now that column privileges are supported (fantastic!), I've been looking at replacing some of my unpleasantly verbose (and probably error-prone) trigger code that's responsible for limiting ...
    Craig RingerCraig Ringer
    Dec 14, 2009 at 4:25 am
    Jan 6, 2010 at 6:07 am
  • Hi all - I have postgres running on 2 servers. one production and one testing. What would be the best way to compare the 2 database, so find out the differences? Can you please advice? regards
    Akp geekAkp geek
    Dec 29, 2009 at 4:44 pm
    Jan 2, 2010 at 10:13 pm
Group Navigation
period‹ prev | Dec 2009 | next ›
Group Overview
grouppgsql-general @

286 users for December 2009

Tom Lane: 93 posts Scott Marlowe: 56 posts Craig Ringer: 49 posts Adrian Klaver: 48 posts John R Pierce: 30 posts Greg Smith: 29 posts Merlin Moncure: 26 posts Dave Page: 18 posts Gauthier, Dave: 16 posts Albe Laurenz: 15 posts Pavel Stehule: 15 posts Alvaro Herrera: 14 posts Richard Broersma: 14 posts Alex -: 13 posts Nick: 13 posts Bruce Momjian: 12 posts Howard Cole: 12 posts Andreas Kretschmer: 11 posts Alban Hertroys: 10 posts Guillaume Lelarge: 10 posts
show more