FAQ

PostgreSQL > pgsql-novice > April 2005

Search Discussions

117 discussions - 383 posts

  • Hi all! When I want to use "copy" to move data in .csv, which has been formatted to tab-formatted file, to my postgresql as follow (DB name: test, tablename: hsi): copy hsi from 'c:\java\hsi.txt' it ...
    Leung Wing Lap ElleryLeung Wing Lap Ellery
    Apr 13, 2005 at 2:29 pm
    Apr 14, 2005 at 7:51 pm
  • Hi All, I am working on a view that needs to join a table that holds lookup information. It is a fairly simple id vs name relationship. How can I get the different names I am looking for? Below is ...
    Keith WorthingtonKeith Worthington
    Apr 6, 2005 at 8:06 pm
    Apr 14, 2005 at 6:27 pm
  • This may be another elementary question - I found some hints in the archives that may have answered my question, but not sure.. I'm designing a database to maintain business records. I'd like to get ...
    DavidDavid
    Apr 8, 2005 at 4:31 am
    Apr 9, 2005 at 3:48 am
  • Hi All, I need to add an audit trail to my application. I thought that I would add the user id and timestamp to the tables where I need to track 'last modified by...'. Currently there is a table ...
    Keith WorthingtonKeith Worthington
    Apr 25, 2005 at 2:41 pm
    Apr 26, 2005 at 3:32 pm
  • Hi all, I've just noticed an interesting behaviour with PGSQL. My software is made up of few different modules that interact through PGSQL database. Almost every query they do is an individual ...
    Slavisa GaricSlavisa Garic
    Apr 13, 2005 at 2:29 am
    Apr 14, 2005 at 1:15 am
  • I'm resending as I didn't get any response earlier.
    Walker, Jed SWalker, Jed S
    Apr 5, 2005 at 6:53 pm
    Apr 6, 2005 at 2:14 pm
  • Is it possible to INSERT data into a table using a rowtype data type? I have a long (~5000 byte, 300 field) record *which I did not design* that needs to be loaded into a table. In my plsql function ...
    Greg LindstromGreg Lindstrom
    Apr 27, 2005 at 4:19 pm
    Apr 27, 2005 at 6:36 pm
  • Hi All, I found this in the documentation. http://www.postgresql.org/docs/8.0/interactive/datatype-character.html The type "char" (note the quotes) is different from char(1)in that it only uses one ...
    Keith WorthingtonKeith Worthington
    Apr 26, 2005 at 2:53 am
    Apr 27, 2005 at 3:59 pm
  • Hi, I have a sequence seq_page owned by user vrnsys. Vrnsys has granted "select" on seq_page to group vrn_admin. vrn_admin group has had user vrngui added to it, but vrngui is not able to access the ...
    Walker, Jed SWalker, Jed S
    Apr 21, 2005 at 11:17 pm
    Apr 22, 2005 at 4:47 pm
  • Hi All...... I'm writing a php web application which sells mp3 music for production use (a rather limited audience, as opposed to a general mp3 download site). Since I've heard large objects were a ...
    BrewBrew
    Apr 18, 2005 at 6:09 am
    Apr 19, 2005 at 12:44 am
  • can anyone provide a general primjer on pgsql encoding? i think i set my db up as ascii encoded. is this optimal for an english language db? my online host wants to default to latin1... which seems ...
    Operationsengineer1Operationsengineer1
    Apr 3, 2005 at 8:47 pm
    Apr 16, 2005 at 4:58 pm
  • hi, im working with php 4 and postgresql 8 and in my php script id like to create a temp table on my database server. how do i do this? how do i verify it was created? i tried the following: $sql = ...
    CimaCima
    Apr 28, 2005 at 1:51 am
    Apr 28, 2005 at 2:55 pm
  • I need record changing history. Of course I need to keep old records, and some how point to it for show changes. First of my idea is to make a single column in every record pointing to his "parent" ...
    TövisTövis
    Apr 18, 2005 at 7:08 pm
    Apr 20, 2005 at 9:49 pm
  • I'm trying to remove duplicate records from a table. The best way I could think of was to select into a new table using DISTINCT. I issued the following command: select distinct on (symbol, date) * ...
    Gerry JensenGerry Jensen
    Apr 14, 2005 at 9:26 am
    Apr 14, 2005 at 5:41 pm
  • Hi, I'm trying to force the precision on an interval so that I can store hours and minutes and then when I do a select just see the hours and minutes. i.e.: 01:00 instead of 01:00:00 is the possible ...
    Jake StrideJake Stride
    Apr 8, 2005 at 6:52 pm
    Apr 8, 2005 at 9:14 pm
  • (Sorry if this appears twice - I sent the previous mail as the wrong mail ID) PostgreSQL 7.4.5 Is there a way of using %ROWTYPE in custom types? I want to return two/three complete record areas to a ...
    Steve TucknottSteve Tucknott
    Apr 3, 2005 at 1:14 pm
    Apr 8, 2005 at 8:35 am
  • Hi, I posted a message yesterday about creating a custom datatype where I store an array of custom strucs. Well I finished implementing it today, but I can not get it to work within postgres. I have ...
    Morgan KitaMorgan Kita
    Apr 2, 2005 at 3:45 am
    Apr 5, 2005 at 1:48 am
  • Hi All, I can not think of a way to copy data directly betweeen two tables. I can only think of two ways to copy the data indirectly. Method 1: Write a function that loops through the results of a ...
    Keith WorthingtonKeith Worthington
    Apr 27, 2005 at 1:16 pm
    Apr 28, 2005 at 3:21 am
  • hi, im handling some important information that needs to be stored in my postgresql database via a php script. i´ve been reading the mails sent on this mailing list on SSL use. my postgresql server ...
    Ruel.cimaRuel.cima
    Apr 22, 2005 at 8:35 pm
    Apr 23, 2005 at 5:19 pm
  • I have a client authentication problem I need help with. I have the postgresql.conf listen_addresses='*' and in pg_hba.conf I have host VRNJED all 2.30.0.0 255.255.0.0 md5 (I've also tried the ...
    Walker, Jed SWalker, Jed S
    Apr 18, 2005 at 6:07 pm
    Apr 18, 2005 at 8:23 pm
  • hi , someone has drawn my attention to the fact that oids may not be such a good idea to set as a primary key in a table. i have designed a relativley large database and defined oids as primary keys. ...
    CimaCima
    Apr 15, 2005 at 3:48 pm
    Apr 15, 2005 at 7:27 pm
  • I have several tables that require auto-generated Ids. I have noticed the serial and bigserial data types (or pseudo-types). These seem like they make things much simpler, but if you use this, how ...
    Walker, Jed SWalker, Jed S
    Apr 13, 2005 at 3:30 pm
    Apr 14, 2005 at 7:46 pm
  • Hi, I am having trouble with binding values to SQL statements using dbi perl. The scenerio is as follows : I have a scheduling database that holds the listings of classes and there schedules for a ...
    DeepbluesDeepblues
    Apr 6, 2005 at 4:43 pm
    Apr 8, 2005 at 4:00 am
  • Hi all, I'm endeavouring to build postgresql from source (something with which I have no experience). I can configure, make and make install and all runs fine but when I try to run initdb it fails ...
    Kim KohenKim Kohen
    Apr 5, 2005 at 5:46 am
    Apr 5, 2005 at 7:46 am
  • Hi: Thanks in part to your help, I've now got a few simple queries and forms running on my website, using PHP and PEAR to talk to Postgres. :-) In one case, I've set up a form where users can provide ...
    Rodolfo J. PaizRodolfo J. Paiz
    Apr 4, 2005 at 5:15 am
    Apr 4, 2005 at 1:51 pm
  • Ok I am creating some important custom data types for my DB. The data should be stored as an array of strucs, which themselves contain a few different data fields. Anyways I wrote the input function ...
    Morgan KitaMorgan Kita
    Apr 1, 2005 at 3:45 am
    Apr 1, 2005 at 10:27 pm
  • Hi! At the moment I'm trying to create an own datatype "timeseries", which should contain among others an array of float8 values. As far as I know, float8 is a base type of postgres and therefore I ...
    Jessica DittJessica Ditt
    Apr 28, 2005 at 12:11 pm
    May 2, 2005 at 5:43 pm
  • Hi All, I have created a function that extracts three parts of a string using plperl. Now I want to use those parts in a view and I don't even know where to start. My first feeble attempt looked like ...
    Keith WorthingtonKeith Worthington
    Apr 28, 2005 at 6:59 pm
    Apr 29, 2005 at 2:49 pm
  • Will this command APPEND TO or REPLACE data in an existing table ? The documentation doesn't seem to indicate.
    Van Ingen, LaneVan Ingen, Lane
    Apr 27, 2005 at 2:44 pm
    Apr 27, 2005 at 3:19 pm
  • unsubscribe
    SqlpythonSqlpython
    Apr 13, 2005 at 3:03 pm
    Apr 24, 2005 at 11:08 pm
  • Hi all, the 8.0 manual says CHECK can be used in the following manner: CHECK (expression) The only stipulations are that it must produce a boolean result (true or unknown) to succeed. If I were to ...
    Van Ingen, LaneVan Ingen, Lane
    Apr 22, 2005 at 4:02 pm
    Apr 22, 2005 at 5:00 pm
  • Hi all, I am a new addition to this mailing list. I am using Postgresql 7.4.3. I went through the postgresql documentation for saving the disk usage. Accordingly i changed the checkpoint_segments ...
    PrashantPrashant
    Apr 20, 2005 at 7:06 am
    Apr 22, 2005 at 1:27 pm
  • Dear people, How do I use the copy command to copy a whole database onto a system file so that i can use the createdb with the -T flag to re-create the database on another system ? I have been ...
    Low Kian SeongLow Kian Seong
    Apr 19, 2005 at 5:16 am
    Apr 19, 2005 at 1:11 pm
  • Greetings - I have installed Fedora Core 3 on a P2-450 at home. I included all the PostgreSQL packages available on the CD's. And I've successfully set up a personal database to start playing around ...
    Anthony MullenAnthony Mullen
    Apr 13, 2005 at 4:57 pm
    Apr 13, 2005 at 5:16 pm
  • Hi, Suppose I have a table (called temp) like this: gp val A 10 A 8 A 6 A 4 B 3 B 2 B 1 B 0 How can I get the largest two values for each group in a single pass? I want to end up with: gp val A 10 A ...
    David OrmeDavid Orme
    Apr 12, 2005 at 11:22 am
    Apr 13, 2005 at 12:26 pm
  • Hi! I'm within a hair of getting my first join to work, but something is wrong and for the life of me I can't figure out why. Hints, anyone? ...
    Rodolfo J. PaizRodolfo J. Paiz
    Apr 9, 2005 at 8:49 pm
    Apr 10, 2005 at 12:54 am
  • hi, i dont remember if someone already asked this but here goes. i have a users table in my database that i will use to control the access of information on my site. its really simple, i have the ...
    CimaCima
    Apr 6, 2005 at 5:46 am
    Apr 6, 2005 at 12:36 pm
  • Hello, When I try to connect as following, I get an error in Carp.pm: use DBI; # connecting to database my $username = 'marc'; my $password = 'marc'; $dbh = DBI- connect("DBI:Pg:dbname=my_db", ...
    Marc MaminMarc Mamin
    Apr 28, 2005 at 2:53 pm
    May 6, 2005 at 3:59 pm
  • CREATE TEMP table stupid ( datestock date, dummy int ); INSERT INTO stupid VALUES( '2005-4-1', 3 ); INSERT INTO stupid VALUES( '2005-5-1', 3 ); INSERT INTO stupid VALUES( '2005-5-4', 3 ); INSERT INTO ...
    AkbarAkbar
    Apr 27, 2005 at 4:13 pm
    May 3, 2005 at 2:29 pm
  • hi, i understand that the oids are descouraged as primary keys becuase of possible duplication and possble lack of uniqueness. what has me worried now is that i'm storing files in my database and ...
    CimaCima
    Apr 15, 2005 at 7:01 pm
    Apr 28, 2005 at 10:52 am
  • I'm trying to install SQL-Ledger on a Mandrake 10.0 box, but I get the following error [root@localhost sql-ledger]# su postgres [postgres@localhost sql-ledger]$ createuser Enter name of user to add: ...
    Roland GieslerRoland Giesler
    Apr 27, 2005 at 5:29 pm
    Apr 27, 2005 at 9:15 pm
  • I have a problem linking my cgi script to the perl function. I have perl functions to perform manipulations to the database. I am creating a web front end to it. I have a html form which accepts data ...
    DeepbluesDeepblues
    Apr 26, 2005 at 1:25 pm
    Apr 26, 2005 at 2:08 pm
  • I know that you can pass rows/records to a function but what about a few rows? Is that possible? For example, I'd like to send to a function a number of rows from the "workers" table (e.g "select * ...
    Vitaly BelmanVitaly Belman
    Apr 24, 2005 at 12:00 am
    Apr 24, 2005 at 8:49 am
  • I wish to migrate from ms sql server to postgresql... an application (windows executable) not developed by me then no sources. We buyed for a lot of money so we must run it on windows clients. All ...
    Bruno DeperoBruno Depero
    Apr 19, 2005 at 3:35 pm
    Apr 23, 2005 at 3:08 pm
  • Hi, I have another question. It appears that when you create a procedure and grant access on it to another user, the user must have privileges to all objects that the procedure references. Can ...
    Walker, Jed SWalker, Jed S
    Apr 22, 2005 at 2:23 pm
    Apr 22, 2005 at 4:11 pm
  • hi, this may not be the best place to ask but since i assume that a considerable number of users in this mailing list use some form of linux, id like to some help on the following: i have windowsxp ...
    CimaCima
    Apr 20, 2005 at 9:02 pm
    Apr 21, 2005 at 11:00 am
  • Dear all, I installed PostgreSQL on my windows xp and on my windows 2000 system using the postgresql-9.0.msi. I completed the installation procedure and now I want to start creating a database. I ...
    Danny GaethofsDanny Gaethofs
    Apr 18, 2005 at 12:53 pm
    Apr 19, 2005 at 1:06 pm
  • I have been using Oracle for years, but have just started with PostgreSQL. I've downloaded & installed the software (v8.0.2), and I'm slowing reading my way through the manual. Is there any sort of ...
    S SS S
    Apr 18, 2005 at 3:11 pm
    Apr 18, 2005 at 3:45 pm
  • PostrgreSQL 7.4.5 Stupid question - how do you see triggers? I have created various triggers but I can't see how to list them (I think I've seen them somewhere before but can't think where). Is the ...
    Steve TucknottSteve Tucknott
    Apr 17, 2005 at 1:15 pm
    Apr 17, 2005 at 2:10 pm
  • Hello all, PG 8.0.1 Mandrake 10.1 Uniqueidentifier 0.2 type and function instatlled (see http://gborg.postgresql.org/project/uniqueidentifier/projdisplay.php) I have a very simple funtion designed to ...
    T- BoneT- Bone
    Apr 6, 2005 at 7:34 pm
    Apr 15, 2005 at 9:06 pm
Apr 2005
123
Group Navigation
period‹ prev | Apr 2005 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions117
posts383
users108
websitepostgresql.org
irc#postgresql

108 users for April 2005

Tom Lane: 45 posts Michael Fuhr: 39 posts Keith Worthington: 30 posts Walker, Jed S: 15 posts John DeSoi: 13 posts Bruno Wolff III: 12 posts Sean Davis: 12 posts Brew: 10 posts Ruel.cima: 9 posts Tövis: 9 posts Bob Henkel: 8 posts Steve Tucknott: 8 posts Operationsengineer1: 7 posts Ennio-Sr: 5 posts Frank Bax: 5 posts Morgan Kita: 5 posts Rodolfo J. Paiz: 5 posts Aarni Ruuhimäki: 4 posts Bruce Momjian: 4 posts David: 4 posts
show more
Archives