FAQ

PostgreSQL > pgsql-novice > December 2004

Search Discussions

81 discussions - 276 posts

  • Hello All; The webpage listing the various mailing lists said that no question was too simple, so here goes: I am trying to evaluate PostGreSQL to see if it can do what I want. My first problem is ...
    Raymond StillRaymond Still
    Dec 10, 2004 at 10:33 pm
    Dec 17, 2004 at 12:53 am
  • Hi All, I would like to write the output of the \d command on all tables in a database to an output file. There are more than 200 tables in the database. I am aware of \o command to write the output ...
    Sarlav kumarSarlav kumar
    Dec 15, 2004 at 2:38 pm
    Dec 15, 2004 at 6:23 pm
  • Hi All, I am receiving a quantity as text and a seperate date and time as text. The quantity is written into a varchar(20) column and the date and time are written into char(8) and char(6) columns ...
    Keith WorthingtonKeith Worthington
    Dec 20, 2004 at 9:58 pm
    Dec 21, 2004 at 2:34 pm
  • Hi All, Thanks to everyone for helping with my previous questions. I have a test database running on Postgres 7.3.2. version ------------------------------------------------------------- PostgreSQL ...
    Sarlav kumarSarlav kumar
    Dec 20, 2004 at 2:40 pm
    Dec 21, 2004 at 7:08 am
  • Hello, I am very new to postgresql and was excited to see that pl/perl was able to do more in the newest version. So I created a database to learn some of is feature. But when I try to to do: ...
    Robert BooneRobert Boone
    Dec 17, 2004 at 2:28 pm
    Dec 17, 2004 at 6:02 pm
  • Hello; I have spent a little time on PgAdmin III. I can see I'm playing with a lot of power. Now I need to figure out how to use the database. Is what I'm looking for the front end? (sorry haven't ...
    Afton & Ray StillAfton & Ray Still
    Dec 19, 2004 at 12:05 am
    Dec 24, 2004 at 4:32 am
  • Hi All, I have the following data: IPADB=# SELECT * FROM inventory.tbl_data; inventory_id | item_id | quantity --------------+------------+---------- 1 | RMFPB14BK | 551 1 | RPP3S114BK | 629 1 | ...
    Keith WorthingtonKeith Worthington
    Dec 23, 2004 at 8:57 pm
    Dec 27, 2004 at 8:50 pm
  • Postgresql 7.4.5 (pgaccess and psql) RedHat 8 Is there a way of 'cross accessing' databases? We tend to use three environments for development - a dev_ , test_ and rel_ prefixed database then exists ...
    Steve TucknottSteve Tucknott
    Dec 17, 2004 at 7:32 am
    Dec 17, 2004 at 9:28 am
  • Hi I have been trawling the archives but have not what I am after with regards to the message below. from pg_dump -d ourdb quick-backup-dec7.db I eventuate with the following $ pg_dump: message type ...
    NeilNeil
    Dec 7, 2004 at 4:23 am
    Dec 10, 2004 at 10:23 pm
  • All, I'm looking for a good book for an absolute PostgreSQL beginner. I have used MySQL a bit but have only gotten as far as installing PG. The local book store only has a few titles: PostgreSQL ...
    Kim KohenKim Kohen
    Dec 2, 2004 at 5:00 pm
    Dec 3, 2004 at 6:03 am
  • Hi All, I have a question regarding multiple inserts. The following function inserts for each country found in country table, values into merchant_buyer_country. ...
    Sarlav kumarSarlav kumar
    Dec 13, 2004 at 4:28 pm
    Dec 29, 2004 at 6:59 pm
  • Hi All, I wrote a query that created a view and when I looked at it in the database the SELECT statement was very different. In part SELECT items.id, COALESCE(sales.sum, 0) AS committed, ...
    Keith WorthingtonKeith Worthington
    Dec 27, 2004 at 6:45 pm
    Dec 27, 2004 at 7:48 pm
  • I admit I'm not real clear on terminolgy. As I understand it, front end means what the user sees and uses to input data and get information. The backend is what does the work and takes care of the ...
    Afton & Ray StillAfton & Ray Still
    Dec 19, 2004 at 5:23 am
    Dec 24, 2004 at 7:09 am
  • I'm sure I'm missing something obvious, but this is the novice list, so here goes: Is there a function to return the day-of-week for a given time/datestamp? What I'm looking for is something like: ...
    Lloyd DieterLloyd Dieter
    Dec 21, 2004 at 12:28 pm
    Dec 21, 2004 at 9:55 pm
  • Hi all, I am running postgresql 7.1.3 on Red Hat Linux 7.2. pg_control file get corrupted on abrupt PC reboot. Can I copy the pg_control file of another PC (in which also postgresql 7.1.3 is running ...
    Deepa KDeepa K
    Dec 18, 2004 at 8:48 am
    Dec 18, 2004 at 5:55 pm
  • I have a table that has a column that has values like XM_29832.11 and I want to do an update to take off the .11 part. I can do this for a single value using: select substring('XM_29832.11' from ...
    Sean DavisSean Davis
    Dec 3, 2004 at 1:19 pm
    Dec 3, 2004 at 9:22 pm
  • Hi All, I am working on the function below. whenever I run it I get the following: IPADB=# SELECT inventory.commit_scanner_data('monthly', 'this_is_a_test'); WARNING: Error occurred while executing ...
    Keith WorthingtonKeith Worthington
    Dec 22, 2004 at 5:55 am
    Dec 22, 2004 at 4:08 pm
  • Hi All, I am trying to create a trigger function that moves data from one table to another. This is patterned after several working functions. After I create the function I attempt to COPY data into ...
    Keith WorthingtonKeith Worthington
    Dec 21, 2004 at 5:23 pm
    Dec 22, 2004 at 3:50 am
  • Dear PostgreSQL Enlightened , Is their any plugin or work around that would allow me to log Squid jobs into PostgreSQL ? -- With Best Regards, Vishal Kashyap. http://vishalkashyap.tk
    Vishal Kashyap @ [SaiHertz]Vishal Kashyap @ [SaiHertz]
    Dec 11, 2004 at 5:39 pm
    Dec 21, 2004 at 6:41 pm
  • Hi, I'm just wondering, what real benefit does inheritance have? When i create two tables, one inherited from the other, does that mean i have two tables with same duplicate data or actually they are ...
    Hasnul Fadhly bin HasanHasnul Fadhly bin Hasan
    Dec 21, 2004 at 3:22 am
    Dec 21, 2004 at 2:42 pm
  • Hi All, I logged in as postgres user and created a new user 'test' with a password. create user test with password 'test'; But when I use the -U option to login with the new user 'test', it does not ...
    Sarlav kumarSarlav kumar
    Dec 20, 2004 at 3:18 pm
    Dec 20, 2004 at 3:25 pm
  • I have a number of sql scripts which I execute using psql -f I can easily redirect the output for logging and archival. However, psql will only display the result of each SQL statement, and not the ...
    Gino LucreziGino Lucrezi
    Dec 17, 2004 at 12:49 pm
    Dec 20, 2004 at 11:40 am
  • Hello, I have a problem I feel Im going about the wrong way but after reading over the date/time data types documentation a few times Im still unsure of how to do this. Id like my application to do ...
    A GilmoreA Gilmore
    Dec 20, 2004 at 12:07 am
    Dec 20, 2004 at 2:35 am
  • Hi All, I am trying to build a function to insert or update data in one table from date stored in another table. Eventually I hope to trigger this process based on data being INSERTed into the ...
    Keith WorthingtonKeith Worthington
    Dec 16, 2004 at 11:02 pm
    Dec 17, 2004 at 12:11 am
  • I am running the latest version of OS X on my PowerBook. When I try to access my 7.4.3 Postgresql installation (I used the package from entropy.ch), I get this message "Login disallowed for security ...
    Lola LeeLola Lee
    Dec 15, 2004 at 11:32 am
    Dec 16, 2004 at 4:06 am
  • I'm having trouble correctly indexing a large table. The table will be receiving about 30 million rows/day, and has the following definition: CREATE TABLE quote ( symbol varchar (5), price numeric ...
    Matthew EngelbertMatthew Engelbert
    Dec 10, 2004 at 8:16 pm
    Dec 15, 2004 at 2:30 am
  • I'm trying to implement a daemon that gets its data from postgresql. The user uses a web interface to store the time that the daemon should begin operations in a table called translog. The schema for ...
    Martin AtukundaMartin Atukunda
    Dec 14, 2004 at 9:44 am
    Dec 14, 2004 at 10:22 pm
  • Hi All, In our database we have a table as described below. When we attempt to write to the table from our visual basic program we receive an error. "ERROR: tbl_receiving_receipt_number_seq.nextval: ...
    Keith WorthingtonKeith Worthington
    Dec 10, 2004 at 10:58 pm
    Dec 12, 2004 at 3:22 am
  • Dear All, I have four tables linked together with FK. An example is, deleting an id in one table, deletes 1,000,000 rows in all the others. However, this operation takes 2-3mins (currently this more ...
    Colin GillespieColin Gillespie
    Dec 7, 2004 at 10:55 am
    Dec 10, 2004 at 8:11 pm
  • Hi All, I installed slony1.0.5 and tried the example replication of pgbench database. That seemed to work. Now I need to replicate a DB running on a different server. slony1.0.5 is installed on the ...
    Sarlav kumarSarlav kumar
    Dec 20, 2004 at 10:25 pm
    Dec 29, 2004 at 4:01 am
  • Hi All, I have a database running on Postgres 7.3.2. I am dumping the database schema from postgres 7.4.6 to restore it on the new Postgres version. The two postgres versions are running on different ...
    Sarlav kumarSarlav kumar
    Dec 27, 2004 at 5:32 pm
    Dec 28, 2004 at 11:58 pm
  • Hi All, I'm stuck again. I have written two queries. The first calculates the total quantity of items that have been ordered. The second calculates the total quantity of items that have been ...
    Keith WorthingtonKeith Worthington
    Dec 28, 2004 at 4:33 am
    Dec 28, 2004 at 4:41 pm
  • Hi! I'd like to upgrade my all postgres databases from pg 7.4 to pg 8.0. Many of them use large objects with oids stored in tables. How can I dump them all at once and restore with right oids? ...
    Marcin GilMarcin Gil
    Dec 20, 2004 at 3:17 pm
    Dec 21, 2004 at 7:36 am
  • I'm building a system in Smalltalk and using unit tests (SUnit) extensively. The unit tests cover all model and persistence aspects of the system, and part of what they do is create and drop the ...
    Bruce BadgerBruce Badger
    Dec 20, 2004 at 4:02 am
    Dec 21, 2004 at 7:35 am
  • If this should be directed to another list, please let me know. First, I want to compliment everyone that has contributed to the development of 8.0. I recently installed Beta 5 (on XP without a ...
    George WeaverGeorge Weaver
    Dec 20, 2004 at 5:51 pm
    Dec 20, 2004 at 7:00 pm
  • Hi All, I have a function/trigger pair operating that move data from one table to another after that data is inserted into the first table. Can triggers and functions have the same name? Is this a ...
    Keith WorthingtonKeith Worthington
    Dec 17, 2004 at 4:05 am
    Dec 17, 2004 at 6:52 am
  • Hi All, Well, I am continueing to make progress on my function to transfer or update data as required. However I have hit another snag. After I successfully create the function below I atttempt to ...
    Keith WorthingtonKeith Worthington
    Dec 17, 2004 at 12:50 am
    Dec 17, 2004 at 1:23 am
  • Hi All, When executing a query in PostgreSQL v7.3.6 are any variables set that indicate the status of that query? Success/Failure, Number of rows retrieved, Number of records written, etc. If not is ...
    Keith WorthingtonKeith Worthington
    Dec 15, 2004 at 2:11 am
    Dec 15, 2004 at 3:40 am
  • I have coments in some tables and columns, how to catch the coment on select ? it forgives my English, I am learning... Tanks Douglas
    DouglasDouglas
    Dec 10, 2004 at 9:36 pm
    Dec 13, 2004 at 5:21 pm
  • Hello, I want to make a Function as table source. As rettype you have to give a composite type but how do I make those? I'm using an new empty table with the the datatypes (INT, INT8, TEXT and a ...
    Tjibbe RijpmaTjibbe Rijpma
    Dec 10, 2004 at 10:18 pm
    Dec 13, 2004 at 2:39 am
  • Hello, I extracted an entire postgreSQL database using EMS PostgreSQL Extract and it saved the extraction as "XXX.sql" file. How can i restore or import into a postgreSQL server. thanks, kuru
    Sudhakar KurumellaSudhakar Kurumella
    Dec 6, 2004 at 7:02 pm
    Dec 10, 2004 at 9:52 pm
  • Dear All, Is there a way to use locks within a trigger? My example below gives the error: ERROR: unexpected error -8 in EXECUTE of query "BEGIN" CONTEXT: PL/pgSQL function "insert_into_t1" line 6 at ...
    Colin GillespieColin Gillespie
    Dec 6, 2004 at 3:43 pm
    Dec 7, 2004 at 10:12 am
  • Why am I getting the FATAL error message below when initializing the database. I did everything correctly as per the installation instructions I am running on REDHAT 9.0 Pentium 2 196 MB Help ...
    Felix OnyangoFelix Onyango
    Dec 6, 2004 at 2:58 pm
    Dec 7, 2004 at 4:41 am
  • Hi All, I am loading data into a PostgreSQL v7.3.6 database running on RedHat Enterprise Linux ES. This is accomplished by a shell script running the COPY command. The data is in comma seperated ...
    Keith WorthingtonKeith Worthington
    Dec 4, 2004 at 1:57 am
    Dec 4, 2004 at 4:14 am
  • Hi, I'm not sure why this does not work. create or replace function test1() returns int as ' return 1; ' LANGUAGE 'plpgsql'; select test1(); -------------------------------------------------------- I ...
    Kevin B.Kevin B.
    Dec 2, 2004 at 5:02 am
    Dec 2, 2004 at 8:02 pm
  • Hi, can somebody help me, I am trying to update a psql table in my data base. I created the table from a comma deliminated file that has four col. state, city, school, autoID. the current table. ...
    SloftusSloftus
    Dec 30, 2004 at 1:49 pm
    Dec 31, 2004 at 5:38 am
  • While trying to INSERT INTO managers table I get the following message: ERROR: relation "managers" does not exist What is this? And how do I make it go away? Thanks for you help. Mark
    Mark Edward SmithMark Edward Smith
    Dec 30, 2004 at 11:31 pm
    Dec 31, 2004 at 4:06 am
  • Hi All, I have a database dump that is created with the following command: pg_dump IPADB -Ft -s -v -U postgres | gzip -9 ${IPA_TMP_DIR}/IPADB.$(date +"% Y%m%d.%H%M%S").tar.gz I want to create a test ...
    Keith WorthingtonKeith Worthington
    Dec 29, 2004 at 6:33 pm
    Dec 29, 2004 at 7:05 pm
  • I followed these steps to create a new user : 1. createuser -P gforge 2. createdb -U gforge -E UNICODE gforge 3. createlang plpgsql gforge this gave no errors. But when I try to log in, I get the ...
    Sukhdeep JoharSukhdeep Johar
    Dec 28, 2004 at 10:57 am
    Dec 28, 2004 at 10:05 pm
  • Hi All, I am working on the query below (having made great progress thanks to your help) and have run into a result I do not understand. When I run the query I get 0 for all columns when the ...
    Keith WorthingtonKeith Worthington
    Dec 27, 2004 at 6:04 pm
    Dec 27, 2004 at 6:18 pm
Dec 2004
12
Group Navigation
period‹ prev | Dec 2004 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions81
posts276
users89
websitepostgresql.org
irc#postgresql

89 users for December 2004

Keith Worthington: 32 posts Michael Fuhr: 28 posts Tom Lane: 28 posts Sarlav kumar: 9 posts John DeSoi: 8 posts Kretschmer Andreas: 8 posts Afton & Ray Still: 7 posts Andreas Kretschmer: 6 posts Bruno Wolff III: 6 posts George Weaver: 6 posts Marcin Gil: 5 posts Sean Davis: 5 posts Tjibbe Rijpma: 5 posts Colin Gillespie: 4 posts Geoffrey: 4 posts Josh Berkus: 4 posts Neil: 4 posts Terry Lee Tucker: 4 posts Vishal Kashyap @ [SaiHertz]: 4 posts Deepa K: 3 posts
show more
Archives