Search Discussions

43 discussions - 128 posts

  • Hi, I'm trying to install postgresql 8.1.10-1PGDG (32 bit) on Red Hat Enterprise Linux v4.. I downloaded the rpms and tried to install it when the 'pl' package alone is failing for the below ...
    Nov 12, 2007 at 10:20 pm
    Nov 13, 2007 at 5:03 pm
  • Hi! I flee arrays in SQL whenever I can... however, to programmatically get index fields from the system catalog, there I am. :( E.g. to get the pk fields I wrote: SELECT a.attname AS "primarykey" ...
    Hans-Peter OeriHans-Peter Oeri
    Nov 12, 2007 at 7:26 am
    Nov 14, 2007 at 11:03 pm
  • Hello, Yep, a newbie, at least to PostgreSQL + ODBC / MapServer... :-) I have: - built and populated a PostgreSQL database (including PostGIS, in case that matters in this case) - set up ODBC (using ...
    Greg CocksGreg Cocks
    Nov 30, 2007 at 7:58 pm
    Feb 1, 2008 at 4:09 am
  • Hi, I have a column with timestamps -- some_ts . I'd like to calculate the amount of time between this timestamp and NOW(). select some_ts - NOW() from some_table; This results in a column of type ...
    Nov 25, 2007 at 7:43 am
    Nov 25, 2007 at 9:10 am
  • Hi, Is there anyway to create constant values that could be used and reused in postgres. Sort of a CREATE CONSTANT name VALUE foo AS integer or some such. Thanks.
    Nov 21, 2007 at 5:02 pm
    Nov 23, 2007 at 9:19 pm
  • Hello list, Is there any way to do version control on a database from one application version to another? IE how do I do an upgrade (or even know that I have to do an upgrade) of the database when I ...
    Alex du PlessisAlex du Plessis
    Nov 19, 2007 at 8:46 pm
    Nov 21, 2007 at 4:43 pm
  • I am trying to build a full-text index (gin(to_tsvector('english', title || abstract))) on about 18 million abstracts and titles from medical literature. However, I keep getting out-of-memory errors. ...
    Sean DavisSean Davis
    Nov 15, 2007 at 12:41 pm
    Nov 16, 2007 at 10:28 pm
  • Hi folks: I wanted to put a reference on a table in the public schema that references a column in a table in another schema. I tried: create table cellphone(emplid integer not null references ...
    Mija LeeMija Lee
    Nov 9, 2007 at 5:48 pm
    Nov 9, 2007 at 6:12 pm
  • Hello, In pgAdmin, I set up some Group Roles yesterday and assigned some table, etc accesses with them - as well as assigning each user to one of the groups... When I opened pgAdmin today, the Group ...
    Greg CocksGreg Cocks
    Nov 30, 2007 at 7:54 pm
    Feb 1, 2008 at 4:20 pm
  • I come from a long background with C and isam. Moving into php and postgresql is therefore not all that strange, but I suffer with the comparative lack of structure at times. I deal with a lot of ...
    G. J. WalshG. J. Walsh
    Nov 14, 2007 at 8:09 pm
    Jan 28, 2008 at 7:52 pm
  • Hello all ! I try to start JIRA with PostgreSQL 8.2.5 and have an error - psql: FATAL: Ident authentication failed for user "jira" when i check JIRA log files. Then i try command psql -U jira -d ...
    Григорий НиконоровГригорий Никоноров
    Nov 27, 2007 at 12:51 pm
    Nov 28, 2007 at 4:34 pm
  • This is probably a really trivial question, so hopefully this is the place to ask it. If I have a couple of STABLE functions f1() and f2(), and then I write a third function f3() which does nothing ...
    Dean RasheedDean Rasheed
    Nov 24, 2007 at 1:00 pm
    Nov 25, 2007 at 5:51 pm
  • Just a quick question, not being a big xpath or xml user in the past. Why does this: select xpath('//Abstract/AbstractText[1]',content) from medlinexml; return an array for each entry rather than a ...
    Sean DavisSean Davis
    Nov 19, 2007 at 3:03 pm
    Nov 22, 2007 at 1:37 pm
  • Hello, I am running PostgreSQL 8.1.0 on Gentoo Linux, DB is replicated with Slon version 1.2.0. Fist problem started with one node, with stopped to replicate with such error: 2007-11-15 13:17:21 EET ...
    Nov 15, 2007 at 2:09 pm
    Nov 16, 2007 at 6:38 pm
  • Hi All, I've been using MS SQL 2k and it's bundled query analyzer SQL editor for more than 5 years. I am exploring postgres right now and I hit a snag I don't understand... MS SQL : debugging - use ...
    Robert BernabeRobert Bernabe
    Nov 8, 2007 at 3:41 am
    Nov 9, 2007 at 7:27 pm
  • What is the best way to treat dates with unknown month and/or day? I have some historical data that has only year or year/month, while the newest data has year/month/day. If there is no other option ...
    Sean DavisSean Davis
    Nov 5, 2007 at 3:20 pm
    Nov 6, 2007 at 7:55 am
  • I have recently been convinced by a colleague to use debian (stable) for our server. Now, I would like to install 8.3beta. I have been running 8.3beta on another server and it (as usual) is quite ...
    Sean DavisSean Davis
    Nov 16, 2007 at 4:28 pm
    Nov 23, 2007 at 7:13 pm
  • hi all, before few days i have installed via apt-get version 8.1 to my debian etch machine. after reading lesson 3 in tutorial [ http://www.postgresql.org/docs/8.1/static/tutorial-advanced.html ] i ...
    Pavel SRBPavel SRB
    Nov 21, 2007 at 5:01 pm
    Nov 22, 2007 at 3:04 am
  • I'm coming from MySQL and still trying to get my head around the PostgreSQL approach to authentication and access control. I got postgres installed on CentOS 5 with yum, started the server (which ...
    Kenneth PorterKenneth Porter
    Nov 15, 2007 at 2:47 am
    Nov 15, 2007 at 8:23 am
  • Hello Everybody, I am trying to establish what does Autovaccum actually do, as it is causing data load failures? Documenatation from : http://www.postgresql.org/docs/8.3/static/routine-vacuuming.html ...
    Kasia TuszynskaKasia Tuszynska
    Nov 9, 2007 at 5:06 pm
    Nov 12, 2007 at 11:27 pm
  • Hi, I need some help to improve my design skills. :) I lately read an article about table design, that teached one shouldn't designe tables where it's clear that some columns aren't relevant for ...
    Nov 11, 2007 at 6:10 pm
    Nov 12, 2007 at 7:11 am
  • Hello, All, I have the need to know the primary key assigned to a record I've just INSERTed . Is there an easy way to solve this ? Similar to SQLServer's SELECT scope_identity() ; ? Any help deeply ...
    Oliveiros CristinaOliveiros Cristina
    Nov 8, 2007 at 5:50 pm
    Nov 8, 2007 at 7:27 pm
  • Hi list, I don't understand the difference between the following syntax : CREATE FUNCTION "test_check_a_id" () RETURNS opaque AS ' And CREATE FUNCTION LAST_UPDATED() RETURNS "trigger" AS $$ ...
    Nico CallewaertNico Callewaert
    Nov 8, 2007 at 8:48 am
    Nov 8, 2007 at 3:35 pm
  • Hey guys, I am an OpenNMS admin and new to Postgres. I have just updated around 1100 devices manually with multiple categories and left out a category from each... What I would like to do is run a ...
    Patrick RamseyPatrick Ramsey
    Nov 2, 2007 at 6:18 pm
    Nov 3, 2007 at 6:30 pm
  • I have a users table that's getting pretty large (~ 2M rows) and that's very sparse, because most users register but don't do much, so a lot of the columns are NULL. I'm thinking of adding a ...
    Plu tardPlu tard
    Nov 28, 2007 at 6:37 am
    Nov 28, 2007 at 12:42 pm
  • Hello, this question maybe a bit simple: I just migrated to postgres, One of my table with over 10,000 records have one field who's value should be True, however when the data was imported it was set ...
    Roody senecalRoody senecal
    Nov 26, 2007 at 2:23 am
    Nov 26, 2007 at 2:26 am
  • Hi All, I need some trigger help. I am very new to SQL, so please bare with me. I have a table: CREATE TABLE table ( id integer, name text, ); Basically, I have values going into name. The values ...
    Mag GamMag Gam
    Nov 20, 2007 at 4:05 pm
    Nov 20, 2007 at 4:19 pm
  • Hi. I'm just getting started with PostgreSQL. Porting over an huge Oracle database application for a fun first project :^) I've got the following query which I'm trying to run on a 4.2 million row ...
    Dr. Kurt RuffDr. Kurt Ruff
    Nov 19, 2007 at 4:15 am
    Nov 19, 2007 at 4:39 am
  • Hi, I originally created a database called memdev. Then I created a second database called inputdev, and put in some files of stuff I wanted to process and then read into memdev. I am not having much ...
    Mary AndersonMary Anderson
    Nov 16, 2007 at 11:05 pm
    Nov 17, 2007 at 8:03 am
  • Hello, My problem: 1. I have a application accessing Postgres 8.2 using NHibernate 3. 2. Using hibernate I lock a registry using the function ' nhibernate.lockmode.upgradenowait'. Ok, its worked. 3. ...
    Carlos gustavoCarlos gustavo
    Nov 16, 2007 at 5:33 pm
    Nov 16, 2007 at 8:16 pm
  • I am trying to make a pg_dumpall via a cronjob. Using Redhat ES release 4 (Nahant Update 5) and postgresql-7.4.17-1.RHEL4.1. The error I get is: Date: Wed, 14 Nov 2007 04:00:01 +0200 From: ...
    Swanepoel, BarrieSwanepoel, Barrie
    Nov 16, 2007 at 5:25 am
    Nov 16, 2007 at 5:41 am
  • Hi, can someone tell me what is the java equivalent for the postgresql database type??? Express yourself instantly with MSN Messenger! Download today it's FREE! ...
    Carlos Muñoz RodríguezCarlos Muñoz Rodríguez
    Nov 15, 2007 at 3:35 pm
    Nov 15, 2007 at 7:20 pm
  • Hello, and yet another clueless newbie question: The precision of time types is specified as follows in the documentation: "For the time types, the allowed range of p is from 0 to 6 when eight-byte ...
    Wolfgang KellerWolfgang Keller
    Nov 13, 2007 at 11:45 am
    Nov 14, 2007 at 12:28 pm
  • PG 8.2 Linux Hello - I would like to update a two-dimensional array field in a table using pure SQL. The field is defined as text[][] My query produces data in the form x, y, z where x is the value ...
    David MonarchiDavid Monarchi
    Nov 9, 2007 at 12:13 am
    Nov 12, 2007 at 6:05 pm
  • In my application, a client will complete a fairly involved registration form containing more personal information than usual. The form content will be encrypted (https) and will contain the client's ...
    G. J. WalshG. J. Walsh
    Nov 7, 2007 at 10:05 pm
    Nov 8, 2007 at 2:15 pm
  • Within a lengthy form script: In MySQL, I had, by way of example, $sql = 'INSERT INTO testee VALUES (? ? ? ? ?)'; $stmt = $dbcx- stmt_init(); $stmt- ...
    G. J. WalshG. J. Walsh
    Nov 3, 2007 at 12:13 am
    Nov 4, 2007 at 4:08 pm
  • Hi All, I am currently building a database where we get batch feeds from various vendors. On a daily basis we generate about 5000 updates. Sometimes the vendor may send us a bad feed/data, and we ...
    Mag GamMag Gam
    Nov 22, 2007 at 4:41 pm
    Nov 22, 2007 at 4:41 pm
  • Hi, I'm trying to create an adhoc backup feature inside an application using PHP. I could perform a pg_dump using the shell, but is there SQL statements that could do the same thing without having to ...
    Jason Tan Boon TeckJason Tan Boon Teck
    Nov 22, 2007 at 3:44 am
    Nov 22, 2007 at 3:44 am
  • Sorry for the cross-post, but I wasn't sure where this should go. I have a large XML file (about 7.5Gb) that is composed of about 17 million individual records. I have successfully loaded these ...
    Sean DavisSean Davis
    Nov 15, 2007 at 12:35 pm
    Nov 15, 2007 at 12:35 pm
  • [posted and mailed] jatrojoomla <jatrojoomla@gmail.com wrote in news:1193657756.847457.305150 @z24g2000prh.googlegroups.com: What platform and what versions of PostgreSQL and phpPgAdmin? Check the ...
    Kenneth PorterKenneth Porter
    Nov 15, 2007 at 3:14 am
    Nov 15, 2007 at 3:14 am
  • Hello, as far as I understand from the (excellent, btw.) PostgreSQL documentation, inheritance of primary or foreign keys is not (yet?) supported. That's a pity, because it makes inheritance ...
    Wolfgang KellerWolfgang Keller
    Nov 13, 2007 at 11:32 am
    Nov 13, 2007 at 11:32 am
  • Hello, I would like to implement Mod_Authn_bdb as per example on Apache web site. http://httpd.apache.org/docs/2.2/mod/mod_authn_dbd.html#example ... Has anyone implemented this, how do I design my ...
    Nov 3, 2007 at 9:46 am
    Nov 3, 2007 at 9:46 am
  • I am using xpath queries against an XML column like so: annodb=# select id,xpath('//LastName/text()',content) from medlinexml limit 10; id | xpath ----------+---------------------------- 12236137 | ...
    Sean DavisSean Davis
    Nov 2, 2007 at 6:49 pm
    Nov 2, 2007 at 6:49 pm
Group Navigation
period‹ prev | Nov 2007 | next ›
Group Overview
grouppgsql-novice @

54 users for November 2007

Sean Davis: 16 posts Tom Lane: 14 posts Hans-Peter Oeri: 5 posts Kenneth Porter: 5 posts Rodrigo E. De León Plicet: 5 posts Andreas: 4 posts Devrim GÃNDÃZ: 4 posts Robert M. Bernabe: 4 posts G. J. Walsh: 3 posts Josh Tolley: 3 posts Michael Glaesemann: 3 posts Oliver Elphick: 3 posts Phillip Smith: 3 posts John: 2 posts Gokul: 2 posts Andrew Hammond: 2 posts David Monarchi: 2 posts Dean Rasheed: 2 posts Greg Cocks: 2 posts Kasia Tuszynska: 2 posts
show more