FAQ

PostgreSQL > pgsql-novice > December 2003

Search Discussions

75 discussions - 240 posts

  • Hello, everyone. I am VERY new, as in simply researching possibilities, to SQL Servers in any shape or form. However, I do have a question: on the PostgreSQL website (About Us Advantages) it ...
    Amy YoungAmy Young
    Dec 9, 2003 at 8:08 pm
    Dec 12, 2003 at 4:41 pm
  • Maybe this sounds stupid, but, where is the actual database file? I'm sure there's a file that is the actual DB, but what/where? --Bryan
    Bryan IrvineBryan Irvine
    Dec 26, 2003 at 6:08 pm
    Jan 1, 2004 at 11:10 pm
  • Hi, I have a view that I want to make updateble, at least kind of. What should happen on update (trying to implement in one rule): - - make the original record invisible in the view by changing the ...
    Thiemo KellnerThiemo Kellner
    Dec 26, 2003 at 5:59 pm
    Feb 2, 2004 at 7:00 pm
  • Hi!... Normally, there is only one attribute for the primary key but in my table, my primary key is composed of two attributes. How do I state this in SQL? What if Region_num and Num_Players, ...
    Peggy GoPeggy Go
    Dec 29, 2003 at 4:22 am
    Dec 29, 2003 at 5:52 pm
  • Same problem I reported earlier. I have a column declared as PK but PostgreSQL 7.4 allowed it to create entries with the same key.. Schemas, database dump available at: http://www.vernet.pl/sql/ All ...
    Marcin GilMarcin Gil
    Dec 23, 2003 at 2:31 pm
    Dec 23, 2003 at 4:30 pm
  • I would like to be able to deny client applications access to tables, and insulate the database through an api of functions. Updater, inserter and deleter functions look to be easy enough, but I am ...
    Gerard MasonGerard Mason
    Dec 16, 2003 at 2:19 pm
    Dec 17, 2003 at 1:31 am
  • I am getting a field of date type from PostgreSQL and an integer that is a number of days (1 to 3). select date, num_days from table $date, $num_days In my perl script I am getting the current date ...
    HodgesHodges
    Dec 3, 2003 at 7:04 pm
    Dec 14, 2003 at 8:16 pm
  • Hi everybody, forgive me if this is covered in an FAQ or something, I just haven't been able to find it. This question might not even belong on this list and I apologize if that's the case. I was ...
    Andrew KellyAndrew Kelly
    Dec 8, 2003 at 1:50 pm
    Dec 14, 2003 at 7:46 pm
  • Hi, as the subject says - if I do the same interactively in the interpreter, it works. I tried plsql < x.sql and plsql -f x.sql, both fail with this code: create function myfunc(text) RETURNS text AS ...
    Wolfgang RohdewaldWolfgang Rohdewald
    Dec 3, 2003 at 9:53 am
    Jan 5, 2004 at 5:42 am
  • Friends In my machine none of the header files coming with postgresql are present. So if u have the header files libpgeasy.h and libpg-fe.h please send me. thanks
    Manu M PManu M P
    Dec 15, 2003 at 8:16 am
    Dec 16, 2003 at 5:55 am
  • Hi! Using PHP, Pear::DB i managed to put duplicate entries on a primary key column. My PostgreSQL version is 7.4 self compiled, running on Slackware 9.1. Doesn't PK implicate Unique in new version? ...
    Marcin GilMarcin Gil
    Dec 8, 2003 at 12:42 pm
    Dec 16, 2003 at 8:44 am
  • I am migrating an application over from mysql to postgresql and am a little confused on how to write the following query in PostgreSQL. The date functions and syntax is a world apart from MySQL and ...
    Alan T. MillerAlan T. Miller
    Dec 11, 2003 at 8:48 am
    Dec 11, 2003 at 8:17 pm
  • Friends The man page of createuser shows that only superusers can create users with "createuser". How can i make an ordinary user a super user? Manu
    Manu M PManu M P
    Dec 11, 2003 at 3:32 am
    Dec 11, 2003 at 9:49 am
  • Hi all, congratulations to the new release, I couldn't try it yet, but the release notes are promising. However there is one thing that needs a bit more explanation: 1) Inner joins using the explicit ...
    Nabil SayeghNabil Sayegh
    Dec 1, 2003 at 1:37 pm
    Dec 1, 2003 at 3:54 pm
  • Is there a way to issue select .. like to ignore letter case? Or do I have to use full text indexing? Regards, -- Marcin Gil marcin.gil @ audax.com.pl, tel. 694972082 OIS Audax Sp. z o.o., ul. ...
    Marcin GilMarcin Gil
    Dec 19, 2003 at 8:53 am
    Dec 19, 2003 at 10:00 am
  • Hi all Running postgres under RedHat9, I moved the /tmp partition to / and copied the /usr into a much larger one in order to get more disk space for programs . Hope I did not loose any file. One of ...
    Patrice DurosayPatrice Durosay
    Dec 18, 2003 at 5:58 pm
    Dec 19, 2003 at 9:24 am
  • Good morning, This may well be a daft question, but I'm confused and I can't find anything referring to this in the PostgreSQL or DBI books, bear with me, I'm new. I have one table containing a ...
    Mace, RichardMace, Richard
    Dec 18, 2003 at 8:45 am
    Dec 18, 2003 at 3:05 pm
  • I am trying to convert a driver for dspam from mysql to postgres. In the files I have they are useing mysql.h. Is there a similar library for postgres? If so what is it and is there any documentation ...
    ChrisChris
    Dec 17, 2003 at 8:25 pm
    Dec 17, 2003 at 9:33 pm
  • How can I modify a table OID? I deleted and recreated a table and now when I try to run my reports (with Cognos Impromptu) it says: How can I solve this? Thanks in advance. Josep Sànchez [papapep]
    PapapepPapapep
    Dec 15, 2003 at 11:33 am
    Dec 15, 2003 at 6:18 pm
  • Dear All, Forgive me if this is a silly question, but I need some advice. I'm setting up a db where users will be able to insert, update, select. I will have three types of users. Lowest can do very ...
    C GC G
    Dec 5, 2003 at 10:46 am
    Dec 6, 2003 at 2:41 am
  • Hi, I have installed pgencrypot so I think... I ran make checkinstall I got: ============== installing PL/pgSQL ============== ============== running regression test queries ============== test init ...
    David HDavid H
    Dec 5, 2003 at 5:11 am
    Dec 5, 2003 at 6:51 am
  • Is there a PostgreSQL equivalent command to the mysql_field_name command above? I am running a select query (7.2) and would like to get the name of the columns I am selecting too, in order to output ...
    Mace, RichardMace, Richard
    Dec 31, 2003 at 12:08 pm
    Dec 31, 2003 at 11:26 pm
  • I'm using PostgreSQL 7.4, and I have two tables, which I created as follows: CREATE TABLE needlestyle ( needle_style_id SERIAL, needle_style_desc varchar(50) NULL, needle_style_lud timestamp NULL, ...
    Lola LeeLola Lee
    Dec 27, 2003 at 12:54 am
    Dec 27, 2003 at 12:04 pm
  • Hi, I'm trying to create a time format string for strptime (GNU, FWIW) that will parse an unmodifed timestamptz string. No luck with Google yet. In other words how to parse, e.g. "2003-12-26 ...
    Paul MakepeacePaul Makepeace
    Dec 26, 2003 at 3:53 am
    Dec 26, 2003 at 4:19 pm
  • Dear All, I was just looking for a nice in depth tutorial for JOINS would be greatefull if anyone of you pass me on some links in said regards. Regards, Vishal Kashyap
    Sai Hertz And Control SystemsSai Hertz And Control Systems
    Dec 23, 2003 at 2:03 pm
    Dec 24, 2003 at 8:24 am
  • Is there any magic sequence of quotes or backslashes that will get the following (simplified version) to do the obvious thing? CREATE FUNCTION doesnt_work(integer) RETURNS date LANGUAGE SQL AS ...
    AndrewAndrew
    Dec 22, 2003 at 7:14 pm
    Dec 23, 2003 at 12:23 am
  • Hi! Im just new to pgsql. I'm trying to use pqxx since the program that I'll be doing is in C++. I'm using Redhat Linux 9.0 and using KDevelop for programming. What do I need to do in order to get ...
    Peggy GoPeggy Go
    Dec 17, 2003 at 6:29 pm
    Dec 18, 2003 at 5:47 am
  • Hi, could somebody tell me what I'm missing here? Postgres appears to not know where to look for the table I am using in my SELECT INTO clause because the error says it is coming before the FROM ...
    Joseph speigleJoseph speigle
    Dec 17, 2003 at 10:25 am
    Dec 17, 2003 at 5:54 pm
  • I cant seem to find an answer to this in the archives... I'm hoping someone has come across this problem before. Beware this is a long email... Ive got 2 servers one used for development and one used ...
    Cody PhanekhamCody Phanekham
    Dec 11, 2003 at 6:00 am
    Dec 12, 2003 at 12:09 am
  • Friends Is there any way to list all the data bases available in a host? Also is there any way to list the users in the system? thanks
    Manu M PManu M P
    Dec 11, 2003 at 11:25 am
    Dec 11, 2003 at 11:59 am
  • Hi all, This is my first attempt at transactions, and I seem to be missing something. Briefly, the transaction is this BEGIN; UPDATE table A; UPDATE table B; COMMIT; I find that the update to table A ...
    Richard LoughRichard Lough
    Dec 3, 2003 at 12:17 pm
    Dec 10, 2003 at 8:21 pm
  • Hi all, new to postgresql and I have a question about how to lay out my database. I have a database with 4 main tables, organizations, contacts, events, grants. My thinking here is that organizations ...
    Taylor LewickTaylor Lewick
    Dec 3, 2003 at 2:42 am
    Dec 10, 2003 at 8:10 pm
  • Hi all, I use Interbase (starting on PostgreSQL) which has a concept of CREATE TABLE My_Table ( First_Name VARCHAR(15), Last_Name VARCHAR(15), Full_Name VARCHAR(30) COMPUTED BY(First_Name || ' ' || ...
    Paul GanainmPaul Ganainm
    Dec 6, 2003 at 10:08 am
    Dec 8, 2003 at 8:21 am
  • Is there a SQL command to delete everything (including the tables) from a db? Not a complete drop so that the db doesn't exist anymore, but just so that there's nothing in it. --Bryan
    Bryan IrvineBryan Irvine
    Dec 6, 2003 at 1:04 am
    Dec 7, 2003 at 12:54 am
  • Tom Much-delayed thanks for pointing me to directions on how to handle multiple installations. Tom Lane posted: I just got my new machine and found these hints very useful in installing PostgreSQL. ...
    Michael GlaesemannMichael Glaesemann
    Dec 24, 2003 at 1:46 pm
    Dec 24, 2003 at 1:52 pm
  • Hello to the whole list, is possible to save a file (PDF) in the database as blob object? Which kind of field should I use to achieve this? Thanks, Luca -- Luca Ferrari, fluca1978@virgilio.it
    Luca FerrariLuca Ferrari
    Dec 23, 2003 at 5:32 pm
    Dec 23, 2003 at 6:54 pm
  • Hi There: I am brand new to PostgreSQL and currently living in India. I would like to download latest version of PostgreSQL. Could you please let me know the step by step procedure to do this. I have ...
    DarbinjDarbinj
    Dec 22, 2003 at 11:25 am
    Dec 23, 2003 at 8:29 am
  • Here are the sample tables for my question. CREATE TABLE bar ( id int2 PRIMARY KEY UNIQUE DEFAULT nextval('bar_id_seq'), ... ); CREATE TABLE foo ( id int2 PRIMARY KEY UNIQUE DEFAULT ...
    Matthew RudolphMatthew Rudolph
    Dec 19, 2003 at 12:45 am
    Dec 22, 2003 at 10:28 pm
  • Hi, I'm attempting to build a table within a pl/pgsql function that is to be populated so that it has an index column 1...N. (without looping). I used to do this in sybase and found it extremely ...
    Stephen ShorrockStephen Shorrock
    Dec 15, 2003 at 6:25 pm
    Dec 22, 2003 at 10:09 pm
  • Is there a table that contains info about the data/index files of a postgresql db, such as filename, bytesize, etc?? I'm looking for something similar to oracle's DBA_DATA_FILES view... Thanks, -- ...
    ChrisChris
    Dec 17, 2003 at 12:00 pm
    Dec 22, 2003 at 9:15 pm
  • I was wondering if postgres generates any logs. If so where are they. Or does it have to be told to make them. If this is the case what do i have to do to do that.
    ChrisChris
    Dec 22, 2003 at 6:03 pm
    Dec 22, 2003 at 6:17 pm
  • Hi, Is their equivalent to SQL Servers xp_cmdshell that can be called in plpsql or plperl function? Michael Godshall GMAC Global Relocation <http://www.gmacglobalrelocation.com/ Services 900 So. ...
    Godshall MichaelGodshall Michael
    Dec 19, 2003 at 10:13 pm
    Dec 20, 2003 at 4:10 am
  • Hi, I recently got a dedicated server at Rackspace.com that came with PostgreSQL server version 7.1.3 installed. I am installing a script that requires PostgreSQL v 7.2 or greater so I decided to ...
    Sergio L. Garza M.Sergio L. Garza M.
    Dec 19, 2003 at 8:23 am
    Dec 19, 2003 at 3:27 pm
  • Hi there- I'm new to pgsql, but would like to use if form my next project. Has anyone successfully install pgsql on a HP-UX machine? I have yet to try to install it, I just wanted to see what others ...
    Ryan KingRyan King
    Dec 14, 2003 at 8:37 pm
    Dec 14, 2003 at 11:50 pm
  • Friends I created a superuser "user1" and given permissions to create users and data bases. I then tried to connect the user to the data base "test" using the psql meta command "\c test user1" . The ...
    Manu M PManu M P
    Dec 12, 2003 at 5:44 am
    Dec 13, 2003 at 7:18 am
  • Hi I have installed RH9.0 with postgresql. When I try to log on using su - postgres it wants a password? I thought "postgres" was the default user that is used for the initial logon before any other ...
    Robert MorganRobert Morgan
    Dec 10, 2003 at 4:36 am
    Dec 10, 2003 at 4:49 am
  • I have a 7.3.4 db that is now around 7 gig in size. Are there any issues with backups and restores on SunOS 5.9? My dumps never seem to be quite right. I'm using 'pg_dump -v -Fc dvm dvm.bak'. It just ...
    Stephen ClancyStephen Clancy
    Dec 5, 2003 at 8:48 pm
    Dec 6, 2003 at 4:08 am
  • Has anyone developed PostgreSQL versions of the Oracle date functions? I'm especially interested in ports of ADD_MONTHS and NEXT_DAY, or hints on replicating them in PostgreSQL. Thanks. -- David ...
    David RickardDavid Rickard
    Dec 4, 2003 at 8:01 pm
    Dec 5, 2003 at 7:16 pm
  • Hy I am new in postgre. I would like to import tables from DBase to PostgreSql 7.3.2 . Please help me. Joe Download Yahoo! Messenger now for a chance to win Live At Knebworth DVDs ...
    Mester JózsefMester József
    Dec 3, 2003 at 9:44 am
    Dec 4, 2003 at 11:55 pm
  • My name is John Tankersley. I am sending this email to ask for assistance with parser error message. I am learning to code in postgresql on my system. I am using SuSE linux distribution. Postgresql ...
    John tankersleyJohn tankersley
    Dec 1, 2003 at 1:09 pm
    Dec 1, 2003 at 1:47 pm
Dec 2003
12
Group Navigation
period‹ prev | Dec 2003 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions75
posts240
users95
websitepostgresql.org
irc#postgresql

95 users for December 2003

Tom Lane: 31 posts Marcin Gil: 12 posts Manu M P: 9 posts SaiHertz And Control Systems: 9 posts Bruce Momjian: 8 posts Joseph speigle: 7 posts Bret Busby: 6 posts Bruno Wolff III: 6 posts Gerard Mason: 6 posts Oliver Elphick: 6 posts Thiemo Kellner: 5 posts Hodges: 4 posts Greg Sabino Mullane: 4 posts Michael Glaesemann: 4 posts Amy Young: 3 posts Andrew Kelly: 3 posts Bruno LEVEQUE: 3 posts Casey Allen Shobe: 3 posts Chris: 3 posts Joe Conway: 3 posts
show more
Archives