FAQ

PostgreSQL > pgsql-general > April 2010

Search Discussions

225 discussions - 1,172 posts

  • Hi, I have been trying to install 8.4 on my Vista without success. Earlier I'd tried to install 8.3 and that failed too. I tried installing these on other Vista machines and they failed too. I ...
    Nikhil G. DaddikarNikhil G. Daddikar
    Apr 1, 2010 at 2:36 am
    Apr 7, 2010 at 7:41 am
  • I think I know what I plan to do, but want to throw this out there to see if there are differing points of view. I have a mailing list table, and 2 of the columns contain values which have to be from ...
    Thom BrownThom Brown
    Apr 21, 2010 at 7:01 pm
    May 4, 2010 at 2:50 pm
  • Hi all. I'm wondering how efficient the inheritance can be. I'm using the constraint exclusion feature and for each child table (maybe but one) I have a proper CHECK constraint. How efficient can the ...
    Vincenzo RomanoVincenzo Romano
    Apr 26, 2010 at 7:46 am
    May 1, 2010 at 11:08 am
  • I believe v9 will have native DB master/slave DB replication (correct if wrong). If so, what's the best guess on when will v9 be released? Thanks!
    Gauthier, DaveGauthier, Dave
    Apr 30, 2010 at 6:27 pm
    May 3, 2010 at 7:13 pm
  • Hello, I have a web application where users upload/share files. After file is uploaded it is copied to S3 and all subsequent downloads are done from there. So in a file's lifetime it's accessed only ...
    RodRod
    Apr 27, 2010 at 8:42 am
    Apr 29, 2010 at 7:45 pm
  • I have compiled some C (pljava.c) for solaris sparc 64 bit, setup the LD_LIBRARY_PATH so postgres can find it, and try and load it. me=# CREATE FUNCTION sqlj.java_call_handler() RETURNS ...
    John R PierceJohn R Pierce
    Apr 16, 2010 at 2:32 am
    Apr 21, 2010 at 7:00 pm
  • I have a query which is not giving me the result even after 30 minutes. I want to know how to detect what is going and what's wrong ? EXPLAIN query - gives me the following: controlsmartdb=# explain ...
    Satish Burnwal (sburnwal)Satish Burnwal (sburnwal)
    Apr 13, 2010 at 12:58 pm
    Apr 15, 2010 at 1:35 pm
  • Dear All Experts, I am using in PostgreSQL 8.3.5 database on windows 64 bit OS. However, I have a batch program written in Java which processes the data and populates them into tables in Postgres ...
    A BhattacharyaA Bhattacharya
    Apr 27, 2010 at 8:27 am
    Apr 29, 2010 at 11:57 pm
  • I enter the identical command: select * from mesh_descriptors; using the psql command line and it works perfectly. The same command in a file produces an immediate syntax error: EFNWeb=# \i ...
    John GageJohn Gage
    Apr 21, 2010 at 10:07 pm
    Apr 25, 2010 at 1:01 am
  • hi, Today is my first day looking at PostgreSQL I am looking to migrate a MS SQL DB to PostgreSQL :) :) My customer requires that DBMS shall support 4000 simultaneous requests Also the system to be ...
    Jaime RodriguezJaime Rodriguez
    Apr 29, 2010 at 1:14 am
    Apr 30, 2010 at 2:07 am
  • The tarball for 64bit 8.4.3 on Solaris Sparc is missing some ./pgxs/... files I seem to need to build pl/java. they exist in the 32bit version but at least of them, Makefile.global, appears quite ...
    John R PierceJohn R Pierce
    Apr 15, 2010 at 5:00 pm
    Apr 16, 2010 at 1:34 am
  • Following a great deal of discussion, I'm pleased to announce that the PostgreSQL Core team has decided that the major theme for the 9.1 release, due in 2011, will be 'NoSQL'. There is a growing ...
    Dave PageDave Page
    Apr 1, 2010 at 8:13 am
    Apr 1, 2010 at 5:26 pm
  • Dear all, I've a problem but I search all the help file and can't find the solution. I want to track all action of a specify role on all or one schema in database. Can you help me? Thanks a lot and ...
    Đỗ Ngọc Trí CườngĐỗ Ngọc Trí Cường
    Apr 19, 2010 at 2:25 am
    May 4, 2010 at 12:23 am
  • If I open a bash terminal and type createlang -l, I get: JohnGage:~ johngage$ createlang -l -bash: createlang: command not found JohnGage:~ johngage$ psql -bash: psql: command not found as one can ...
    John GageJohn Gage
    Apr 25, 2010 at 9:08 am
    Apr 27, 2010 at 9:57 am
  • Dears, Sorry to be a royal pain, but I cannot find it anywhere in the documentation: how many threads/CPU cores Postgres v. 8.4 can utilise? We're thinking about installing Postgres on a virtual ...
    Piotr KublickiPiotr Kublicki
    Apr 28, 2010 at 9:22 am
    Apr 30, 2010 at 2:17 pm
  • Hello, I'm writing a SRF following the example from http://www.postgresql.org/docs/8.4/interactive/xfunc-c.html (section 34.9.10). In the example, in the code executed in first call, we get the ...
    Jorge ArevaloJorge Arevalo
    Apr 28, 2010 at 4:26 pm
    Apr 30, 2010 at 8:25 am
  • Hi all - I would like to know, if there is a open source BI tool for creating reports against Postgres database ? appreciate your help Regards
    Akp geekAkp geek
    Apr 27, 2010 at 4:33 pm
    Apr 27, 2010 at 8:54 pm
  • Hello, At the moment, users of my application, which runs on 8.4.3, may search for products in a way that is implemented roughly like this: SELECT * FROM products WHERE description ILIKE ...
    Peter GeogheganPeter Geoghegan
    Apr 5, 2010 at 7:10 pm
    Apr 14, 2010 at 1:37 am
  • Hi all, Monitoring "top" in database server , i could noticed an query with reserved 8GB on physical memory. select count(field) from big_table 1 inner join big_table2... There is the possibility of ...
    Paulo matadrPaulo matadr
    Apr 7, 2010 at 2:11 pm
    Apr 7, 2010 at 5:13 pm
  • Hi chaps, I've just upgraded a server from 8.3 to 8.4, and when trying to use the parallel restore options I get the following error: "pg_restore: [custom archiver] dumping a specific TOC data block ...
    Glyn AstillGlyn Astill
    Apr 30, 2010 at 9:53 am
    May 21, 2010 at 12:20 pm
  • Hello, Redhat EL4 update 8, 2.6.9-89.0.23.ELsmp Quad Proc, Dual Core Xeon, 16GB RAM Postgres 8.1.18 I'm having some trouble pinning down exactly what is causing our Postgres cluster to run slowly. ...
    Justin PasherJustin Pasher
    Apr 23, 2010 at 9:02 pm
    May 20, 2010 at 10:11 pm
  • I have downloaded the one click installer on Vista. I right click on the executable and select run as administrator, and an empty dialog box appears. This is as far as I can go. Any suggestions?
    Watson, NathanielWatson, Nathaniel
    Apr 21, 2010 at 5:20 pm
    Apr 23, 2010 at 5:52 pm
  • Hi, could anyone please tell me what is wrong in below query. Does it mean that EXCEPT doesn't allow comparing TIMESTAMP type? techdb=# INSERT INTO changelogtest (id, txid, txtime) values (5, 123, ...
    Dipti shahDipti shah
    Apr 23, 2010 at 10:32 am
    Apr 23, 2010 at 2:32 pm
  • Hello, Im here because Oleg Bartunov invite me to this mailing list. Im searching for help with ltree module, in todo list (in this module) is Better documentation, since 2003 year, no one make ...
    CojackCojack
    Apr 19, 2010 at 7:38 am
    Apr 20, 2010 at 8:25 pm
  • Dear All, How to insert encoded data that is(/\_+@#$%^&*)(_+) something like that....I have Csv file .Which contains encoded values.when i try to insert those. I am getting error..I am not able to ...
    VenkatVenkat
    Apr 14, 2010 at 10:52 am
    Apr 20, 2010 at 3:10 pm
  • hi i've got the database (about 300G) and it's still growing. i am inserting new data (about 2G/day) into the database (there is only one table there) and i'm also deleting about 2G/day (data older ...
    Jan KrcmarJan Krcmar
    Apr 14, 2010 at 2:01 pm
    Apr 16, 2010 at 9:33 am
  • is pl/java kind of dead? I don't see much activity since years ago. I note the pgfoundry page, http://pgfoundry.org/projects/pljava/?readme the link to the project home page ...
    John R PierceJohn R Pierce
    Apr 14, 2010 at 4:52 am
    Apr 15, 2010 at 4:39 pm
  • I am using Postgres 8.4.1 on Windows XP Professional Service Pack 3. I have a PL/pgSQL function which is defined as "returns record". The record contains three values. In one execution path, the ...
    Alan MillingtonAlan Millington
    Apr 9, 2010 at 10:46 am
    Apr 15, 2010 at 2:20 pm
  • Hi All, Please find the below scenario, and suggest me... Trying to start the server, but not starting. ---------------------------------------------------------- [postgres@dbarhel564 mypg]$ pg_ctl ...
    Raghavendra tRaghavendra t
    Apr 14, 2010 at 5:27 am
    Apr 14, 2010 at 2:57 pm
  • Dear list, I have some data (big size) and I've written a long function in pl/pgsql which processes the data in several steps. At a test run my function aborted because of memory exhaustion. My guess ...
    Birgit LaggnerBirgit Laggner
    Apr 1, 2010 at 10:30 am
    Apr 12, 2010 at 1:09 pm
  • Hi, I have a simple table that has indexes on 2 integer columns. Data is inserted very often (no updates, no deletes, just inserts): at least 4000/5000 rows per second. The input for the 2 indexed ...
    Leonardo FLeonardo F
    Apr 19, 2010 at 4:30 pm
    May 6, 2010 at 12:27 pm
  • Hi all, I've installed Postgres with few instances/clusters, however I've got a problem with start-up scripts for all clusters. As far as I know the file postgresql should be modified in the ...
    Eustace ScrubbEustace Scrubb
    Apr 26, 2010 at 11:45 am
    Apr 29, 2010 at 3:01 pm
  • I'm trying the following: ship_date between '04/30/2010' AND '04/30/2010' + 14 But this returns: ERROR: invalid input syntax for integer: "04/30/2010" Can I use between with dates? -- Geoffrey Myers ...
    Geoffrey MyersGeoffrey Myers
    Apr 29, 2010 at 2:02 pm
    Apr 29, 2010 at 2:58 pm
  • Hi, I need some advice about a subject. I generate e-mail messages to a database table and then with a CronJob I sent the e-mails. My doubt is... The CronJob runs every 10 minutes, but If I have ...
    Andre LopesAndre Lopes
    Apr 21, 2010 at 9:01 am
    Apr 22, 2010 at 12:39 am
  • Hi all, I have a table with three columns: one integer and two doubles. There are two indexes defined (one on the integer and one on one of the doubles). This table stores 700000 records, which take ...
    Peter BexPeter Bex
    Apr 16, 2010 at 9:43 am
    Apr 20, 2010 at 9:07 am
  • Hi all. We had a crisis this week that was resolved by tuning pg_autovacuum for a particular table. The table is supposed to contain a small number of items at any given point in time (typically ...
    Herouth MaozHerouth Maoz
    Apr 14, 2010 at 9:08 am
    Apr 14, 2010 at 7:31 pm
  • In 8.3 code below causes exception ERROR: set-valued function called in context that cannot accept a set CONTEXT: PL/pgSQL function "wordwrap" line 21 at RETURN NEXT How to fix this so that wordwrap ...
    AndrusAndrus
    Apr 5, 2010 at 11:14 am
    Apr 5, 2010 at 5:34 pm
  • I want a column in my Users table that will keep track of which types of notifications the user wants to subscribe to. There's probably about 10 different types, so I don't want to have 10 boolean ...
    Mike ChristensenMike Christensen
    Apr 30, 2010 at 9:02 am
    May 2, 2010 at 11:59 am
  • Hello, Many thanks to andreas.kretschmer for this helpful reply about how to set up a window function to perform a running total: http://archives.postgresql.org/pgsql-general/2010-03/msg01122.php It ...
    Oliver KohllOliver Kohll
    Apr 29, 2010 at 8:53 am
    Apr 30, 2010 at 10:07 am
  • Dear All Experts, We have a java exe making a call to a postgres function. This postgres function internally makes a call to a dll (which is written using Postgres extended C). Now the issue is that, ...
    A BhattacharyaA Bhattacharya
    Apr 29, 2010 at 11:35 am
    Apr 30, 2010 at 6:59 am
  • Hi All - I have a table bloated with following details rows:29431 pages:516039 shouldbe:534 (966.4X) wasted size:4223016960 (3 GB) * I did a vacuum on the database and also I did vacuumdb full on the ...
    Akp geekAkp geek
    Apr 26, 2010 at 2:43 pm
    Apr 26, 2010 at 6:56 pm
  • Hi, I hope someone can help me. When running psql from the command line with the PGHOST environment variable or the -h command line host set, it throws a segmentation fault. $ psql -U morgan -d cid ...
    Morgan TaschukMorgan Taschuk
    Apr 22, 2010 at 5:32 pm
    Apr 23, 2010 at 10:53 am
  • Hi, Is there a way to run Postgres in embedded mode? More precisely, to run it without using TCP/IP port, and without installing as a service? I am aware of Unix-domain sockets, but is there ...
    Ognjen BlagojevicOgnjen Blagojevic
    Apr 21, 2010 at 3:09 pm
    Apr 22, 2010 at 5:13 pm
  • I have a ques - say I have a table that has 10 columns. But in a simple select query from that table, I use just 3 columns. I want to know whether even for fetching 3 columns, read happens for all ...
    Satish Burnwal (sburnwal)Satish Burnwal (sburnwal)
    Apr 16, 2010 at 6:06 am
    Apr 16, 2010 at 12:31 pm
  • Hi, I have granted ALL permissions on 'techtable' to 'user1'. techdb=# select pc.relname, pc.relacl from pg_class pc, pg_namespace pn where pc.relnamespace=pn.oid and pn.nspname='techdb' and ...
    Dipti shahDipti shah
    Apr 15, 2010 at 7:50 am
    Apr 16, 2010 at 12:13 pm
  • Hi, I have a trigger that runs in my Development machine but not in my Production machine. the code is the following: [code] CREATE OR REPLACE FUNCTION "aprtr_geraemail_agcompagamento" () RETURNS ...
    Andre LopesAndre Lopes
    Apr 14, 2010 at 1:03 pm
    Apr 15, 2010 at 7:47 am
  • Dear all - Can you please help me with this? Is there a way to restore multiples ( more than one table ) using a single command from a whole database dump that was created using pg_dump regards
    Akp geekAkp geek
    Apr 14, 2010 at 2:56 pm
    Apr 14, 2010 at 4:45 pm
  • Hi, from postgesql features list mentioned at http://www.postgresql.org/about/press/features84.html, I came to know that it is possible to grant column level permissions. PostgreSQL is "the most ...
    Dipti shahDipti shah
    Apr 8, 2010 at 8:22 am
    Apr 8, 2010 at 11:58 am
  • Hi all, I'm trying to write my first plpgsql function and I'm running into a problem that may or may not have to do with a coalesce statement. I wrote a very similar sql function that does basically ...
    Jeff RossJeff Ross
    Apr 25, 2010 at 6:13 pm
    Apr 25, 2010 at 11:35 pm
  • What is the expected performance impact of the log streaming replication in 9.0? In the past I've used the log shipping replication of MySQL and it caused the performance of the master to drop by ...
    AndyAndy
    Apr 20, 2010 at 9:16 pm
    Apr 22, 2010 at 6:40 pm
Apr 2010
12345
Group Navigation
period‹ prev | Apr 2010 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions225
posts1,172
users267
websitepostgresql.org
irc#postgresql

267 users for April 2010

Tom Lane: 76 posts John R Pierce: 47 posts Craig Ringer: 45 posts Scott Marlowe: 38 posts Greg Smith: 31 posts John Gage: 30 posts Merlin Moncure: 28 posts Dipti shah: 21 posts Alban Hertroys: 20 posts Akp geek: 19 posts Alvaro Herrera: 19 posts Bruce Momjian: 18 posts Dave Page: 18 posts Raghavendra t: 17 posts Andre Lopes: 15 posts Magnus Hagander: 15 posts Raymond O'Donnell: 14 posts Bill Moran: 13 posts Scott Mead: 13 posts Thom Brown: 13 posts
show more
Archives