Search Discussions

83 discussions - 207 posts

  • I remember seeing something about issues with PHP using Postgrs persistent connections. I have been unable to find anything in the archives. I have been having a problem where backend processes ...
    Nov 23, 2000 at 3:10 am
    Nov 27, 2000 at 4:57 pm
  • Hello all. It's like this. ;-) I have a table with a column that has a default nextval('sequence'). The sequence is a standard increment 1 cycle sequence. What happens when the sequence wraps after ...
    Nov 23, 2000 at 7:44 pm
    Nov 26, 2000 at 10:47 am
  • Not just a pgsql novice, but an SQL novice in general. Is there an equivalent for the SQL command DESC for listing the columns and their various types? (I've played around with Oracle's sqlplus stuff ...
    Mike CastleMike Castle
    Nov 21, 2000 at 7:00 pm
    Nov 22, 2000 at 10:51 pm
  • I have compiled succesfully PostgreSQL 7.0.2, and I had ran psql at least twice and built a database without problem. Now psql is not starting and throws the following message: psql: FATAL 1: ...
    Diego A. Puertas F.Diego A. Puertas F.
    Nov 9, 2000 at 1:18 pm
    Nov 9, 2000 at 9:01 pm
  • Hi - There has been suggestions to start psql with the -E switch to see the queries that the \ commands exectue. However, 1-I can not use this option...we are currently running 6.3 version and I only ...
    Beth GatewoodBeth Gatewood
    Nov 2, 2000 at 12:38 am
    Jan 17, 2001 at 5:54 pm
  • Good time of the day! I'm a real novice to PostgreSQL, so please be patient with me :)) I've run into few questions I can't find answers to... Will appreciate any responce. 1. Is it possible to ...
    Dmitri TouretskyDmitri Touretsky
    Nov 26, 2000 at 1:54 am
    Nov 26, 2000 at 5:36 am
  • Hello ! I want to do a VACUUM ANALYSE on some tables but when i do : EDEN= VACUUM ANALYSE cvdb; ERROR: parser: parse error at or near "cvdb" But cvdb is a working table. Does someone have a idea of ...
    Mickaël JouanneMickaël Jouanne
    Nov 8, 2000 at 5:38 pm
    Nov 8, 2000 at 9:28 pm
  • I'm working on a scheduler, and my first inclination was to use tinterval (since I happen to have data available in YYYY-MM-DD HH:MM-HH:MM anyway). After some trial and error, I've finally discovered ...
    Mike CastleMike Castle
    Nov 24, 2000 at 5:43 pm
    Nov 24, 2000 at 11:20 pm
  • Hello ! We had a database server on Mysql and we move to postgres last month. But there is problems that i don't understand ! When i runthe "top" command the load average is very high : 'load ...
    Mickaël JouanneMickaël Jouanne
    Nov 20, 2000 at 10:31 am
    Nov 20, 2000 at 2:12 pm
  • Hi, I am following Chris's postgres tutorial at http://users1.50megs.com/tomcat/postgresql-tutorial/. I am currently trying to grant browser access to the database, but it comes back with: ...
    James SnellingJames Snelling
    Nov 15, 2000 at 1:57 pm
    Nov 16, 2000 at 12:34 pm
  • ** Reply Requested When Convenient ** Is anybody using MS Access as an interface to PgSQL in a network environment? Mike Hammonds, CNE5, MCP-NT Fellon-McCord & Associates, Inc. Office: 502.426.4500 ...
    Mike HammondsMike Hammonds
    Nov 13, 2000 at 4:10 pm
    Nov 13, 2000 at 9:25 pm
  • Hi all, I have a Database and my interface is with PHP, but I hace problems, I can connect to a Data Base using PHP with using login and password. If I have an user with restricted privileges, how ...
    Luz LopezLuz Lopez
    Nov 7, 2000 at 6:17 pm
    Nov 7, 2000 at 6:33 pm
  • Is there some way for Postgres to recover from "frozen" locks? Ex: PHP opens a persistent connection to the database. Script queries and recieves a lock. Something happens so that the lock is not ...
    Nov 25, 2000 at 9:29 pm
    Nov 25, 2000 at 10:56 pm
  • I just instaled the version 7.0.3 on a FreeBSD. i made : ./configure gmake gmake install adduser postgres su -postgres /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data ...
    Nov 21, 2000 at 1:46 pm
    Nov 21, 2000 at 3:46 pm
  • I've been trying to upgrade from 6.5 to 7.0. Red hats upgrade scripts didn't work. I finally ended up reinstalling 6.5 on my machine at home and have been trying to use pg_dumpall to dump my database ...
    Kevin StachowskiKevin Stachowski
    Nov 18, 2000 at 10:16 pm
    Nov 19, 2000 at 6:04 pm
  • Hello, I have just started learning about PostgreSQL. I am fairly familiar with MySQL/Perl DBI. I have some perl code that I downloaded that talks to a pgsql database and am trying to understand one ...
    OTR CommOTR Comm
    Nov 16, 2000 at 4:11 am
    Nov 16, 2000 at 3:58 pm
  • Hello! How i do a replication of my database in other server?, is posible?? how?? where can I get some information? Thanks Mauricio Alarcon
    Mauricio AlarconMauricio Alarcon
    Nov 14, 2000 at 12:25 pm
    Nov 15, 2000 at 5:44 am
  • I have an integer column which holds a time represented as the number of seconds since 1970/01/01 00:00 UTC. I want to view this table with the time converted to an understandable text string. I've ...
    Bill MorrowBill Morrow
    Nov 14, 2000 at 11:05 pm
    Nov 15, 2000 at 1:50 am
  • Hello ! I have a table with : prixandern | smallint | prixcvdern | smallint | but i want to change smallint to bigint without droping the table. How can i make that ? thx for answers. -- Mickaël ...
    Mickaël JouanneMickaël Jouanne
    Nov 14, 2000 at 11:23 am
    Nov 14, 2000 at 5:26 pm
  • I have a problem dropping a function which attribute type was already deleted. So basically this is what has happened: 1) a type 'lo' was created 2) a function lo_oid(lo) was created 3) type 'lo' was ...
    Joonas MakkonenJoonas Makkonen
    Nov 14, 2000 at 1:28 pm
    Nov 14, 2000 at 3:54 pm
  • Hej I have succesfully migrated 28 tables in MSaccess to Pgsql 7.0 on RH6.2 through ODBC. I have to migrate 2 more tables, but get the message "Query string is to long". I have tried to raise the ...
    Poul KristensenPoul Kristensen
    Nov 8, 2000 at 9:31 pm
    Nov 8, 2000 at 10:40 pm
  • Hello ! I have this table : Attribute | Type | Modifier -----------------+--------------+--------------------------------------- ref | integer | default nextval('cvdb_ref_seq'::text) nom | ...
    Mickaël JouanneMickaël Jouanne
    Nov 8, 2000 at 4:36 pm
    Nov 8, 2000 at 4:49 pm
  • Hi all, Does anyone know if you can send email using pgsql and triggers or some other way? Thanks
    Ian KulmatyckiIan Kulmatycki
    Nov 7, 2000 at 12:29 am
    Nov 7, 2000 at 1:23 pm
  • hi, Im using linux and i have postgresql 6.5 and perl 5.003 installed on system. Im having problems connecting to postgresql where as ive pgsql_perl5 installed, only that im not sure whether its ...
    Kisala MuhaviKisala Muhavi
    Nov 5, 2000 at 4:06 am
    Nov 5, 2000 at 3:18 pm
  • I'm working with version 6.5.2 and I've created a test table that contains both a one and a two dimensional array. CREATE TABLE testa ( name text, links int2[], vals int2[][] ); I'v populated the ...
    John BurskiJohn Burski
    Nov 1, 2000 at 4:30 pm
    Nov 2, 2000 at 8:34 am
  • I tryied to put a rule in that file, did not work and I removed it. Then I got an error when I try to open a db in pgaccess: eror trying to connect..... Missing or erroneos pg_hba.conf... What should ...
    Nov 1, 2000 at 11:52 am
    Nov 1, 2000 at 1:06 pm
  • Iam with a problem to compile a C program that uses postgres. I am on FreeBSD with Potgsresql installed in usr/local/pgsql. any help? compile messages: make all-recursive Making all in everestserver ...
    Eduardo KotujanskyEduardo Kotujansky
    Nov 27, 2000 at 7:32 pm
    Nov 28, 2000 at 12:26 am
  • I wrote a little test function in pl/pgsql : create function TEST (char(5),char(6),char(11)) returns boolean as ' DECLARE bank alias for $1; guichet alias for $2; compte alias for $3; cmpt record; ...
    Laurent HERVELaurent HERVE
    Nov 25, 2000 at 1:08 pm
    Nov 25, 2000 at 4:50 pm
  • Could some one send-me an example ( or tell-me where it is in docs ) of a shell script for start postgresql in a FreeBSD installation Thanks Eduardo
    Eduardo KotujanskyEduardo Kotujansky
    Nov 23, 2000 at 12:20 pm
    Nov 23, 2000 at 7:31 pm
  • Hi- What does this mean? % psql template1 NOTICE: Unrecognized variable client_encoding I am able to connect, I can create a db and tables but what is this notice???? I have just upgraded to 7.0.3. ...
    Beth K. GatewoodBeth K. Gatewood
    Nov 22, 2000 at 6:32 pm
    Nov 22, 2000 at 7:14 pm
  • I tryied: su postgres export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/pgsql/lib and I got to createdb and start psql. But after a logout , I need do "export..." again. In my Linux red hat machine, ...
    Eduardo KotujanskyEduardo Kotujansky
    Nov 21, 2000 at 5:57 pm
    Nov 21, 2000 at 7:38 pm
  • Hello, I found a query in some code that I am evaluating: $query = qq|SELECT ap.id, ap.invnumber, vendor.name, acc_trans.transdate, ap.invoice, acc_trans.amount FROM ap, acc_trans WHERE $where AND ...
    OTR CommOTR Comm
    Nov 20, 2000 at 7:50 pm
    Nov 20, 2000 at 8:15 pm
  • Does any one know where I can find icons for postgresql and pgaccess?
    Mike WhiteMike White
    Nov 18, 2000 at 3:45 pm
    Nov 19, 2000 at 12:34 pm
  • Hi Is there some kind of introduction or tutorial on using the postgresql JDBC drivers? If not, could anyone post a snippet of code on how to connect to postgresql? Thanks Christian Hemmingsen
    Christian HemmingsenChristian Hemmingsen
    Nov 17, 2000 at 6:32 pm
    Nov 18, 2000 at 8:51 am
  • I just downloaded and compiled postgresql v7.0.3 afterwards I ran the regresion tests. First, I did a 'make runcheck' and everything was 'ok'. Then I ran 'make bigcheck'. It failed on "test random". ...
    Robert HentoshRobert Hentosh
    Nov 17, 2000 at 6:52 am
    Nov 17, 2000 at 7:25 am
  • Please, help me. I configure/compile perl with option ( other options stay default ): ./Configure -Dprefix=/usr/local/perl -Duseshrplib make make install I add string ...
    Nov 16, 2000 at 11:01 am
    Nov 16, 2000 at 3:43 pm
  • How are Postgres administrators (e.g. ISPs) securing table creation? As I see it, any user may create tables under any database (except Postgres system catalogs) whether they are meant to be allowed ...
    Nov 15, 2000 at 10:46 pm
    Nov 15, 2000 at 11:21 pm
  • OK. I'm a bit overwhelmed over I think. I'm going to start out by saying I dont know Linux very well at all. Basicly, what I'd like to do is access the database from a web page. The person hosting ...
    Greg ThomasGreg Thomas
    Nov 9, 2000 at 10:39 pm
    Nov 10, 2000 at 5:29 pm
  • Dear All, I have recently started working on psql, I am experiencing an error, and I am unable to find any documentation on Psql's error messages. The problem is as follows; If I say : "DELETE FROM ...
    Luke Tudor - RSGLuke Tudor - RSG
    Nov 10, 2000 at 3:34 pm
    Nov 10, 2000 at 3:54 pm
  • Hi: Have this curious situation and would like some help from you: Create an employee table: CREATE TABLE employee( id_employee SERIAL PRIMARY KEY, sex CHAR(1) DEFAULT 'm' CHECK(sex = 'f' OR sex = ...
    Luis MagañaLuis Magaña
    Nov 8, 2000 at 11:53 pm
    Nov 9, 2000 at 3:49 am
  • Hello! I want to limit the available space in a table, How can I do that? Tahnks Mauricio Alarcon
    Mauricio AlarconMauricio Alarcon
    Nov 8, 2000 at 6:44 pm
    Nov 8, 2000 at 7:05 pm
  • ** Reply Requested When Convenient ** is there a tool out there that will convert my MS Access 97 database to PgSQL? Mike Hammonds, CNE5, MCP-NT Fellon-McCord & Associates, Inc. Office: 502.426.4500 ...
    Mike HammondsMike Hammonds
    Nov 8, 2000 at 6:25 pm
    Nov 8, 2000 at 6:37 pm
  • When using pgAdmin in trying to import an Access97-exported text file into my PostgreSQL database, I'm getting this error: Tuple: 1 Error: Too many quote characters found. Expected: 54 Found: 96 ...
    Nov 6, 2000 at 7:50 pm
    Nov 6, 2000 at 9:01 pm
  • Hello, I successfully installed DBI, and I tried "install DBD::Pg" at the cpan prompt. I retrieve the tar file alright, and it untars, and then it goes to build M/ME/MERGL/DBD-Pg-0.95.tar.gz. It then ...
    Tod EmkoTod Emko
    Nov 5, 2000 at 5:25 pm
    Nov 5, 2000 at 7:30 pm
  • ** Reply Requested When Convenient ** Does PgSQL support relational integrity and cascading updates, also cascading deletions? Mike Hammonds, CNE5, MCP-NT Fellon-McCord & Associates, Inc. Office: ...
    Mike HammondsMike Hammonds
    Nov 3, 2000 at 7:10 pm
    Nov 3, 2000 at 7:21 pm
  • Hi, I've gone through Kevin Lo's directions for installing PostgreSQL on Windows 2000 -- but I blew it when I ran "initdb". Even though the directions said not to run this command as administrator ...
    Erion, PaulErion, Paul
    Nov 29, 2000 at 7:58 pm
    Nov 29, 2000 at 7:58 pm
  • Hi, i have to enhance my shopsystem by a simple closed user group. One of our customers wants to give some of his customers "special prices". Up to now I used mysql and therefore used one single ...
    Nabil SayeghNabil Sayegh
    Nov 28, 2000 at 11:40 pm
    Nov 28, 2000 at 11:40 pm
  • Is there a way to ask for user autentication when an ODBC connection betwen Access and Postgres is stablished? I'm using Access 97 as a frontend for Postgres 7.02, several users are going to be using ...
    Diego A. Puertas F.Diego A. Puertas F.
    Nov 28, 2000 at 7:50 pm
    Nov 28, 2000 at 7:50 pm
  • TINTERVAL is a poorly supported, old and creaky data type. It is based on ABSTIME, which is not as capable as TIMESTAMP. Maybe. The SQL9x function/operator OVERLAPS is recognized by PostgreSQL 7.x, ...
    Thomas LockhartThomas Lockhart
    Nov 27, 2000 at 6:21 pm
    Nov 27, 2000 at 6:21 pm
  • You could set MaxRequestsPerChild in apache's httpd.conf. This controls how many requests each apache process is allowed to serve. After it serves this many the process dies which should close the ...
    Philip HallstromPhilip Hallstrom
    Nov 27, 2000 at 4:55 pm
    Nov 27, 2000 at 4:55 pm
Group Navigation
period‹ prev | Nov 2000 | next ›
Group Overview
grouppgsql-novice @

91 users for November 2000

GH: 22 posts Tom Lane: 20 posts Mike Castle: 7 posts Mickaël Jouanne: 6 posts Mike Hammonds: 5 posts Stephan Szabo: 5 posts D. Duccini: 4 posts Eduardo Kotujansky: 4 posts James Snelling: 4 posts Poul L. Christiansen: 4 posts Ron Chmara: 4 posts Rynell Wesson: 4 posts Thomas Good: 4 posts Davidb: 3 posts Ghaverla: 3 posts Beth K. Gatewood: 3 posts Diego A. Puertas F.: 3 posts Dmitri Touretsky: 3 posts Ian Kulmatycki: 3 posts Larry Rosenman: 3 posts
show more