Search Discussions

35 discussions - 121 posts

  • I'm running psql version 8.1.11 on a Linux server from the command line. It gives me absolutely no feedback from SQL commands and all SQL commands fail, but the internal psql commands such as /d or ...
    John PayneJohn Payne
    Apr 28, 2011 at 3:03 am
    Apr 28, 2011 at 8:38 pm
  • Sorry for getting defensive, and yes I think Leif's suggestion is much better than mine. A statistics program I use (R) has a simple and elegant solution: it drops the cursor one line and puts in a ...
    John PayneJohn Payne
    Apr 28, 2011 at 8:08 pm
    Apr 28, 2011 at 10:58 pm
  • Greetings, I've got a Postgresql-8.4.x instance with a bunch of tables taht have a text column (called 'active') that can contain any one of the following values: NULL 'disabled' <some other text ...
    Lonni J FriedmanLonni J Friedman
    Apr 27, 2011 at 4:27 pm
    Apr 28, 2011 at 1:37 pm
  • Readers, Is it possible to use the result of a SELECT function to populate a new table? The objective is to write the new table for use by gnuplot. The SELECT function features a mathematical ...
    Apr 24, 2011 at 8:52 pm
    Apr 24, 2011 at 9:29 pm
  • After many more hours than it would've taken someone more competent, I finally have postgresql 9.0 installed on my Mac (OS 10.6). Now I'm trying to start the server and create a test database, but ...
    Apr 19, 2011 at 2:47 am
    Apr 19, 2011 at 3:21 pm
  • [postgres@localhost bin]$ ./initdb --enable-selinux -D /opt/sepgsql/ The program "postgres" is needed by initdb but was not found in the same directory as "/usr/local/pgsql/bin/initdb". Check your ...
    H SH S
    Apr 18, 2011 at 9:45 pm
    Apr 19, 2011 at 12:01 pm
  • Hello, I want to compare the time needed to execute 2 queries (which give the same results). Of course this depends on the server load, the network, etc. The basic idea is to use "\timing on" under ...
    Mathieu DuboisMathieu Dubois
    Apr 7, 2011 at 7:52 pm
    Apr 11, 2011 at 5:19 pm
  • Hi, I have standard main 5432 cluster with postgres owner/superuser. I made: su -c "su - postgres" psql -c "\du" List of roles Role name | Attributes | Member of ...
    Grzegorz SzpetkowskiGrzegorz Szpetkowski
    Apr 8, 2011 at 3:15 am
    Apr 8, 2011 at 5:35 pm
  • I installed a new XP SP2 workstation and to my surprise PgAdmin III 1.12.2 (latest version) installs but will not run, gives weird error on start. Yes, XP is still used by us. Mainly due to Mobo ...
    Francisco LeoveyFrancisco Leovey
    Apr 28, 2011 at 1:15 pm
    May 2, 2011 at 2:55 pm
  • Can an after update trigger function do an insert into the the same table ? Thanks Tom -- View this message in context: ...
    Apr 22, 2011 at 2:11 pm
    Apr 22, 2011 at 2:39 pm
  • Would someone kindly offer an opinion as to which of the admin tools below has a better standing in the Postgres community? pgAdmin vs phpPgAdmin Thanks very much. Sandy Keathley
    Sandy KeathleySandy Keathley
    Apr 21, 2011 at 3:27 pm
    Apr 22, 2011 at 12:05 pm
  • Well, this is a novice list, so I hope no one will find me too pitiful to answer. Although I have used Postgres before, some years ago, I had never installed it (maybe I still haven't). I have ...
    Sandy KeathleySandy Keathley
    Apr 20, 2011 at 11:04 pm
    Apr 21, 2011 at 8:30 am
  • I have a table with sampledate, meter1, meter2...etc I am trying to develop a function or query where: select sampledate, (meter1 - (select meter1 where sampledate = sampledate + interval '1 days')) ...
    Mark KingMark King
    Apr 18, 2011 at 3:16 pm
    Apr 18, 2011 at 3:44 pm
  • Hello For a new project where I am running 2 versions of Postgres (8.4 and 9.0) simultaneously on an Ubuntu server: I need the syntax of an SQL statement in order to create tables and all index from ...
    Francisco LeoveyFrancisco Leovey
    Apr 11, 2011 at 3:55 pm
    Apr 11, 2011 at 8:51 pm
  • In standard postgres/main/5432 cluster I created new role (from postgres account): createuser -SRD user psql -c "\du" List of roles Role name | Attributes | Member of ...
    Grzegorz SzpetkowskiGrzegorz Szpetkowski
    Apr 8, 2011 at 3:21 am
    Apr 8, 2011 at 9:39 pm
  • Readers, The command 'INSERT INTO' was used to enter the sum of a mathematical function into a table. On a condition, the result was null, causing the creation of an empty row in the table. Using tho ...
    Apr 26, 2011 at 9:38 pm
    Apr 27, 2011 at 1:31 pm
  • If I have a table that has a column where values can be the same, how can I SELECT them? For example, consider the following table: -------------------------------------- Team Score ...
    Apr 21, 2011 at 5:05 pm
    Apr 26, 2011 at 6:16 am
  • Is there any clear performance difference of using multi-byte character set (such as UTF-8) and single-byte (e.g. SQL_ASCII, LATIN2). Why there is no UTF-32 (generally more space for chars, but ...
    Grzegorz SzpetkowskiGrzegorz Szpetkowski
    Apr 20, 2011 at 8:30 pm
    Apr 21, 2011 at 6:37 pm
  • ?'Range partitioning in PGSQL' Hello Is there as in oracle? My problem is as follows. I have telephone_ subscriber table with tel no as Pkey As the table has to contain millions of rows, I have to ...
    Saseendra BabuSaseendra Babu
    Apr 11, 2011 at 6:28 pm
    Apr 11, 2011 at 8:38 pm
  • Good day, I have a query in which I'm using a function called fx_get_parcel() like this: SELECT fx_get_parcel(cast('cash' AS varchar), cast(rs_i.d_depot AS varchar)) FROM... Without the type casts, ...
    Apr 4, 2011 at 9:07 am
    Apr 5, 2011 at 8:14 am
  • I want to perform an UPDATE to a field in a table. Such a field is of type numeric, does not allow null values and has a default value of 0 (zero). The situation I am facing is that the records that ...
    Apr 26, 2011 at 5:40 pm
    Apr 26, 2011 at 6:05 pm
  • Readers, A csv file contains data with date and time values in format dd/mm/yy hh:mm: number,date time,text So the CREATE command was used: CREATE TABLE tablename (number int,timestamp,text ...
    Apr 23, 2011 at 7:40 am
    Apr 23, 2011 at 8:52 am
  • I want my client app to communicate some information to the Postgres server. Specifically: My app logs into Postgres with its own user-name, rather than the human user's name. I have a trigger to ...
    Basil BourqueBasil Bourque
    Apr 16, 2011 at 3:36 am
    Apr 18, 2011 at 12:48 pm
  • 1


    I am following your website. And here I would like to ask you few questions related to Postgre.Can you please, compare the Postgre Plus Advanced Server with Oracle10g Server Instance. I searched alot ...
    Apr 15, 2011 at 7:20 am
    Apr 15, 2011 at 11:20 am
  • Hi all, I wanted to find out if i can use pg_dump to display dead tuples/rows. Cheers Aaron -- View this message in context: http://postgresql.1045698.n5.nabble.com/pg-dump-tp4281853p4281853.html ...
    Apr 4, 2011 at 2:33 pm
    Apr 5, 2011 at 5:18 pm
  • Hello, i'm considering in using PgSql for my next project. I'm expirenced oracle db developer...Can someone in short describe key differences between the two if that is even possible. For example i ...
    Apr 4, 2011 at 8:27 pm
    Apr 5, 2011 at 3:36 am
  • Hi, I was googling without success to find information about PostgreSQL sessions. I wonder if it's possible to create them and manage them to allow different connections... it would be useful to ...
    Glus XofGlus Xof
    Apr 28, 2011 at 10:26 am
    Apr 28, 2011 at 10:26 am
  • Dear all When database files are on a VxFS filesystem, performance can be significantly improved by setting the VX_CONCURRENT cache advisory on the file according to vxfs document, my question is ...
    Apr 28, 2011 at 3:42 am
    Apr 28, 2011 at 3:42 am
  • Is there any way to obtain server (cluster wide) stats such as: Bytes received - bytes received from all clients Bytes send - bytes sent to all clients Connections - number of connection attempts ...
    Grzegorz SzpetkowskiGrzegorz Szpetkowski
    Apr 27, 2011 at 3:29 pm
    Apr 27, 2011 at 3:29 pm
  • Hello! We are using PostgreSQL as a data storage for C++ application. We are using full-text search within Postgre and trying to reduce search time. I am a novice in configuring Postgre and wanna ask ...
    Apr 26, 2011 at 9:13 am
    Apr 26, 2011 at 9:13 am
  • Hello List, We are getting the following log while configuring hot standby, 2011-04-20 17:34:40 ETC/GMT FATAL: the database system is starting up 2011-04-20 17:34:41 ETC/GMT FATAL: database system ...
    Deka, Rajib IN MAA SLDeka, Rajib IN MAA SL
    Apr 20, 2011 at 1:40 pm
    Apr 20, 2011 at 1:40 pm
  • For reference I am using postgres 8.4. When I create a database and specify the encoding and collation why is it necessary to also set the Ctype? Or alternatively when I set the collation and Ctype ...
    Fletcher JohnsonFletcher Johnson
    Apr 19, 2011 at 3:26 pm
    Apr 19, 2011 at 3:26 pm
  • A quick search on message archives pointed to below link: http://archives.postgresql.org/pgsql-admin/2000-10/msg00000.php http://archives.postgresql.org/pgsql-admin/2002-04/msg00013.php ...
    Chetan SuttrawayChetan Suttraway
    Apr 18, 2011 at 7:16 am
    Apr 18, 2011 at 7:16 am
  • Greetings, I have a table full of automated test data, which continuously has new unique data inserted: Column | Type | Modifiers ...
    Lonni J FriedmanLonni J Friedman
    Apr 12, 2011 at 9:21 am
    Apr 12, 2011 at 9:21 am
  • Hi, I'm relatively new to postgres and at the moment I'm very interested in postgres extensions that can make life easier :) I was wondering if there is an extension (maybe a special data type) that ...
    Christian BChristian B
    Apr 12, 2011 at 7:21 am
    Apr 12, 2011 at 7:21 am
Group Navigation
period‹ prev | Apr 2011 | next ›
Group Overview
grouppgsql-novice @

54 users for April 2011

Tom Lane: 11 posts Grzegorz Szpetkowski: 10 posts Leif Biberg Kristensen: 6 posts Lew: 6 posts John Payne: 5 posts Josh Kupershmidt: 5 posts Robert Poor: 5 posts Francisco Leovey: 4 posts Vibhor Kumar: 4 posts E-letter: 3 posts Lonni J Friedman: 3 posts Mathieu Dubois: 3 posts Pyrogerg: 3 posts Raghu ram: 3 posts Slapo: 2 posts Brent Dombrowski: 2 posts Chetan Suttraway: 2 posts JORGE MALDONADO: 2 posts Mark King: 2 posts Michael Glaesemann: 2 posts
show more