FAQ

Search Discussions

149 discussions - 841 posts

  • It's currently (9.2) not possible to define DEFERRABLE NOT NULL constr= aints. Meaning the following is not valid: =C2=A0 CREATE TABLE my_table( id varchar PRIMARY KEY, stuff_id BIGINT NOT NULL ...
    Andreas Joseph KroghAndreas Joseph Krogh
    Feb 4, 2013 at 6:49 pm
    Feb 8, 2013 at 1:26 pm
  • Hi Everyone, Riddle me this. I have a database column of type "real" that gets mapped to a Java field of type double via JDBC. We have two databases, test and production, and the test database is ...
    Tom DuffeyTom Duffey
    Feb 25, 2013 at 2:13 am
    Mar 6, 2013 at 2:24 pm
  • We are hitting a situation where REINDEX is resulting in postgresql to go to dead lock state* for ever*. On debugging the issue we found that 3 connections are going in to some dead lock state. 1 ...
    Anoop KAnoop K
    Feb 6, 2013 at 9:28 am
    Feb 11, 2013 at 6:47 am
  • Hi all; Im looking for in information and resources to setup postgresql 8.0.5 in Ubuntu server . tq
    Wan HashimWan Hashim
    Feb 11, 2013 at 11:40 pm
    Feb 14, 2013 at 2:43 pm
  • Hi, i have created a normal user (no superuser) akretschmer01 and another normal user ak02. All fine. The first user is the owner of the db. As user akretschmer01 i granted: -bash-4.1$ psql -U ...
    Andreas KretschmerAndreas Kretschmer
    Feb 8, 2013 at 2:26 pm
    Feb 8, 2013 at 6:03 pm
  • I am trying, without success, to create a PG-9.2 database without including the plpgsql extension. I have tried specifying template0 and the database is nonetheless created with plpgsql. I have ...
    James B. ByrneJames B. Byrne
    Feb 21, 2013 at 5:38 pm
    Feb 22, 2013 at 10:36 pm
  • Greetings, What would happen if I create multiple threads from within a postgresql function written in C? I have the opportunity to do parallel processing on binary data, and I need to create ...
    Seref ArikanSeref Arikan
    Feb 18, 2013 at 11:10 am
    Feb 19, 2013 at 3:28 pm
  • Hello all As I can tell the PostgreSQL 9.2 yum repository for use with RHEL6 (64bit) is broken. On a fresh RHEL6.3 (64-bit) installation, as root, run the following commands: rpm -i ...
    Jeffrey JonesJeffrey Jones
    Feb 13, 2013 at 3:03 am
    Feb 15, 2013 at 8:55 am
  • Hi, I`m trying to figure out why a query runs in 755ms in the morning and 20054ms (26x) in the evening. Morning: pgipm=# explain analyze SELECT XMAX, ANO, MES, CODFUNC, SEQFUNC, TIPOPGTO, CODPD, ...
    Carlos Henrique ReimerCarlos Henrique Reimer
    Feb 13, 2013 at 6:43 pm
    Feb 14, 2013 at 5:03 pm
  • G'day, I hope to be shown to be an idiot, but we are receiving the message ERROR: invalid input syntax for integer: "" when using a pl/pgsl function with some quite complex queries that seem to be ...
    Ben MadinBen Madin
    Feb 6, 2013 at 4:25 am
    Feb 7, 2013 at 3:27 pm
  • Hey folks, We're wanting to implement a more secure password policy, and so have considered switching to LDAP/Active Directory for passwords. Normally, this would be fine, but for two things: 1. Tons ...
    Shaun ThomasShaun Thomas
    Feb 5, 2013 at 5:15 pm
    Feb 6, 2013 at 4:56 am
  • When I run pg_upgrade, it tries to start the old cluster with the -w flag, which waits a while and declares failure, even though it starts the server. If I start/stop without -w everything is great ...
    Ian HardingIan Harding
    Feb 15, 2013 at 5:21 am
    Mar 4, 2013 at 4:27 am
  • Hi, I have an application that requires to connect to each database available in PostgreSQL. I have the following questions: 1. Is there a USE DATABASE command or something of the sort (similar to ...
    Frank CavalieroFrank Cavaliero
    Feb 25, 2013 at 6:23 pm
    Feb 25, 2013 at 9:30 pm
  • Hi, I'm looking for some good visual query builder which can be used by non-tech people for some ETL tasks. Do you have any recommendation? Now, we're moving our data from Excel to PostgreSQL to deal ...
    Satoshi NagayasuSatoshi Nagayasu
    Feb 8, 2013 at 7:42 am
    Feb 18, 2013 at 8:16 am
  • Timezone configuration parameter (defaulting to system timezone) worked fine for us before upgrading from 8.4. to 9.2. Now we've got a problem. 9.2 Release Notes says: * Identify the server time zone ...
    Igor NeymanIgor Neyman
    Feb 6, 2013 at 6:32 pm
    Feb 7, 2013 at 3:41 pm
  • I tried copying postgres over to a new directory. it was working until I deleted a bunch of databases from the "old" postgres. Lo and behold this somehow broke the "new" copy too. Now when I start ...
    JD WongJD Wong
    Feb 22, 2013 at 11:46 pm
    Mar 1, 2013 at 10:27 pm
  • I have a seemingly simple query that returns way too many records. Here is the count query select count(*) from ( select crm.* from sap_crm_sales crm inner join model_configurations mc on ...
    Tim UckunTim Uckun
    Feb 17, 2013 at 8:16 am
    Feb 18, 2013 at 11:05 pm
  • I've been seeing the following error in one database of ours: "cache lookup failed for relation 7640518" The SQL that apparently triggers this is: drop table if exists ...
    David ClymerDavid Clymer
    Feb 11, 2013 at 5:09 pm
    Feb 11, 2013 at 8:14 pm
  • I am trying to write a query that grabs one particular day from a timestamp column. The data are ordered in 15 minute chunks like this: 2010-07-07 12:45:00 2010-07-07 13:00:00 2010-07-07 13:15:00 ...
    Kirk WythersKirk Wythers
    Feb 4, 2013 at 2:45 pm
    Feb 5, 2013 at 9:37 am
  • Hello, when trying to add a forgotten primary key pair to a PostgreSQL 8.4.13 table I get the error: # \d pref_rep Table "public.pref_rep" Column | Type | Modifiers ...
    Alexander FarberAlexander Farber
    Feb 4, 2013 at 2:17 pm
    Feb 4, 2013 at 7:29 pm
  • Hi. Sorry if this is repetitive, I tried posting to pgsql-performance first but I think it got stuck in moderation. I'm trying to create a view that uses a window function, but it seems that Postgres ...
    Chris HanksChris Hanks
    Feb 28, 2013 at 2:22 am
    Mar 1, 2013 at 10:54 pm
  • Hi everyone; I have a project right now where functional foreign keys would be very handy. Let me explain the specific use case I am looking at and I would assume that there are many more. I am ...
    Chris TraversChris Travers
    Feb 7, 2013 at 9:38 am
    Feb 7, 2013 at 11:20 pm
  • My postgresql-9.0-main.log file has suddenly stopped getting updated. I do not know why it stopped all of a sudden. We made a slight modification where changed in the postgresql.conf param: From ...
    Anson AbrahamAnson Abraham
    Feb 28, 2013 at 4:19 pm
    Feb 28, 2013 at 9:39 pm
  • Hi, If I understand http://www.postgresql.org/docs/9.1/static/routine-vacuuming.html correctly, the autovacuum threshold in could be estimated like this in PostgreSQL 9.1: SELECT ...
    Stefan AndreattaStefan Andreatta
    Feb 22, 2013 at 1:57 pm
    Feb 25, 2013 at 11:07 am
  • Hello Gurus, Table A has integer[] column. I need to delete specific integer value from that column. f1 | f2 1 {100, 101, 102, 103} 2 {200, 300, 400} I want to remove 101 from f2 and also preserve ...
    ChoonSoo ParkChoonSoo Park
    Feb 20, 2013 at 4:24 pm
    Feb 20, 2013 at 7:24 pm
  • See https://gist.github.com/joevandyk/4957646/raw/86d55472ff8b5a4a6740d9c673d18a7005738467/gistfile1.txtfor the code. I have promotions(id, end_at, quantity) and promotion_usages(promotion_id). I ...
    Joe Van DykJoe Van Dyk
    Feb 15, 2013 at 12:33 am
    Feb 15, 2013 at 9:58 pm
  • http://citusdata.com/blog/57-postgresql-full-text-search merlin
    Merlin MoncureMerlin Moncure
    Feb 11, 2013 at 2:04 pm
    Feb 11, 2013 at 11:13 pm
  • Hi everyone, We are experiencing a strange situation after upgrading our Postgres from 8.4 to 9.1 and our OS from Debian 6 to Ubuntu 12.04 LTS. We have an application where we are collecting ...
    Vlad BailescuVlad Bailescu
    Feb 1, 2013 at 8:14 am
    Feb 1, 2013 at 1:41 pm
  • I still can't access my SSL enabled server!!! Is root.crt supposed to be an exact copy of server.crt file which I use in my client's keystore? I have another observation. As I start the coordinator ...
    Maz MohammadiMaz Mohammadi
    Feb 24, 2013 at 4:05 am
    Feb 25, 2013 at 4:16 am
  • Can PG V9.1* support a DB that's on an NFS disk? I googled around, but nothing popped out. Also, would you happen to know the answer to this for MySQL v5.5*? Thanks in Advance.
    Gauthier, DaveGauthier, Dave
    Feb 11, 2013 at 10:22 pm
    Feb 13, 2013 at 10:31 am
  • Hi! Assumptions: PostgreSQL 9.2.2, Win64, already run vacumm full freeze analyze. No problems in the database. I know there are 1247 records to be found. Why does these queries return different ...
    Edson RichterEdson Richter
    Feb 3, 2013 at 2:25 am
    Feb 4, 2013 at 3:52 pm
  • Hello all, I've been following the instructions on http://www.postgresql.org/docs/9.1/static/ssl-tcp.html to enable SSL for postgres 9.1 which I have installed on linux. When I start the server, ...
    Maz MohammadiMaz Mohammadi
    Feb 22, 2013 at 3:55 am
    Feb 22, 2013 at 8:43 pm
  • Hi, we have a Java daemon that´s repeatedly calling a Perl function inside our database (version 9.1.8). The function is called about 200 times per second. While the Java program is running you can ...
    Jan StrubeJan Strube
    Feb 19, 2013 at 11:03 am
    Feb 22, 2013 at 2:33 pm
  • Hi all, I'm hoping someone could help me with this issue, not sure if the general mailing list is the right place so apologies if this needs to be directed else where. We have several clients who are ...
    Bastiaan OlijBastiaan Olij
    Feb 19, 2013 at 4:26 am
    Feb 20, 2013 at 12:11 am
  • Greetings, I use postgresql on a Linux server on a virtual machine (despite my protest to IT personal). The client is typically a web server implementing PHP sites. Customers many times close a page ...
    David harelDavid harel
    Feb 19, 2013 at 9:53 am
    Feb 19, 2013 at 7:08 pm
  • Hi All, We are having a thorny problem I'm hoping someone will be able to help with. We have a pair of machines set up as an active / hot SB pair. The database they contain is quite large - approx ...
    Michael HarrisMichael Harris
    Feb 5, 2013 at 12:35 am
    Feb 18, 2013 at 3:31 am
  • Hi, A bulk import (script attached) is failing. Error message: psql:/home/andyt/projects/django-stringer/txc/stops_inport.txt:86: ERROR: invalid input syntax for type double precision: "stop_lat" I ...
    Andrew TaylorAndrew Taylor
    Feb 16, 2013 at 5:02 pm
    Feb 16, 2013 at 6:30 pm
  • Hi: Looking for a table or view which contains the list of arguments that are passed to a stored procedure. Doesn't seem to be in pg_proc.prosrc or other pg_proc columns. Thanks in Advance for any ...
    Gauthier, DaveGauthier, Dave
    Feb 13, 2013 at 2:13 pm
    Feb 15, 2013 at 4:10 pm
  • Hi folks, It's more like a question of best practice: How do you managing different version of database layout for e.g. software releases? We are planing to do an application based on postgres and ...
    Frank LanitzFrank Lanitz
    Feb 12, 2013 at 10:01 am
    Feb 12, 2013 at 7:18 pm
  • I have been trying to get the Tcl package for client applications PgTcl to work for some time now. I have tried the SourceForge pgtclng 2.0 project, I have recompiled it with MinGW-64, I have ...
    Carlo StonebanksCarlo Stonebanks
    Feb 9, 2013 at 5:52 pm
    Feb 12, 2013 at 2:33 pm
  • Hi people, I need to write an algorithm for processing large amounts of data. I want to write a function on PgAdmin 3 to solve my problem. I need to know what language should be used, C or PL/PgSQL? ...
    Karel Riverón EscobarKarel Riverón Escobar
    Feb 2, 2013 at 3:42 pm
    Feb 5, 2013 at 6:56 am
  • Hello, in a Facebook game running on PostgreSQL 8.4.13 and having so many players: # select count(*) from pref_users; count -------- 223964 I am trying to get rid of inactive users, who just visited ...
    Alexander FarberAlexander Farber
    Feb 1, 2013 at 9:38 am
    Feb 1, 2013 at 4:24 pm
  • Hi all, I open a transaction, create a few temporary tables, import data in them, then insert into the final tables from the temporary tables and commit. In dev, it works, but not in prod. I'm trying ...
    François BeausoleilFrançois Beausoleil
    Feb 27, 2013 at 9:19 pm
    Feb 27, 2013 at 11:58 pm
  • Hi, I have a simple void function: CREATE OR REPLACE FUNCTION myfn(myparam OUT int) AS $$ BEGIN pnr := 1; END; $$ LANGUAGE plpgsql; How do I access myparam? I thought this should work with 9.1/9.2 ...
    Stefan KellerStefan Keller
    Feb 25, 2013 at 5:22 pm
    Feb 25, 2013 at 6:34 pm
  • Hi folks, I'm building a PHP script for a web site I'm developing. At the moment, there is absolutely no real data in the database, so obviously performance is pretty good right now. I'm in the midst ...
    Raymond C. RodgersRaymond C. Rodgers
    Feb 22, 2013 at 8:42 pm
    Feb 24, 2013 at 4:57 pm
  • Hello, I have a table with the following structure: nn= \d documents Table "public.documents" Column | Type | Modifiers ...
    Ivan VorasIvan Voras
    Feb 21, 2013 at 11:52 am
    Feb 21, 2013 at 4:27 pm
  • My assumption was that WITH acted just like subselects, but apparently they don't? Using WITH doesn't use the expected index. (the below also at ...
    Joe Van DykJoe Van Dyk
    Feb 18, 2013 at 11:05 pm
    Feb 21, 2013 at 3:10 pm
  • Hi, We are developing an application that uses various web analytics packages (like Google Analytics) to run analyses on. We are currently in closed beta stadium where we don't have a lot of data in ...
    Tiemo KieftTiemo Kieft
    Feb 17, 2013 at 8:02 am
    Feb 20, 2013 at 2:09 am
  • Hi. I'm unable to offload my backups to one of my PG 9.1 hot standbys using purely streaming replication. After a few hours, usually on the same large table, pg_dump is failing with 'ERROR: canceling ...
    Stuart BishopStuart Bishop
    Feb 13, 2013 at 8:53 am
    Feb 14, 2013 at 6:27 am
  • Is there any way to change the character set of a database and its tables? I did a pg_dumpall to upgrade from Postgres 8.4 to Postgres 9.2, and all the tables came back as UTF-8, and now Bacula is ...
    Tim GustafsonTim Gustafson
    Feb 12, 2013 at 4:34 pm
    Feb 12, 2013 at 7:43 pm
Group Navigation
period‹ prev | Feb 2013 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions149
posts841
users197
websitepostgresql.org
irc#postgresql

197 users for February 2013

Adrian Klaver: 76 posts Tom Lane: 42 posts Albe Laurenz: 31 posts Kevin Grittner: 21 posts John R Pierce: 20 posts Merlin Moncure: 16 posts Pavel Stehule: 16 posts Scott Marlowe: 16 posts Bèrto ëd Sèra: 13 posts Jeff Janes: 13 posts Alban Hertroys: 12 posts Jasen Betts: 12 posts Sergey Konoplev: 12 posts Anoop K: 11 posts Alexander Farber: 10 posts Jeffrey Jones: 10 posts Russell Keane: 10 posts Thomas Kellerer: 10 posts Ben Madin: 9 posts Bruce Momjian: 9 posts
show more
Archives