Search Discussions

23 discussions - 66 posts

  • Hello all, I have an EXPLAIN statement that gives me output I understand, but on the other hand I don't... tium=# explain select codec1, phonetype from phone; QUERY PLAN ...
    Ron ArtsRon Arts
    Jun 3, 2008 at 9:56 am
    Jun 4, 2008 at 7:57 am
  • Hello, I would like to use VB6 to create a report. I've never use a database before. Can someone point me to some information and examples. Thanks, Gary
    Jun 17, 2008 at 3:33 pm
    Jun 19, 2008 at 3:18 am
  • Dear all, I am new to PostgreSQL and have just started using it for a few weeks. I have a (probably very simple) question regarding an execution of a SQL command which is automatically repeated every ...
    Yos SunitiyosoYos Sunitiyoso
    Jun 27, 2008 at 9:08 am
    Jul 2, 2008 at 9:42 am
  • I was beginning to create some financial functions for calculating Future Values, PV's, etc -for basic retirement planning. example: CREATE OR REPLACE FUNCTION lotsa.FVPMT(payment double precision, ...
    Mike EllsworthMike Ellsworth
    Jun 30, 2008 at 9:44 pm
    Jul 2, 2008 at 1:40 pm
  • I'm planning on upgrading Ubuntu 7.10 to 8.04. Is there anything special I need to do to preserve my Postgres 8.3 installation? Should I backup the cluster and reinstall Postgres, or should I just do ...
    Lee HachadoorianLee Hachadoorian
    Jun 26, 2008 at 4:42 pm
    Jun 26, 2008 at 6:44 pm
  • A total novice here! Machine A: Kubuntu 8.04 has the required database under user userA Machine B: RHEL 5 is the destination machine with userB I want to transfer the entire database under userA from ...
    P KapatP Kapat
    Jun 25, 2008 at 10:15 pm
    Jun 26, 2008 at 9:24 pm
  • I'm actually have installed: postgresql- 8.1.11-1.el5_1.1 pgadmin3.i686 0:1.8.4-1.rhel5 I added the Centos Repo as it saids on this page http://yum.pgsqlrpms.org/howtoyum.php to have the new ...
    Ernesto Eduardo Medina NúñezErnesto Eduardo Medina Núñez
    Jun 19, 2008 at 6:14 am
    Jun 25, 2008 at 11:50 pm
  • Hello: I think I'm a little confused about the something in the documentation: - I think table oids have been deprecated ...
    Mija LeeMija Lee
    Jun 20, 2008 at 11:37 pm
    Jun 23, 2008 at 4:42 pm
  • Hello all- I'm getting an error on a Postgres database when I access a table: Unfortunately, as you can tell, this is causing problems, especially with creating new databases. I'm wondering if anyone ...
    Brian HurtBrian Hurt
    Jun 17, 2008 at 4:11 pm
    Jun 21, 2008 at 6:52 pm
  • Hello, I started working on PostgreSQL 8.2 and I used some temporary tables to pass data between stored functions. To avoid any issue, according to this post ...
    Gabriele MessineoGabriele Messineo
    Jun 17, 2008 at 12:36 pm
    Jun 17, 2008 at 3:13 pm
  • I am developing an application in which I need to create several equal databases based on one that I will take as standard. What I mean is that I will create one basic empty complete database ...
    Jun 11, 2008 at 3:44 pm
    Jun 11, 2008 at 4:52 pm
  • Hi folks, I use a hack to make psql automatically set search_path to the relevant schema for the dump directory I am currently working in. I achieved this by running a wrapper script that changed the ...
    Jun 1, 2008 at 10:01 am
    Jun 1, 2008 at 2:56 pm
  • Is there a way wherein I can dump only the create statements (plus the indexes and triggers) of a `specific` table without including the data? I just need the dump of the table structure, indexes, ...
    Ridvan Lakas ng Bayan S. BaluyosRidvan Lakas ng Bayan S. Baluyos
    Jun 27, 2008 at 7:52 am
    Jun 27, 2008 at 8:26 am
  • hello, i have installed postgresql, and it's up and running fine, using the postgres user account. however, when i run the pgadmin III utility, and attempt to File Open pg_hba.conf file, i cannot ...
    Eric JarviesEric Jarvies
    Jun 25, 2008 at 3:44 am
    Jun 26, 2008 at 5:16 am
  • Hi! I'm not quite sure if this is the right place to discuss this issue but here goes. I've been testing PL/R language coupled with SPI and postgis to produce Voronoi tiles, the following function ...
    João GonçalvesJoão Gonçalves
    Jun 18, 2008 at 5:36 pm
    Jun 22, 2008 at 3:57 pm
  • Hi, I have a very large table (in the order of millions of rows). The most expensive search I do on that table is something like this: 1. select * from friends where 2. age = ? and 3. country = ? and ...
    Ram RavichandranRam Ravichandran
    Jun 13, 2008 at 8:13 pm
    Jun 13, 2008 at 9:47 pm
  • When a table is a supertable of other tables and a subtable consists of identical rows of the supertable and then you do a query on the supertable, would the identical rows be displayed twice since ...
    Patricia MitchellPatricia Mitchell
    Jun 10, 2008 at 2:48 pm
    Jun 10, 2008 at 4:51 pm
  • Hi All, I have 4 tables namely User_profile , Friends, Video , Audio. Friend, Image , Video and Audio table datas are related to Users. All these tables holds Foreignkey to User_profile table. I want ...
    Siva cSiva c
    Jun 6, 2008 at 6:15 pm
    Jun 6, 2008 at 6:35 pm
  • I am developing an ASP.NET web site in which I will use PostgreSQL and such a site is going to be hosted in a hosting company (not in my server). All of the information will be processed through the ...
    Jun 4, 2008 at 10:40 pm
    Jun 4, 2008 at 11:47 pm
  • Hi all, I need to specify servers and storage to run PostgreSQL. Does anyone know any source of information (articles, presentations, books, etc.) which describes methods of hardware sizing for ...
    Sérgio R F OliveiraSérgio R F Oliveira
    Jun 26, 2008 at 7:30 pm
    Jun 26, 2008 at 7:30 pm
  • I can't seem to find ecpg in my PostgreSQL installation yet the libraries seem to be there in /usr/lib64. In the doc it says it should be there in a typical install (which I believe mine is). whereis ...
    Wright, GeorgeWright, George
    Jun 20, 2008 at 6:00 pm
    Jun 20, 2008 at 6:00 pm
  • Having been badly 'bitten' in the recent past, I am doubly cautious about the most minute postgresql complaint. I have finally been able to restore a database completely as a trial for scheduling ...
    G. J. WalshG. J. Walsh
    Jun 17, 2008 at 11:35 pm
    Jun 17, 2008 at 11:35 pm
  • Hi everybody thank you for your help. I apologize for my writing becuase my english is very bad. I have PostgreSQL database on Windows Server 2003, I changed the password of the Postgres user, this ...
    Jun 4, 2008 at 4:08 am
    Jun 4, 2008 at 4:08 am
Group Navigation
period‹ prev | Jun 2008 | next ›
Group Overview
grouppgsql-novice @

39 users for June 2008

Andreas Kretschmer: 5 posts Ron Arts: 5 posts Richard Broersma: 4 posts Steve Crawford: 4 posts Tom Lane: 4 posts Brian Hurt: 2 posts Gabriele Messineo: 2 posts Gary: 2 posts JORGE MALDONADO: 2 posts Lee Hachadoorian: 2 posts Mark Roberts: 2 posts Obe, Regina: 2 posts P Kapat: 2 posts Ridvan Lakas ng Bayan S. Baluyos: 2 posts Shane Ambler: 2 posts Alan Hodgson: 1 post Bret Fledderjohn: 1 post Ceduardo: 1 post Derrick Betts: 1 post Devrim GÃNDÃZ: 1 post
show more