FAQ

Search Discussions

45 discussions - 157 posts

  • Well, as long as you realize that PostgreSQL is always right you are on track ;) I'm guessing that you have a damaged timezone database on your system. What time zone does your system think it is in? ...
    Thomas LockhartThomas Lockhart
    Apr 9, 2002 at 2:08 am
    Apr 15, 2002 at 7:48 am
  • Ok, this sit around for a while, and, because there was no responses, I assume, that nothing jumps out at you as being terribly with my logic... Here is the patch (see the original problem ...
    Dmitry TkachDmitry Tkach
    Apr 19, 2002 at 4:05 pm
    Jun 24, 2002 at 12:23 pm
  • PostgreSQL 7.2.1's pg_dump prduces bad SQL for VIEW's. The SQL for CREATE VIEW as output by pg_dump generates an error, because the appropriate nesting of SELECTs with parentheses is missing: ERROR: ...
    Ian MorganIan Morgan
    Apr 22, 2002 at 6:07 am
    Apr 23, 2002 at 11:10 pm
  • It is very natural to careful system administrator to upgrade production database following way: 1. Install new version of PostgreSQL in alternate location 2. Start it on alternate port 3. restore ...
    Victor WagnerVictor Wagner
    Apr 8, 2002 at 6:59 pm
    Apr 8, 2002 at 7:43 pm
  • pg_dumpall now prints status messages; I find them to be a nuisance, and the patch below implements a --quiet option, though not necessarily well. thanks, -neil ...
    Neil T. SpringNeil T. Spring
    Apr 23, 2002 at 9:37 pm
    Jun 24, 2002 at 12:37 pm
  • ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : ...
    Dmitry TkachDmitry Tkach
    Apr 3, 2002 at 8:28 pm
    Jun 7, 2002 at 9:41 pm
  • ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : ...
    Gerhard HäringGerhard Häring
    Apr 21, 2002 at 9:11 am
    Apr 22, 2002 at 11:02 am
  • Hi, I have just upgraded to 7.2 and found a bug in the LIKE command. The command I am using is SELECT AccNum , StuID , StuInsUID , RefPhyNam , StuDes , PatAge , PatSiz , PatWei , Owner , GroupName , ...
    Bob KennyBob Kenny
    Apr 30, 2002 at 9:44 am
    Apr 30, 2002 at 2:52 pm
  • Hi, Tried to compile PG from CVS today, my platform is: $ uname -a Linux pastis 2.4.17-686 #2 Sat Dec 22 21:58:49 EST 2001 i686 unknown $ gcc -v Reading specs from ...
    Jean-Paul ARGUDOJean-Paul ARGUDO
    Apr 23, 2002 at 8:42 am
    Apr 23, 2002 at 4:40 pm
  • I would just want to ask if what is the default password of postgresql after installing it... coz when i type su postgres it ask me a password which i dont know what? Thnx -- Sign-up for your own ...
    Martin tanMartin tan
    Apr 23, 2002 at 8:05 am
    Apr 23, 2002 at 4:18 pm
  • To whom it may concern: I tried to create a new table with the following statement: CREATE TABLE "bit" ( provider_name varchar ); I got the error message: ERROR: TypeCreate: type bit already defined ...
    James VinettJames Vinett
    Apr 18, 2002 at 4:46 pm
    Apr 19, 2002 at 2:43 pm
  • Problem: -------- pg_dump does not honour case-sensitivity in user names, which results to failures when restoring database. Environment: ------------ Version: PostgreSQL 7.2 on i686-pc-linux-gnu, ...
    Michal SchwarzMichal Schwarz
    Apr 16, 2002 at 3:31 pm
    Apr 16, 2002 at 11:27 pm
  • Problem: -------- SELECT * FROM <view returns following error message: ERROR: replace_vars_with_subplan_refs: variable not in subplan target list Environment: ------------ Version: PostgreSQL 7.2 on ...
    Michal SchwarzMichal Schwarz
    Apr 16, 2002 at 3:19 pm
    Apr 16, 2002 at 11:27 pm
  • b=# create table stuff (stuff_id serial unique); NOTICE: CREATE TABLE will create implicit sequence 'stuff_stuff_id_seq' for SERIAL column 'stuff.stuff_id' NOTICE: CREATE TABLE / UNIQUE will create ...
    Rod TaylorRod Taylor
    Apr 16, 2002 at 4:11 pm
    Apr 16, 2002 at 11:19 pm
  • Hi I have installed a 7.1.3 postgresql version on my linux server. When I type "createuser xxxxxxxx" it asks me : Shall the new user allowed to create databases (y/n)? Shall the new user allowed to ...
    Pierre-Alexis PaquinPierre-Alexis Paquin
    Apr 4, 2002 at 7:56 am
    Apr 8, 2002 at 5:44 pm
  • Hi all, I have a problem with metadata.........just read this ....... Let us simply suppose a table "test" with 2 fileds "name (varchar(10))" and "age (numeric)" and there b values as ...
    ShraShra
    Apr 27, 2002 at 5:31 am
    Apr 27, 2002 at 7:44 am
  • Hi, I tried the following on 7.1.3-38 and pgsl used the index: EXPLAIN mp3base=# explain mp3base-# select * from mp3_ mp3base-# where name ~ '^cre'; NOTICE: QUERY PLAN: Index Scan using mp3_name on ...
    Holger DörlHolger Dörl
    Apr 25, 2002 at 10:21 pm
    Apr 26, 2002 at 2:59 pm
  • Sir, recently I have downloaded the postgreSql and I want to install it in windows 2000 operating system. can you suggest me please what to do or where I can look for this. thank you. Rahman
    Pathhara1Pathhara1
    Apr 19, 2002 at 5:00 pm
    Apr 21, 2002 at 5:56 pm
  • RedHat7.1 Upgrade from pg-7.0.3.8 to pg-7.1.3 on CD 7.2 rpm upgrade of python module depndency error for module "mx" - what is this! ignoring the python problem, installation ok, then try to use ...
    HeilkrauterHeilkrauter
    Apr 18, 2002 at 7:39 pm
    Apr 19, 2002 at 2:37 pm
  • Hi Im using a PostgreSQL database on Slackware Linux Server. I have some reports created with Crystal Reports 8.5 on WIMDOWS 98 that retrieve data from database and communicate with database through ...
    Daniel PecciniDaniel Peccini
    Apr 18, 2002 at 1:52 pm
    Apr 19, 2002 at 3:13 am
  • Dear Bug Killer, I created table xxxx with int8/bigint columns in postgres version 7.2 database. 1.When I inserted data with an integer less than or equal to 10 digit, it ok. But when I inserted data ...
    Vicky PanVicky Pan
    Apr 17, 2002 at 4:38 pm
    Apr 18, 2002 at 2:35 pm
  • I noticed a small but misleading documentation error. /usr/share/doc/postgresql-7.2/html/lo-interfaces.html ====================================================== 2.3.9. Removing a Large Object To ...
    Warwick HunterWarwick Hunter
    Apr 18, 2002 at 12:20 am
    Apr 18, 2002 at 2:28 pm
  • Hello, I've recenly been working with 7.2.1 and been having problems with corrupting the DB when loading a new database with a Perl/DBI script doing large numbers of inserts to a single table. I was ...
    Matt OlsonMatt Olson
    Apr 17, 2002 at 6:04 pm
    Apr 18, 2002 at 3:41 am
  • the problem is my postgresql compile with enable multi bytes = unicode and my default language is BIG5 encoding, in previous version of postgresql 7.1 i can use unicode encoding to do my back-end ...
    Terry LouTerry Lou
    Apr 8, 2002 at 3:31 pm
    Apr 16, 2002 at 1:11 am
  • Hi all, I use actually MySQL Database but i have see your database and i think, it was better than MySQL. But i have just a question. When i have tested PostGreSQL, i have try to modidy the name of a ...
    Grégory BécueGrégory Bécue
    Apr 14, 2002 at 11:38 am
    Apr 15, 2002 at 7:42 pm
  • I've used pgAccess to make all the tables and colums. Ex.: table diagnosis column diagnosis_ID Then, when I use psql to execute select statements, diagnosis_ID does not exist. But when I change the ...
    Øystein ThorsenØystein Thorsen
    Apr 3, 2002 at 8:40 pm
    Apr 4, 2002 at 4:37 pm
  • I have added the following packages: drwxr-xr-x 4 root other 512 Apr 1 14:29 SMCflex drwxr-xr-x 4 root other 512 Apr 1 14:29 SMCgtext drwxr-xr-x 4 root other 512 Apr 1 14:28 SMCmake drwxr-xr-x 4 root ...
    Joe PiscitellaJoe Piscitella
    Apr 1, 2002 at 9:42 pm
    Apr 2, 2002 at 8:29 pm
  • In a ON UPDATE trigger on Toto table , i insert in a log a timestamp like this CREATE TABLE LogProtocole ( logprotocole_id SERIAL, logprotocole_message text, logprotocole_date timestamp, CONSTRAINT ...
    Laurent BelmonteLaurent Belmonte
    Apr 29, 2002 at 4:38 pm
    Apr 29, 2002 at 4:38 pm
  • I have a problem when i use lo_import() of postgres.You must have postgres super user priveledge to use server side lo_import()Anyone can use the client side lo_import() provided by libpq. I am ...
    MedassistMedassist
    Apr 27, 2002 at 9:32 am
    Apr 27, 2002 at 9:32 am
  • i am running version 7.1.3-2 (downloaded using GNORPM) on Linux 7.2. i have created a database, and populated the database with some rows, using a command like: INSERT INTO database VALUES ...
    Stev knowlesStev knowles
    Apr 25, 2002 at 11:34 pm
    Apr 25, 2002 at 11:34 pm
  • Version: 7.3 devel, updated today, 7:00 am warsaw time. Operating System: Linux polpot 2.2.20 #1 Sun Mar 17 11:56:15 UTC 2002 i686 Pentium_III_(Coppermine) Compiler and libraries: $ ldd ...
    Hubert depesz LubaczewskiHubert depesz Lubaczewski
    Apr 24, 2002 at 11:17 am
    Apr 24, 2002 at 11:17 am
  • Some inheritances bugss are fiked but not all !!!! In the New version of postgresSQL (7.2.1) inheritance bug was fixed. Now SQL99 is respect for simple inheritance behavior. // Example : create table ...
    Alban MédiciAlban Médici
    Apr 19, 2002 at 4:09 pm
    Apr 19, 2002 at 4:09 pm
  • Using latest CVS sources with Linux 2.4 i586: Comparing using domains versus traditional explicit field types. Here's the control test: test=# create table t1 (f varchar(5) not null); CREATE test=# ...
    Joel BurtonJoel Burton
    Apr 18, 2002 at 1:19 pm
    Apr 18, 2002 at 1:19 pm
  • Hi there, I try to compile postgres on an IBM RS/6000 44P Model 170 with AIX Version 4.3 And it works. But when I try to create the TclTk (I need only the Libraies for tcl) then I got an Error ... ...
    Peter KollPeter Koll
    Apr 18, 2002 at 12:22 pm
    Apr 18, 2002 at 12:22 pm
  • Your name :Kexin Wang Your email address :wangkx@wbu.edu Your name :Geoffrey Ritchey Your email address :ritcheyg@wbu.edu System Configuration --------------------- Architecture (example: Intel ...
    Geoffrey RitcheyGeoffrey Ritchey
    Apr 16, 2002 at 10:47 pm
    Apr 16, 2002 at 10:47 pm
  • Hi, everybody! I was wonderring if it is a known "feature" to begin with, and, if there are any plans to fix it in future? I had two very large tables in my database (about 30 million rows each), ...
    Dmitry TkachDmitry Tkach
    Apr 15, 2002 at 3:41 pm
    Apr 15, 2002 at 3:41 pm
  • To : PostgreSQL Person incharge From : anGie RE : Problem with database Dear sir, I'm an academy student that interested about database environment. Recently, I was using Kondara MNU/Linux 2.2 and ...
    呉 安棋呉 安棋
    Apr 12, 2002 at 7:23 am
    Apr 12, 2002 at 7:23 am
  • I have stupid problem after installation.... I can't access my postgres db after installation, when asking me the login and the password, i set 'postgres' (i'm on root) and leave password to blank : ...
    Renaud diezRenaud diez
    Apr 11, 2002 at 9:32 am
    Apr 11, 2002 at 9:32 am
  • Daniel Ferreira FelixDaniel Ferreira Felix
    Apr 10, 2002 at 1:50 pm
    Apr 10, 2002 at 1:50 pm
  • Hi, I am trying to use postgreysql. I am getting the following errors while creating a new database at given location. The errors are as shown below. createdb -D /home/naren/ramu Ramu ERROR: Absolute ...
    Akula Ramanjaneyul ReddyAkula Ramanjaneyul Reddy
    Apr 10, 2002 at 6:41 am
    Apr 10, 2002 at 6:41 am
  • pls unsubscribe me .. from the list ... if anybody having doubts sending mails pgsql-bugs@postgresql.org i am receiving i tried to block it but in vain pls unsunscribe from that mailing list
    Ganesh KumarGanesh Kumar
    Apr 4, 2002 at 8:24 am
    Apr 4, 2002 at 8:24 am
  • please , unsubscribe me from list i dont want to receive nay mails reg : postgresql
    Ganesh KumarGanesh Kumar
    Apr 4, 2002 at 8:09 am
    Apr 4, 2002 at 8:09 am
  • hi i got a problem with postgresql i install the pgsql like you said on the help file and when i try to create a db (database) it always give me that error: psql: FATAL 1: cannot open ...
    Chemseddine garaChemseddine gara
    Apr 3, 2002 at 11:22 pm
    Apr 3, 2002 at 11:22 pm
  • Hi I have installed a 7.1.3 postgresql version on my linux server. When I type "createuser xxxxxxxx" it asks me : Shall the new user allowed to create databases (y/n)? Shall the new user allowed to ...
    Pierre-Alexis PaquinPierre-Alexis Paquin
    Apr 3, 2002 at 8:58 am
    Apr 3, 2002 at 8:58 am
  • I have a pg_dump file which contains only schemas, I think there is a bug, which causes function reload fail, look at following pieces of dump file: ...... ...... -- -- TOC Entry ID 212 (OID ...
    Jie LiangJie Liang
    Apr 1, 2002 at 8:05 pm
    Apr 1, 2002 at 8:05 pm
Group Navigation
period‹ prev | Apr 2002 | next ›
Group Overview
grouppgsql-bugs @
categoriespostgresql
discussions45
posts157
users60
websitepostgresql.org
irc#postgresql

60 users for April 2002

Tom Lane: 43 posts : 26 posts Bruce Momjian: 17 posts Sean Chittenden: 9 posts Thomas Lockhart: 7 posts Stephan Szabo: 5 posts Dmitry Tkach: 4 posts Michael Loftis: 4 posts Ian Morgan: 3 posts Pierre-Alexis Paquin: 3 posts Thomas Lockhart: 3 posts Victor Wagner: 3 posts Andreas Schwab: 2 posts Ganesh Kumar: 2 posts Gerhard Häring: 2 posts Jean-Paul ARGUDO: 2 posts Medassist: 2 posts Michal Schwarz: 2 posts Peter Eisentraut: 2 posts Ron Mayer: 2 posts
show more
Archives