FAQ

PostgreSQL > pgsql-novice > September 2010

Search Discussions

52 discussions - 197 posts

  • Hi all, So my configuration manager and I sat down to get pg 9.0 into our build/code repo today and hit some oddities and was wondering if I was just doing it wrong on my end or if there might be an ...
    MarkMark
    Sep 28, 2010 at 1:28 am
    Oct 2, 2010 at 2:22 am
  • I downloaded the new PostgreSQL 9.0 and it isn't quite there yet: -bash-3.2$ NEWDATADIR=`pwd` -bash-3.2$ OLDBINDIR=/usr/bin -bash-3.2$ NEWBINDIR=/opt/PostgreSQL/9.0/bin/ -bash-3.2$ pg_upgrade ...
    Mladen GogalaMladen Gogala
    Sep 26, 2010 at 11:20 pm
    Oct 14, 2010 at 4:46 pm
  • Good day all.... I hope that someone can help me out with this one question quickly.... I am busy setting up a security compliance report for one of our clients and one of the things to check is the ...
    Machiel RichardsMachiel Richards
    Sep 1, 2010 at 8:54 am
    Feb 1, 2011 at 3:54 am
  • Hi all, I have just installed PostGreSQL on my Gentoo Linux Desktop for the first time. Installation is ok. Then, I have started to install an application that uses PostGreSQL. To test if I am ...
    LalebardeLalebarde
    Sep 23, 2010 at 11:14 pm
    Sep 24, 2010 at 2:37 pm
  • Hello, Pavel Stehule wrote an article for Linux Technical Review which is published now. The language is German. It's regarding PostgreSQL and its possibilities with e.g. Stored Procedures. The first ...
    Thomas UzunoffThomas Uzunoff
    Sep 8, 2010 at 8:51 am
    Sep 21, 2010 at 4:02 pm
  • A nice string concatenation aggregator in pg would be nice. Is there one in 8.4? I've been using array_agg but it's not quite the same. Nor xml_agg. In any case I was wondering if our community has ...
    Charles HolleranCharles Holleran
    Sep 28, 2010 at 10:21 am
    Sep 28, 2010 at 3:22 pm
  • Once I try to do something (whatever that may be) with VIEWS, the OK button never goes from gray to black (as if I didn't have all the privileges) to be clicked on as to accept the creation or ...
    JosefloresJoseflores
    Sep 16, 2010 at 1:49 am
    Sep 17, 2010 at 3:19 pm
  • hi, how can i "easily" log changes to individual fields in a table without naming these fields explicitly? i looked at the auditing example in ...
    Matthias LeopoldMatthias Leopold
    Sep 9, 2010 at 10:14 am
    Sep 9, 2010 at 9:13 pm
  • One of the current projects I'm working on calls for a database with temporal support, thus I came across PostgreSQL being informed that it was "headed in the right direction" and as far as I can ...
    Turner, John JTurner, John J
    Sep 1, 2010 at 9:01 pm
    Sep 2, 2010 at 5:46 pm
  • Hello, I need to get de last entry from a table. I try using: DECLARE variable CURSOR FOR SELECT id FROM table; FETCH LAST FROM variable; And works fine, but when i try to use this code in a ...
    Rodrigo QuezadaRodrigo Quezada
    Sep 9, 2010 at 10:13 pm
    Sep 12, 2010 at 2:53 pm
  • I am having problems explaining the following course of events: I created table test_keys(key int,val varchar(10)); No PK, no indexes. I populated the table using the following SQL: insert into ...
    Mladen GogalaMladen Gogala
    Sep 10, 2010 at 8:49 am
    Sep 11, 2010 at 6:54 am
  • John, Are you behind a proxy server? If yes try setting the Proxy details on the Introduction/First page od Stackbuilder and then try to connect. -- Regards, Sachin Srivastava EnterpriseDB ...
    Sachin SrivastavaSachin Srivastava
    Sep 3, 2010 at 6:56 am
    Sep 7, 2010 at 6:54 pm
  • Good day to all of you. Currently i have 2 databases in my postgresql server, and i want to transfer the data from my db1.table1 to my db2.table2. Both of the tables are very simmilar from each ...
    Jorge Alberto Fuentes CasillasJorge Alberto Fuentes Casillas
    Sep 21, 2010 at 9:34 pm
    Sep 23, 2010 at 12:49 pm
  • Hi all, I am trying to write plpgsql that must create a sequence generators during runtime. The min/max values are provided as function parameters. The following isn't working for me and I'm not too ...
    Leon StarrLeon Starr
    Sep 21, 2010 at 9:44 pm
    Sep 22, 2010 at 9:05 pm
  • Hi, I am experimenting with GNUMed EMR which uses a Mirth (HL7 engine) channel to write data into postgreSQL table (JDBC) and I am getting the error - "transaction is read-only". I think it is ...
    Salil WadnerkarSalil Wadnerkar
    Sep 14, 2010 at 9:31 am
    Sep 20, 2010 at 10:34 am
  • I'm sure this has been answered so many times that the answers are buried somewhere in the millions of hits I get when I try to search for it. I have a table whose rows contain the number of seconds ...
    Rob RichardsonRob Richardson
    Sep 15, 2010 at 1:17 pm
    Sep 17, 2010 at 11:33 am
  • I figured out how to speed up the sequential scans using "blockdev" command. Essentially, this increases the read-ahead on the underlying block device for the file system. It will change the ...
    Mladen GogalaMladen Gogala
    Sep 14, 2010 at 9:30 pm
    Sep 15, 2010 at 3:40 pm
  • hi guys. Does postgreSQl support raw partitions?
    Majid AzimiMajid Azimi
    Sep 4, 2010 at 6:00 pm
    Sep 8, 2010 at 1:10 pm
  • Hello, I have come accross a strange thing. I had to reinstall Ubuntu and after I installed PostgreSQL (using apt-get install postgresql-8.4) when I tried to configure the password I got "Cannot ...
    Lukasz BrodziakLukasz Brodziak
    Sep 28, 2010 at 5:03 am
    Sep 28, 2010 at 8:49 pm
  • Necesito saber que diferencias hay entre la versión 8.2 de postgres y la 8.3 si alguien sabe donde puedo encontrarla por favor .... ah y si es en español mucho mejor sino igual salud2
    IvetteIvette
    Sep 24, 2010 at 2:46 pm
    Sep 24, 2010 at 5:22 pm
  • Is there a log option that will display the SQL statement triggering WARNING; without having to log *all* queries? 2010-09-22 11:18:27 EDT WARNING: nonstandard use of escape in a string literal at ...
    Frank BaxFrank Bax
    Sep 23, 2010 at 10:37 am
    Sep 24, 2010 at 1:35 pm
  • Hello folks! I'm using postgresql-9.0 on linux. While i was restoring backup from plain dump, it stopped with message: " 2010-09-28 21:30:29 CEST BAZA:netams USER:netams VTID:7/3952 ERROR: null value ...
    Marcin MirosławMarcin Mirosław
    Sep 29, 2010 at 5:59 pm
    Sep 29, 2010 at 6:18 pm
  • I have a table with 45 million rows, partitioned on a date field. Each of the partitions has a primary key. There are 3 partitions so far, 15 million records each. I retrieve up to 200k document id's ...
    Mladen GogalaMladen Gogala
    Sep 23, 2010 at 1:33 pm
    Sep 23, 2010 at 2:37 pm
  • Hello. Excuse me, i need to do a pg_dump in my pgadmin 8.3 running in mac, i've tried to do this via terminal typing pg_dump --help as in windows, however it doesn't shows anything, could somebody ...
    Jorge Alberto Fuentes CasillasJorge Alberto Fuentes Casillas
    Sep 22, 2010 at 5:45 pm
    Sep 22, 2010 at 10:15 pm
  • I do select circle '((0,0),3)' @ point '(0,0)'; and I get true. I do select box '((0,0),(1,1))' @ point '(0,0)'; and I get this: ERROR: operator does not exist: box @ point ROW 1: select box ...
    A BA B
    Sep 2, 2010 at 5:50 am
    Sep 2, 2010 at 11:18 pm
  • Hi, I want to update a column matching all elements of array. But,I don't want to iterate over all elements of array. Basically, I am writing a procedure for update tx set delete_flag=''true'' where ...
    Mehrotra, Abhinav (GE Healthcare)Mehrotra, Abhinav (GE Healthcare)
    Sep 28, 2010 at 6:41 am
    Sep 28, 2010 at 6:50 am
  • Hi, I have just started looking at roles on a database. I have a few schemas and would like to revoke access for a user on some functions and tables in the schema and grant access to other functions ...
    Carel CombrinkCarel Combrink
    Sep 23, 2010 at 8:01 am
    Sep 23, 2010 at 4:36 pm
  • Hello! I've been sweating over this for a few hours now, and hope someone can help ... T*his is the error I get for this sql with the comment removed, I believe because some of the rows contain empty ...
    Kevin burdishKevin burdish
    Sep 23, 2010 at 3:45 pm
    Sep 23, 2010 at 4:14 pm
  • I have a development version of Postgres 8.4.4 database which utilizes pgstatspack to produce performance reports and pgfouine to analyze /var/log/pgsql. There are some suspect SQL statements and I ...
    Mladen GogalaMladen Gogala
    Sep 21, 2010 at 6:16 pm
    Sep 22, 2010 at 9:38 pm
  • Just testing wether my mails get to list. -- Łukasz Brodziak
    Lukasz BrodziakLukasz Brodziak
    Sep 21, 2010 at 9:21 am
    Sep 21, 2010 at 10:55 am
  • Hi, I installed pg 9.0 and found the GUI of pgAdmin III 1.12 updated. Whats this dropdown-list-field ontop of the sql area in pgAdmin's SQL editor doing? The help still describes the old GUI. :)
    AndreasAndreas
    Sep 20, 2010 at 11:51 pm
    Sep 21, 2010 at 8:47 am
  • Hi guys. I have these questions about SQL functions. some of them are not covered in documentation: 1. Can a SQL function call another SQL function? 2. How about recursive calls? 3. Consider we have ...
    Majid AzimiMajid Azimi
    Sep 4, 2010 at 5:05 pm
    Sep 17, 2010 at 10:44 am
  • Hi, Found Sim's functions: http://www.mail-archive.com/pgsql-general@postgresql.org/msg57733.html How do you run the viewchanger function? I have tried: SELECT 1 FROM viewchanger( 'beplanallcover', ...
    ThangalinThangalin
    Sep 10, 2010 at 3:15 pm
    Sep 12, 2010 at 6:50 am
  • Any problems? Here is why I am asking: http://yum.pgsqlrpms.org/8.4/redhat/rhel-5-i386/repodata/repomd.xml: [Errno 14] HTTP Error 404: Not Found Trying other mirror. Error: Cannot retrieve repository ...
    Mladen GogalaMladen Gogala
    Sep 11, 2010 at 9:03 pm
    Sep 12, 2010 at 3:05 am
  • Good day all I just wanted to follow up again on a previous post by asking the questions differently after doing a lot of research into the matter. A previous post was related to table locking on ...
    Machiel RichardsMachiel Richards
    Sep 10, 2010 at 7:04 am
    Sep 10, 2010 at 8:23 am
  • Greetings! A charge consists of a set of coils arranged in one or more stacks. It is possible for a stack to be empty. I need a query that lists all possible stacks, along with the coils that are in ...
    Rob RichardsonRob Richardson
    Sep 9, 2010 at 3:43 pm
    Sep 9, 2010 at 5:14 pm
  • Please pardon the total nubie question. There is a nice syntax for functions, "CREATE OR REPLACE FUNCTION xyz ..." What is the best syntax to create or replace a row in a table? Specifically: Update ...
    Charles HolleranCharles Holleran
    Sep 2, 2010 at 1:37 am
    Sep 2, 2010 at 3:54 am
  • My pgAdmin tool continues to show my older 8.4 server along with 9.0 in the server list. When I drop/delete the 8.4 server, it shows up again when I restart pgAdmin. I tried trashing the prefs files, ...
    Adam WizonAdam Wizon
    Sep 29, 2010 at 3:32 pm
    Sep 29, 2010 at 3:32 pm
  • I have PostgreSQL 9.0 installed on my Mac. The pg_hba.conf file is supposed to live in the data subdirectory of the installation, but the folder is locked. Is there a way to set up the file through ...
    Adam WizonAdam Wizon
    Sep 29, 2010 at 1:22 pm
    Sep 29, 2010 at 1:22 pm
  • Hello, I have a problem with creating a new cluster with cp1250 encoding on Ubuntu. When I run sudo pg_createcluster -e pl_PL.cp1250 --start 8.4 main, sudo pg_createcluster -e cp1250 --start 8.4 ...
    Lukasz BrodziakLukasz Brodziak
    Sep 29, 2010 at 7:34 am
    Sep 29, 2010 at 7:34 am
  • Hi list, I'm trying to make a rights manager that retrieve all its info from PG tables. I found out how to retrieve function names; but now I'm stuck after that, as I can't find a way to retrieve ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Sep 26, 2010 at 9:26 pm
    Sep 26, 2010 at 9:26 pm
  • Hi list, I'm building LUA classes to recover all rights I need from a specific DB (DB, Languages, Schemas, Tables, Columns, Sequences & Functions.) Is there an URL where I can find the corresponding ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Sep 24, 2010 at 1:09 pm
    Sep 24, 2010 at 1:09 pm
  • Hello everyone... again. Some of you know what i want to do by the name of the subject, however i will explain it again along with the suggestions that some of you have kindly told me: I have my ...
    Jorge Alberto Fuentes CasillasJorge Alberto Fuentes Casillas
    Sep 23, 2010 at 5:22 pm
    Sep 23, 2010 at 5:22 pm
  • Good day all I am hoping that someone can perhaps assist in the following as I don't have as much experience in postgres as most people on this list. I need to verify and check the referencial ...
    Machiel RichardsMachiel Richards
    Sep 21, 2010 at 10:56 am
    Sep 21, 2010 at 10:56 am
  • Hello, I have a question regarding changing datatypes of columns. Is there a way of changing the type of database column without having to drop and recreate views that depend on that column? -- ...
    Lukasz BrodziakLukasz Brodziak
    Sep 20, 2010 at 8:42 pm
    Sep 20, 2010 at 8:42 pm
  • In looking at the discussion in Section 3.4 of the 8.4.4 Documentation on transactions, it appears that it is meant to be transparent. If the transaction succeeds, it succeeds. If it doesn't, it is ...
    James HartleyJames Hartley
    Sep 20, 2010 at 8:36 pm
    Sep 20, 2010 at 8:36 pm
  • Good day everyone. I am posting this question on the mailing list even though I am also trying to research it as all information will be helpful. Our client are currently running about 13 servers ...
    Machiel RichardsMachiel Richards
    Sep 13, 2010 at 9:50 am
    Sep 13, 2010 at 9:50 am
  • Hey Everyone, Bit of a long shot but maybe someone can point me in the right direction. We attempted to install postgres 8.4.4 on a 64bit windows 2008 server and it failed halfway through the install ...
    Bastiaan OlijBastiaan Olij
    Sep 9, 2010 at 10:15 pm
    Sep 9, 2010 at 10:15 pm
  • Good day everyone.... I would like to ask a question when determining the amount of locks on a postgresql database. Currently we are monitoring over 100 Postgresql databases and one of the things we ...
    Machiel RichardsMachiel Richards
    Sep 7, 2010 at 9:54 am
    Sep 7, 2010 at 9:54 am
  • Greetings, I've got a bunch of tables with the same schema, that I'm accessing via a UNION query. However, I'd like to get the count of returned rows from this query. The best that I've been able to ...
    Lonni J FriedmanLonni J Friedman
    Sep 4, 2010 at 10:28 pm
    Sep 4, 2010 at 10:28 pm
Sep 2010
12
Group Navigation
period‹ prev | Sep 2010 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions52
posts197
users62
websitepostgresql.org
irc#postgresql

62 users for September 2010

Tom Lane: 18 posts Mladen Gogala: 14 posts Josh Kupershmidt: 13 posts Mladen Gogala: 13 posts Rob Richardson: 10 posts Thom Brown: 10 posts Jean-Yves F. Barbier: 8 posts Lukasz Brodziak: 8 posts Thomas Kellerer: 6 posts Turner, John J: 6 posts Frank Bax: 5 posts Machiel Richards: 5 posts Devrim Gündüz: 4 posts Lalebarde: 4 posts Leon Starr: 4 posts Bruce Momjian: 3 posts Jorge Alberto Fuentes Casillas: 3 posts Richard Broersma: 3 posts Sachin Srivastava: 3 posts Salil Wadnerkar: 3 posts
show more
Archives