Search Discussions

219 discussions - 1,154 posts

  • With 9.0 there is the new hex encoding for BYTEA, which is activated by default. libpq BEFORE 9.0 are not able to decode that encoding. I am programming with Python, using psycopg2. When psycopg2 is ...
    Massa, Harald ArminMassa, Harald Armin
    Oct 5, 2010 at 7:33 am
    Dec 14, 2010 at 4:56 pm
  • For reasons I do not understand, the Slackware start-up file for postgres (/etc/rc.d/rc.postgresql) fails to work properly after I reboot the system. (Reboots normally occur only after a kernel ...
    Rich ShepardRich Shepard
    Oct 20, 2010 at 10:53 pm
    Oct 21, 2010 at 8:20 pm
  • My production server is running Postgres 9.0 on Ubuntu Server, and I'm getting some errors in sprocs that call uuid_generate_v1().. This is because the function is missing. On my Windows box, this ...
    Mike ChristensenMike Christensen
    Oct 7, 2010 at 1:18 am
    Oct 25, 2010 at 12:26 pm
  • I have a very simple update query. update cu set screenshot_file_name = tu.screenshot_file_name, screenshot_content_type = tu.screenshot_content_type, screenshot_file_size = tu.screenshot_file_size, ...
    Tim UckunTim Uckun
    Oct 21, 2010 at 2:24 am
    Oct 22, 2010 at 10:03 pm
  • Hello Postgres users, to mimic the MySQL-REPLACE statement I need to try to UPDATE a record and if that fails - INSERT it. But how can I detect that the UPDATE has failed in my SQL procedure? begin ...
    Alexander FarberAlexander Farber
    Oct 31, 2010 at 8:22 am
    Nov 2, 2010 at 5:14 pm
  • I have MinGW installed and I've unpacked the pg 9.0 source files which now reside in the following path: * C:\Program Files\postgresql-9.0.0 In Chapter 15.5 of the 9.0 manual, the installation ...
    Turner, John JTurner, John J
    Oct 15, 2010 at 9:13 pm
    Oct 25, 2010 at 3:43 pm
  • OK so I have read the docs and Google to try and find a way to add a new column to an existing table. My problem is I need this new column to be created 3rd rather than just dumping this new column ...
    Carlos MennensCarlos Mennens
    Oct 13, 2010 at 10:09 pm
    Oct 14, 2010 at 3:09 pm
  • Just wondering how you guys feel about NoSQL and I just wanted to share the following article... http://www.linuxjournal.com/article/10770 Looking to read your feedback and / or opinions. -Carlos
    Carlos MennensCarlos Mennens
    Oct 11, 2010 at 11:46 pm
    Oct 19, 2010 at 5:48 pm
  • Hi, today I noticed that in the documentation there is DROP INDEX CASCADE. I've got one question: what is that for? What can depend on index? regards Szymon
    Szymon GuzSzymon Guz
    Oct 26, 2010 at 8:13 am
    Nov 3, 2010 at 10:15 am
  • Hello, I'm trying to create a table, where md5 strings will serve as primary keys. So I'd like to add a constraing that the key length should be 32 chars long (and contain [a-fA-F0-9] only): create ...
    Alexander FarberAlexander Farber
    Oct 16, 2010 at 4:20 pm
    Oct 17, 2010 at 4:43 pm
  • I know I've seen posts on how to do this, but i can't seem to find them. I've got a data set A, B A, C A, D [...] and so on and i'd like to be able to wite a query that would result in 1,A,B 2,A,C ...
    David KerrDavid Kerr
    Oct 20, 2010 at 10:22 pm
    Oct 22, 2010 at 12:36 am
  • I know that MySQL uses MyISAM storage engine by default and was just trying to look on Google to try and see if I could understand what storage engine does PostgreSQL use by default when I generate a ...
    Carlos MennensCarlos Mennens
    Oct 8, 2010 at 9:30 pm
    Oct 13, 2010 at 2:39 pm
  • I have a web application with a Postgres backend. In my initial prototype, I decided not to have a Postgres database user created for each application user, opting instead to use my own users table. ...
    Tony CebzanovTony Cebzanov
    Oct 21, 2010 at 4:02 pm
    Oct 27, 2010 at 10:15 am
  • Folks, Postgree is the most amazing DB, even more it will be the only one that will remain free (the good ones) as MySQL has been taken. In order to move on with this project, as an Java Senior ...
    Mauricio ChamatiMauricio Chamati
    Oct 19, 2010 at 2:13 pm
    Oct 20, 2010 at 6:29 pm
  • A customer was reviewing the database that supports the application we have provided. One of the tables is very simple, but has over 16 million records. Here is the table's definition: CREATE TABLE ...
    Rob RichardsonRob Richardson
    Oct 29, 2010 at 8:52 pm
    Oct 31, 2010 at 6:22 am
  • Hello Postgres Hackers, We have a simple 'event log' table that is insert only (by multiple concurrent clients). It has an integer primary key. We want to do incremental queries of this table every 5 ...
    Karl PickettKarl Pickett
    Oct 29, 2010 at 2:04 am
    Oct 31, 2010 at 3:27 am
  • Okay my required n00b question of the week, hopefully this'll be an easy one.. I decided to give pgAgent a shot, because there's this stored sproc (sorry, function) I need to run nightly and I think ...
    Mike ChristensenMike Christensen
    Oct 17, 2010 at 2:39 pm
    Oct 18, 2010 at 10:45 am
  • CHAR(20) columns in 8.4 database may contains spaces and - signs like 13-333-333 12 3-44 33 33 333 12345 User enters code to search without spaces and - signs, like 12344 How to search for product ...
    Oct 13, 2010 at 8:42 pm
    Oct 14, 2010 at 11:23 am
  • Hi all, We're currently testing a new javascript change on the PostgreSQL docs. This is to make sure monospaced fonts still appear at a reasonable size between browsers. I'd appreciate it if some of ...
    Thom BrownThom Brown
    Oct 4, 2010 at 6:41 pm
    Oct 6, 2010 at 2:49 pm
  • Some one know how to solve the problem of db that became huge from 700 Mbyte to 16 Gbyte in 10 days and grow... Vacuum doesn't solve the problem. Only vacuum full is too invasive, the only way to ...
    Oct 26, 2010 at 9:22 pm
    Oct 28, 2010 at 1:38 pm
  • Hi, The quick question is: How (if possible) can I do to get data (maybe through xlogs) from two separate databases and merge them into one? For those that want to know my situation, here it is: I ...
    Daniel CrespoDaniel Crespo
    Oct 27, 2010 at 2:00 pm
    Oct 28, 2010 at 8:03 pm
  • Hello everyone. I have been investigating the PG async calls and trying to determine whether I should go down the road of using them. In doing some experiments I found that using ...
    Michael ClarkMichael Clark
    Oct 27, 2010 at 9:02 pm
    Oct 28, 2010 at 5:52 pm
  • Defaulting bytea output from the backend to use hex mode encoding, which is incompatible with pre-9.0 interfaces, wasn't a friendly thing to do. The default should have been escape mode. Or else you ...
    Oct 13, 2010 at 1:05 am
    Oct 22, 2010 at 10:24 pm
  • Hi, I'm trying to require SSL for Postgres connections from certain IPs.. This is on Postgres 9.0. First, I've followed the directions at: http://www.postgresql.org/docs/9.0/static/ssl-tcp.html I've ...
    Mike ChristensenMike Christensen
    Oct 10, 2010 at 3:53 am
    Oct 11, 2010 at 6:34 pm
  • Is there any tutorials or detailed instructions on how to set up HA postgresql & failover? The documentation (http://www.postgresql.org/docs/9.0/interactive/warm-standby-failover.html) on this topics ...
    Oct 7, 2010 at 6:27 am
    Oct 7, 2010 at 6:10 pm
  • Hello Postgres users, I have a Linux website with phpBB serving a small Facebook game: # uname -a Linux XXXXX 2.6.18-194.17.1.el5 #1 SMP Wed Sep 29 12:50:31 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux # ...
    Alexander FarberAlexander Farber
    Oct 4, 2010 at 9:20 am
    Oct 4, 2010 at 7:08 pm
  • We are using both DB2 and PostgreSQL at work and DB2 has a nice tool, i5 Navigator, where one can enable logging of SQL statements and then it will recommed indexes that should/could be created to ...
    Bjørn T JohansenBjørn T Johansen
    Oct 1, 2010 at 10:11 am
    Oct 1, 2010 at 3:24 pm
  • Hi there, I have a database with statistical tables which look like this: id | year_start | value 3 1960 736.1 3 1961 723.3 .... 4 1960 123.4 Years can cover 40 years for each of the countries (ID) ...
    Stefan SchwarzerStefan Schwarzer
    Oct 19, 2010 at 10:15 am
    Nov 4, 2010 at 7:00 am
  • Composite Index question: I have composite index on 3 columns on a table, by mistake the composite index was created twice on the table. Will there any performance issues on this table because of the ...
    Oct 20, 2010 at 11:44 pm
    Oct 21, 2010 at 6:08 pm
  • Hello all, I'm experiencing a weird issue where my postgresql is creating strange files (all with the same size ~200MB) under /var/lib/pgsql. The filenames are like "?" and "?default". Anyone knows ...
    Juan SueiroJuan Sueiro
    Oct 7, 2010 at 1:46 pm
    Oct 8, 2010 at 12:14 pm
  • I have two tables. Table C has about 300K records in it. Table E has about a million records in it. Today I tried to run this query. update C set result_count = X.result_count from C inner join ...
    Tim UckunTim Uckun
    Oct 5, 2010 at 9:20 am
    Oct 5, 2010 at 9:06 pm
  • Dear List, Firstly thanks to the postgresql global development team for releasing postgresql with such a great enterprise feature of SR & HS. As an enduser i setup SR based on ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Oct 2, 2010 at 4:02 pm
    Oct 5, 2010 at 10:16 am
  • Hi, I have some issue where SELECT * from pg_stat_activity WHERE current_query='<IDLE '; returns too many rows . What is the meaning of IDLE ? I suspect that the server is overloaded with idle ...
    Georgi IvanovGeorgi Ivanov
    Oct 6, 2010 at 1:26 pm
    Feb 12, 2011 at 11:36 pm
  • Hi, i have very big XML documment which is larger than 50GB and want to import it into databse, and transform it to relational schema. When splitting this documment to smaller independent xml ...
    Viktor BojovićViktor Bojović
    Oct 30, 2010 at 9:48 pm
    Dec 29, 2010 at 8:58 am
  • Dear All, I want to convert integer datatype to serial datatype.. is that possible.Please let me know. Thanks and Regards, Ven
    Oct 29, 2010 at 4:49 am
    Oct 29, 2010 at 5:30 am
  • Hello I have a master PG 8.1.11 sending WAL files to a cold-standby using rsync For some reason it failed recently with "return codes 32512" and I couldn't find this num. as a valid rsync exit code ...
    Zhong ming wuZhong ming wu
    Oct 23, 2010 at 12:01 pm
    Oct 26, 2010 at 1:29 am
  • Is there a way to select the top 10% of the values from a column? For example the top 10% best selling items where number of sales is a column. Thanks.
    Tim UckunTim Uckun
    Oct 17, 2010 at 11:34 pm
    Oct 18, 2010 at 3:23 am
  • I have a large Postgres DB (1100 GB) that I'd like to move to a new physical machine. In the past I've done this via pg_dump & restore, but the DB was much smaller then, and I'm concerned about how ...
    Oct 13, 2010 at 4:30 pm
    Oct 14, 2010 at 3:44 pm
  • MayVACUUM FULL on a table improve perfromance of the system?
    AI RummanAI Rumman
    Oct 7, 2010 at 11:38 am
    Oct 7, 2010 at 2:23 pm
  • Hi everyone, I'm trying to take a base backup of my primary DB ready for copying to my standby. I've followed the instructions to configure my postgresql.conf at ...
    Oct 28, 2010 at 11:42 am
    Oct 28, 2010 at 2:38 pm
  • Hi, Here is my problem: I have a postgresql C function that looks like this: Datum filter(PG_FUNCTION_ARGS); It takes identifiers and queries a bunch of tables and ends up returning true or false. So ...
    Gabi JulienGabi Julien
    Oct 21, 2010 at 12:04 am
    Oct 21, 2010 at 5:58 pm
  • Steps to reproduce: 1. Ran latest pgAdmin in windows server 2005 Standard x64 Edition 2. Restore data to Postgres 9.0 linux server from 450 MB backup file if only SSL connection is enabled After some ...
    Andrus MoorAndrus Moor
    Oct 2, 2010 at 8:30 pm
    Oct 21, 2010 at 2:05 pm
  • Hi List, Is there any feature to drop the view with out cascading the dependents. Below is my requirement. I have a view which is dependent on the other view/table. I wanted to drop the view ...
    Ravi KatkarRavi Katkar
    Oct 19, 2010 at 5:53 am
    Oct 20, 2010 at 3:02 pm
  • Hello, i'm using initdb of an PostgreSQL 8.4 installed over the port-system of FreeBSD: ===== --lc-ctype=de_DE.UTF-8 --lc-messages=de_DE.UTF-8 --lc-monetary=de_DE.UTF-8 --lc-numeric=de_DE.UTF-8 ...
    Torsten ZühlsdorffTorsten Zühlsdorff
    Oct 18, 2010 at 2:53 pm
    Oct 19, 2010 at 2:03 pm
  • Is it possible to get the results of this snip of a function without using a function? All tables include an id and title column. tables := ARRAY[table_one,table_two,table_three]::VARCHAR; CREATE ...
    Oct 14, 2010 at 11:53 pm
    Oct 16, 2010 at 4:10 am
  • Hi, I have the following table: CREATE TABLE A ( a1 integer not null, a2 integer, a3 integer, a4 integer ) and have the following four indices: create index ind_a1 on A USING gist(a1); create index ...
    Oct 12, 2010 at 10:03 pm
    Oct 13, 2010 at 3:31 pm
  • While compiling PostgreSQL-9.0.0 on HP-UX/ia64 (B.11.23) gmake breaks up with the next errors: ..... gmake -C libpq all gmake[3]: Entering directory ...
    Derk Jan HorstmanDerk Jan Horstman
    Oct 4, 2010 at 1:58 pm
    Oct 12, 2010 at 9:25 am
  • Hi all. I am trying to create two databases in two different machines connected over the lan. Both the databases have similar tables and fields in them. I will be updating database A always. I want ...
    Sairam KrishnamurthySairam Krishnamurthy
    Oct 4, 2010 at 8:02 pm
    Oct 6, 2010 at 3:23 pm
  • I'm trying to come up with an automated monitoring system to watch the WAL log progress and sound appropriate alarms if it gets too far behind for some reason (e.g. communications problems, etc.) - ...
    Karl DenningerKarl Denninger
    Oct 3, 2010 at 3:50 am
    Oct 3, 2010 at 9:27 pm
  • Please, help me. Why the condition SELECT 5 NOT IN (NULL) returns NULL, but not FALSE (as I thought)? -- Paul
    Oct 31, 2010 at 4:37 pm
    Oct 31, 2010 at 5:19 pm
Group Navigation
period‹ prev | Oct 2010 | next ›
Group Overview
grouppgsql-general @

278 users for October 2010

Tom Lane: 63 posts Craig Ringer: 44 posts Scott Marlowe: 37 posts Mike Christensen: 31 posts Dave Page: 26 posts Thom Brown: 24 posts Merlin Moncure: 22 posts Raymond O'Donnell: 21 posts Rob Sargent: 21 posts Alexander Farber: 20 posts Rajesh Kumar Mallah: 20 posts Tim Uckun: 20 posts Adrian Klaver: 19 posts John R Pierce: 19 posts Pavel Stehule: 18 posts Vivek Khera: 17 posts Alban Hertroys: 16 posts Dmitriy Igrishin: 16 posts Rich Shepard: 14 posts Darren Duncan: 13 posts
show more