FAQ

PostgreSQL > pgsql-general > January 2010

Search Discussions

264 discussions - 1,351 posts

  • In a PL/PgSQL function I have the following: ---- execute $l2$ alter table $l2$||ct||$l2$ add check( data =$1::timestamp and data<$2::timestamp and maga=$3 ) $l2$ using rec.d0,rec.d1,rec.maga; ---- ...
    Vincenzo RomanoVincenzo Romano
    Jan 12, 2010 at 2:09 pm
    Jan 15, 2010 at 9:29 am
  • Hello, We use PG 8.3. We use pg_dump and pg_restore overnight to create copies of main database for reporting etc. One dump/restore runs at 9 PM, another at 11 PM. Today I discovered that the restore ...
    Konrad GarusKonrad Garus
    Jan 7, 2010 at 10:12 am
    Jan 15, 2010 at 9:16 am
  • I am not sure whether I am doing the correct benchmarking way. I have the following table ; CREATE TABLE measurement_type ( measurement_type_id bigserial NOT NULL, measurement_type_name text NOT ...
    Yan Cheng CheokYan Cheng Cheok
    Jan 5, 2010 at 3:36 am
    Jan 7, 2010 at 5:02 pm
  • Hi all. I'm using the printf() function as seen here: http://wiki.postgresql.org/wiki/Sprintf What I see is that when I call that function with just 1 argument, it's always OK. As here: -- code mp1=# ...
    Vincenzo RomanoVincenzo Romano
    Jan 22, 2010 at 5:41 pm
    Jan 27, 2010 at 4:07 pm
  • Hi I am getting a strange result when using the following - Select fluid_id into fluidid from p_id.processes where new.pump1 = 'True' and old.pump1 = 'False' or old.pump1 is null; The fluid_id return ...
    Bob PawleyBob Pawley
    Jan 21, 2010 at 11:09 pm
    Jan 25, 2010 at 6:39 pm
  • Hi, I'm trying to figure out how to use an index on an immutable function call in order to speed up queries. I came up with this small test: ---------------------------------------- --create database ...
    Philippe LangPhilippe Lang
    Jan 19, 2010 at 6:59 am
    Jan 19, 2010 at 2:47 pm
  • Hello, I'm running version 8.4.1 and have a table that appears on listing ( when i run \l ) but i can't drop it. Example: postgres=# \l List of databases Name | Owner | Encoding | Collation | Ctype | ...
    Fernando MorgensternFernando Morgenstern
    Jan 8, 2010 at 4:39 pm
    Jan 11, 2010 at 2:48 pm
  • I'm not getting something about the best way to set up a server using PostgreSQL as a backend for a busy web server running drupal. The postgresql performance folks ...
    Jeff RossJeff Ross
    Jan 27, 2010 at 9:59 pm
    Feb 13, 2010 at 6:18 pm
  • I have deployed PostgresSQL 8.4.1 on a Fedora 9 c1.xlarge (8x1 cores) instance in the Amazon E2 Cloud. When I run pgbench in read-only mode (-S) on a small database, I am unable to peg the CPUs no ...
    Mike BresnahanMike Bresnahan
    Jan 27, 2010 at 9:24 pm
    Jan 29, 2010 at 8:07 pm
  • all is there a external table create method ( similar to oracle external table ) ? where to find the information ? thanks Amy
    Amy SmithAmy Smith
    Jan 18, 2010 at 3:27 am
    Jan 20, 2010 at 7:57 am
  • My problem is that retrieving sorted data from large tables is sometimes very slow in PostgreSQL (8.4.1, FWIW). I typically retrieve the data using cursors, to display them in UI: BEGIN; DECLARE ... ...
    Milan ZamazalMilan Zamazal
    Jan 5, 2010 at 10:03 am
    Jan 5, 2010 at 8:06 pm
  • Hi All, I installed postgres from the enterprisedb-maintained one-click installer at http://www.postgresql.org/download/macosx. However, it starts automatically when the machine boots up, and I'd ...
    Chris WithersChris Withers
    Jan 4, 2010 at 8:50 am
    Aug 31, 2011 at 4:31 pm
  • While looking into a failed check_postgres check, I found a problem with the canonical versions page here: http://www.postgresql.org/versions.rss It only goes back to 8.0, but as far as I know, 7.4 ...
    Greg Sabino MullaneGreg Sabino Mullane
    Jan 29, 2010 at 2:40 pm
    Feb 11, 2010 at 4:29 pm
  • Hi, We are a software publisher searching for a new DBMS for our software. We have more than one hundred installed servers, running Mac OS and a Primebase database. We have spend some time evaluating ...
    Martin FlahaultMartin Flahault
    Jan 12, 2010 at 11:46 am
    Jan 18, 2010 at 3:34 pm
  • Hello, Given that the EU has approved Oracle's acquisition of Sun w/ MySQL it's fairly likely that there may be a number of people and companies looking to move from MySQL to Postgres in the coming ...
    Erik JonesErik Jones
    Jan 22, 2010 at 7:39 pm
    Feb 3, 2010 at 8:08 am
  • Hello, I have a function with three parameters that would populate a table in one schema from another table of the same name in another schema. The tables are dynamically selected at execution time. ...
    Aycock, Jeff R.Aycock, Jeff R.
    Jan 27, 2010 at 3:55 pm
    Jan 27, 2010 at 5:09 pm
  • I haven't been able to find anything better than the online manual and pg source code to learn how to write extensions. I couldn't find a reference of all the function/macros I could use and some ...
    Ivan Sergio BorgonovoIvan Sergio Borgonovo
    Jan 20, 2010 at 2:42 pm
    Jan 23, 2010 at 7:43 pm
  • Hello, I need to generate unique id which is not guessable unlike serial(integer) type. I need an id in format like md5 hash of random number. On top of that I need this id to be unique across ...
    Joe KramerJoe Kramer
    Jan 29, 2010 at 8:20 am
    Jan 30, 2010 at 1:21 am
  • I have 3 tables - lot, unit and measurement 1 lot is having relationship to many unit. 1 unit is having relationship to many measurement. delete cascade is being used among their relationship I try ...
    Yan Cheng CheokYan Cheng Cheok
    Jan 13, 2010 at 8:09 am
    Jan 22, 2010 at 6:16 am
  • Hi All - I have query in production and test. The tables in both the environment has the same structure ,indexes and constraints. But the in the test and the prod the explain plan is totally ...
    Akp geekAkp geek
    Jan 8, 2010 at 4:11 am
    Jan 8, 2010 at 7:44 pm
  • Can't help myself, but I've used mysql in the past, and got on a list of some sort once upon a time about that. Just received an email petition from Monty to help save mysql. Certainly you know the ...
    Andrew LardinoisAndrew Lardinois
    Jan 1, 2010 at 2:20 am
    Jan 4, 2010 at 5:41 pm
  • Hii am experience slow queries when i run some functions. I noticed the following entries in my server log. From this, can anyone tell me if I need to change some config parmeters? System has 18GB ...
    Alex -Alex -
    Jan 22, 2010 at 4:13 am
    Jan 25, 2010 at 9:59 am
  • Assuming I have the following table: CREATE TABLE refers ( id SERIAL PRIMARY KEY, name VARCHAR(255) NOT NULL, parent_id INTEGER NOT NULL, FOREIGN KEY (parent_id) REFERENCES refers(id) ); I need to ...
    OvidOvid
    Jan 24, 2010 at 1:43 pm
    Jan 24, 2010 at 3:56 pm
  • Hello All, When is the release date for Postgres 8.5? Thanks Deepak
    DMDM
    Jan 22, 2010 at 8:07 am
    Jan 23, 2010 at 4:03 am
  • A main issue in my case with the suggested (chapter 5.9) implementation is that child tables need to be created in advance, For a number of reasons (complex partitioning schemas, rows also related to ...
    Vincenzo RomanoVincenzo Romano
    Jan 20, 2010 at 10:20 am
    Jan 21, 2010 at 10:11 am
  • We have recently discovered a problem with our slony-1 cluster of 8.1.19 installs. Specifically, we are unable to vacuum a table on the master node; vacuum always hangs on the same index of the same ...
    Ben ChobotBen Chobot
    Jan 15, 2010 at 5:49 am
    Jan 19, 2010 at 2:29 am
  • Currently, I have a table which I implement table (measurement) partition policy. http://www.postgresql.org/docs/current/static/ddl-partitioning.html Whenever an item being inserted into measurement ...
    Yan Cheng CheokYan Cheng Cheok
    Jan 26, 2010 at 10:01 am
    Jan 29, 2010 at 12:22 pm
  • Hy, can anybody give us a hint if we can use that combination? Thanks, Daniel. -- Daniel Schuchardt /Softwareentwicklung/ /http://www.prodat-sql.de/
    Daniel SchuchardtDaniel Schuchardt
    Jan 13, 2010 at 10:45 am
    Jan 13, 2010 at 6:01 pm
  • Is there any way of getting psql to display the name of the currently-connected server in its prompt, and perhaps a custom string identifying e.g. a disc set, without having to create a psqlrc file ...
    Mark Morgan LloydMark Morgan Lloyd
    Jan 8, 2010 at 11:20 am
    Jan 9, 2010 at 2:14 pm
  • Customer ================== Customer_ID | Name Order ============================== Order_ID | Customer_ID | Price To insert an order, here is what I need to do usually, For example, "John" place ...
    Yan Cheng CheokYan Cheng Cheok
    Jan 4, 2010 at 8:53 am
    Jan 5, 2010 at 11:19 am
  • We are going to be setting up a PostgreSQL server on a guest under VMWare ESX 4... Is there any performance improvement by choosing 64bits Linux over 32bits Linux as the guest OS or is it almost the ...
    Bjørn T JohansenBjørn T Johansen
    Jan 21, 2010 at 7:39 am
    Jan 21, 2010 at 3:18 pm
  • Hello, Sorry for the poor subject. Not sure how to describe what I need here. I have an application that logs to a single table in pgsql. In order for me to get into our log management, I need to ...
    TerryTerry
    Jan 18, 2010 at 10:09 pm
    Jan 19, 2010 at 2:50 pm
  • Is there a way to set a column to be read only? I have a table with several columns with values that are determined by triggers. I want users to be able to view, but never edit them. Thanks
    Gauthier, DaveGauthier, Dave
    Jan 17, 2010 at 1:32 am
    Jan 17, 2010 at 3:53 am
  • Hello dear list members, I have strange problem with my new 8.4 deployment, which I never encountered on previous 8.3 deployment. IOwait values are extremely high exactly when Postgres finishes a ...
    Anton BelyaevAnton Belyaev
    Jan 8, 2010 at 6:16 pm
    Jan 12, 2010 at 1:22 am
  • Hi Everybody. I have two questions. 1. We have a system that is accessed by Crystal reports which is in turned controlled by another (3rd party) system. Now, when a report takes too long or the user ...
    Herouth MaozHerouth Maoz
    Jan 24, 2010 at 10:29 am
    Jan 25, 2010 at 1:52 pm
  • Hi, In reading the documentation it states that the SQL dump backup does not block other operations on the database while it is working. I presume that while a restore is occurring that no reads or ...
    John MitchellJohn Mitchell
    Jan 21, 2010 at 1:12 pm
    Jan 23, 2010 at 7:25 am
  • We had WAL Log shipping (warm standby) working fine under 8.1.4 but under 8.3.7 we can't get the slave to come up properly. Nothing has changed in our process with regard to start_backup, rsync, ...
    Keaton AdamsKeaton Adams
    Jan 7, 2010 at 8:01 pm
    Jan 12, 2010 at 9:27 pm
  • Is there a way to know/estimate how much is left to complete a restore? It would be enough just knowing which part of the file is being restored (without causing too much extra IO, that will ...
    Ivan Sergio BorgonovoIvan Sergio Borgonovo
    Jan 8, 2010 at 10:28 am
    Jan 12, 2010 at 6:47 am
  • Hi everyone, I am using postgresql 8.3-beta3. I have a table 'test' with three fields: sid data date 1 1.1 2009-09-01 1:00:00 1 2.1 2010-01-01 1:00:20 2 3.1 2009-09-01 1:00:10 2 0.1 2010-01-01 ...
    Zxo102 ouyangZxo102 ouyang
    Jan 9, 2010 at 4:43 pm
    Jan 12, 2010 at 5:55 am
  • I know I can convert SQL timestamp to unix timestamp, using the following way. SELECT extract(epoch FROM now()); Now, I have a stored procedure function, which will directly return a table row to the ...
    Yan Cheng CheokYan Cheng Cheok
    Jan 11, 2010 at 6:16 am
    Jan 11, 2010 at 12:31 pm
  • Is there any nice way to do something like that in plpgsql: EXECUTE 'INSERT INTO '||partition_table_name||' VALUES'||(NEW.*)||''; It would probably work, but some values are NULL, and plpgsql ...
    Grzegorz JaśkiewiczGrzegorz Jaśkiewicz
    Jan 8, 2010 at 2:56 pm
    Jan 10, 2010 at 1:05 am
  • Is it possible to set postgres in case insensitive mode ? If so, how? Thanks / Moe
    MoeMoe
    Jan 29, 2010 at 9:52 pm
    Feb 1, 2010 at 5:54 pm
  • Hello, I observed the event that CPU utilization of the process related to postgres records almost 100% for unknown reason. It would be appreciated if any of you provide any information on this. The ...
    Hashimoto YuyaHashimoto Yuya
    Jan 25, 2010 at 4:19 am
    Jan 27, 2010 at 1:10 pm
  • Hi folks, I have a simple script file db : #!/bin/bash pg_dump -U postgres prodDB /var/a/db/$(date "+%Y-%m-%d_%H:%M")-prodDB.dump ---------- Which works fine when executed manually ( ./db ).. I get a ...
    MoeMoe
    Jan 26, 2010 at 4:54 pm
    Jan 26, 2010 at 10:37 pm
  • Our setup is a real valid one. Looks like it has to do more with remote connections. Any idea? Thanks Danny
    Abraham, DannyAbraham, Danny
    Jan 25, 2010 at 3:39 pm
    Jan 26, 2010 at 2:24 am
  • all Any kind of parameter in solaris root section need to be checked before install postgres in Solaris thanks Amy
    Amy SmithAmy Smith
    Jan 9, 2010 at 3:24 pm
    Jan 25, 2010 at 11:43 pm
  • Hi, everyone: First I can successful run this query:select name, ts_rank_cd(vectors, query) as rank from element, to_tsquery('item') query where query @@ vectors order by rank desc;But actually I ...
    Xu feiXu fei
    Jan 24, 2010 at 1:21 am
    Jan 25, 2010 at 11:30 pm
  • I'm having difficulties with one of my 8.1.19 installs. log_min_duration_statement is currently set to 500. I would like to change it to 0. Changing it in the config file and sending a HUP to the ...
    Ben ChobotBen Chobot
    Jan 19, 2010 at 9:28 pm
    Jan 19, 2010 at 11:36 pm
  • Hi, I'm trying to make constraint exclusion work correctly in a query with only one parameter, but I have some issues. Please have a look at the scenario below and tell me how I can improve it. ...
    Mathieu De ZutterMathieu De Zutter
    Jan 16, 2010 at 6:02 pm
    Jan 17, 2010 at 9:49 pm
  • to_tsquery and plainto_tsquery produce AND tsquery 'apple banana orange' - 'apple' & 'banana' & 'orange' I can't see anything that will produce OR tsquery. 'apple banana orange' - 'apple' | 'banana' ...
    Ivan Sergio BorgonovoIvan Sergio Borgonovo
    Jan 16, 2010 at 2:32 pm
    Jan 17, 2010 at 6:28 pm
Jan 2010
123456
Group Navigation
period‹ prev | Jan 2010 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions264
posts1,351
users287
websitepostgresql.org
irc#postgresql

287 users for January 2010

Tom Lane: 92 posts Yccheok: 60 posts Craig Ringer: 54 posts Vincenzo Romano: 54 posts Scott Marlowe: 40 posts Pavel Stehule: 35 posts Adrian Klaver: 33 posts Greg Smith: 32 posts John R Pierce: 29 posts Ivan Sergio Borgonovo: 25 posts Alban Hertroys: 24 posts Andreas Kretschmer: 24 posts Grzegorz Jaśkiewicz: 24 posts Andy Colson: 19 posts Konrad Garus: 19 posts Sam Mason: 17 posts Dimitri Fontaine: 14 posts Joshua D. Drake: 14 posts Andreas Kretschmer: 13 posts Gauthier, Dave: 13 posts
show more
Archives