FAQ

PostgreSQL > pgsql-novice > February 2001

Search Discussions

57 discussions - 147 posts

  • 10

    CUG

    Hi, what would be the best way to implement a closed user group in an app with postgresql ? The app will be a cgi, so there will be an enormous number of 'guest'-users. Groups should be containable ...
    Nabil SayeghNabil Sayegh
    Feb 3, 2001 at 4:44 pm
    Feb 5, 2001 at 8:49 pm
  • Justin, Thank you for the response. Out of curosity, what type of memory usage are you experiencing with the current setup (14GB)? And have you figured out what your upgrade path may be? For ...
    Michael Miyabara-McCaskeyMichael Miyabara-McCaskey
    Feb 2, 2001 at 5:45 am
    Feb 7, 2001 at 7:40 pm
  • I need every postgres account to be authenticated by password. However I would also like to have the local unix user 'postgres' to be able to bypass that password authentication. The reason is that I ...
    Heath JohnsHeath Johns
    Feb 27, 2001 at 5:35 pm
    Feb 27, 2001 at 11:39 pm
  • 1) Hi I am a novice in pgsql and I am trying to introduce a long text to one record... supposly text field size are unlimited but when I tried to insert the record the follow message appears : ERROR: ...
    Hector DiazHector Diaz
    Feb 27, 2001 at 1:03 pm
    Mar 1, 2001 at 5:23 pm
  • A couple of general question about postgresql. 1) Does postgresql support unsigned datatypes? 2) Is there a maximum number of simultaneous connection to postgresql via JDBC? Mike
    Mike FriesenMike Friesen
    Feb 21, 2001 at 7:19 pm
    Feb 21, 2001 at 9:18 pm
  • Hi All, Thanks for the help on the 'lumper' vs. 'splitter' question. I asked my practice database: select count (*) from titles where price 20 It responded: PostgreSQL said: ERROR: Unable to identify ...
    Conrad SchulerConrad Schuler
    Feb 7, 2001 at 7:35 pm
    Feb 8, 2001 at 8:15 pm
  • I've downloaded and printed off al the pgsql documentation from the greatbridge website, but can't find a comprehensive list of data types for pgsql columns. Can anyone point me in the right ...
    DerekDerek
    Feb 1, 2001 at 10:17 am
    Feb 5, 2001 at 3:36 pm
  • I'm trying to update a column to it's orignal contents plus a space plus the contents of another column. UPDATE cases SET citation = citation + ' ' + text(year); (citation is text type and year is ...
    Donald BramanDonald Braman
    Feb 28, 2001 at 6:46 pm
    Mar 3, 2001 at 1:07 am
  • Hi. I am trying to copy tables. I want to copy a table in one database to a table in another database. The tables are identical. Here is to code and the error when using DBI. Can I just use ...
    Robert KernellRobert Kernell
    Feb 20, 2001 at 3:50 pm
    Feb 27, 2001 at 1:01 pm
  • Hello, I have a pgsql db (v.6.5.3) with some tables. On my pc1 I have created a MS access front end (with ODBC) with these tables linked. When I start the MS access front end from my pc2 (same ODBC ...
    Carsten HuettlCarsten Huettl
    Feb 15, 2001 at 7:59 am
    Feb 20, 2001 at 11:55 am
  • I'm looking for a good college-level text that covers general database design and implementation. I've copies of all the PostgreSQL documentation and they are fine when it comes to answering ...
    John BurskiJohn Burski
    Feb 6, 2001 at 2:23 pm
    Feb 7, 2001 at 1:39 pm
  • I have upgraded from PostgreSQL 7.0.2 to 7.1beta4. I am trying to convert a database from the older version to work in the newer version. Unfortunately ALL I have is the base directory zipped up ...
    Peter T. BrownPeter T. Brown
    Feb 28, 2001 at 10:06 pm
    Feb 28, 2001 at 11:35 pm
  • I'm afraid this will expose me as a true SQL novice. But this is the place for that, so here goes... Here's a simplified version of what I want to do. Anyone know how? Or can anyone just tell me with ...
    James McMurryJames McMurry
    Feb 28, 2001 at 12:14 am
    Feb 28, 2001 at 4:00 am
  • Are there any Win32 client tools for interacting with PostgreSQL? Are they version specific v7, v6? Thanks Dan
    Dan HooverDan Hoover
    Feb 23, 2001 at 5:59 pm
    Feb 25, 2001 at 4:18 am
  • My apologies to the lists...in trying to stop my own spam, I spammed you all. This has now been fixed. Again, sorry for any inconvenience. -Ken
    Ken CoreyKen Corey
    Feb 13, 2001 at 2:20 am
    Feb 21, 2001 at 4:50 pm
  • Hi: Check This!
    Mike HammondsMike Hammonds
    Feb 13, 2001 at 3:36 pm
    Feb 13, 2001 at 5:15 pm
  • Are client connections to the database thread-safe? Can each client thread have its own connection? What happens if multiple threads share one connection? For instance, can one thread open a ...
    Gunkel, Marc BGunkel, Marc B
    Feb 12, 2001 at 9:09 pm
    Feb 13, 2001 at 2:26 pm
  • anyone have an idea why this won't work? when i print out "i" it says 893, but it should be 41. and the values are null for the array $userinfo. thanks in advance, andy arledge if(!($result= ...
    Andy ArledgeAndy Arledge
    Feb 12, 2001 at 4:48 am
    Feb 12, 2001 at 5:28 am
  • Hi All, I am managing a database design project. It will database our entire website including: images, articles, bibliography, ecommerce, membership in website, site statistics, etc. The 'lumper' ...
    Conrad SchulerConrad Schuler
    Feb 7, 2001 at 1:52 am
    Feb 7, 2001 at 3:23 am
  • Hello All, How would I go about importing a large M$ Excel sheet into a PostgreSQL database? Regards, Ben Hooper ------------------------------------------------ Systems Consultant Email: ...
    Ben HooperBen Hooper
    Feb 1, 2001 at 12:51 pm
    Feb 5, 2001 at 3:37 pm
  • Does anyone know where to get a precomiled mod of php4 for apache that is setup for pgsql? I can't sen to find the docs on how to do this. Herbie Pabst
    Herb PabstHerb Pabst
    Feb 2, 2001 at 5:00 pm
    Feb 2, 2001 at 11:30 pm
  • Hello, 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 ...
    Stéphane EVEILLARDStéphane EVEILLARD
    Feb 22, 2001 at 8:10 am
    Feb 23, 2001 at 6:37 pm
  • Hello All, I have installed the latest version of PostgreSQL 7.0.3 and all seems to be fine with it. My problem is that I have used www-sql in the past with MySQL which works fine, but since I have ...
    LonnieLonnie
    Feb 23, 2001 at 6:36 pm
    Feb 23, 2001 at 6:36 pm
  • I have a table/class filled with records/instances in which I accidentally set the fields/attributes data type to text rather than boolean. I now have 75,000 records with 't' and 'f' So now I want to ...
    Donald BramanDonald Braman
    Feb 19, 2001 at 11:38 pm
    Feb 20, 2001 at 9:06 am
  • I have installed Postgres to Linux 2.2.16-22 and everything seemed to go fine until I tried to create a new database. I get the error message "USer no in pg_shadow". When I try createuser connected ...
    Michele HeikkiläMichele Heikkilä
    Feb 14, 2001 at 5:45 pm
    Feb 14, 2001 at 7:08 pm
  • What is the current status of compatibility of pgsql to Darwin and OS X Beta? I see some activity last december. What are the current plans? Thanks john
    John JamesJohn James
    Feb 12, 2001 at 8:41 pm
    Feb 12, 2001 at 9:14 pm
  • How can I update several columns in one UPDATE query ? The users's guide says: UPDATE table SET col = expression [, ...] [ FROM fromlist ] [ WHERE condition ] But this is what I get: jd= CREATE TABLE ...
    Johan DaineJohan Daine
    Feb 12, 2001 at 3:02 pm
    Feb 12, 2001 at 3:35 pm
  • Hi! I am after a power outage and some fsck. pg_dump gives me 'backend dies' messages but only on certain tables. The faulty tables give only the schema. How can I recover my data? Regards, Zoltan ...
    Boszormenyi ZoltanBoszormenyi Zoltan
    Feb 12, 2001 at 12:57 pm
    Feb 12, 2001 at 1:03 pm
  • Hello again, I want to normalize an existing table. Is there a way to drop the unwanted columns in my original table? SQL-alter does not seem to do it, neither can I specify the columns used in ...
    Stefan Waidele jun.Stefan Waidele jun.
    Feb 10, 2001 at 9:13 pm
    Feb 10, 2001 at 11:18 pm
  • I am writing my first trigger & function. First question: --------------- I can't get psql to take the function declaration. ds=# CREATE FUNCTION trigger_insert_update_copay() ds-# RETURNS opaque ...
    Dan BDan B
    Feb 10, 2001 at 4:47 am
    Feb 10, 2001 at 5:58 am
  • Hi all! I am having troubles getting started with a database, I have pgsql installed, but can not seem to connect. I am running Linux Mandrake 7.2 here is what I get from the command line: ...
    Fred SchroederFred Schroeder
    Feb 8, 2001 at 8:19 pm
    Feb 9, 2001 at 4:50 am
  • Hello, I have a Qube2 and I want to install a software which needs postgresql installation Postgresql is not installed on my Qube2 and my kernel is 2.0.34 ; mips nevada v10.0 I have found on the net ...
    Benoit Le-DizesBenoit Le-Dizes
    Feb 6, 2001 at 1:44 pm
    Feb 6, 2001 at 2:58 pm
  • Hi All, I'm trying to call a plpgsql function: func(varchar(255).varchar(255).varchar(255).varchar(255).varchar(255).varchar(255).varchar(255).varchar(255).varchar(255).varchar(255).varchar(255)); ...
    Ken CoreyKen Corey
    Feb 6, 2001 at 7:54 am
    Feb 6, 2001 at 8:04 am
  • At freshmeat.net there is an entry for a program dbf2sql. However trying to go to the homepage times out. Any ideas where I could get such a program? I also saw the dbf2pgsql, but the program seemed ...
    Francisco ReyesFrancisco Reyes
    Feb 3, 2001 at 5:17 am
    Feb 5, 2001 at 3:38 pm
  • I'm sure there is a simple answer, but I haven't found it yet. Permission is being denied and I don't see why... Here's the table structure:(please ignore irregularities in syntax due to sanitizing ...
    EricnielsenEricnielsen
    Feb 4, 2001 at 9:20 pm
    Feb 4, 2001 at 9:36 pm
  • I am a bit frustrated with the postgresql.org archives. The two different times I have tried it was unusable. Searchinges the "General" list archive returned an error about URL not found. A day or ...
    Francisco ReyesFrancisco Reyes
    Feb 3, 2001 at 5:15 am
    Feb 3, 2001 at 6:03 am
  • I just installed PostgreSQL-6.5.2 on a box running Red Hat Linux 6.2 and I've run into the following problem with MultiByte Strings. Initially when I compiled it, it had been configured with ...
    Allen KimberlyAllen Kimberly
    Feb 28, 2001 at 4:18 pm
    Feb 28, 2001 at 4:18 pm
  • Hello all, I am trying to populate a field in a table by looking up values from another table. Here are my (simplified tables): CREATE TABLE small( id char(14), addr int4, street char(15), city ...
    Larry HolishLarry Holish
    Feb 27, 2001 at 7:13 pm
    Feb 27, 2001 at 7:13 pm
  • I have 2 table with the same primary key. If I try and do a join on them, it is very slow unless I explicitly specify in my select statement that those two keys are equal. Is there any way to tell ...
    Mike FriesenMike Friesen
    Feb 26, 2001 at 6:06 pm
    Feb 26, 2001 at 6:06 pm
  • Hi, Just wondering if PostgreSQL 7.0.3 runs OK on solaris 2.8. Thanks. Kevin Sprague NRCAN ksprague@nrcan.gc.ca
    KspragueKsprague
    Feb 23, 2001 at 6:36 pm
    Feb 23, 2001 at 6:36 pm
  • I can post info to PostgreSQL from a webform via JSP, and I can post reports from PostgreSQL to a webpage. Can anyone tell me how I might format a PostgreSQL report to a web page so that it will ...
    Richard EhrlichRichard Ehrlich
    Feb 20, 2001 at 8:09 pm
    Feb 20, 2001 at 8:09 pm
  • Hi, Not sure if the first posting went through ... here it is again: Just wondering if PostgreSQL 7.0.3 runs OK on solaris 2.8. Thanks. Kevin Sprague NRCAN ksprague@nrcan.gc.ca
    KspragueKsprague
    Feb 20, 2001 at 2:01 pm
    Feb 20, 2001 at 2:01 pm
  • What user did you run initdb as? Apparently it wasn't "postgres" ... No, I must have done that as root. (Which is not in pg_shadow either) Cheers, Michele Heikkilä
    Michele HeikkiläMichele Heikkilä
    Feb 16, 2001 at 7:28 pm
    Feb 16, 2001 at 7:28 pm
  • I'm trying to use an r-tree indexed search on a box data type, but the explain statement tells me that a sequence scan is being preformed instead. The table has 130 000 tuples and I can't beleive the ...
    Geordie HobartGeordie Hobart
    Feb 12, 2001 at 8:36 pm
    Feb 12, 2001 at 8:36 pm
  • Hi, You make a mistake in your update query . You must just write one time set command. Your Correct query is : PDATE foo SET v2=3,v3=4 WHERE v1=1 ; Cheers, PEJAC Pascal
    PejacPejac
    Feb 12, 2001 at 3:33 pm
    Feb 12, 2001 at 3:33 pm
  • Hi, Yes it's possible in where clause. exemple: create table t1 (id integer,name varchar(55)); create table t2 (id integer,name varchar(55)); insert into t1 values (1,'toto'); INSERT 25005844 1 log=# ...
    PejacPejac
    Feb 12, 2001 at 3:16 pm
    Feb 12, 2001 at 3:16 pm
  • I need to keep a database of objects, some of which contain arbitrary length arrays of other objects in the database. My plan is to use Postgresql objects for each object, then keep arbitrary length ...
    Raymond GolishRaymond Golish
    Feb 12, 2001 at 3:02 pm
    Feb 12, 2001 at 3:02 pm
  • Hello, I want to update mutiple rows on one specific table in the database. However I do not know the old value in the database but do have a PRIMARY KEY which will be specific to one value in the ...
    Etienne De KerckhoveEtienne De Kerckhove
    Feb 12, 2001 at 2:55 pm
    Feb 12, 2001 at 2:55 pm
  • Hi, I'm currently using 7.0.3 What standard or at least compatible ways to we have to store large objects (in terms of the language only) ? Should I wait until 7.1 ? Is TOAST compatible (e.g. with ...
    Nabil SayeghNabil Sayegh
    Feb 12, 2001 at 12:19 pm
    Feb 12, 2001 at 12:19 pm
  • Hi, I am getting a file not found on the JDBC page http://jdbc.postgresql.org/Templates/docs Does anyone know another URL to this stuff, or have a copy? I am trying to get info on support for ...
    Eric FrazierEric Frazier
    Feb 12, 2001 at 7:08 am
    Feb 12, 2001 at 7:08 am
Feb 2001
12
Group Navigation
period‹ prev | Feb 2001 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions57
posts147
users77
websitepostgresql.org
irc#postgresql

77 users for February 2001

Francisco Reyes: 16 posts Tom Lane: 10 posts Nabil Sayegh: 6 posts ERIC Lawson - x52010: 5 posts Mike Friesen: 4 posts Stefan Waidele jun.: 4 posts Brett W. McCoy: 3 posts Einar Karttunen: 3 posts Heath Johns: 3 posts Ken Corey: 3 posts Ksprague: 2 posts Pejac: 2 posts Info: 2 posts Anthony E . Greene: 2 posts Ben Hooper: 2 posts Boszormenyi Zoltan: 2 posts Carsten Huettl: 2 posts Conrad Schuler: 2 posts Dan B: 2 posts Derek: 2 posts
show more
Archives