Search Discussions

92 discussions - 279 posts

  • PostGreSQL 7.4.5 If I have the situation where process 1 has selected record1 from table a for update and then process 2 tries to do the same, am I right in assuming that process 2 will wait until ...
    Steve TucknottSteve Tucknott
    Nov 5, 2004 at 7:24 am
    Nov 6, 2004 at 3:30 am
  • Hello I have made my own type alignres that holds a string and an integer. I have created the type in postgres and tried to insert into it and it works. I also have a function that returns a row (or ...
    Kjetil HaalandKjetil Haaland
    Nov 18, 2004 at 1:54 pm
    Feb 14, 2005 at 9:08 am
  • Hi all, I am new to postgres. The current version of postgres we are using is 7.3.2. I am looking to upgrade to 7.4.x. Is the upgrade necessary? If so, which is the most stable version to upgrade to? ...
    Sarlav kumarSarlav kumar
    Nov 15, 2004 at 2:47 pm
    Nov 18, 2004 at 5:20 pm
  • Hello I am writing my own type for use in postgres. I want to be able to save a value - an integer, and a string in this type. I have looked at the documentation for how to do this. The insert into ...
    Kjetil HaalandKjetil Haaland
    Nov 8, 2004 at 12:26 pm
    Nov 19, 2004 at 4:20 pm
  • Hi! One of my colleagues upgraded his postgresql 7.3.x installation to 7.4 without pg_(dump/restore) cycle. Will he encounter any problems with working with such db? Is there a way to correct it? ...
    Marcin GilMarcin Gil
    Nov 29, 2004 at 11:12 am
    Dec 1, 2004 at 8:19 am
  • Hi, We have a table collectiong all details of an item: Here is a simplified representation of the tables Tables: items ------ item_id item_details ------------ item_detail_id item_id ...
    Raphael BauduinRaphael Bauduin
    Nov 3, 2004 at 1:18 pm
    Nov 8, 2004 at 1:18 pm
  • Hello List... I'd like to move a db containing large objects from one db to another. Using the command syntax directly from man pg_dump: pg_dump -Ft -b mydb mydb.tar pg_restore -d mydb mydb.tar I ...
    John-Paul DelaneyJohn-Paul Delaney
    Nov 4, 2004 at 10:31 am
    Nov 5, 2004 at 9:00 am
  • Greetings, Here is a simple question: Is it ok to put a unique index on the oid for my tables? We are in the process of moving from Progress Software to PostgreSQL. In the Progress world, you can ...
    Terry Lee TuckerTerry Lee Tucker
    Nov 11, 2004 at 5:10 pm
    Nov 11, 2004 at 8:50 pm
  • Hello I am writing a c extension function to my postgres database and in this i am trying to allocate memory space for a table of char. When i try to call a function that returns a value from this ...
    Kjetil HaalandKjetil Haaland
    Nov 3, 2004 at 9:29 am
    Nov 5, 2004 at 10:19 pm
  • Hi there, i have read http://archives.postgresql.org/pgsql-novice/2001-07/msg00098.php which dates back to july 2001. Has pg developed any further -.. ? i am trying to makes a project compatible for ...
    Thomas Hermann(Software)Thomas Hermann(Software)
    Nov 27, 2004 at 8:06 pm
    Nov 30, 2004 at 6:23 pm
  • Hi everyone! What is the cause of the following error message: FATAL: invalid cache id: 30 and how do I fix it...? 8-) Regards, Evert Meulie
    Evert MeulieEvert Meulie
    Nov 26, 2004 at 12:30 pm
    Nov 30, 2004 at 6:58 pm
  • After a friend's house recently caught fire, I decided that it would be a good idea to catalog my comic collection (for insurance purposes if nothing else). I estimate that I have some four hundred ...
    Jeff FlowersJeff Flowers
    Nov 22, 2004 at 7:55 pm
    Nov 22, 2004 at 10:55 pm
  • Hi! Does anyone know a solution how to use mod_auth or other apache autorization with Postgres? Thanks, -Marcin
    Dzial TechnicznyDzial Techniczny
    Nov 17, 2004 at 11:07 am
    Nov 21, 2004 at 8:49 am
  • Dear Group, I have two tables 1. Contacts and 2. Experiment. I have another link table con_exp_link table. Contacts Con_id con_fname con_lname con_address Experiment exp_id exp_name exp_scientist ...
    Kumar SKumar S
    Nov 2, 2004 at 1:49 pm
    Nov 2, 2004 at 6:34 pm
  • Hi people, Is there a / what is the way to query a list of values ? some_list = '1,2,3,4,5' some_list could also be null or any length. <cfif some_list IS NOT NULL SELECT some_id, some_name FROM ...
    Aarni RuuhimäkiAarni Ruuhimäki
    Nov 18, 2004 at 12:39 pm
    Nov 18, 2004 at 6:36 pm
  • I am using PostgreSQL 7.3.4 and have noticed something odd while using a sequence. After using 3000 values, I seem to be getting a duplicate. I'm running a stored procedure that uses this sequence ...
    Betsy BarkerBetsy Barker
    Nov 12, 2004 at 9:39 pm
    Nov 16, 2004 at 5:18 pm
  • I remember when I first play with postgresql, I play with template1 directly not created first the database ( then play with it ). So I just want to know is there any way to cleaning up the ...
    Nov 14, 2004 at 3:36 am
    Jan 5, 2005 at 5:42 pm
  • Hi, I'm not sure what the cause of this error is, but I figured I should post it. I had to restore from back to stop getting these errors "ERROR: cache lookup failed for type 813612037" . This was ...
    Michael GuerinMichael Guerin
    Nov 27, 2004 at 5:41 pm
    Nov 27, 2004 at 9:45 pm
  • Hi all, I have not subscribed to this list. However I have registered to the list with another id of mine which is not working right now. I have a table as follows - table TrendData( TrendID ...
    Pradeep KumarPradeep Kumar
    Nov 24, 2004 at 5:31 am
    Nov 27, 2004 at 7:57 am
  • Hello all I have written my own type and a some functions to use in postgres, but i have some problems with the memory allocation. In one of the functions, the stuff that is inserted is supposed to ...
    Kjetil HaalandKjetil Haaland
    Nov 22, 2004 at 1:28 pm
    Nov 24, 2004 at 9:05 am
  • Hi, Can I set my own postgresql session variables? My idea is the following: I have a web based app, working with a postgresql db. The app connects to the postgresql with user db_user. All users of ...
    Raphael BauduinRaphael Bauduin
    Nov 12, 2004 at 10:20 am
    Nov 19, 2004 at 10:21 am
  • I am a novice at both sql and php. I am looking for a tutorial to help me get started. Last year I worked on very simple mysql/php projects for my own interest. I would like to try using postgres. ...
    Steph & MattSteph & Matt
    Nov 6, 2004 at 2:58 am
    Nov 16, 2004 at 7:15 pm
  • Is there an easy way to duplicate a row within a table? -- Jeff Flowers
    Jeff FlowersJeff Flowers
    Nov 25, 2004 at 3:44 pm
    Jan 7, 2005 at 9:02 pm
  • Hi, I'm coming over from the MS sql server world and I've been reading up on sequences. I have a question: I see that you can create an implicit sequence like this: CREATE TABLE test (field ...
    Kevin B.Kevin B.
    Nov 30, 2004 at 4:57 pm
    Nov 30, 2004 at 6:21 pm
  • Hello all Sorry for asking so many question about this topic, but i don't get it to work. The problem is when i allocate memory for char pointers (char*). I have a function that i run many times in ...
    Kjetil HaalandKjetil Haaland
    Nov 26, 2004 at 2:56 pm
    Nov 28, 2004 at 1:32 pm
  • Hi All, We just started to play with the 8.0.0 Beta and can't seem to find the function lower() which we used in our where clauses to lower case text. Can anyone explain where it can be found. Kind ...
    Keith WorthingtonKeith Worthington
    Nov 27, 2004 at 5:25 pm
    Nov 27, 2004 at 6:25 pm
  • Hi all. I have got a database in 7.4.2 version of postgres ....I have taken out the dump of it...I would like to dump it into the previous versions of postgres mainly 7.1.3 and 7.3.2 ....but couldnt ...
    Ravi shankarRavi shankar
    Nov 24, 2004 at 6:41 am
    Nov 24, 2004 at 8:03 am
  • I want to create a date column that contains only the year, such as YYYY. Can this done in PostgreSQL? I didn't see this listed in the handbook and right now, the only way I can see to do would be to ...
    Jeff FlowersJeff Flowers
    Nov 23, 2004 at 1:16 pm
    Nov 23, 2004 at 3:21 pm
  • hello everyone, is there already a built-in function that returns the previous month from the current timestamp? (and includes functionality to turn back one year if current month is january) i don't ...
    Matt Arnilo S. BaluyosMatt Arnilo S. Baluyos
    Nov 17, 2004 at 9:13 am
    Nov 17, 2004 at 3:27 pm
  • Where can I find a document that lists the changes for the 7.4.x dot releases? (I looked on postgresql.org but did not see one.) Thanks, Kevin
    Kevin B.Kevin B.
    Nov 11, 2004 at 8:46 pm
    Nov 11, 2004 at 9:18 pm
  • It's an old rh version I know, so I'm wondering if there'll be problems with installing the latest postgresql server? Thanks, /j-p.
    John-Paul DelaneyJohn-Paul Delaney
    Nov 5, 2004 at 11:09 am
    Nov 5, 2004 at 3:44 pm
  • Hello Is there any way to take a varchar as an input to a c function? I want to take a varchar and a cstring as inputs to a function and then use them as cstrings in my c program. Does anyone know ...
    Kjetil HaalandKjetil Haaland
    Nov 5, 2004 at 11:59 am
    Nov 5, 2004 at 1:42 pm
  • Apologies for a longish message, but I'm no SQL expert and am trying to get my head round some concepts. What I am trying to do is get a set of rows out of a table based on a set of grouping ...
    Nigel MetheringhamNigel Metheringham
    Nov 4, 2004 at 5:34 pm
    Nov 5, 2004 at 11:32 am
  • Hi Group, I am finding an increase in insertion rate with time with steady insertion and updation rate of 70 records per sec with my app using Postgres 7.4.5 on Solaris 5.8. I am using Postgres7.4.5 ...
    Rajan BhideRajan Bhide
    Nov 1, 2004 at 6:28 am
    Nov 1, 2004 at 7:08 am
  • Hi, I have table which has two column ( column a & b ). One of the column has type string..... that is column_a. Assume somebody insert this value to my table: INSERT INTO my_table ( column_a ) ...
    Nov 30, 2004 at 8:11 am
    Nov 30, 2004 at 10:31 am
  • PostgreSQL 7.4.5 Redhat 8 I have a cursor: SELECT lo_export(document,'/tmp/vendBImage.png') AS image, docForeignRecNo AS vendBRecNo FROM document AS document JOIN lookupCodes ON ...
    Steve TucknottSteve Tucknott
    Nov 29, 2004 at 9:10 pm
    Nov 29, 2004 at 10:50 pm
  • Hi All I am currently running PostgreSQL v7.3.6 on Red Hat Linux ES v3 because that is what Red Hat gave me. Can I run PostgreSQL v7.4.6 and/or v8.0.0Beta in parallel? Can anyone give me some ...
    Keith WorthingtonKeith Worthington
    Nov 29, 2004 at 4:14 pm
    Nov 29, 2004 at 4:23 pm
  • iam fed of mails iam getting relating to this subscription i am not getting a way to unsubscribe please help me out in this regards., malini
    Malini buMalini bu
    Nov 28, 2004 at 1:07 pm
    Nov 28, 2004 at 4:20 pm
  • Being completely new to the database arena..... Could someone suggest a front end for accessing a database? While I can beat sql into submission, maybe the other way around, my wife will need ...
    Wayne T. CarnallWayne T. Carnall
    Nov 27, 2004 at 6:52 am
    Nov 27, 2004 at 6:13 pm
  • Hi people, This is not quite a pg question, but any suggestions are most welcome. How can one query a list of values against a db field that contains a list of values ? Table foo foo_id | foo_name | ...
    Aarni RuuhimäkiAarni Ruuhimäki
    Nov 26, 2004 at 1:52 pm
    Nov 26, 2004 at 3:42 pm
  • I am converting data from dBaseIII format trying to load into Postgresql. I am having a problem with DATE field, the file I am working with does not have any data for this field on some records. I ...
    Fred WohlfertFred Wohlfert
    Nov 23, 2004 at 9:36 pm
    Nov 26, 2004 at 2:53 pm
  • Hi, I've installed the new Postgresql 8 Beta 5 on my webserver but I can't create or access a database. When I just type pgsql in the Linux bash I'll get the following error: psql: FATAL: database ...
    Alexander JochumAlexander Jochum
    Nov 26, 2004 at 1:08 pm
    Nov 26, 2004 at 1:18 pm
  • Hi All, Is there a difference between the usages of NOT NULL and < NULL?? Do the following in anyway affect the use of index scan? 1) use of NOT NULL 2) use of now() instead of the actual date ...
    Sarlav kumarSarlav kumar
    Nov 23, 2004 at 8:52 pm
    Nov 23, 2004 at 9:59 pm
  • I am trying to compile contrib/xml2 under version 7.3.2, and receive the following error message: xpath.c:659: error: `work_mem' undeclared (first use in this function) xpath.c:659: error: (Each ...
    George WeaverGeorge Weaver
    Nov 22, 2004 at 7:50 pm
    Nov 23, 2004 at 4:17 pm
  • I compiled Postgresql 7.4.6 on OSX 10.3.6 into /Volumes/Apps/pgsql then I compiled readline, proj4, and geos-2.1.0 into /usr/local. Now I am trying to compile contrib/postgis-0.9.0 and I am getting ...
    Nov 22, 2004 at 8:13 pm
    Nov 22, 2004 at 9:18 pm
  • Dear All I have Develop Web Apllication On PHP and Postgresql. Now my server is working ok. but some time it speed problem. My server have innuff Configuration mean PIV IBM Server with 1 GB RAM . Now ...
    Ramesh PatelRamesh Patel
    Nov 22, 2004 at 6:30 am
    Nov 22, 2004 at 10:09 am
  • Two things... I'm looking for the syntax to get a trigger function written in PL/pgSQL to write to a text file. I want to be able to append to the file and not open as new each time I write to it. ...
    Claire McGovernClaire McGovern
    Nov 16, 2004 at 10:32 am
    Nov 21, 2004 at 6:03 pm
  • I would like to create an index on table ecn_sales, based on the day of year value of a timestamp column tv_time. However, I'm getting an error: CREATE INDEX ecn_sales_index_day on ecn_sales ...
    Matthew EngelbertMatthew Engelbert
    Nov 19, 2004 at 10:12 pm
    Nov 20, 2004 at 1:19 am
  • Hi I need to setup a multihomed box with 2 ethernet cards, and i wonder how i can choose the network on which posgresql will run. Thanks for help Alex
    Nov 18, 2004 at 6:20 pm
    Nov 18, 2004 at 6:45 pm
  • PostGreSQL 7.4.5 (RedHat 8) We have images stored in the database, that our application allows the user to export (using lo_export), update, and then reimport. How do I get around the permissions ...
    Steve TucknottSteve Tucknott
    Nov 18, 2004 at 5:43 pm
    Nov 18, 2004 at 6:40 pm
Group Navigation
period‹ prev | Nov 2004 | next ›
Group Overview
grouppgsql-novice @

95 users for November 2004

Tom Lane: 34 posts Kjetil Haaland: 18 posts Michael Fuhr: 15 posts Bruno Wolff III: 10 posts Sarlav kumar: 10 posts Terry Lee Tucker: 10 posts Jeff Flowers: 8 posts John-Paul Delaney: 8 posts Raphael Bauduin: 8 posts Vishal Kashyap @ [Sai Hertz And Control Systems]: 8 posts Joe Conway: 6 posts Kumar S: 6 posts Marcin Gil: 6 posts M. Bastin: 6 posts Sean Davis: 6 posts Aarni Ruuhimäki: 4 posts Akbar: 3 posts Betsy Barker: 3 posts Bruce Momjian: 3 posts Evert Meulie: 3 posts
show more