FAQ

PostgreSQL > pgsql-novice > September 2005

Search Discussions

77 discussions - 218 posts

  • hi all, i'm baffled by a sql issue. i use adodb and the code is as follows (the sql should be pretty evident - even if you don't follow adodb). $result_update = $db- Execute('UPDATE t_defect SET ...
    Operationsengineer1Operationsengineer1
    Sep 7, 2005 at 11:48 pm
    Sep 12, 2005 at 12:25 pm
  • Ok after a bunch of testing I have discovered it isn't data corruption. Bingo it is the custom datatype code. The curious things is this... When I do the dump it calls COPY... which balks on an ...
    Morgan KitaMorgan Kita
    Sep 3, 2005 at 3:48 am
    Sep 4, 2005 at 10:46 pm
  • I want to run an outer join query on two tables so that the tags from one will always appear even if the other table is lacking those attributes. Unfortunately, while the join seems to work there is ...
    Martin FosterMartin Foster
    Sep 25, 2005 at 11:51 pm
    Sep 26, 2005 at 1:06 am
  • Good afternoon to you all. First of all I want to thank each one of you for the efforts you make to provide the world with a first class Open source Database. I myself started only recently working ...
    EradictEradict
    Sep 28, 2005 at 2:27 pm
    Oct 5, 2005 at 4:24 pm
  • Anyone can provide the init script (that resides in /etc/rc.d/ini.t) for Postgresql-8.0.3? it's installed in /usr/local/pgsql Thanks Marc
    Marc KhayatMarc Khayat
    Sep 23, 2005 at 3:30 pm
    Sep 26, 2005 at 1:57 pm
  • Hi all, The following may be too silly even for this mailing list... but however: i've never used PostgreSQL before, always been using MySQL. I installed postgresql-8.0.1, but when trying to run it, ...
    Marc KhayatMarc Khayat
    Sep 20, 2005 at 6:54 am
    Sep 20, 2005 at 7:58 pm
  • Hello all, I know how do do this in IBM DB2 and MySQL, but now my interrest has shifted towards postgresql; I need to be able to insert a row, and find out which id it was assigned. (I'm talking ...
    Jan DanielssonJan Danielsson
    Sep 4, 2005 at 6:01 pm
    Sep 6, 2005 at 2:33 pm
  • [Using postgres (PostgreSQL) 7.4.7 on GNU/Linux 2.4.27-1-386 - Debian/Sarge] ---------------------------------------- Hi all, testing a few arithmetic calculations to make sure I understood how they ...
    Ennio-SrEnnio-Sr
    Sep 29, 2005 at 7:42 pm
    Sep 30, 2005 at 12:04 am
  • Hi all, [Using postgres (PostgreSQL) 7.4.7 on GNU/Linux/Debian-Sarge] running the command: $ pg_dump finanz -t ult_qq | psql finanza ennio ult.qq I can see that table 'ult_qq' is regularly created in ...
    Ennio-SrEnnio-Sr
    Sep 17, 2005 at 3:03 pm
    Sep 18, 2005 at 4:22 pm
  • Hi all, I have already posted my query regarding libpq functions and wide character support. Pls somebody help me. I am using libpq API functions in my C code to do operations on the database. But ...
    Pradeepkumar, Pyatalo (IE10)Pradeepkumar, Pyatalo (IE10)
    Sep 8, 2005 at 6:43 am
    Sep 12, 2005 at 3:00 am
  • Just a short question with hopefully a bit longer answer: how do I get around the password prompt? regards, Ivo <http://www.incredimail.com/index.asp?id=96317 FREE Emoticons for your email! Click ...
    Jessica BroomansJessica Broomans
    Sep 2, 2005 at 8:50 am
    Sep 7, 2005 at 11:47 am
  • When I use "select (f1+f2+f3+f4+f5) as f0 ..." in 7.4.3, it seems I can use "f0" is "order by", but not "where" clause [column 'f0' does not exist]? Does this change in more current versions? Is ...
    Frank BaxFrank Bax
    Sep 1, 2005 at 3:18 pm
    Sep 3, 2005 at 5:17 pm
  • Hi list, I need to setup a RULE for INSERTing into a VIEW. The rule has to insert several times into the same table, and I need to remember the currval()s for another INSERT. Are there any variables ...
    Nabil SayeghNabil Sayegh
    Sep 1, 2005 at 6:31 pm
    Sep 2, 2005 at 2:09 am
  • I am coding a procedure to purge data from a table. I want to commit the data I'm purging at intervals (for example, every 1000 rows). The problem I'm encountering is that when I have begin ...
    Walker, Jed SWalker, Jed S
    Sep 30, 2005 at 8:47 pm
    Oct 3, 2005 at 1:48 pm
  • List, I have a temporary table and I need to get the tableoid from the interface. The table may not have any data in it so something like SELECT tableoid FROM tmp_table LIMIT 1, returns zero when ...
    Terry Lee TuckerTerry Lee Tucker
    Sep 30, 2005 at 10:26 am
    Sep 30, 2005 at 5:38 pm
  • I have the following related tables: PEOPLE -------------- peopleid pkey, name, etc GROUPS ------------- groupid pkey, description, etc PEOPLEGROUPS ------------------- peopleid pkey/fkey, groupid ...
    A. BanksA. Banks
    Sep 22, 2005 at 12:45 am
    Sep 24, 2005 at 2:55 pm
  • hi all, i'm trying to acces our new in-house pgsql server. pgsql 8.0.3 is running on fc3. i vpn into the company network, then i sign into the fc3 server a "user" via an accuterm session. i typed in ...
    Operationsengineer1Operationsengineer1
    Sep 23, 2005 at 5:08 pm
    Sep 23, 2005 at 6:10 pm
  • Hello! I want to create a view of a table that is in several schema's. The table is CREATE TABLE "operator" ( "operatorid" INTEGER PRIMARY KEY, "accountid" INTEGER REFERENCES "account"("accountid"), ...
    ToffToff
    Sep 19, 2005 at 10:18 am
    Sep 23, 2005 at 1:43 pm
  • When i try inserting a quite large amount from data (imported from a text file via Java) i get this error wich cames non always at the same time. What is this caused by ? -- L'Estetica del lavoro è ...
    Fabrizio piccaFabrizio picca
    Sep 13, 2005 at 8:43 am
    Sep 14, 2005 at 7:29 pm
  • i've been having a dandy day reading the pgsql docs... and i think i learned some things, but i want to bounce them off of ya'll to see if i'm right or out to lunch. here are the facts: 1. current ...
    Operationsengineer1Operationsengineer1
    Sep 12, 2005 at 11:46 pm
    Sep 13, 2005 at 5:44 pm
  • (Sorry for asking so many questions, but I can't find answers in the documentation.) Why would one bother to create a schema (with "create schema blah blah")? Isn't a database enough to keep tables, ...
    KynnKynn
    Sep 10, 2005 at 5:49 pm
    Sep 10, 2005 at 11:38 pm
  • hi list i got a weird problem. somehow, for pg-sql, this statement is not true: SELECT lower('zwiebelbäcker') = 'zwiebelbäcker' = false (which is the wrong answer, obviously) amazingly, this one ...
    MeMe
    Sep 3, 2005 at 9:26 pm
    Sep 4, 2005 at 11:33 pm
  • I am trying to copy some rows from a table to another table using "create table as" but I keep getting a "column name 'ogc_fid' is duplicated" error. Can anyone tell me why this is happening? The ...
    Frances CollierFrances Collier
    Sep 28, 2005 at 5:07 pm
    Oct 7, 2005 at 12:31 am
  • hi list, i'm relatively new in creating stored procs and i'm having this problem: i created a stored proc that creates an aggregated view and it was successfully loaded without errors. my problem ...
    ShadowboxShadowbox
    Sep 28, 2005 at 11:59 am
    Sep 29, 2005 at 3:14 am
  • I think I have a stored procedure that is running longer than it should, and am trying to time how long each section of a stored procedure is taking the most time. I have used localtimestamp, now(), ...
    Lane Van IngenLane Van Ingen
    Sep 28, 2005 at 8:12 pm
    Sep 28, 2005 at 9:33 pm
  • Hello, I have dates in a database that look something like so : CREATE TABLE myEvents ( id integer DEFAULT nextval('serial_seq') PRIMARY KEY, cal_id integer not null references saa_calendars(id) on ...
    A GilmoreA Gilmore
    Sep 24, 2005 at 7:08 pm
    Sep 27, 2005 at 5:52 pm
  • This is my first post to ANY mailing list so apologies in advance if I screw up anywhere. I'm using the pg_restore utility in PostgreSQL 8.0.3 with the following command: pg_restore.exe -i -h ...
    Wye Jon LeeWye Jon Lee
    Sep 23, 2005 at 8:22 am
    Sep 26, 2005 at 6:36 am
  • Just a quick question: Bytea columns are backed up appropriately using pg_dump/dumpall? The docs mention specifics about large objects, and I just wanted to check whether bytea is considered a large ...
    Sean DavisSean Davis
    Sep 23, 2005 at 11:12 am
    Sep 23, 2005 at 2:18 pm
  • Hello everyone, I've decide to use PostgreSql as the SGBD for the application i'm developing. I've already have some info based on dbf files. Someone has any idea on how can i use the info on this ...
    Rafael BarbosaRafael Barbosa
    Sep 22, 2005 at 7:22 pm
    Sep 23, 2005 at 2:01 pm
  • Hi to everyone i hope you can help me Im doing a query in a database, but i want to use crontab to do it each monday There isn´t no problem when i run my script manually ]$ ./mdnimsi.sh It generates ...
    Sigrid MenesesSigrid Meneses
    Sep 21, 2005 at 11:20 am
    Sep 23, 2005 at 4:48 am
  • Is there a way to determine if a table is temporary. Currently I have a cursor that goes through pg_class for all tables and views owned by a particular owner, but I need to exclude temporary tables. ...
    Walker, Jed SWalker, Jed S
    Sep 15, 2005 at 7:54 pm
    Sep 15, 2005 at 9:59 pm
  • I have a simple Java Application running on Windows 2000 I am working on at home. Initially it accessed data in an Access database via Jdbc:Odbc, but I detest Microsoft and their database is a ...
    Peter CookPeter Cook
    Sep 13, 2005 at 2:10 am
    Sep 15, 2005 at 5:48 am
  • hi, i have a zip code field in a table that is used by "international" customers, which lead to very "random" data there. but a query should be possible "by number" if there is only a number in the ...
    Christoph FrickChristoph Frick
    Sep 14, 2005 at 9:21 am
    Sep 14, 2005 at 2:11 pm
  • Hi All, I am trying to generate a dynamic date value as part of a much larger query. The date must be at least one day prior to the ship date and must not be a weekend or a holiday. I have created a ...
    Keith WorthingtonKeith Worthington
    Sep 13, 2005 at 4:01 pm
    Sep 13, 2005 at 6:39 pm
  • Hi All, i'm facing a db / data migration issue. i have 3 dbs. my dev box is pgsql 7.4.6 (laptop, winxp / cygwin) my current production box is 7.3.x (webhost, linux) my new production box is 8.03 ...
    Operationsengineer1Operationsengineer1
    Sep 9, 2005 at 11:49 pm
    Sep 13, 2005 at 3:32 pm
  • hi, i'm new to postgreSQL as well as new to database concepts. please tell me how can i learn. i mean the easiest and fast way. Your help will be appreciated.
    Suresh ramasamySuresh ramasamy
    Sep 12, 2005 at 11:37 am
    Sep 13, 2005 at 3:56 am
  • Hi, I'm having trouble finding out how to add non-ascii chars into the database from c#. 'ERROR: 22021: invalid byte sequence for encoding "UNICODE": 0xfc ' is the error I get when attempting to add ...
    Peter SchonefeldPeter Schonefeld
    Sep 10, 2005 at 3:30 am
    Sep 10, 2005 at 6:47 am
  • How do I retrieve a list of columns for a table from an outside application? I don't want to retrieve any rows from the table just the column related data like what is retrieved using '\d [table ...
    Kevin CrenshawKevin Crenshaw
    Sep 7, 2005 at 10:20 pm
    Sep 8, 2005 at 12:38 am
  • I'm trying to build postgreSQL 8.0.3 from source using MinGW (the suggested emulator), and I don't see any step-by-step instructions on how to do this. I've seen the INSTALL and FAQ_MINGW docs, but ...
    Lee, Patricia S.Lee, Patricia S.
    Sep 7, 2005 at 4:28 pm
    Sep 7, 2005 at 7:05 pm
  • hi all, i read the followin gon slashdot... (*) Nested loops are like candy to SQL server, and I've heard this is the same for Sybase (understandably). Deep sets of nested loops will kick the other ...
    Operationsengineer1Operationsengineer1
    Sep 5, 2005 at 11:29 pm
    Sep 6, 2005 at 1:05 am
  • Hi, I just tried to call pg_dump for my database this evening, and it fails on one of my tables. The error it gives in the log is: ERROR: invalid memory alloc request size 3221230573 So at this point ...
    Morgan KitaMorgan Kita
    Sep 2, 2005 at 4:06 am
    Sep 2, 2005 at 8:08 pm
  • Is there a way of backing up and then restoring an 8.0.3 database into a 7.4.5 environment? Regards, Steve Tucknott
    Steve TucknottSteve Tucknott
    Sep 26, 2005 at 6:59 pm
    Oct 3, 2005 at 6:48 am
  • Hello, If I have an interval of say '1 day 3 hours 30 minutes' how might I express that form of a specified interval type, ie for hours : '27.3 hours'. Is the only option to write a function that ...
    A GilmoreA Gilmore
    Sep 30, 2005 at 4:59 pm
    Sep 30, 2005 at 5:34 pm
  • Hi in pgsql I can execute a list of sql commands from a text file using ... lumbribasetest=# \i comm_list.sql but in a perl script using DBI and the syntax... $com = $conn- prepare("\i ...
    Ann hedleyAnn hedley
    Sep 29, 2005 at 1:17 pm
    Sep 30, 2005 at 12:34 am
  • I'm hoping someone has a script pre-cooked that they're willing to share with me. Here's what I'd like to do: Create a cgi perl script which does the following: Thru a web browser (ergo cgi) connect ...
    Greg T.Greg T.
    Sep 16, 2005 at 1:15 pm
    Sep 23, 2005 at 2:33 pm
  • Here is my table: table tst: id | date | num ---+---------------------+---- 1 | 2005-09-22 14:37:21 | 5 2 | 2005-09-22 10:22:33 | 3 3 | 2005-09-21 10:22:34 | 3 4 | 2005-09-14 10:33:21 | 5 5 | ...
    PgsqlPgsql
    Sep 22, 2005 at 7:27 pm
    Sep 22, 2005 at 10:05 pm
  • Hi, Yesterday I tried to restore from a data dump of my db from about a week ago. I am running 8.0.1 and have been since I first started use postgresql. As an example when I ran the dump I used: ...
    Morgan KitaMorgan Kita
    Sep 15, 2005 at 7:57 pm
    Sep 15, 2005 at 8:17 pm
  • Hello group: I have two different types of data. this data is processed to derive a set of values. I am trying to store the data in a database using postgres. I have designed two tables for two ...
    Srinivas IyyerSrinivas Iyyer
    Sep 14, 2005 at 10:36 pm
    Sep 15, 2005 at 5:31 pm
  • phppgadmin (my only access to db - cheesy webhost) has an "export" link that only allows me to... export data, structure or data and structure (fine so far, i want data only). format options are ...
    Operationsengineer1Operationsengineer1
    Sep 13, 2005 at 5:07 pm
    Sep 13, 2005 at 7:35 pm
  • i run the program like createdatabse, but don't able to put the passowrd the keyboard doesn't respond why is this?
    LucianoLuciano
    Sep 11, 2005 at 4:46 am
    Sep 13, 2005 at 8:05 am
Sep 2005
12
Group Navigation
period‹ prev | Sep 2005 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions77
posts218
users79
websitepostgresql.org
irc#postgresql

79 users for September 2005

Tom Lane: 24 posts Operationsengineer1: 18 posts Michael Fuhr: 11 posts Me: 8 posts Oliver Elphick: 8 posts Ennio-Sr: 7 posts Marc Khayat: 6 posts Morgan Kita: 6 posts John DeSoi: 5 posts A Gilmore: 4 posts Andrej Ricnik-Bay: 4 posts Josh Berkus: 4 posts Martin Foster: 4 posts Michael Glaesemann: 4 posts Pradeepkumar, Pyatalo (IE10): 4 posts Terry Lee Tucker: 4 posts Toff: 4 posts Frank Bax: 3 posts Lane Van Ingen: 3 posts Peter Cook: 3 posts
show more
Archives