FAQ

PostgreSQL > pgsql-novice > September 2003

Search Discussions

96 discussions - 314 posts

  • I wish to track some additional info about users. Can I just add columns to the pg_shadow table? Can I add a system table while I am at it? (how?) How do I back up the pg_ system tables? Thanks Jason ...
    Jason HihnJason Hihn
    Sep 8, 2003 at 8:28 pm
    Sep 9, 2003 at 8:48 pm
  • Hi - I am trying to concatenate a text field in a query with a group by clause, similar to a sum() function on a numeric value - for example: SELECT groupid, sum(numeric_field), ???(text_field) FROM ...
    Brian G. HuberBrian G. Huber
    Sep 9, 2003 at 5:04 pm
    Sep 13, 2003 at 8:38 pm
  • I have a db that contains phone numbers The data that get inserted looks like this 425 555 1212 I have a script that inserts that into the DB, the problem is that sometimes the suffix might start ...
    Bryan IrvineBryan Irvine
    Sep 10, 2003 at 4:59 pm
    Sep 11, 2003 at 2:11 pm
  • Hi, I need to store strings with non-english characters in my DB. I created my db with unicode encoding, but am not able to insert data into it from psql nor pgaccess, which seems not to suport non ...
    Andreas FrommAndreas Fromm
    Sep 8, 2003 at 9:46 am
    Sep 9, 2003 at 3:00 pm
  • Hello, I'm new to using PostgreSQL as a backend for NetReg (www.netreg.org <http://www.netreg.org/ ). I have some questions on getting started. I have installed the database on a Linux box. 1. How do ...
    Williams, Quinton LWilliams, Quinton L
    Sep 26, 2003 at 11:12 pm
    Sep 29, 2003 at 10:19 pm
  • We have encountered numerous instances when we have encountered the following error message: ERROR: Query was cancelled. Specific instances include: Attempting an export with pg_dump: % pg_dump -c -C ...
    David RickardDavid Rickard
    Sep 16, 2003 at 6:37 pm
    Sep 16, 2003 at 7:36 pm
  • Is there an easy way to count how many records there are? --Bryan
    Bryan IrvineBryan Irvine
    Sep 10, 2003 at 4:58 pm
    Sep 11, 2003 at 1:44 am
  • On restoring a plain-text SQL script file dumped from a version 7.1.2 database to 7.3.3 I got the following errors. ERROR: copy: line 67568, Temporary log file is full lost synchronization with ...
    Stuart WoodwardStuart Woodward
    Sep 4, 2003 at 2:13 am
    Sep 4, 2003 at 9:13 am
  • One of the extras I had hoped for with PgSQL 7.3 Schemas was a somewhat cosmetic, but useful, change in the way that MS-Query sees tables in a database. What I *actualy* want to achieve is for the ...
    Harry BroomhallHarry Broomhall
    Sep 17, 2003 at 1:54 pm
    Oct 1, 2003 at 3:04 pm
  • Hi all, Can anyone please tell me how to modify the postgresql startup script to accept TCP/IP connections? This is on a Redh Hat 9 machine running Postgresql 7.3.4 RPM installation. The RPMs were ...
    Balazs WellischBalazs Wellisch
    Sep 19, 2003 at 11:11 pm
    Sep 20, 2003 at 12:13 am
  • Hello, I'm not sure who I should be posing this question to but I'm a System Administrator who has inherited several Debian Linux servers one of which apparently hosts a rather large Postgres ...
    Jonathan TelepJonathan Telep
    Sep 24, 2003 at 6:56 pm
    Sep 26, 2003 at 5:34 am
  • Hi I modified my function to: CREATE FUNCTION buscablista (character varying, character varying) RETURNS SETOF cabezalista AS ' select * from cabezalista where idlista like CAST($1 AS CHAR(20)) and ...
    Juan Francisco DiazJuan Francisco Diaz
    Sep 25, 2003 at 3:57 pm
    Sep 25, 2003 at 10:29 pm
  • What is the best way to reference (use as foreign key) a table with multiple primary keys? Here's what I have: Table1: field1 field2 field3 ... primary key (field1, field2, field3) Then I have ...
    Daniel StaalDaniel Staal
    Sep 22, 2003 at 9:34 pm
    Sep 23, 2003 at 7:01 am
  • 4

    DTS

    Hi, in SQLServer there is something called DTS, we in our race to improve the load of millions of records are planning to use them on SQLServer. BUT we would like to achieve similar performance in ...
    Juan Francisco DiazJuan Francisco Diaz
    Sep 16, 2003 at 3:30 pm
    Sep 22, 2003 at 7:56 am
  • Dear Friends, I have a crucial problem, I try to develop an application using Python and PostgreSQL. I try to make a GUI using Python and i've planned to SELECT, INSERT and UPDATE the data on the ...
    Santoso berkahSantoso berkah
    Sep 15, 2003 at 5:05 am
    Sep 20, 2003 at 11:15 pm
  • Does PostgreSQL manage an internal log of db operations? For example, a user with uid logs into the database and updates several rows.. Does engine log it? Regards -- Marcin Gil marcin.gil @ ...
    Marcin GilMarcin Gil
    Sep 12, 2003 at 12:59 pm
    Sep 16, 2003 at 1:05 pm
  • I have 2 tables: MainTable, fields: id, data1 RelatedTable, fields: id, data2 RelatedTable is joined to MainTable via the 'id' field. Field 'data2' in RelatedTable holds the same sort of data as ...
    SzucsSzucs
    Sep 10, 2003 at 9:27 am
    Sep 15, 2003 at 3:08 pm
  • I'm running postgresql on a linux box and having trouble connecting to my database from another machine. When I do I get a list of 4 databases but I cannot connect to any of them remotely, as they ...
    Steve BondSteve Bond
    Sep 12, 2003 at 2:51 pm
    Sep 15, 2003 at 1:06 pm
  • Hi all, I have a table which includes a field for the date and time an item was added to it. What's the most efficient way of selecting all of the items added on a specific date (this is a really ...
    Simon WillisonSimon Willison
    Sep 9, 2003 at 8:30 pm
    Sep 12, 2003 at 10:31 am
  • Greetings - It looks to me as if there is no way to alter the datatype of a table column, as in from timestamp to varchar. Am I right? (I will cry if I'm right.) :-(. It appears that I must drop and ...
    Louise CofieldLouise Cofield
    Sep 3, 2003 at 7:57 pm
    Sep 4, 2003 at 6:07 am
  • I wish to SELECT * FROM testTable WHERE any field contains any word in the string "my name is bill" All I can come up with is this. SELECT * FROM testTable WHERE testfeild LIKE '%my%' OR testfield2 ...
    Kevin WatersonKevin Waterson
    Sep 2, 2003 at 6:45 am
    Sep 2, 2003 at 2:43 pm
  • Hello. I've got a problem in porting the following select statement from Oracle to Postgres, because of the characters after "b.bet_id" and "f.ask_id" in the where clause: (+) I don't know what these ...
    Doris BernloehrDoris Bernloehr
    Sep 28, 2003 at 1:12 pm
    Sep 28, 2003 at 4:32 pm
  • Hello, I am new to PostgreSQL (but not new to SQL; I am an experienced Oracle Programmer). Any help to resolve my problem will be greatly appreciated. I am trying to create a new database user and ...
    Partha SurPartha Sur
    Sep 27, 2003 at 3:23 am
    Sep 27, 2003 at 5:42 am
  • Have read the docs, tried to look through go(o)gles.. came up with nothing... How can I make postgres to store transaction log on a different drive? Ie. my postgres files reside in /var/lib/pgsql ...
    Marcin GilMarcin Gil
    Sep 25, 2003 at 6:41 am
    Sep 25, 2003 at 1:31 pm
  • hi to all.. Can anyone suggest a good tutorial for win32 programming... Thanks in advance regds smitha ********************************************************************* Disclaimer: The ...
    Smitha V. BabuSmitha V. Babu
    Sep 18, 2003 at 5:17 am
    Sep 18, 2003 at 10:07 am
  • Hi to all.. Does anybody know how to use Python with tkinter to create the GUI in linux... In our project we need to use python for GUI.... Can anybody help me .... Smitha V.Babu System Analyst ...
    Smitha V. BabuSmitha V. Babu
    Sep 8, 2003 at 6:21 am
    Sep 16, 2003 at 12:57 pm
  • Hi again, I just tried the first load in my brand new pg database... And IT SUCKS! yeah! it took over an hour to load around 200 thousand records, while the sqlserver2000 took about 5-7 minutes... Im ...
    Juan Francisco DiazJuan Francisco Diaz
    Sep 4, 2003 at 8:36 pm
    Sep 4, 2003 at 10:51 pm
  • Attempting to install PostGreSQL 7.3.X on a sparc-sun-solaris2.9 (SunOS 5.9) machine; during configure, numerous errors like these were logged: configure:4357: gcc -o conftest conftest.c -lbsd &5 ld: ...
    David RickardDavid Rickard
    Sep 3, 2003 at 5:18 pm
    Sep 4, 2003 at 10:37 pm
  • Hi, im trying to use the copy command to load some data in my tables but i get the following message: 000081": can't parse "pg_atoi: error in "0 When i execute the following command: copy ...
    Juan Francisco DiazJuan Francisco Diaz
    Sep 2, 2003 at 3:24 pm
    Sep 3, 2003 at 6:31 am
  • Hi, I'm a novice for using Postgres and Linux - any help or suggestions would be really appreciated, thanks!!! I'm having trouble logging on as the postgres user. I wanted to create a database, so I ...
    Jennifer LiuJennifer Liu
    Sep 1, 2003 at 4:11 pm
    Sep 2, 2003 at 3:50 am
  • Hi all, I’d like to set up a computed column that uses a function to derive its data, but can’t seem to find any information on how to do this. My issue, specifically, is this: I have a user table ...
    David BenoffDavid Benoff
    Sep 29, 2003 at 2:51 pm
    Sep 29, 2003 at 5:47 pm
  • Hi, I have a table which contains information about MRTG graphs. Each of the graphs belongs to a device (switch, router, host) or to a service (web server, news server etc.), so I made a second table ...
    Oliver FrommeOliver Fromme
    Sep 29, 2003 at 11:41 am
    Sep 29, 2003 at 3:46 pm
  • Greetings, I am having a little difficulty installing PostgreSQL7.3.4 with java. The box is is running SuSE9.2 linux. I have environmental variables set in bash-profile as: JAVA_HOME=wherever export ...
    Sibusiso xoloSibusiso xolo
    Sep 26, 2003 at 1:11 am
    Sep 26, 2003 at 7:06 pm
  • Hi list, Wondering if you could help me out here? I've got a table like this: id name data 1 sully 567 2 sully 789 3 sully 456 4 denan 890 5 denan 678 now I want to have this: id name data rank 1 ...
    SjorsSjors
    Sep 25, 2003 at 3:47 pm
    Sep 25, 2003 at 11:38 pm
  • Hi, I have created a function(a) that within this function(a) another function(b) is called. When I execute function(a) I am getting a syntax error near ; message. When I comment out the line of code ...
    Godshall MichaelGodshall Michael
    Sep 25, 2003 at 3:34 pm
    Sep 25, 2003 at 10:47 pm
  • Hello All, I've recently made the transition to PostgreSQL from MySQL - and am trying to learn how to program functions using pl/pgsql - but todate have not found any really excellent examples in one ...
    SimonSimon
    Sep 24, 2003 at 2:02 pm
    Sep 25, 2003 at 11:20 am
  • I am somewhat new to PostgreSQL's procedure language, and I have not been able to find a way to do ad-hoc outputs to the console from plpgsql functions -- mostly for debugging purposes. Oracle has ...
    Glenn_wiensGlenn_wiens
    Sep 23, 2003 at 2:07 pm
    Sep 23, 2003 at 3:14 pm
  • Hi, Can anyone kindly enlighten me on how to write a connection string from an ASP.NET application to PostgreSQL db without the use of Npgsql or other data providers? Roslyn
    Roslyn TeoRoslyn Teo
    Sep 15, 2003 at 11:17 am
    Sep 17, 2003 at 1:09 pm
  • DEBUG: XLogWrite: new log file created - consider increasing WAL_FILES DEBUG: XLogWrite: new log file created - consider increasing WAL_FILES ERROR: Cannot insert a duplicate key into unique index ...
    MickeyMickey
    Sep 16, 2003 at 3:32 am
    Sep 16, 2003 at 3:29 pm
  • Hi all, I have a question: I deleted half of the records in my table and to free up the space I do a VACUUM VERBOSE. Is it normal that my VACUUM VERBOSE runs in a loop? If not, what can I do to free ...
    WimWim
    Sep 15, 2003 at 5:26 pm
    Sep 15, 2003 at 6:25 pm
  • I'm trying to initialize and start postgresql under Red Hat 8 using the command: /etc/rc.d/init.d/postgresql start The script fails, and from looking at the log, it would appear that the error ...
    White, BenjaminWhite, Benjamin
    Sep 12, 2003 at 9:02 pm
    Sep 13, 2003 at 5:55 am
  • Hi, I posted this question before on this list but got no replies and still didn't find the answer myself, so here's another attempt: How can I find the currently connected users? I.e. what query ...
    M. BastinM. Bastin
    Sep 12, 2003 at 10:11 am
    Sep 12, 2003 at 3:53 pm
  • I am using a BDE connection from a windows app I'm building to connect to Postgres 7.3.2 running on Redhat on a linux box. When I attempt to Post the dataset which I have loaded with a very large ...
    Derrick BettsDerrick Betts
    Sep 11, 2003 at 2:35 am
    Sep 11, 2003 at 2:27 pm
  • Hi, Is there a way to find out which files in $PGDATA belong to which database? I need that information for accounting purposes (users are billed per Gbyte of data). In mysql it is very easy, because ...
    Oliver FrommeOliver Fromme
    Sep 10, 2003 at 10:13 am
    Sep 10, 2003 at 4:08 pm
  • I am a Postgres novice. I have not done anything in the way of configuring the DB differently from what the defaults are. Here is my problem... I am sending the source text from web pages to the DB ...
    Derrick BettsDerrick Betts
    Sep 8, 2003 at 3:40 pm
    Sep 8, 2003 at 4:07 pm
  • Is there some easy way I can take an old PGDATA directory and load it into a new instance of Postgres? My server was rebuilt, and I didn't get a chance to dump the database to restore it in the new ...
    Damon CourtneyDamon Courtney
    Sep 5, 2003 at 4:46 pm
    Sep 7, 2003 at 1:06 am
  • I have a few databases that set for ASCII encoding right now. Is there a way to convert them to Unicode? I tried using "alter database mConceptsEd set encoding='UNICODE' and about a hundred other ...
    Brad RhineBrad Rhine
    Sep 5, 2003 at 12:40 pm
    Sep 6, 2003 at 7:24 am
  • After a successful install, and with postmaster running, we cannot get psql (or any of the psql-dependent scripts) to run; The error message is: ld.so.1: /usr/local/app/pgsql/bin/psql: fatal: ...
    David RickardDavid Rickard
    Sep 5, 2003 at 8:16 pm
    Sep 5, 2003 at 9:35 pm
  • Hello, all. I need to transfer a database from postgres 7.3.3 to another server, managed by other people, running version 7.2.3. So, I've pg_dump'ed the db with SQL output. While visually inspecting ...
    Marcus Andree S. MagalhaesMarcus Andree S. Magalhaes
    Sep 4, 2003 at 4:13 pm
    Sep 4, 2003 at 4:29 pm
  • So lets say I got a table A(x,y,z, Q) ordered by column Q, with contents like so: x y z Q ------------------------ 21 5 x 1 21 5 x 2 43 10 t 3 1 2 a 5 43 10 t 10 21 5 x 50 what I would like is to ...
    LHLH
    Sep 4, 2003 at 2:54 am
    Sep 4, 2003 at 6:13 am
Sep 2003
12
Group Navigation
period‹ prev | Sep 2003 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions96
posts314
users110
websitepostgresql.org
irc#postgresql

110 users for September 2003

Tom Lane: 40 posts Bruno Wolff III: 13 posts Juan Francisco Diaz: 13 posts Jason Hihn: 12 posts Oliver Fromme: 11 posts M. Bastin: 10 posts Oliver Elphick: 10 posts Ron Johnson: 9 posts Stephan Szabo: 9 posts David Rickard: 7 posts Jeffrey Melloy: 6 posts Bryan Irvine: 5 posts Derrick Betts: 5 posts Louise Cofield: 5 posts Marcin Gil: 5 posts Mickey: 5 posts Wim: 5 posts Godshall Michael: 4 posts Heath Tanner: 4 posts Stuart Woodward: 4 posts
show more
Archives