Search Discussions

48 discussions - 135 posts

  • Hi guys, Which tool do you recommend for modeling pg database? I'm using Aqua Data Studio, and it has a good and friendly UI and its ER it's quite well too, but it's paid and besides of design of it, ...
    Luiz Eduardo Cantanhede NeriLuiz Eduardo Cantanhede Neri
    May 25, 2009 at 10:44 am
    Jun 3, 2009 at 2:40 pm
  • Hi, I'm trying to do something like this: BEGIN; CREATE TABLE A ( idA serial not null primary key, someColumn text ); CREATE TABLE B ( someData text ) INHERITS(A); CREATE TABLE C ( idC serial not ...
    Luiz Eduardo Cantanhede NeriLuiz Eduardo Cantanhede Neri
    May 24, 2009 at 5:54 pm
    May 25, 2009 at 7:06 am
  • Sorry for the cross post - but I'm not sure my original posting to the performance mailing list was the right place to send my question. So, let me try again at the novice list. I have a query and I ...
    Zach CalvertZach Calvert
    May 27, 2009 at 2:35 pm
    May 27, 2009 at 8:49 pm
  • What is the command to create a table from a pre-written description text file? In mysql it is: %mysql sample_db < create_xxxx.sql In postgresql, there are schema and I want to create the DB in a ...
    Just E. MailJust E. Mail
    May 25, 2009 at 8:07 pm
    May 27, 2009 at 2:23 pm
  • Hi, I am looking at a very simple query (select * from queue), which takes forever to finish. I don't understand the output that explain tells me: m=# explain select * from queue; QUERY PLAN ...
    Ron ArtsRon Arts
    May 26, 2009 at 8:38 am
    May 26, 2009 at 7:58 pm
  • This question seems so simple but I don't have an answer. Installed CentOS 5.3, Postgresql 8.3.7 (Libs, Server, Devel) & pgAdmin. Then created a user/role as follows: --------------------- % su - ...
    Just E. MailJust E. Mail
    May 26, 2009 at 6:20 pm
    May 28, 2009 at 11:55 am
  • Dear All, Once in a while I ever installed the old progreSQL, but then I uninstalled it. Now, I want to install it again, but always asked for a password, when I enter the password it will said that ...
    May 25, 2009 at 2:58 am
    May 27, 2009 at 3:31 am
  • This question is about installing Postfix with PostgreSQL. I am posting on this Forum hoping that somebody has done it and help me out. CentOS 5.3, PostgreSQL-8.3.7, Postfix-2.5.6 I have setup a ...
    Just E. MailJust E. Mail
    May 9, 2009 at 9:14 pm
    May 11, 2009 at 10:49 am
  • Thanks, this works :) -----Original Message----- From: pgsql-novice-owner@postgresql.org On Behalf Of Leif B. Kristensen Sent: Friday, May 22, 2009 2:46 PM To: pgsql-novice@postgresql.org Subject: ...
    Mehrotra, Abhinav (GE Healthcare)Mehrotra, Abhinav (GE Healthcare)
    May 22, 2009 at 10:36 am
    May 24, 2009 at 11:44 am
  • Hi, i'm looking for a way to create a custom sort table. The table has a column which is currently character varying (255), although i might do with an array of double if it will help. This column ...
    May 16, 2009 at 5:59 pm
    May 21, 2009 at 11:08 pm
  • Hi, I have problem with simple query on existing table. On list below is evidently, that my table "Zed" exists, but when I ask that by SELECT, I have no result. When I list this table in PgAdmin3, ...
    Jaromír KamlerJaromír Kamler
    May 21, 2009 at 8:17 am
    May 21, 2009 at 11:40 am
  • I have a table A of data: [id][parameter][value] ----------------------------- [01][aa][20] [02][bb][21] [03][cc][22] [04][aa][23] [05][bb][24] [06][cc][25] [07][aa][26] [08][bb][27] [09][cc][28] ...
    Jason Tan Boon TeckJason Tan Boon Teck
    May 15, 2009 at 8:51 am
    May 15, 2009 at 11:52 am
  • I have a table to inventory trees, that looks something like this: CREATE TABLE tree ( tree_id SERIAL PRIMARY KEY, tree_species_id INT NOT NULL REFERENCES tree_species, tree_location POINT NOT NULL, ...
    Karl NackKarl Nack
    May 29, 2009 at 8:23 pm
    May 29, 2009 at 8:44 pm
  • Dear List, Is there any way to force a query to return just a few records? For ex, returning just the first ten rows from a long ORDER BY query ? And then, eventually, obtaining the remaining records ...
    Oliveiros CristinaOliveiros Cristina
    May 25, 2009 at 1:34 pm
    May 25, 2009 at 2:15 pm
  • Hi all - I need to select the rows of a table that satisfy a condition that includes a function call, and I want to include the result of the function call as a column in the resulting table. For ...
    Dallas MorisetteDallas Morisette
    May 17, 2009 at 12:44 am
    May 17, 2009 at 2:16 pm
  • Using PostgreSQL 8.3.7, I'd like to make a 'hot' backup of my dbases. I've been using "pg_dumpall -c -o" for a while, but I realize that this is no good. After all, for a restore, the PostgreSQL ...
    May 14, 2009 at 11:13 am
    May 15, 2009 at 10:33 am
  • Hi all, I'm having a problem with LIMITed queries, and I don't know is it me who is doing something wrong or Postgres. (Probably me.) When I browse through the list of employees: id id_dept name ...
    Ognjen BlagojevicOgnjen Blagojevic
    May 14, 2009 at 6:46 pm
    May 14, 2009 at 7:22 pm
  • Hi, What is the best way to call C-Language function from another one? Now I see only one method - to call SPI_execute("EXECUTE funcName(...);", false, 0). For example: ...
    Ilya UrikhIlya Urikh
    May 13, 2009 at 11:39 pm
    May 14, 2009 at 7:04 am
  • Hi list, I have a question on postgres' tablespace. I just wanted to ask if this is possible. I have a postgres database that is running out of disk space. I'm trying to mount additional disk space ...
    Ridvan Lakas ng Bayan S. BaluyosRidvan Lakas ng Bayan S. Baluyos
    May 13, 2009 at 12:01 pm
    May 14, 2009 at 1:58 am
  • Hi, I am trying to read the attributes of columns from a database table in postgresql Can you please help me.. this is an important task with a very short deadline Thank you ahead,
    Pallayya Sarma KarraPallayya Sarma Karra
    May 8, 2009 at 4:02 pm
    May 12, 2009 at 4:05 pm
  • Is it possible to convert a numeric value to string within a SELECT query statement? For example, let's say that I have a table with a numeric field named "quantity". A normal SELECT would be "SELECT ...
    May 4, 2009 at 10:22 pm
    May 6, 2009 at 2:41 pm
  • 2


    Hi everyone ! I am supposed to get the properties of each column of each table in a database of postgresql. I know querying the tables of a database for values inside them. But not how to get the ...
    Pal karPal kar
    May 4, 2009 at 8:52 pm
    May 5, 2009 at 12:47 am
  • I am a Linux Newbie. Never installed software on Linux OS before. I need to upgrade an existing Postgresql 7.3.4-3 running on RHEL 3 to Postgresql 8. From my research so far I do not believe that ...
    Fred MoseleyFred Moseley
    May 1, 2009 at 5:31 pm
    May 1, 2009 at 6:07 pm
  • Hi, I'm new to postgresql, but do have some experience in MySQL. I wanted to create a new enum type and used the command: CREATE TYPE gender AS ENUM ('male', 'female', 'unknown') Which returned ...
    Mark HageMark Hage
    May 12, 2009 at 3:02 pm
    Jul 6, 2009 at 5:46 pm
    Luiz Eduardo Cantanhede NeriLuiz Eduardo Cantanhede Neri
    May 27, 2009 at 3:02 pm
    May 27, 2009 at 3:09 pm
  • Is there a way to make a conditional ALTER TABLE command? If I want to drop a column only if that table's column exists, what would be the correct syntax. I have tried several IF EXISTS, but I get an ...
    Dale SeaburgDale Seaburg
    May 26, 2009 at 10:59 pm
    May 26, 2009 at 11:03 pm
  • I am trying to create pgsql database/tables for freeRADIUS. I notice that PostgreSQL has a schema for freeRADUS. Is there any procedure to create the DB/Tables from this schema or I have to type all ...
    Just E. MailJust E. Mail
    May 23, 2009 at 9:05 pm
    May 25, 2009 at 12:28 am
  • Hi, I have a table temp (name varchar(64), seq bigserial) And a stored procedure : Create function ...... .......... Val bigint; BEGIN: Val:= insert into temp("hello") RETURNING seq; END; I am unable ...
    Mehrotra, Abhinav (GE Healthcare)Mehrotra, Abhinav (GE Healthcare)
    May 22, 2009 at 9:11 am
    May 22, 2009 at 9:16 am
  • Dear All, I want to write a query which returns three different counts based on three different conditions. The following data set and result set may explain my scenario. *Table Data * PersonId work ...
    May 17, 2009 at 1:05 pm
    May 17, 2009 at 2:15 pm
  • I have a query like this: SELECT field1 || field2 AS finalfield FROM table1 Is it possible to insert a new line between "field1" and "field2" (carriage return, line feed or something) so when ...
    May 14, 2009 at 7:03 pm
    May 14, 2009 at 7:29 pm
  • hello in using postgres 8.3 on windows and i have aproblem to update a table, this is the facts, I have a tables where i want to update the name based on a lenght of a field for instance i want to ...
    Paul AlarconPaul Alarcon
    May 13, 2009 at 7:53 pm
    May 14, 2009 at 5:19 am
  • I have 5 tables like named this: 2009.01 2009.02 2009.03 2009.04 2009.05 Each table has a columns like this: ( id integer, ts timestamp, value char(50) ); If I would like to search from 2009.01 to ...
    Mag GamMag Gam
    May 11, 2009 at 12:17 pm
    May 11, 2009 at 12:37 pm
  • I am currently in the process of refactoring my database schema. As part of that I am changing the primary key on one of my tables. The first thing I did was place a unique contraint on the column I ...
    May 30, 2009 at 12:12 am
    May 30, 2009 at 12:12 am
  • According to the documentation, step 1 in making a base backup for pitr reads "Ensure that WAL archiving is enabled and working.". It doesn't spell out anything more. To do a thorough job of it, what ...
    Komei mitsuiKomei mitsui
    May 29, 2009 at 5:48 pm
    May 29, 2009 at 5:48 pm
  • I'm trying to add range check constraints to tables but I'm not 100% sure I'm doing it correctly for one of them. Specifically, what do you do if you want to allow two non-overlapping ranges? For ...
    Robert SchnabelRobert Schnabel
    May 27, 2009 at 7:04 pm
    May 27, 2009 at 7:04 pm
  • Some PL/Java or PL/J function might do what you want, provided Java gives you a means to access the registry. But what's wrong with "SHOW data_directory;" or "SELECT setting FROM pg_settings WHERE ...
    Joshua TolleyJoshua Tolley
    May 27, 2009 at 3:30 pm
    May 27, 2009 at 3:30 pm
  • One more thing if you dont wish to use this existing user, the Administrative Tools also provide facility to change the password (RESET) for any user. Simply reset the password and set a new one. All ...
    Pushpendra Singh ThakurPushpendra Singh Thakur
    May 27, 2009 at 3:00 am
    May 27, 2009 at 3:00 am
  • Is there an good way to extract the interval unit that were used? E.g. I used interval '2h' and another case I used '3d', theses are respectively 2 hours and 3 days, but the format that came on ...
    Luiz Eduardo Cantanhede NeriLuiz Eduardo Cantanhede Neri
    May 25, 2009 at 1:15 pm
    May 25, 2009 at 1:15 pm
  • Wow guys and gals, that was a whole new kind of fantastic, I have to say! I went to your "soul searching" on Thursday and am currently checking my friends network to see if I can find anyone with bug ...
    Alan McKayAlan McKay
    May 22, 2009 at 11:33 pm
    May 22, 2009 at 11:33 pm
  • Good morning. I am trying to encourage my department away from our dozens of installations of SQL Server 2000/2005. My goal is to use PostgreSQL instead. To that end, I am using PostgreSQL in one of ...
    Hartman, MatthewHartman, Matthew
    May 17, 2009 at 3:02 pm
    May 17, 2009 at 3:02 pm
  • Hi, I am a novice PG user. I would like to know which among these data types are best suited to be used as Primary/Foreign Keys. Some of my assessment follows; SERIAL autonumber. auto generated in ...
    Dante torioDante torio
    May 15, 2009 at 12:33 pm
    May 15, 2009 at 12:33 pm
  • Hello I tried to install PostGres 8.3.7. It installed OK but hung on trying to install the GIS database. I felt that the GIS installation was hung because the postgres ID had a password which the GIS ...
    Avinash KachhyAvinash Kachhy
    May 13, 2009 at 3:28 am
    May 13, 2009 at 3:28 am
  • Hi, I am trying to run pg_dump on windows 2003 server. I want to run this as a batch process, so I have specified my password in the %appdata%\postgresql\pgpass.conf file, however, when this is ...
    James BowkettJames Bowkett
    May 12, 2009 at 3:45 pm
    May 12, 2009 at 3:45 pm
  • Dear all, Can I restrict an array from containing NULL elements? Regards, Dave
    David GaramondDavid Garamond
    May 12, 2009 at 8:08 am
    May 12, 2009 at 8:08 am
  • Hi, I've got a database on a hosted server that I'm interested in looking at statistics for, initially the pg_stat_user_tables view. When I query it, it's empty. Looking at the output the of SHOW ...
    Neil SaundersNeil Saunders
    May 11, 2009 at 2:58 pm
    May 11, 2009 at 2:58 pm
  • Hi If you would like to see me sleeping on the streets, well guess what: you can get your wish. I'll be sleeping out as part of the St Vincent Sleep Out on the 18th June. Apart from seeing me rough ...
    Stephen ChoulartonStephen Choularton
    May 10, 2009 at 1:08 am
    May 10, 2009 at 1:08 am
  • I am setting up Linux Virtual Server (LVS). It is a three layer setup. The first layer is two Virtual Servers, the second layer is 2+ Real Servers (CentOS 5.3, Apache, freeRADIUS, mail server, etc.) ...
    Just E. MailJust E. Mail
    May 6, 2009 at 2:17 am
    May 6, 2009 at 2:17 am
  • I'm in the middle of researching migrating a moderate-sized database (Currently 720GB) to PostgreSQL, and I stumbled across the idea of partitions, which look to be a major win for maintainence and ...
    Daniel StaalDaniel Staal
    May 4, 2009 at 5:23 pm
    May 4, 2009 at 5:23 pm
Group Navigation
period‹ prev | May 2009 | next ›
Group Overview
grouppgsql-novice @

58 users for May 2009

Just E. Mail: 12 posts Tom Lane: 12 posts Luiz Eduardo Cantanhede Neri: 11 posts Ognjen Blagojevic: 5 posts Thomas Kellerer: 5 posts Adam Ruth: 4 posts Daniel Staal: 4 posts Jasen Betts: 4 posts Andreas Kretschmer: 3 posts Dallas Morisette: 3 posts Ron Arts: 3 posts Zach Calvert: 3 posts Alan McKay: 2 posts Edward Vanden Berghe: 2 posts Frank Bax: 2 posts Fred Moseley: 2 posts Ilya Urikh: 2 posts Jana: 2 posts Jaromír Kamler: 2 posts Jason Tan Boon Teck: 2 posts
show more