Search Discussions

36 discussions - 132 posts

  • Greetings, I have a PostgreSQL-8.x database that contains several tables which hold the results of automated regression tests. Each table contains a specific class of test, however the results from ...
    Lonni J FriedmanLonni J Friedman
    Aug 10, 2007 at 9:47 pm
    Aug 13, 2007 at 10:28 pm
  • Hi: We've been getting a message in our logs on a semi-regular basis in response to a cron job that drops and recreates a number of databases using the dropdb command. The message indicates that a ...
    Mija LeeMija Lee
    Aug 30, 2007 at 5:15 pm
    Aug 31, 2007 at 7:13 am
  • I've got a simple select query that runs every 10 minutes in order to update data in some external rrds (it lets us make pretty graphs and so forth). This has been working fine for months on end, ...
    Jon JensenJon Jensen
    Aug 16, 2007 at 2:27 am
    Aug 16, 2007 at 9:27 pm
  • Greetings, I was just trying to get a live backup of my database and had the following error: uselton]# pg_dumpall /tmp/osp5_pgsql.dump Password: pg_dumpall: could not connect to database ...
    Andrew C. UseltonAndrew C. Uselton
    Aug 10, 2007 at 6:58 pm
    Aug 11, 2007 at 4:10 am
  • Hi I have 4 tables: 1) Owner Table - rcaowm - having own_code, owm_name 2) Tenant Table - rcatnm - having tnm_code (owner's code), tnm_acno (tenant's account number), tnm_name 3) Owner Transactions - ...
    Paul MalherbePaul Malherbe
    Aug 1, 2007 at 12:34 pm
    Aug 2, 2007 at 3:30 am
  • Hi all, I need to have two different vesions of postgres running in parallel on different ports. Does anyone knows how to install two different versions of postgres (7.4.5 and 8.2.4) on the same ...
    Loredana CurugiuLoredana Curugiu
    Aug 10, 2007 at 11:34 am
    Aug 15, 2007 at 12:42 pm
  • Hi, I did some updating on my Linux server and was a bit too efficient. Databases on the server prior to the update is no longer reachable from pgsql all though still present on the server. Of course ...
    Peter FalkPeter Falk
    Aug 20, 2007 at 8:52 am
    Aug 20, 2007 at 4:50 pm
  • To Whom It May Concern: Wanted to set up a database in a small network with PostgreSQL on Windows. Before I start there is one question: Is there free/opensource-ware to set up a self designed ...
    Peter N. ErnstPeter N. Ernst
    Aug 10, 2007 at 3:17 pm
    Aug 11, 2007 at 2:20 pm
  • Hello *, I would like to save a tree-like structure in a pgsql table. Can anyone give me some suggestions about how can I achieve this task? I will also appreciate any information that points to how ...
    Angelica GarciaAngelica Garcia
    Aug 6, 2007 at 7:55 pm
    Aug 7, 2007 at 2:39 pm
  • CREATE TABLE tunnel ( username integer UNIQUE, -- ranges from 1 to ~250.000 password varchar ); I need to write a function to "allocate" an empty "tunnel" on a prepopulated table where all fields, ...
    Sten Daniel SoersdalSten Daniel Soersdal
    Aug 6, 2007 at 2:02 am
    Aug 6, 2007 at 3:19 pm
  • My application is designed in such a way that the amount of data is expected to be enormous (in the terabytes). I would like to cluster the data and have the luxury of being able to slice up ...
    Chirag PatelChirag Patel
    Aug 4, 2007 at 11:32 pm
    Sep 27, 2007 at 10:26 pm
  • Greetings all, I was wondering if there was a way to SELECT from a parent table and display the schema associated with a child table's data. There's the general idea now let me explain further... I ...
    Matthews, JamesMatthews, James
    Aug 30, 2007 at 1:36 pm
    Aug 30, 2007 at 7:57 pm
  • Hi, I am very new to postgresql and am not really a programmer of any type. I use pgsql to manage very large voter databases for political science research. My problem is that my database is creating ...
    Ryan D. EnosRyan D. Enos
    Aug 17, 2007 at 7:24 am
    Aug 18, 2007 at 7:31 am
  • I have a table with a column that will join with one of several tables based on the value of another column. I'm not sure if this column can be set as a foreign key to any of these tables, may be ...
    Kevin McCarthyKevin McCarthy
    Aug 13, 2007 at 4:14 pm
    Aug 15, 2007 at 1:49 am
  • I'm trying to start my postgres server and it gives me the following errror FATAL: could not create lock file "/var/run/postgresql/.s.PGSQL.5432.lock": Permission denied Now obviously to touch the ...
    Jasbinder Singh BaliJasbinder Singh Bali
    Aug 13, 2007 at 4:50 pm
    Aug 14, 2007 at 6:23 pm
  • Hi: I'm definitely a postgres newbie, and was wondering about how much can be done with the system catalogs. I'd like to a create table that links up with the pg_database catalog so I can track more ...
    Mija LeeMija Lee
    Aug 29, 2007 at 6:26 pm
    Aug 29, 2007 at 7:58 pm
  • The following command works great, SELECT AVG(column) FROM table WHERE timestamp 2007-08-23; But when I try it with finer resolution (hour, minutes, seconds) like this, I get a syntax error SELECT ...
    Chirag PatelChirag Patel
    Aug 27, 2007 at 4:49 am
    Aug 27, 2007 at 5:24 am
  • Hi, I am trying to import a file into a table. The file has the form integer, string integer, string Table has 5 columns, but I just need to fill the first two, the others can remain blank I've tried ...
    Oliveiros CristinaOliveiros Cristina
    Aug 24, 2007 at 12:06 pm
    Aug 24, 2007 at 1:50 pm
  • Hi I built PostGreSql 7.4.17 on HP-UX 11.23 m/c IA m/c. After compilation when i do a gmake check as a diff user as recomended i get the message ============== creating database "regression" ...
    Rajaram JRajaram J
    Aug 19, 2007 at 8:18 am
    Aug 19, 2007 at 6:49 pm
  • Hello - I'm using PG 8.2.4. I am executing a function which includes the code fragment shown below. It goes through the loop and then fails with the error message ERROR: relation with OID 591161 does ...
    David MonarchiDavid Monarchi
    Aug 17, 2007 at 3:48 pm
    Aug 18, 2007 at 3:08 pm
  • The timestamp data type in postgreSQL has the option for a parameter 'p' that defines the precision from 0-6. The documentation indicates 8 bytes as the default size for the column. If I use ...
    Chirag PatelChirag Patel
    Aug 14, 2007 at 6:53 pm
    Aug 14, 2007 at 7:56 pm
  • I have a database with 150 fields per row. For historical reasons, it's broken into three databases, data_a, data_b and data_c. One of the fields is a timestamp and one of them is a serial number ...
    Howard EglowsteinHoward Eglowstein
    Aug 13, 2007 at 8:48 pm
    Aug 14, 2007 at 3:11 pm
  • Help! I am creating a fail over server and one element of my system is using postgresql 8.0. I created a dump of the current DB and I want to restore "as is" on the fail over server. On the fail over ...
    Demian QuinonezDemian Quinonez
    Aug 8, 2007 at 10:17 pm
    Aug 10, 2007 at 8:06 am
  • Hi , I have two tables First table is employee table EMP_ID Ename MGR_ID ---------- -- ---------- 1 a 1 2 b 1 3 c 2 Second one is manager table MGR_ID Manager name ---------- -------------------- 1 d ...
    Aug 6, 2007 at 4:08 pm
    Aug 7, 2007 at 8:08 am
  • Greetings pgsql gurus, I have a pgsql database that uses md5 passwords. When I want to back it up the "pg_dumpall dump_file" command prompts for the administrative password, evidently via stderr. I'd ...
    Andrew C. UseltonAndrew C. Uselton
    Aug 27, 2007 at 8:19 pm
    Aug 27, 2007 at 8:32 pm
  • I have been reading about transactional DDLs at http://archives.postgresql.org/pgsql-general/2007-06/msg00190.php. This discussion seems to be recent though; is this feature available in version 7.4? ...
    Burak SeydiogluBurak Seydioglu
    Aug 23, 2007 at 10:08 pm
    Aug 24, 2007 at 1:34 am
  • How does once create a spatial index on point data. I did the following and got the error given below. create table foo(x point); create index foo_x on foo using gist(x); ERROR: data type point has ...
    S anwarS anwar
    Aug 16, 2007 at 5:48 pm
    Aug 16, 2007 at 9:13 pm
  • My application is designed in such a way that the amount of data is expected to be enormous (in the terabytes). I would like to cluster the data and have the luxury of being able to slice up ...
    Chirag PatelChirag Patel
    Aug 3, 2007 at 8:46 pm
    Aug 16, 2007 at 5:15 am
  • Howdy all, We do not know the superuser (postgres) password to our database cluster. The auth configuration (pg_hba.conf) has the only auth method set to: Type db user method param local all all md5 ...
    Andrew C. UseltonAndrew C. Uselton
    Aug 13, 2007 at 5:17 pm
    Aug 13, 2007 at 5:42 pm
  • Hi I am new to PostGres and I am evaluating it for our purposes. The biggest requirement I have is that I need the ability to constantly add columns dynamically to a table. How is the efficiency of ...
    Avinash LakshmanAvinash Lakshman
    Aug 10, 2007 at 10:58 pm
    Aug 11, 2007 at 4:16 am
  • Actually, I have something of a weird problem. I'm trying to test some code of mine to handle cases where a retry is needed when working with serializable transactions. My problem is that I can *not* ...
    Brian HurtBrian Hurt
    Aug 10, 2007 at 8:23 pm
    Aug 10, 2007 at 9:34 pm
  • Hi, if I get it right a heap buffer page (that contains several tuples) requires a pin and a lock to access the page content, and a change to a tuple requires a lock on the tuple too. Disregarding ...
    Luca FerrariLuca Ferrari
    Aug 7, 2007 at 7:52 am
    Aug 8, 2007 at 10:20 pm
  • Hi all, I am using inheritance of types in the following way on a ROLAP schema to allow for extra dimensions to be used: CREATE TABLE data (data_id int4 SERIAL, data_value double, ... some ...
    Mary AndersonMary Anderson
    Aug 7, 2007 at 6:50 pm
    Aug 7, 2007 at 7:06 pm
  • I need to get Postgresql installed on 64bit Debian 4.0. Postgresql was installed as a part of the Trend IWSS web security suite, but Postgresql doesn't seemt to work on 64bit Debian 4. What happens ...
    Ralf StrandellRalf Strandell
    Aug 2, 2007 at 12:01 pm
    Aug 2, 2007 at 3:51 pm
  • Hi, I'm trying to set up my DB to authenticate against a PAM back-end (in this case just a plain old local password DB). Here's my configuration as it currently stands: positionwhile[pg]% grep pam ...
    Marcin PorwitMarcin Porwit
    Aug 10, 2007 at 7:59 pm
    Aug 10, 2007 at 7:59 pm
  • Wrong setting of TERM, maybe? regards, tom lane
    Tom LaneTom Lane
    Aug 7, 2007 at 2:24 pm
    Aug 7, 2007 at 2:24 pm
Group Navigation
period‹ prev | Aug 2007 | next ›
Group Overview
grouppgsql-novice @

55 users for August 2007

Tom Lane: 24 posts Oliver Elphick: 8 posts Michael Glaesemann: 7 posts Andrew C. Uselton: 5 posts Richard Broersma Jr: 5 posts Jon Jensen: 4 posts Lonni J Friedman: 4 posts Mija Lee: 4 posts Paul Malherbe: 4 posts Chirag Patel: 3 posts Decibel!: 3 posts Loredana Curugiu: 3 posts Alan Hodgson: 2 posts Angelica Garcia: 2 posts Ashish Karalkar: 2 posts David Monarchi: 2 posts Jasbinder Singh Bali: 2 posts Jon Sime: 2 posts Kevin McCarthy: 2 posts Luca Ferrari: 2 posts
show more