Search Discussions

36 discussions - 125 posts

  • Respected Committers, It may be a silly question, still out of curiosity I want to know, is there any possible way to flush the Postgres Shared Memory without restarting the cluster. In Oracle, we ...
    Raghu ramRaghu ram
    May 3, 2011 at 11:12 am
    May 3, 2011 at 2:58 pm
  • Hello everyone! I read several old messages about encoding. I consult the documentation about initdb and the light bulb still does not “click” over my head. I installed Postgres 8.4 on Windows 2008. ...
    Sébastien D'ErricoSébastien D'Errico
    May 3, 2011 at 1:42 pm
    May 3, 2011 at 6:23 pm
  • I get the following error on running COPY - array value must start with "{" or dimension information CONTEXT: copy tablename, line 1, column field1: ""1"". the structure of the csv file is: ...
    Sindile BidlaSindile Bidla
    May 11, 2011 at 12:10 pm
    May 11, 2011 at 4:11 pm
  • Hi, I am new to PostreqSQL and I would like to know if there is a table in PostregSQL database that contains the Operating System, Platform, and Processor information which the PostregSQL database ...
    Lieu, PeterLieu, Peter
    May 5, 2011 at 12:44 am
    May 5, 2011 at 7:04 pm
  • 5


    Hello, This might seem a Little off topic, but maybe someone here can help me. I need to extract toponomical data from old digitized paper maps. I wish to explore *Optical character recognition ...
    May 4, 2011 at 9:49 am
    May 5, 2011 at 8:57 am
  • Hi list, I need to read/write pictures to my DB and I wonder which column type would be the best? (and DON'T feed the troll: I won't put them onto the FS), client will be written in Python. I ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    May 31, 2011 at 5:09 pm
    May 31, 2011 at 7:53 pm
  • Hi list, I followed the http://www.howtoforge.com/postgresql-ssl-certificates HOWTO and succeeded to install SSL certificates (although pg_hba.conf line should be: hostssl mydb myuser cert ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    May 30, 2011 at 8:31 pm
    May 31, 2011 at 11:16 am
  • Hi All One of our clients are running a combination of postgresql 8.1 and 8.3. On the 8.3 databases I can run the following select in order to determine when last a table was autovacuumed: SELECT ...
    Machiel RichardsMachiel Richards
    May 9, 2011 at 7:54 am
    May 9, 2011 at 12:36 pm
  • Hi all. I'm working with Postgres 9.0 and wxWidgets. I need to query the db about a field of a table. The table T has a field varchar(50). table: TAB0 customer: varchar(50) How can I get the max size ...
    Mauro ZilianiMauro Ziliani
    May 5, 2011 at 8:50 am
    May 5, 2011 at 10:11 am
  • I'm configuring a multi-tenant PostgreSQL server. When I create a new database, anyone can connect to it. For me, that is bad. I run: REVOKE CONNECT ON DATABASE d FROM public; Now I'm only able to ...
    Alan GutierrezAlan Gutierrez
    May 27, 2011 at 7:40 pm
    May 27, 2011 at 11:43 pm
  • I have read the docs twice; I have tried all sorts of things; there must be some way to do this simple thing: Take the result of "show timezone", and assign it to a variable in a function. murf
    Steve MurphySteve Murphy
    May 24, 2011 at 1:21 pm
    May 24, 2011 at 1:59 pm
  • Readers, A database is structured as follows: 1 text1 1000 text2 500 text3 where column 1 consists of integers. Is it possible to create query that will select the most appropriate records for a sum ...
    May 14, 2011 at 10:49 am
    May 15, 2011 at 12:07 pm
  • Hello everybody ! I want to know if I could share PLpgSQL variables between different functions and within different calls just using memory (not tables or other methods). If it is really possible ? ...
    Charles N. CharottiCharles N. Charotti
    May 2, 2011 at 9:43 pm
    May 3, 2011 at 11:14 am
  • Hi list, as the doc says: SELECT name FROM test2 WHERE major = constant AND minor = constant; then it might be appropriate to define an index on the columns major and minor together, e.g.: CREATE ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    May 31, 2011 at 1:18 pm
    May 31, 2011 at 2:31 pm
  • I trying to do a backup on my test database however I get testrec=# select pg_stop_backup(); WARNING: pg_stop_backup still waiting for archive to complete (60 seconds elapsed) WARNING: pg_stop_backup ...
    Birchall, AustenBirchall, Austen
    May 23, 2011 at 10:56 am
    May 23, 2011 at 2:13 pm
  • sir I got a server connection error when connection to linux server RHEL5.The connection is below Error connecting to the server: could not connect to the server: Connection was refused ...
    Sanal mkSanal mk
    May 19, 2011 at 10:35 am
    May 19, 2011 at 12:24 pm
  • I'm an experienced programmer, but for the first time I'm developing an app that connects to a Postgres server over the internet. How do you secure the password used to connect to Postgres? My idea ...
    Basil BourqueBasil Bourque
    May 10, 2011 at 8:07 pm
    May 10, 2011 at 8:31 pm
  • Hi I am about to create my first postgres database with the aim of establishing some backup and recovery routines. While I am OK with creating the basic database my question is: Is there available ...
    Birchall, AustenBirchall, Austen
    May 9, 2011 at 9:41 am
    May 9, 2011 at 2:06 pm
  • I have a script that inserts country names in a table but such names are in lowercase except the first letter. This is an example of what I have: INSERT INTO chartsclub.cat_paises (pss_nombre) VALUES ...
    May 5, 2011 at 6:06 pm
    May 6, 2011 at 3:43 am
  • Hi, Is there any possibility to overcome the restriction to not use a higher number than appr. 100 as an argument for the exponential function in postgres ? Currently, I try to shift a data related ...
    Gregor GT. TrefsGregor GT. Trefs
    May 3, 2011 at 4:36 pm
    May 4, 2011 at 4:54 pm
  • Hello I have the following problem. I am trying to create to tables that both reference each other first try CREATE TABLE A ( pk_a_id INTEGER NOT NULL, fk_main_b_id INTEGER NOT NULL, CONSTRAINT IXP_A ...
    May 3, 2011 at 9:13 am
    May 3, 2011 at 10:30 am
  • Hi everybody i have a error while conencting to the database. i am trying to creating a database from the client on a server and it is reporting the following error.. This is the command *" create ...
    Siva kiran balijepalliSiva kiran balijepalli
    May 2, 2011 at 7:18 am
    May 2, 2011 at 10:54 am
  • Our psql server has been upgraded several times over the years. The start-up includes some -o options, namely: -o '-i -B 3500 -D /var/pgsql/data' I'm looking into replacing cli options with config ...
    Frank BaxFrank Bax
    May 31, 2011 at 10:00 pm
    Jun 11, 2011 at 3:39 am
  • Dear all, Would appreciate some help. I have created an existing database (with PostGIS extension) andhas a table called CAMDENGPS which is populated with approx 600,000 rows. There are 20 or so ...
    James SmithJames Smith
    May 29, 2011 at 8:27 pm
    May 31, 2011 at 5:10 pm
  • Greetings, I am new to linux and I am trying to connect from CentOS 5.6 to a window$ server running PostgreSQL version 8.4.3. I get a message that I do not have the correct drivers installed, I ...
    Dan HajdukDan Hajduk
    May 31, 2011 at 1:43 am
    May 31, 2011 at 8:23 am
  • Hi, The following code works as expected, returning two columns of data (a row number and a valid value): sql_amounts := ' SELECT row_number() OVER (ORDER BY taken)::integer, avg( amount )::double ...
    May 29, 2011 at 9:47 pm
    May 31, 2011 at 1:39 am
  • Is it possible to log the creation and deletion of PostgreSQL users? I'm on PostgreSQL 8.4 and am trying to log using this approach: log_connections = true log_disconnections = true log_statement = ...
    Mike ThomsenMike Thomsen
    May 20, 2011 at 5:05 pm
    May 27, 2011 at 10:07 am
  • I recently installed PostgreSQL8.4 on a PC running WindowsXP. I wasn't paying attention when it asked for a password during the installation process and I think it put in a default password and I ...
    Robert WestRobert West
    May 27, 2011 at 4:01 am
    May 27, 2011 at 10:04 am
  • Hi, We had an application running in our office with PG 8.4 as the back-end. Since the PC went bad, we were to take backup and for some reason we only have the base directory with us. Please advise ...
    Gaurav machallaGaurav machalla
    May 6, 2011 at 11:29 am
    May 27, 2011 at 9:58 am
  • Hi, I'm attempting to import data into a Postgresql database, which was defined as using a utf8 character set. A few of the text fields in my import contain accented characters (SAINT-ANDRÉ) as an ...
    Chris CampbellChris Campbell
    May 26, 2011 at 7:28 pm
    May 26, 2011 at 8:51 pm
  • Readers, For a table: value name 10 text1 20 text2 30 text3 40 text4 The function SELECT ... WHERE cannot be used with an aggregate function SUM. Is it possible to obtain a result of the rows where ...
    May 22, 2011 at 7:57 am
    May 23, 2011 at 2:09 pm
  • Hi once again Am I right to assume that running a pg_dumo -Fc against a database: (i) Does not require WAL log archiving be be switched on? (ii) That running this will have no (or a very small) ...
    Birchall, AustenBirchall, Austen
    May 12, 2011 at 1:29 pm
    May 14, 2011 at 1:44 pm
  • Hi again and thanks for your help on my previous post. Now I ask: From the docs it seems that if I wish to enable WAL archiving for a database I change the settings of archive_mode ...
    Birchall, AustenBirchall, Austen
    May 12, 2011 at 8:32 am
    May 12, 2011 at 9:41 am
  • I need to design a query statement and this is the general structure of what I have in mind: SELECT STATEMENT (EXCEPT (SELECT STATEMENT)) UNION SELECT STATEMENT (EXCEPT (SELECT STATEMENT)) Is this a ...
    May 10, 2011 at 10:30 pm
    May 10, 2011 at 10:30 pm
  • Hi, It just occurred to me that it is not necessarily the case that reading the indexes causes a lot of random I/O (on the index itself). I mean, maybe the index is generally read sequentially and ...
    Willy-Bas LoosWilly-Bas Loos
    May 5, 2011 at 3:28 pm
    May 5, 2011 at 3:28 pm
  • Is there provision for creating none numeric exclusion constraints on GIST indexes? From my reading of the following, ti doesn't appear to be possible: ...
    Richard BroersmaRichard Broersma
    May 5, 2011 at 3:15 pm
    May 5, 2011 at 3:15 pm
Group Navigation
period‹ prev | May 2011 | next ›
Group Overview
grouppgsql-novice @

60 users for May 2011

Grzegorz Szpetkowski: 10 posts Jean-Yves F. Barbier: 8 posts Birchall, Austen: 5 posts Michael Wood: 5 posts Simon Riggs: 5 posts Tom Lane: 5 posts Francisco Leovey: 4 posts Merlin Moncure: 4 posts Chetan Suttraway: 3 posts E-letter: 3 posts Frank Bax: 3 posts Gregor Trefs: 3 posts Machiel Richards: 3 posts Mauro Ziliani: 3 posts Raghu ram: 3 posts Sindile Bidla: 3 posts Willy-Bas Loos: 3 posts ALT SHN: 2 posts Andreas Kretschmer: 2 posts Cédric Villemain: 2 posts
show more