Search Discussions

38 discussions - 110 posts

  • Hi there, I think that this may be my first post to this list so be gentle. I'm having a very strange problem (to me) and I hope that someone can shed some light on what I'm not seeing. I created a ...
    Brant FitzsimmonsBrant Fitzsimmons
    Jan 17, 2007 at 6:49 am
    Jan 17, 2007 at 3:53 pm
  • Another DST related problem in pgsql 8.1.5 ... drop table dst; create table dst (tz1 timestamp with time zone, tz2 timestamp with time zone, tzage interval); insert into dst ( select ...
    Frank BaxFrank Bax
    Jan 1, 2007 at 8:01 pm
    Jan 4, 2007 at 3:02 pm
  • I'm sorry if this has been answered before, but I've searched through the archives and haven't found anything. I have a machine that was built about two years ago and runs Debian. I just built a new ...
    Howard EglowsteinHoward Eglowstein
    Jan 12, 2007 at 11:30 pm
    Jan 13, 2007 at 2:25 pm
  • Greetings, I have been asked by a programmer to restore a single table from a PG_DUMPALL backup. Is this possible, and if so, would anyone be able to tell me please, what PSQL options and switches ...
    Jim StalewskiJim Stalewski
    Jan 22, 2007 at 11:06 pm
    Jan 26, 2007 at 5:58 am
  • Hi, this is probably an SQL question instead of PostgreSQL but here it goes. I have a table containing phone destinations and pricing as follows: prefix | cost | timeframe | provider ...
    Ron ArtsRon Arts
    Jan 17, 2007 at 10:53 pm
    Jan 18, 2007 at 11:26 am
  • guys, i have a table which contains 5 fields, of these 2 fields need to be filled in through an inner join from one same table. now i have managed to fill in one field using the inner join method. ...
    Peter DawnPeter Dawn
    Jan 29, 2007 at 6:12 am
    Feb 6, 2007 at 6:50 pm
  • Hi all, a little doubt that came into my mind reading the official manual (chapter 37, page 677): "functions and trigger procedures are always executed within a transaction established by an outer ...
    Luca FerrariLuca Ferrari
    Jan 26, 2007 at 7:39 am
    Jan 27, 2007 at 5:21 pm
  • Hello, I am running Postgres 8.0 on a Gento Box and would like to access the information about the tables in my database. How do I access the column names, data types, comments, etc? Thanks, --greg ...
    Greg LindstromGreg Lindstrom
    Jan 25, 2007 at 2:49 pm
    Jan 25, 2007 at 3:10 pm
  • Hi all :) Is it possible to fetch data from another database than the current? I have stored procedure in DB_1 and I would like do INSERT to table in DB_2. Is it possible? If yes, ho to do it? Thanks ...
    Robert RakRobert Rak
    Jan 8, 2007 at 11:58 am
    Jan 8, 2007 at 12:51 pm
  • I am using Postgre DB 8.1.5. I am using another machine on the same network to connect via IP with no success. I have edited the postgresql.conf file and changed listen_address = '*' and edited the ...
    Jeff StanleyJeff Stanley
    Jan 31, 2007 at 3:37 am
    Feb 6, 2007 at 1:08 pm
  • SELECT name FROM pseudonyms WHERE person_id=125; I know in advance that this query yields between 0 and 5 rows of results, depending on the actual person_id. How can I concatenate those results into ...
    Pierre ThibaudeauPierre Thibaudeau
    Jan 30, 2007 at 2:50 am
    Jan 30, 2007 at 4:10 am
  • Thanks for your time. I have an access/VBA system accessing data stored in a PostGRESQL db via functions. One of the function uses temporary tables. If I execute the function repeatedly via my vba ...
    Brian stapelBrian stapel
    Jan 23, 2007 at 4:52 pm
    Jan 23, 2007 at 5:25 pm
  • Thanks for your time. I'm in the process of trying to incorporate three Human Resource systems into one. Each of the three systems had a different author and no standards were followed - consequently ...
    Brian stapelBrian stapel
    Jan 8, 2007 at 10:39 pm
    Jan 9, 2007 at 5:09 pm
  • What would be the proper data type to store an image into? Or what is the preferred method of storing an image (.jpg). I'm running v8.1.5. Thanks!
    Jan 4, 2007 at 9:50 am
    Jan 4, 2007 at 10:59 am
  • I'm a sysadmin, not a DBA, and I inherited a legacy app after the developer left the company. It's 4 early mod_perl (1.29) + early DBI (1.43) app servers, going against postgres 7.4.6. The DB just ...
    Greg CoxGreg Cox
    Jan 3, 2007 at 9:52 pm
    Jan 3, 2007 at 11:13 pm
  • Hello, is there a way to write to a file in the filesystem from a pgplsql function? The reason for this is the architecture of our user system: Each new database has a file in $PGDATA/users with a ...
    Sven SporerSven Sporer
    Jan 2, 2007 at 9:09 am
    Jan 2, 2007 at 5:13 pm
  • select age('2007-01-01 03:00','2007-01-01 04:59'); age ----------- -01:59:00 (1 row) select to_char(age('2007-01-01 03:00','2007-01-01 04:59'),'HH24:MI'); to_char --------- -1:-59 (1 row) Isn't just ...
    Frank BaxFrank Bax
    Jan 29, 2007 at 2:31 am
    Jan 29, 2007 at 11:09 am
  • Hello, I'm having difficulty installing PostgreSQL 8.2 on Windows 2000. It gets most of the way through the installation and fails (I think) after trying to initialize the database. The log message ...
    Neil BibbinsNeil Bibbins
    Jan 25, 2007 at 4:54 pm
    Jan 25, 2007 at 6:28 pm
  • I can't seem to get CASE to work for me here and every example that I see is using CASE in a completely different way. have a table: day(default CURRENT_DATE), user, count_of_a, count_of_b index is ...
    Brian NeuBrian Neu
    Jan 25, 2007 at 5:18 pm
    Jan 25, 2007 at 5:25 pm
  • Thanks for your time! I've asked a number of questions recently - thanks to all who have responded. Your responses have been very helpful and appreciated. :) I'm writing a function that generates ...
    Brian stapelBrian stapel
    Jan 18, 2007 at 4:08 pm
    Jan 19, 2007 at 1:24 pm
  • Hi In my ubuntu server I have two places where are logged the messages from postgreSql. Some kind of messages are logged in /var/log/postgresql/postgresql-8.1-main.log and others messages are loggued ...
    Leticia LarrosaLeticia Larrosa
    Jan 18, 2007 at 10:17 pm
    Jan 18, 2007 at 10:50 pm
  • ......... Imagine a database-within-a-database implementation like this: CREATE TABLE virtual_tables( tableid serial PRIMARY KEY, tablename varchar(50) UNIQUE NOT NULL ); INSERT INTO virtual_tables ...
    Jan 16, 2007 at 10:24 pm
    Jan 17, 2007 at 12:13 am
  • Hello, I have migrated one of our Posgres databases from Unix to an NT server. I have set up the database, turned SSL on, created the reuired certificates on the server but when I try to access the ...
    Hackenberg, RickHackenberg, Rick
    Jan 16, 2007 at 9:19 pm
    Jan 16, 2007 at 9:50 pm
  • Thanks for your time. I'm having some difficulties with the age function. I need to calculate the difference in days between the current date and a value provided to a function via an argument. When ...
    Brian stapelBrian stapel
    Jan 16, 2007 at 8:03 pm
    Jan 16, 2007 at 8:47 pm
  • Imagine you have a sequentially indexed table (just think any table with an id field). When you select a record, you want to at the same time grab the id of the following record, as well as the id of ...
    Alan T. MillerAlan T. Miller
    Jan 11, 2007 at 9:18 pm
    Jan 11, 2007 at 10:10 pm
  • I am using EMS's PostGreSQL manager to create a new function using language SQL and pgSQL In my function I am trying to declare a variable of type RECORD. DECLARE curRecord RECORD; But it gives an ...
    Greg QuinnGreg Quinn
    Jan 11, 2007 at 7:28 pm
    Jan 11, 2007 at 8:26 pm
  • Thanks for your time. I'm building an application using PostGreSQL and MS Access 2003 for the front end. All table transactions(add, edit, delete, select) occur via PostGreSQL functions written in ...
    Brian stapelBrian stapel
    Jan 11, 2007 at 3:44 pm
    Jan 11, 2007 at 4:34 pm
  • Hi, Do you know if 8.2.1 RPMs provided at: http://www.postgresql.org/ftp/binary/v8.2.1/linux/rpms/ are supposed to be signed by PGP Key (http://www.gunduz.org/devrimgunduz.pgp.pub)? At least it seems ...
    Mathieu PeltierMathieu Peltier
    Jan 9, 2007 at 7:36 pm
    Jan 9, 2007 at 7:45 pm
  • I have two Linux servers running with one as a hot standby should the primary fail. It is not critical that they be in sync with every transaction, but I would like to sync them up with a cron job in ...
    Carlson, James (Jim)Carlson, James (Jim)
    Jan 9, 2007 at 12:59 pm
    Jan 9, 2007 at 1:37 pm
  • Hi All, I am having trouble to dump a table on postgres 8.1.5 version using pg_dump 7.3/7.4. I get the following message pg_dump: server version: 8.1.5; pg_dump version: 7.4.14 pg_dump: proceeding ...
    Saranya SivakumarSaranya Sivakumar
    Jan 3, 2007 at 4:25 pm
    Jan 3, 2007 at 4:38 pm
  • Hi all Probably is a stupid question, But I don’t want to destroy my server :-) Is possible to install two different version of postgresql on the same Linux server? I want to install the 8.2 version ...
    Jan 30, 2007 at 11:29 am
    Jan 30, 2007 at 11:29 am
  • I'll second that! Thanks for helping others learn and use PostgreSQL. Thanks to the devs for making such a nice product and making it available to the masses (that need the help all the time. ;-) oe1 ...
    Jan 29, 2007 at 10:48 pm
    Jan 29, 2007 at 10:48 pm
  • Hi All, Thanks to all in this support community. You are doing a great job! With all the information/support from the communities and documentations, we successfuly upgraded to 8.1 from 7.3.2 on our ...
    Saranya SivakumarSaranya Sivakumar
    Jan 29, 2007 at 8:51 pm
    Jan 29, 2007 at 8:51 pm
  • Thanks for your time. Are records created by performing function with in a function, immediately available to the calling function? For example, function A calls function B via the perform command. ...
    Brian stapelBrian stapel
    Jan 25, 2007 at 2:52 pm
    Jan 25, 2007 at 2:52 pm
  • Hi, I want to select the available schemas based on what is available to a user -user/group rules. Is there a simple way to do this? -- John Fabiani
    Jan 19, 2007 at 7:41 pm
    Jan 19, 2007 at 7:41 pm
  • hello guys, this is one admin from the mysql2psql.perl gborg site http://gborg.postgresql.org/project/mysql2psql/projdisplay.php is its homepage we are adding support for mysql comments and can ...
    Joe speigleJoe speigle
    Jan 17, 2007 at 4:19 pm
    Jan 17, 2007 at 4:19 pm
  • Hi! Right now, I have the following user management concept: -) when creating a database, an equally named role is created; every user of this db is in this role, this is to handle the CONNECT ...
    Sven SporerSven Sporer
    Jan 12, 2007 at 4:54 pm
    Jan 12, 2007 at 4:54 pm
  • Hi all, I'm working on a database (postgresql of course) which has a number of user-defined functions, some in plperl, some in plpgsql and one in plpython. Some of these seem pretty slow - I'm not ...
    Sue FittSue Fitt
    Jan 11, 2007 at 9:42 am
    Jan 11, 2007 at 9:42 am
Group Navigation
period‹ prev | Jan 2007 | next ›
Group Overview
grouppgsql-novice @

55 users for January 2007

Chad Wagner: 9 posts Tom Lane: 7 posts Brant Fitzsimmons: 6 posts Brian stapel: 6 posts Andreas Kretschmer: 5 posts Duncan Garland: 5 posts Frank Bax: 5 posts Sean Davis: 5 posts Brandon Aiken: 4 posts Alan Hodgson: 3 posts Ron Arts: 3 posts Aarni Ruuhimäki: 2 posts Bruno Wolff III: 2 posts Howard Eglowstein: 2 posts Jasbinder Singh Bali: 2 posts Pierre Thibaudeau: 2 posts Robert Rak: 2 posts Saranya Sivakumar: 2 posts Sven Sporer: 2 posts Psql-novice: 1 post
show more