Search Discussions

35 discussions - 126 posts

  • I installed CentOS 4 which included Postgresql 7.something, updated to final, but it seems that the configuration was not done during install. On top of that, the file structure doesn't match what's ...
    Bruce HyattBruce Hyatt
    Apr 28, 2008 at 11:56 pm
    May 4, 2008 at 12:32 am
  • Dear list, I am trying to connect to my database over the network. When trying to connect to the server from a Windows client via psql with #- psql -h pg_server_ip -d postgres -U postgres OR #- psql ...
    Nils ZierathNils Zierath
    Apr 16, 2008 at 5:58 pm
    Apr 22, 2008 at 12:38 pm
  • Readers, I play chess and occasionally (i.e. when I win!) I save the moves to a text file, of the following format: [Event "Online Game"] [Site "www.flyordie.com"] [Date "yyyy.mm.dd"] [Round "1"] ...
    Apr 13, 2008 at 6:58 am
    Apr 22, 2008 at 10:20 am
  • Is it possible for a whole set of sequences to suddenly 'jump'? I have a set of claims tables that cover the claim itself, the customer, contact points etc. Yesterday there was a power failure and ...
    Steve TSteve T
    Apr 15, 2008 at 9:35 am
    Apr 15, 2008 at 5:04 pm
  • What is the best way to dump a database? Currently, I am using pg_dump dbname. However, my data contains a lot of escape sequences and various characters which is causing a restore problem. How can I ...
    Mag GamMag Gam
    Apr 6, 2008 at 8:25 pm
    Apr 7, 2008 at 4:16 am
  • Readers, I am using a program that saves data in csv format. I have realised that I cannot view the file in my spreadsheet due to 256 column limit. I think that I need to import the file into a ...
    Apr 2, 2008 at 2:56 pm
    Apr 3, 2008 at 3:00 pm
  • Hi, I have a question, that's probably really stupid, but could someone please explain to me what difference there is between a WHERE clause and a HAVING clause besides the syntax? I read the ...
    Adam ŠindelářAdam Šindelář
    Apr 28, 2008 at 7:22 pm
    Apr 28, 2008 at 9:10 pm
  • I have found a nasty bug in one of the trigger function I did put into production a couple of days ago. I have a fix for it but wonder if I can put it into the production database with users ...
    Didier Gasser-MorlayDidier Gasser-Morlay
    Apr 24, 2008 at 9:08 am
    Apr 25, 2008 at 5:03 am
  • Probably a silly question but if I restore with pg_restore to an existing database I get several messages 'primary key violation' ... clearly if I restore to a database I create for the occasion, ...
    Didier Gasser-MorlayDidier Gasser-Morlay
    Apr 23, 2008 at 4:21 pm
    Apr 25, 2008 at 4:59 am
  • hi all please i have one question. I made table called tab_article with CREATE TABLE "tab_article" ( "id" serial NOT NULL PRIMARY KEY, "flag" boolean NOT NULL, "title" text NOT NULL, "journal" ...
    Pavel SRBPavel SRB
    Apr 7, 2008 at 8:58 pm
    Apr 8, 2008 at 4:31 am
  • Greetings, This is a followup to an issue that I had about 9 months ago: http://archives.postgresql.org/pgsql-novice/2007-08/msg00067.php Back then, I was effectively mangling timestamps in a table, ...
    Lonni J FriedmanLonni J Friedman
    Apr 29, 2008 at 5:12 pm
    Apr 29, 2008 at 8:27 pm
  • Hello, We've just put into production with our main application which we ported from MSSQLserver to PostgreSQL; We are overall very pleased with PostgreSQL speed and stability are fantastic. We have ...
    Didier Gasser-MorlayDidier Gasser-Morlay
    Apr 22, 2008 at 5:18 pm
    Apr 24, 2008 at 9:12 am
  • Hi All, While reading this article, History tables and event logging -- http://www.ibm.com/developerworks/web/library/wa-dbdsgn2.html, I realized I try to do event logging in SQL. My question are: Is ...
    Mag GamMag Gam
    Apr 17, 2008 at 7:43 pm
    Apr 20, 2008 at 6:33 pm
  • Hi, I've got to import data into a remote database. I get some stuff usually as excel-files that doesn't fit the db-structure in respect of normalisation so I import it into Access, brush up the data ...
    Apr 16, 2008 at 1:54 am
    Apr 16, 2008 at 11:04 am
  • Hi, Is there a way to make postgresql to automatically convert integer values to boolean? Consider create table x (a boolean); insert into x (a) values (1); the inser fails :-( Is there a way to make ...
    A BA B
    Apr 8, 2008 at 9:54 am
    Apr 8, 2008 at 10:06 am
  • I'm wondering if there is a way to write an expression on an expression alias... or 'build on' an existing expression alias. I am slowly converting old Filemaker work to PG and the below would be ...
    Mike EllsworthMike Ellsworth
    Apr 18, 2008 at 8:21 pm
    Apr 18, 2008 at 8:42 pm
  • I have a query: SELECT fruit, group_number, ordering_number FROM fruit_groups ORDER BY group_number, order_number; The results look like: fruit | group_number | ordering_number ...
    Derrick BettsDerrick Betts
    Apr 13, 2008 at 3:00 am
    Apr 13, 2008 at 6:41 pm
  • Hi list: I uploaded a table using psql command to both Postgres 8.0 and 8.2. The upload to 8.2, I got a warning message: INSERT 01 psql:XXXX.sql :01: WARNING: OGC WKT expected, EWKT provided - use ...
    Jessica FendosJessica Fendos
    Apr 9, 2008 at 9:52 pm
    Apr 10, 2008 at 1:36 pm
  • Hi, I am trying to write a function, and have written this : var_params_shootingstar := $v$ WHERE ( t1.status = TRUE, AND ( ( ( SELECT z( pointn( geometryn(d3.the_geom,1), 1) ) AS z FROM streets_3d ...
    Matthew PulisMatthew Pulis
    Apr 9, 2008 at 10:46 am
    Apr 9, 2008 at 11:10 am
  • Hi, I'm still doing test with PostgreSQL with C++ Builder using MicroOLAP DAC and one big problem I have is with numerical data type. Suppose the following table: CREATE TABLE "TestNumbers" ( ...
    Francois CoteFrancois Cote
    Apr 4, 2008 at 7:48 pm
    Apr 8, 2008 at 12:03 pm
  • Hello. What is the proper way of inserting stuff into a table with two fields (A and B) with a constraint unique(A,B) and you suspect you will get some unique constraint violations? Should I just do ...
    A BA B
    Apr 29, 2008 at 7:56 am
    Apr 30, 2008 at 6:45 am
  • Hi Everyone, May I ask your advices about the following hardware configuration : DELL PE2900 III - Quad-Core Xeon X5450 3.0GHz/2x6MB 4GB 667MHz 6 X 1TB SATA (7.200 rpm) RAID 1/0 or RAID 0/1 PERC 6/i ...
    Apr 29, 2008 at 7:36 am
    Apr 29, 2008 at 11:25 pm
  • With this group's help (which is MUCH appreciated, thanks) I am slowly starting to live with Postgres in a production environment. I have setup an automated backup/restore between two machines, all ...
    Didier Gasser-MorlayDidier Gasser-Morlay
    Apr 26, 2008 at 6:51 pm
    Apr 26, 2008 at 8:07 pm
  • Hello, We clearly have a bug in our application: sometimes for reasons we have not been able to understand yet, the application will start creating connection like madness (several dozens in a matter ...
    Didier Gasser-MorlayDidier Gasser-Morlay
    Apr 24, 2008 at 9:18 am
    Apr 24, 2008 at 9:28 am
  • what's the syntax of the PGOPTIONS environment variable? I'm trying to put something like 'autocommit=off', but more generally I want to know all the options that it has. regards
    Fernando FontanaFernando Fontana
    Apr 22, 2008 at 6:45 pm
    Apr 22, 2008 at 11:59 pm
  • I have a function defined as: CREATE OR REPLACE FUNCTION word_doc_from_raw(character varying, character varying, bytea) RETURNS record AS $BODY$ SELECT ROW( id_from_word( $1 ), id_from_doc_name( $2 ...
    Apr 16, 2008 at 7:48 am
    Apr 16, 2008 at 1:55 pm
  • Hai, I use Debian Etch. I have a problem with postgresql 8.1. I have uninstalled the postgresql-8.3, which I was took from debian back ports, removed its configuration files, and the user postgres ...
    Jaisen N.D.Jaisen N.D.
    Apr 12, 2008 at 5:31 am
    Apr 13, 2008 at 4:25 am
  • Hi all. I hope someone can help me with a problem that's been bedeviling me for a couple of days now. I'm on a development team that's using PostgreSQL and we're all supposed to be using the same ...
    Justin BaileyJustin Bailey
    Apr 8, 2008 at 12:27 am
    Apr 9, 2008 at 2:50 pm
  • Hey folks! First off - been using postgres for a short time and am really impressed! Much more professional than mysql. When I saw a query plan that actually looked like a query plan I was very ...
    Mat DodgsonMat Dodgson
    Apr 1, 2008 at 12:15 pm
    Apr 1, 2008 at 2:44 pm
  • To find out more about Twitter, visit the link below: http://twitter.com/i/b092aaa2423cb06f296e89ebd180650b8839a3d8 Thanks, -The Twitter Team About Twitter Twitter is a unique approach to ...
    Apr 30, 2008 at 1:43 am
    Apr 30, 2008 at 1:43 am
  • Hi - I'm looking for a variety of info about tables and databases in my system (pg 8.1.4, solaris 10). I'm looking for 1. creation date of a database 2. creation date of a table 3. date of last ...
    Mija LeeMija Lee
    Apr 18, 2008 at 8:15 pm
    Apr 18, 2008 at 8:15 pm
  • Hello, I would like to use a temp table to store some calculations that i use later on. The problem is that if i create such a table, drop it and then create it again during the same session the ...
    Michal KochanowskiMichal Kochanowski
    Apr 9, 2008 at 11:44 am
    Apr 9, 2008 at 11:44 am
  • Hi Guys, Broadly, I'm trying to read and write to a postgres database from a VB6 application. There's seems to be two main ways to accomplish this; OleDB or ODBC and I hit a roadblock with both of ...
    Karl MartindaleKarl Martindale
    Apr 7, 2008 at 2:14 am
    Apr 7, 2008 at 2:14 am
  • Hello! I have attempted to install a session handler based on the script laid out on page 442 of "Beginning PHP and PostgreSQL 8". The script works correctly in that session info is written to the ...
    G. J. WalshG. J. Walsh
    Apr 5, 2008 at 10:42 pm
    Apr 5, 2008 at 10:42 pm
  • postmaster logger process background writer wal writer autovacuum stats collector wal writer is listed in the 8.3 release notes as new. background writer, stats collector, and autovacuum are on by ...
    John KollerJohn Koller
    Apr 5, 2008 at 3:24 am
    Apr 5, 2008 at 3:24 am
Group Navigation
period‹ prev | Apr 2008 | next ›
Group Overview
grouppgsql-novice @

52 users for April 2008

Tom Lane: 15 posts Didier Gasser-Morlay: 10 posts Sean Davis: 9 posts E-letter: 7 posts Nils Zierath: 5 posts Mag Gam: 4 posts Phillip Smith: 4 posts Steve T: 4 posts A B: 3 posts Andrej Ricnik-Bay: 3 posts Bruce Hyatt: 3 posts Frank Bax: 3 posts Mike Ellsworth: 3 posts Pavel SRB: 3 posts Adam Šindelář: 2 posts Andreas: 2 posts Andreas Kretschmer: 2 posts Derrick Betts: 2 posts Emil Obermayr: 2 posts Francois Cote: 2 posts
show more