FAQ

PostgreSQL > pgsql-general > March 2011

Search Discussions

215 discussions - 1,095 posts

  • When I run the following query in Postgres 8.0, it runs in 61,509.372 ms When I run it in Postgres 8.4, it runs in 397,857.472 ms Here is the query: select course_id AS EXTERNAL_COURSE_KEY, user_id ...
    Davenport, JulieDavenport, Julie
    Mar 16, 2011 at 3:53 pm
    Mar 23, 2011 at 2:44 pm
  • Hi Guys, I'm trying to allow a remote host on our 10.3.55.X network remote access to a Postgres Database on the same network. We're running Solaris 10 with Postgres 83 My postgresql.conf looks like ...
    General_leeGeneral_lee
    Mar 15, 2011 at 4:10 pm
    Mar 15, 2011 at 9:04 pm
  • I'm trying to validate a day of the week, and thought that to_date would do the job for me. But I found a case where it cannot tell the difference between sunday and monday. Is this a bug or intended ...
    Marc MunroMarc Munro
    Mar 29, 2011 at 3:07 pm
    Sep 4, 2012 at 2:53 am
  • Our WAL files are 16 Mb in size each. I cannot find where you configure them to make them larger. 16 Mb is too small for our instalation. If necessary, I can rebuild the entire cluster. Our DBA ...
    RunnerRunner
    Mar 11, 2011 at 5:49 pm
    Jan 10, 2012 at 5:38 pm
  • am i the only one thinking that postgres is seriously lacking recordings from conferences? when i look at talks schedule from some postgres conference i always wonder why nobody records talks? i've ...
    Aljoša MohorovićAljoša Mohorović
    Mar 21, 2011 at 6:56 pm
    Apr 1, 2011 at 5:16 am
  • I use pgsql 9.0.3 and I know that postgresql tries to use the fields in indexes instead of the original table if it possible But when I run SELECT COUNT(id) FROM tab or SELECT COUNT(*) FROM tab where ...
    ObamabarakObamabarak
    Mar 3, 2011 at 2:04 pm
    Mar 8, 2011 at 7:30 pm
  • Hi, I was using Holdem Manager and Postgres database server until a month ago when it just stopped. Whatever I did didn't help, incl. a teamviewer session with one of the HM administrators. I've ...
    AlphadionAlphadion
    Mar 15, 2011 at 12:25 pm
    Mar 15, 2011 at 6:08 pm
  • Is there a fundamental difference between a primary key and a unique index? Currently we have primary keys on tables that have significant amounts of updates performed on them, as a result the ...
    Voils, Steven MVoils, Steven M
    Mar 17, 2011 at 12:34 pm
    Jul 6, 2012 at 7:26 pm
  • hi, i have a server with pg 8.3.11. Every now and then, for no apparent reason (io normal, cpu usage normal, web traffic normal) i see hundreds of connections in "PARSE" state. to give some ...
    Hubert depesz lubaczewskiHubert depesz lubaczewski
    Mar 9, 2011 at 8:38 pm
    Apr 30, 2011 at 7:17 pm
  • Good afternoon. I've been looking at the Oracle Functionality package. It's very interesting. However, the one place I'm stuck is that while user Postgres can access the functions, no other user ...
    Matt WarnerMatt Warner
    Mar 4, 2011 at 9:12 pm
    Mar 4, 2011 at 10:08 pm
  • Hi, We're getting a deadlock in our application (a web application with a PostgreSQL backend) which I've traced to libpq. I've started our application in gdb, and when it hangs, I've inspected the ...
    Erik HesselinkErik Hesselink
    Mar 24, 2011 at 9:17 am
    Mar 26, 2011 at 10:54 am
  • Dear list, As discussed extensively in the past [1], pg_dump tends to be slow for tables that contain bytea columns with large contents. Starting with postgres version 8.5 the COPY format of bytea ...
    Chris r.Chris r.
    Mar 2, 2011 at 8:42 am
    Mar 7, 2011 at 3:53 pm
  • I'm considering porting a MySQL database to PostgreSQL. That database uses MySQL's SET type. Does anyone have advice about representing this type in PostgreSQL? MySQL DDL excerpt: CREATE TABLE ...
    Reece HartReece Hart
    Mar 9, 2011 at 1:32 am
    Mar 16, 2011 at 2:54 pm
  • I already have a domain name but I am looking for a hosting company that I can use PG with. The few I have contacted have said that they support MySQL only and won't give me access to install what I ...
    Matty jonesMatty jones
    Mar 5, 2011 at 9:08 pm
    Mar 9, 2011 at 1:53 pm
  • Hey all, dmitigr= select to_char(1, '9'); to_char --------- 1 dmitigr= select length(to_char(1, '9')); length -------- 2 Why to_char() includes preceding blank space in the result ? -- // Dmitriy.
    Dmitriy IgrishinDmitriy Igrishin
    Mar 9, 2011 at 1:12 pm
    Mar 11, 2011 at 3:48 pm
  • Hi All, I would like to know about the best approach to take for providing a merged model of libpq library. When I say "merged model" it means that the client and server would be running as a single ...
    Annamalai GurusamiAnnamalai Gurusami
    Mar 31, 2011 at 4:35 pm
    Apr 4, 2011 at 4:19 pm
  • Hi, I have a weird problem with my custom functions (written in C,C++) that use bytea as input type (cstring works fine). The functions will work as expected if they are the only function that uses ...
    Adrian SchreyerAdrian Schreyer
    Mar 22, 2011 at 2:21 pm
    Mar 23, 2011 at 3:34 pm
  • Hi, I need to transform an PHP array to an PlPgSQL array. The PHP array is like this: [quote] $arr = array( 0 = array( "base64" = "ddfffffff", "image_type" = "jpg", "width" = "343", "height" = "515", ...
    Andre LopesAndre Lopes
    Mar 5, 2011 at 7:22 pm
    Mar 6, 2011 at 4:23 pm
  • Hi all, I've just set up a test user, revoked all access from them to a database, then tried to connect to that database and it let me in. When I try it all from scratch, it works correctly. Here's ...
    Thom BrownThom Brown
    Mar 29, 2011 at 7:47 pm
    Mar 29, 2011 at 9:29 pm
  • Hi all, I'm having problems with pg_dump, apparently, from one of our servers. The scenario is like this. I tried today to dump a DB from our production server to load on our development server and ...
    Martín MarquésMartín Marqués
    Mar 23, 2011 at 12:33 pm
    Mar 30, 2011 at 2:40 pm
  • Hello, I'm using CentOS 5.5 with PostgreSQL 8.4.7 and am migrating my site from phpBB 3 to Drupal 7. I would like to copy these fields from one table: select user_id, username, user_email, ...
    Alexander FarberAlexander Farber
    Mar 9, 2011 at 1:59 pm
    Mar 15, 2011 at 9:40 pm
  • My XP is crashed and now I have to take a full backup of my postgresql 8.4 I am used to get backup of ldf/mdf files in case of SQLServer Please let me know the right way of doing this for postgresql ...
    Waqar AzeemWaqar Azeem
    Mar 24, 2011 at 7:07 am
    May 3, 2011 at 5:35 pm
  • Hey all I have a question, using the autocommit off option in postgres. As starting position I use a table called xxx.configuration using a unique id constraint. Why does postgres rollback the whole ...
    Vogt, MichaelVogt, Michael
    Mar 14, 2011 at 9:59 am
    Mar 29, 2011 at 2:04 pm
  • Hello, we have performance problems running several queries pon postgres 8.4 . Using the previous version (8.3) our queries performs well (The queries are quite complex, consisting of several ...
    JoJo
    Mar 14, 2011 at 12:50 pm
    Mar 16, 2011 at 1:22 pm
  • Hi, I'm using a bytea field to store small images in base64. I need to know if I can compare bytea rows for equality. To know for example if the file already exists in the database, this is possible ...
    Andre LopesAndre Lopes
    Mar 8, 2011 at 6:28 pm
    Mar 10, 2011 at 2:53 pm
  • Hey guys, I'm trying to get a VB program to make a client connection to my PostgreSQL server running on an Ubuntu 10.10 server. Here's what I've done: Client side - installed and registered the OLE ...
    John EdensJohn Edens
    Mar 9, 2011 at 4:33 pm
    Mar 9, 2011 at 9:43 pm
  • Hi: I have to update all the records of a table. I'm worried about what the table will look like in terms of fragmentation when this is finished. Is there some sort of table healing/reorg/rebuild ...
    Gauthier, DaveGauthier, Dave
    Mar 4, 2011 at 3:04 am
    Mar 5, 2011 at 11:42 pm
  • Hi, I would like to write a generic plpgsql function with a text parameter being a callback function name so that my general function can call this callback function. e.g.: CREATE OR REPLACE FUNCTION ...
    Pierre RacinePierre Racine
    Mar 1, 2011 at 11:11 pm
    Mar 2, 2011 at 3:14 pm
  • I'm converting a MySQL webapp to PostgreSQL. I have a backup server which is refreshed twice daily with mysqldump/mysql and has a continuously-running copy of the webapp. I want to replicate this ...
    Mike OrrMike Orr
    Mar 30, 2011 at 8:56 pm
    Apr 12, 2011 at 9:10 pm
  • Hello, I have a table holding number of games per week for each user: # select id,completed,yw from pref_match limit 3; id | completed | yw ----------------+-----------+--------- OK2650139676 | 10 | ...
    Alexander FarberAlexander Farber
    Mar 15, 2011 at 9:33 pm
    Mar 17, 2011 at 1:46 pm
  • Whenever I attempt to create a sequence whether this is done directly via CREATE SEQUENCE or indrirectly vial declaring a column as SERIAL, PG truncates it to 64 characters. Is this a documented ...
    Carlo StonebanksCarlo Stonebanks
    Mar 31, 2011 at 5:24 pm
    Mar 31, 2011 at 11:04 pm
  • hi, when trying to insert a long-long value, I get the following error: index row size 3120 exceeds maximum 2712 for index "ir_translation_ltns" HINT: Values larger than 1/3 of a buffer page cannot ...
    Viktor NagyViktor Nagy
    Mar 13, 2011 at 3:01 pm
    Mar 29, 2011 at 3:54 am
  • Hi, Is there any way for a SQL or PL/pgSQL function to receive a table as parameter? As an illustration, consider the dummy example below. Note that functions get_from_data1 and get_from_data2 follow ...
    Jon SmarkJon Smark
    Mar 21, 2011 at 6:56 pm
    Mar 21, 2011 at 9:10 pm
  • I am looking for some help in database design. I would like to design a database to help design alternative designs of a basic electronic circuit design. I have a list of components that will be ...
    RayRay
    Mar 20, 2011 at 4:52 am
    Mar 21, 2011 at 3:26 am
  • We're considering using postgres as a way to host database services for many, many independent applications. One obvious way to do this is with schemas, roles, and proper permissions, but that still ...
    Ben ChobotBen Chobot
    Mar 18, 2011 at 6:25 pm
    Mar 18, 2011 at 8:41 pm
  • Hi all! I received a bug report about problems with identifiers. If I do the following select: select 1 as tést The column name returned contains strange chars. If I do: select 'tést' as tést the ...
    Francisco Figueiredo Jr.Francisco Figueiredo Jr.
    Mar 15, 2011 at 6:14 pm
    Mar 18, 2011 at 4:29 am
  • hello, i have a question about the PRIMARY KEY, how can we let it start from for example 1000 instead of 1? This is our program: CREATE TABLE hy3_pack ( hy3_id serial NOT NULL, hy3_serie_nummer text ...
    Peter EvensPeter Evens
    Mar 14, 2011 at 8:07 am
    Mar 14, 2011 at 4:29 pm
  • Hi! In other RDBMS I found a way to make dynamic statements. I can use variables, or concat the SQL segments, and execute it all. :tablename = call CreateTempTable; insert into :tablename .... drop ...
    DurumdaraDurumdara
    Mar 7, 2011 at 2:32 pm
    Mar 7, 2011 at 9:47 pm
  • Hi, I have a table like this: id date min max value 1 2011-03-25 20 30 17 3 2011-03-21 40 55 43 3 2011-03-23 40 55 52 2 2011-02-25 5 2 4 2011-03-15 74 4 2011-03-25 128 1 2011-03-22 20 30 24 I'm ...
    MarcoMarco
    Mar 25, 2011 at 1:52 pm
    Mar 27, 2011 at 10:22 pm
  • Hello, How can I determine the views which are using a certain view. Thanks in advance
    Salah jubehSalah jubeh
    Mar 24, 2011 at 4:06 pm
    Mar 25, 2011 at 6:31 pm
  • Hi, I am understanding the postgres code. In code, i just want to see what are values that are passing through the variables? Can you please tell me if the variable is of type Datum, then how to ...
    Nick RajNick Raj
    Mar 23, 2011 at 5:46 pm
    Mar 24, 2011 at 9:14 am
  • I have set up a pg database server for my organization on a cloud server using PG 8.2; I am trying to provide connections to the db for some members using MS Access. I developed a small MS Access ...
    Joseph DoenchJoseph Doench
    Mar 17, 2011 at 9:29 pm
    Mar 17, 2011 at 10:33 pm
  • Hello, Is there any way of casting (reinterpreting) a varchar/text field containing arbitrary backslashes to bytea without making an escaped copy of the varchar/text first? In the examples below I am ...
    Vlad RomascanuVlad Romascanu
    Mar 16, 2011 at 3:05 pm
    Mar 16, 2011 at 11:46 pm
  • Hi there, I have done quite a bit of searching but have been unable to find any way to do this. I am quite keen to use PostgreSQL 9.0's streaming replication to create a master/slave write/read ...
    Damien ChurchillDamien Churchill
    Mar 11, 2011 at 11:58 am
    Mar 11, 2011 at 12:10 pm
  • Somehow, when I installed 9.0.3 the man pages weren't installed. They're in the source tree but not in /usr/local/pgsql/share/ so I cannot make a symlink to /usr/share/man. Might this be something in ...
    Rich ShepardRich Shepard
    Mar 10, 2011 at 5:57 pm
    Mar 11, 2011 at 12:02 am
  • Hi everybody, i'm having a very strange Problem: My JEE Application initially persists Users at startup. The problem is that the passwords are not stored, while other data with the same datatype on ...
    Altmann, SebastianAltmann, Sebastian
    Mar 24, 2011 at 11:01 am
    Apr 6, 2011 at 8:10 pm
  • Hi Guys, I tried to setup kerberos authentication with postgresql 8.4.7 on Ubuntu 10.10. When I use: $ psql –h ubuntu.server –U gavin dbname I get following error: psql: Kerberos 5 authentication not ...
    Yandong YaoYandong Yao
    Mar 23, 2011 at 5:06 pm
    Mar 25, 2011 at 2:18 am
  • Any way I can have all newly created schemas/tables be owned by, or have all permissions granted to, a certain group, without having to remember to GRANT ALL ON [SCHEMA|TABLE] TO that group? Thanks ...
    Yang ZhangYang Zhang
    Mar 24, 2011 at 8:52 pm
    Mar 25, 2011 at 2:09 am
  • hello pgsql fans out there, i've already created a function that returns a list of IDs of all sub-samples based on a given sample ID. this works fine. now i like to extend this function so that it ...
    Sven HaagSven Haag
    Mar 23, 2011 at 3:29 pm
    Mar 24, 2011 at 9:50 pm
  • Please help me understanding this execution plan : I have a table and 3 levels of partitions . All the tables on second level have date constraints. Execution plan shows that all partitions are ...
    Helen_yelluasHelen_yelluas
    Mar 23, 2011 at 12:41 am
    Mar 24, 2011 at 2:52 pm
Mar 2011
12345
Group Navigation
period‹ prev | Mar 2011 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions215
posts1,095
users271
websitepostgresql.org
irc#postgresql

271 users for March 2011

Adrian Klaver: 64 posts Merlin Moncure: 58 posts Tom Lane: 38 posts Vibhor Kumar: 29 posts John R Pierce: 26 posts David Johnston: 25 posts Pavel Stehule: 24 posts Tomas Vondra: 20 posts Dmitriy Igrishin: 19 posts Andrew Sullivan: 17 posts Raymond O'Donnell: 16 posts Bruce Momjian: 15 posts Hubert depesz lubaczewski: 14 posts Steve Crawford: 14 posts Alexander Farber: 12 posts Joshua D. Drake: 12 posts Alban Hertroys: 11 posts Francisco Figueiredo Jr.: 11 posts Scott Marlowe: 11 posts Matt Warner: 10 posts
show more
Archives