Search Discussions

77 discussions - 211 posts

  • Hi all, I cannot to get this to run... I think I am mistaking some basic concept or I have a big brain-lock . Somebody know what is the problem to execute this function ? Thanks in advance... ...
    Terry YaptTerry Yapt
    Sep 10, 2002 at 3:32 pm
    Dec 16, 2004 at 6:01 pm
  • I don't have a clue why it's doing this - has anyone else seen this sort of behavior, or know why it might be doing it? It shows times wrong, for instance, it shows 00:04:60 where it should show ...
    Casey Allen ShobeCasey Allen Shobe
    Sep 15, 2002 at 7:58 am
    Sep 17, 2002 at 5:15 am
  • Hi there, I've just been trying to install Postgresql 7.2.2 on Debian Sid/Unstable and have been repeatedly failed to do so. I believe the problem is related to there being "Unknown id: -" The ...
    Sep 25, 2002 at 6:16 am
    Sep 26, 2002 at 8:58 am
  • /* I have a bit theoretical and/or practical problem that I am trying (and I would like) to resolve with PL/PGSQL language. In summary: =========== Sum(Table A) generates Table B. Primary key on ...
    Terry YaptTerry Yapt
    Sep 11, 2002 at 1:34 pm
    Sep 11, 2002 at 9:44 pm
  • Hi All, I'm trying to format a date type column, which contains some nulls. I'm getting an error: ewtest=# select to_char(birthday, 'YYYY-MM-DD') from contacts; ERROR: Unable to convert date to tm ...
    Eric WalstadEric Walstad
    Sep 2, 2002 at 10:50 pm
    Sep 4, 2002 at 5:20 am
  • hi all, I am using postgresql from a c application with asyncronous Query processing. Since only 1 query can be executed at a time, i am using a buffering mechanism to store the other queries ...
    Sep 25, 2002 at 4:39 am
    Oct 4, 2002 at 5:12 am
  • Hello, I am using Zope with Postgre with Psycopg. Now I have 4 related tables, and would like to write a query which will input data from one html form. So here are my tree sql statements, is there a ...
    Norman KhineNorman Khine
    Sep 22, 2002 at 9:18 pm
    Sep 23, 2002 at 9:56 am
  • I have problems after exporting then importing data into newly created databases that the sequence and the indexed serial fields get out of alignment. I wonder if it isn't better to always simply ...
    Rory Campbell-LangeRory Campbell-Lange
    Sep 19, 2002 at 2:14 pm
    Sep 22, 2002 at 4:16 pm
  • Hi all, I am trying to setup logging. I have updated the postgresql.conf by making the following changes: #debug_level = 0 # range 0-16 debug_level = 2 # range 0-16 #debug_print_query = false ...
    Devinder K RajputDevinder K Rajput
    Sep 25, 2002 at 6:37 pm
    Sep 27, 2002 at 5:52 am
  • While converting data to PostgreSQL (using PostgreSQL ODBC) I got the following message: Connectivity error: ERROR: cannot extend addresses_pkey: No space left on device. Check free disk space. I ...
    Joachim SmitJoachim Smit
    Sep 24, 2002 at 2:51 am
    Sep 25, 2002 at 4:03 am
  • Hi, I've been meaning to recompile with Java enabled, and got around to it this morning. Got Ant, built & installed it. Then ran: "./configure --enable-locale --enable-recode --enable-multibyte ...
    Joel RodriguesJoel Rodrigues
    Sep 17, 2002 at 10:06 am
    Sep 19, 2002 at 9:43 am
  • I've tried searching the archives for a solution to this, but I was unable to find it. So, I hope you'll forgive my newbie question if it's been asked before. I'm trying to backup a database on our ...
    Curtis MortensenCurtis Mortensen
    Sep 6, 2002 at 7:07 pm
    Sep 11, 2002 at 9:50 pm
  • I see in the documentation that a unique index does not place any constraints on the number of nulls in a table. In my case, I have a table with has four columns (plus other data) where that ...
    Roland RobertsRoland Roberts
    Sep 11, 2002 at 2:26 am
    Sep 11, 2002 at 5:21 pm
  • Hello, No doubt this is a simple question for those more experienced with SQL than I (that is, most everyone), but I'm stumped. For the table in question, each row represents some information about a ...
    Mark FletcherMark Fletcher
    Sep 3, 2002 at 6:20 am
    Sep 3, 2002 at 2:13 pm
  • Hello, Are there any open source applications that access PostgresQL using libpq (the C API to PostgresQL)? I would like access to the sources of such applications. Thanks in advance, Sandeep.
    Sandeep SikkaSandeep Sikka
    Sep 30, 2002 at 8:54 pm
    Oct 5, 2002 at 12:09 am
  • Not sure if it's a concern, but when I downloaded the 7.2.2 version, the MacAfee virus scan flags the file as containing a virus. MD5 checks out OK. Any idea why this happens? And is there a ...
    J Matt ClarkJ Matt Clark
    Sep 29, 2002 at 5:40 pm
    Oct 1, 2002 at 8:19 pm
  • Looking for a quick and dirty way to programmatically write to an ASCII file (not looking for a COPY). Something similar to utl_file.fopen and utl_file.put_line in Oracle. Thanks
    Sep 20, 2002 at 7:51 pm
    Sep 25, 2002 at 1:18 pm
  • I have written a function that will allow connections to the postgresql database using tcp/ip sockets written in 'C'. I have one application (still in load testing phase) that runs fine and I can ...
    Randy NeumannRandy Neumann
    Sep 6, 2002 at 3:58 pm
    Sep 9, 2002 at 5:38 pm
  • Hi all. I search papers about PostgreSQL all other the web and i can't find these. Someon can tell me where I could find : On Rules, Procedures, Caching and Views in Database Systems ...and... A ...
    Jerome ChochonJerome Chochon
    Sep 3, 2002 at 9:36 am
    Sep 3, 2002 at 12:46 pm
  • Hello, I am storing a schedule of services in a restaurant database (e.g. breakfast, lunch...), and want to be able to order the results by the day of the week. The table is as follows. Table ...
    D. A.D. A.
    Sep 28, 2002 at 1:35 am
    Sep 29, 2002 at 12:30 am
  • I would like to be able to redefine a field in a table to be a foreign reference -- however this field was initially defined as just "serial" and not "serial primary key". I tried to add that ...
    Doug SilverDoug Silver
    Sep 25, 2002 at 4:51 pm
    Sep 25, 2002 at 5:37 pm
  • Hi I am having trouble installing pgcrypto. PostgreSQL version: 7.2.2 In short I don't know where to start, I have experience with MySQL and wanted to use something similar to the password() function ...
    Steinn E. SigurdarsonSteinn E. Sigurdarson
    Sep 23, 2002 at 2:25 pm
    Sep 25, 2002 at 4:39 pm
  • Hello all, I am installing a new postgreSQL 7.2.2 in a fresh RedHat 7.3 installation. I have downloaded the source pgsql files. I am having problems with readline library, I mean: I don't have tab, ...
    Terry YaptTerry Yapt
    Sep 16, 2002 at 12:12 pm
    Sep 16, 2002 at 8:43 pm
  • Hi i would like to know if i can use the database and in the same time make a backup without stop the database? Is it the backup very good or not? can i program the backup? Thanks
    Florian LitotFlorian Litot
    Sep 11, 2002 at 12:35 pm
    Sep 16, 2002 at 8:14 pm
  • I can't seem to get the quoting around "Customers" right in the statement below. In db2, I can use \' to escape the quote, and it will insert into the database properly. How do I insert single quote ...
    Casey Allen ShobeCasey Allen Shobe
    Sep 15, 2002 at 11:56 am
    Sep 15, 2002 at 3:07 pm
  • Hi, I need to changes to pg_hba.conf and now need to "SIGHUP the postmaster" Does anyone no how to do this. Thx Mark
    Mark SeftelMark Seftel
    Sep 14, 2002 at 10:02 pm
    Sep 14, 2002 at 10:05 pm
  • I have a table that lists numbers and gives them a rank either 'A' or 'B'. There is a ranking of 'C' if the number is not in this table. I have another that lists numbers. It is very easy to find ...
    Chad ThompsonChad Thompson
    Sep 11, 2002 at 9:39 pm
    Sep 11, 2002 at 10:56 pm
  • Hi all, I am very new to the Postgres subject and hope that someone will take the time to answer this, or point me the right direction: 1. How do I go about installing Postgres on a Windows Box? Does ...
    Sep 11, 2002 at 2:18 pm
    Sep 11, 2002 at 2:36 pm
  • I can't work out how to delete users from Postgresql? DSL -- Con te partiro, su navi per mari Che io lo so, no, no non esistono piu Con te io li vivro. (Sartori F, Quarantotto E)
    David LloydDavid Lloyd
    Sep 10, 2002 at 12:54 pm
    Sep 11, 2002 at 2:06 pm
  • Hi I'm using pg 7.2 in s SuSE 8.0 box. I have no problem loging from the command line with psql -U ernesto -d docmgr but I'm unable to login from pgaccess or TOra. It gives an error of connection ...
    Ernesto JardimErnesto Jardim
    Sep 10, 2002 at 2:13 pm
    Sep 10, 2002 at 4:49 pm
  • hi all I am using postgres 7.1.3 on redhat 7.2. i have a table with the following entry: wire_dev=# select * from power where sys_key = 10; num | cercuit | phase | ref | sys_key | red | power_id | ...
    Duncan Adams (DNS)Duncan Adams (DNS)
    Sep 10, 2002 at 12:50 pm
    Sep 10, 2002 at 3:40 pm
  • Hello, Anyone know why trying to create this column : "gender CHAR(1) CHECK (gender IN ('M','F'))" Results in this error: ERROR: Unable to locate type name '? in catalog It appears on: ...
    Joel RodriguesJoel Rodrigues
    Sep 7, 2002 at 2:02 pm
    Sep 9, 2002 at 7:03 pm
  • Hi: Are the following error PostgreSQL related? Has anyone seen this message before? This came from the syslog file. I saw this when I was in midst of executing a complicated query. Sep 25 21:28:06 ...
    Ludwig LimLudwig Lim
    Sep 28, 2002 at 7:28 am
    Sep 29, 2002 at 7:43 pm
  • What is the best way (I mean, the simple way) to install PostgreSQL and libpq on a Mac OS X 10.2 (Jaguar) system. I would preferred not compiling... Thanks ------------------- Stéphane Pinel
    Stéphane PinelStéphane Pinel
    Sep 26, 2002 at 6:37 am
    Sep 26, 2002 at 8:46 am
  • Currently I have a perl script that I use to cleanse text fields in a file for use in our mainframe. I would like to do this as a function and bypass using perl if possible. Is this possible? I do ...
    Patrick HatcherPatrick Hatcher
    Sep 25, 2002 at 3:31 pm
    Sep 25, 2002 at 4:21 pm
  • Hi: I want to create a function that will return rows from a table based upon a parameter that I pass. TABLE - NAMES int ID, varchar(50) NAME, varchar(50) ADDRESS, char(2) STATE I would like my ...
    Jim SteilJim Steil
    Sep 24, 2002 at 7:01 pm
    Sep 25, 2002 at 8:08 am
  • Hello, Postgres newbie here. I have the following table: id code version active process 1 PAP1 1 0 0 2 PAP1 1 1 5 3 PAP2 1 0 0 4 PAP2 2 1 8 5 PAP1 1 1 17 It means that: I have objects identified by ...
    Ciprian PopoviciCiprian Popovici
    Sep 19, 2002 at 8:58 am
    Sep 19, 2002 at 10:36 am
  • (Not sure which list to post this to, so I'm doing novice and php). Using php, I create a table with a SERIAL field. In the same script, the last thing I do is a COPY ... FROM ... USING ...
    Jim BeckstromJim Beckstrom
    Sep 18, 2002 at 6:47 pm
    Sep 18, 2002 at 7:16 pm
  • Hi all I must be reading the wrong documentation but i just can't get the following function working. I don't get an error but it appears as if the function goes in to a loop. I could do this with ...
    Duncan Adams (DNS)Duncan Adams (DNS)
    Sep 17, 2002 at 3:47 pm
    Sep 17, 2002 at 4:11 pm
  • We've been trying to alter user postgres with passwd '...' createdb createuser; and the like, and we get alter user output showing that the command is successful. However, when we later psql -U ...
    Sep 11, 2002 at 5:36 pm
    Sep 16, 2002 at 8:21 pm
  • Hi, I need to changes to pg_hba.conf and now need to "SIGHUP the postmaster" Does anyone no how to do this. Thx Mark
    Mark SeftelMark Seftel
    Sep 14, 2002 at 10:00 pm
    Sep 16, 2002 at 8:18 pm
  • Hi, I am using a Live PostgreSQL database system for multiple web applications. Everything was all working fine until completely at random the database engine came up with a JDBC error: "The backend ...
    Brendon MatthewsBrendon Matthews
    Sep 11, 2002 at 12:36 am
    Sep 16, 2002 at 3:58 pm
  • Hello guys, Again I'm having the same problem with postgres 7.2.1. Let me explain: When i do a: \dt or \dS i get: belbonedb_v2=# \dS ERROR: AllocSetFree: cannot find block containing chunk 4da330 ...
    Sep 16, 2002 at 12:31 pm
    Sep 16, 2002 at 12:39 pm
  • Under src/interfaces/odbc, connection.c generates the SQL statement select oid from pg_type where typname = '" PG_TYPE_LO_NAME"'; and PG_TYPE_LO_NAME is 'lo' lo does not seem to exist in pg_type. ...
    J Matt ClarkJ Matt Clark
    Sep 14, 2002 at 9:24 pm
    Sep 14, 2002 at 9:51 pm
  • I am attempting to convert an existing DB and client code from DB2 and/or Oracle to run using PostgreSQL. One major problem is that there appear to be a number of words that cannot be used as column ...
    Matt ClarkMatt Clark
    Sep 12, 2002 at 9:25 pm
    Sep 13, 2002 at 4:38 am
  • Hi! I use debian woody and postgres version 7.2.1 which. i am tring to keep my system up with official debian fixes and updates. I did the usual apt-get update && apt-get upgrade and forgot to ...
    Imre OolbergImre Oolberg
    Sep 12, 2002 at 9:58 pm
    Sep 12, 2002 at 10:25 pm
  • I have been trying to get postgresql version 7.2.2 up and running properly on a SuSE 8.0 machine. SuSE comes with a 7.1.* version, which installs into /var/lib/pgsql in part, but distributes the ...
    John DoughertyJohn Dougherty
    Sep 11, 2002 at 10:00 pm
    Sep 12, 2002 at 4:35 am
  • How can I update several columns in one UPDATE query ? The users's guide says: UPDATE table SET col = expression [, ...] [ FROM fromlist ] [ WHERE condition ] CREATE TABLE time( orderdate date, day ...
    Sudharshan ReddySudharshan Reddy
    Sep 9, 2002 at 1:55 am
    Sep 9, 2002 at 2:39 pm
  • I'm using Kdevelop and PostgreSQL 7.0.3. When compiling, including libpq++, I have the following errors : everytime there is the word string in .h files from libp++, Kdevelop said there is a syntax ...
    Torres Montañes Manuel EduardoTorres Montañes Manuel Eduardo
    Sep 6, 2002 at 10:25 pm
    Sep 6, 2002 at 10:26 pm
  • Is there any way to enforce a reference on an array datatype?
    Rod KreislerRod Kreisler
    Sep 5, 2002 at 5:07 pm
    Sep 6, 2002 at 6:54 pm
Group Navigation
period‹ prev | Sep 2002 | next ›
Group Overview
grouppgsql-novice @

86 users for September 2002

Tom Lane: 25 posts Oliver Elphick: 15 posts Josh Berkus: 10 posts Terry Yapt: 9 posts Casey Allen Shobe: 6 posts David Lloyd: 6 posts Chad Thompson: 4 posts Joel Rodrigues: 4 posts Norman Khine: 4 posts Roland Roberts: 4 posts Wim: 4 posts Curtis Mortensen: 3 posts Devinder K Rajput: 3 posts Duncan Adams (DNS): 3 posts Eric Walstad: 3 posts Giles Lean: 3 posts Jerome Chochon: 3 posts Joachim Smit: 3 posts Paul butler: 3 posts Steinn E. Sigurdarson: 3 posts
show more