FAQ

Search Discussions

36 discussions - 147 posts

  • Hello, I need a bit of advice for the following problem as I do not know where to start. My client has a sales prospection database in the office. each salesperson has access to it's own clients and ...
    Didier Gasser-MorlayDidier Gasser-Morlay
    Jan 8, 2011 at 6:26 am
    Jan 11, 2011 at 11:25 pm
  • Hi, is there a way to change the way how postgresql outputs floating point numbers? For example: Instead of 2.34 = 2,34 or Instead of 334,323.53 = 334.323,53 Can this be adjusted per session? ...
    Jasmin DizdarevicJasmin Dizdarevic
    Jan 5, 2011 at 1:17 am
    Jan 26, 2011 at 7:23 pm
  • I'm not sure what I'm doing wrong here. I've tried to install the pgcrypto module from: 1. psql shell: i\ path/to/pgcrypto.sql 2. pgAdmin: execute pgScript pgcrypto.sql Both showed me multiple lines ...
    David PatricolaDavid Patricola
    Jan 27, 2011 at 9:37 pm
    Jan 28, 2011 at 5:25 pm
  • Using: Windows 7 64bit VB.net 2010 The latest devart.data.PostgreSQL (.net data connection) PostgreSQL 9.0.2 Hi all, Question: Is there a way to pass a variable from an application's user interface ...
    Chris CampbellChris Campbell
    Jan 21, 2011 at 6:46 pm
    Jan 24, 2011 at 6:36 pm
  • In mysql this query works fine, what is the equivalent in posgresql? SELECT * FROM products p LEFT JOIN products_images pi ON p.id = pi.product_id LIMIT 1 WHERE products.company = 7 postgresql ...
    Behringer BehringerBehringer Behringer
    Jan 15, 2011 at 2:32 am
    Jan 16, 2011 at 11:17 am
  • Hi, I'd like to use the following in pga_hba.conf: local all all trust map=mymap host all all 127.0.0.1/32 trust map=mymap where pga_ident.conf contains mymap jan dbuser With this setup in place, the ...
    Jan EdenJan Eden
    Jan 2, 2011 at 10:47 am
    Jan 2, 2011 at 4:46 pm
  • I am deep into debugging some pretty extensive plpgsql and it would be nice sometimes if I could somehow output the content of a table to the psql console at a particular point in a function. For ...
    Leon StarrLeon Starr
    Jan 29, 2011 at 6:06 am
    Jan 31, 2011 at 9:52 pm
  • I'm running into a bizarre issue with "database XYZ does not exist." I've done a lot of searching, but can't find the cause. For the sake of reference, this is PG 8.4.6 running on RHEL 5.4. Here's ...
    Mike ThomsenMike Thomsen
    Jan 21, 2011 at 5:01 pm
    Jan 21, 2011 at 5:39 pm
  • I posted a message about PostgreSQL vacuuming to this list in Feb. 2010, received some responses, but probably didn't understand what I was being told at that time. There's a script running on my ...
    PeterPeter
    Jan 20, 2011 at 7:41 pm
    Jan 20, 2011 at 11:31 pm
  • Hi, I am trying to load the libpq library of "PostGreSQL 9.0" version on Linux("Red Hat 3.4.6-3") and it is failing. Where as I could successfully load the libpq library of "PostGreSQL 8.4" version ...
    Trupti GhateTrupti Ghate
    Jan 3, 2011 at 11:53 am
    Jan 3, 2011 at 12:25 pm
  • hi, after systable_getnext_ordered returned NULL, is it ok to call it again? if yes, will it always returns NULL again? i'm wondering because inv_truncate seems to do it and expecting NULL. YAMAMOTO ...
    YAMAMOTO TakashiYAMAMOTO Takashi
    Jan 26, 2011 at 9:56 am
    Jan 31, 2011 at 11:48 pm
  • I noticed that the EnterpriseDb web site is brand new, so I figured I would check and see if they fixed the issue where I am unable to log into the forums (post to them) and noticed that when I click ...
    Bill P.Bill P.
    Jan 19, 2011 at 3:25 pm
    Jan 19, 2011 at 3:44 pm
  • hi, is there any easy way to issue large object operations like lo_write, or more generally fast-path calls, asynchronously? (async in the sense of PQsendQuery so that i can poll to wait a result) ...
    YAMAMOTO TakashiYAMAMOTO Takashi
    Jan 13, 2011 at 12:21 am
    Jan 16, 2011 at 11:58 pm
  • Hi, Im moving over from MS SQL. I've been googling this for ages now and suprisingly cannot find a clear answer. I want my data in tables to be case insensitive. This is so i can: 1. Put keys on ...
    Phillip SmithPhillip Smith
    Jan 13, 2011 at 2:55 pm
    Jan 15, 2011 at 12:41 am
  • Hi guys, Our company is looking into the possibility of using it. Firstly, we would like to find out what kind of applications are suitable for using postgreSQL. From the internet, it seems like it ...
    Man LamMan Lam
    Jan 4, 2011 at 3:37 pm
    Jan 7, 2011 at 12:25 am
  • I am trying to connect to my OSX installed version of PG from Windows XP SP3 running in Parallels on my mac. When I try to connect, i get an error about no entry in the pg_hba.conf for the ip i am ...
    Bill P.Bill P.
    Jan 4, 2011 at 4:51 pm
    Jan 4, 2011 at 7:30 pm
  • hi group, i have the following problem. i have a simple updateable view V with a status field S. nowadays i have two clients that try to consume data out of this view V if S = 'TOBEPROCESSED' the two ...
    Christian BrennsteinerChristian Brennsteiner
    Jan 26, 2011 at 3:44 pm
    Feb 1, 2011 at 8:50 am
  • Is there a way to set a different time zone as the default for a session? By default, Postgres displays my data stored in "TIMESTAMP WITH TIME ZONE" columns' data as a local time for the time zone of ...
    Basil BourqueBasil Bourque
    Jan 28, 2011 at 4:54 am
    Jan 29, 2011 at 3:32 am
  • Hello there! If I want to create a table create table users ( id integer name varchar(8) enabled boolean ); and a constraint unique(id,name) but the unique constraint should only be used for the ...
    A BA B
    Jan 24, 2011 at 10:16 am
    Jan 28, 2011 at 11:56 am
  • i have got java application and i want to pass lat,long and distance in metres to geoserver in querystring and want to get near by locations within that distance. please guide me what should i do? -- ...
    Gargdevender74Gargdevender74
    Jan 25, 2011 at 5:25 am
    Jan 28, 2011 at 4:06 am
  • I'm trying to implement a priority queue. Performance is not much of an issue but there will be about 10m entries. I need to lock the table, select ~1000 entries (out of ~1m matching the query) and ...
    Matt wMatt w
    Jan 24, 2011 at 2:54 am
    Jan 24, 2011 at 6:39 pm
  • How can I tell if a session is in a pending transaction? In other words, a "BEGIN TRANSACTION" has been issued but the transaction has not yet done a COMMIT or ROLLBACK. How can I ask if that is the ...
    Basil BourqueBasil Bourque
    Jan 18, 2011 at 8:53 pm
    Jan 21, 2011 at 10:10 pm
  • Hi there, I have around 10 databases in my PostGreSQL database, but i want to delete some of those im not using. I've looked, but i have no clue how to delete them? Can you give me any information or ...
    Ruud van DijkRuud van Dijk
    Jan 4, 2011 at 2:18 pm
    Jan 4, 2011 at 2:28 pm
  • Hello all, I'm looking for some reassurance/advice. Having developed my very-limited database skills in isolation, using only a postgres manual for reference, I've probably fallen into some bad ...
    Nathaniel TrelliceNathaniel Trellice
    Jan 24, 2011 at 11:19 am
    Jan 24, 2011 at 11:41 am
  • Hi. While looking through the error codes in Appendix 1 in the doc, I found restrict_violation. What is that and how do I get it?
    A BA B
    Jan 21, 2011 at 9:53 am
    Jan 21, 2011 at 3:29 pm
  • Hi, I have a little problem with psql with 8.4.6 , select E'é\fr'; gives : ?column? ---------- é\x0Cr (1 ligne) whereas with 8.1 select E'é\fr'; gives ?column? ---------- é r (1 row) I tried changing ...
    Thomas BouffonThomas Bouffon
    Jan 20, 2011 at 10:42 am
    Jan 20, 2011 at 3:37 pm
  • Hello. I read in the release notes for 9.0 "No longer automatically rename indexes and index columns when the underlying table columns are renamed (Tom Lane) " What does this mean? If I have a table ...
    A BA B
    Jan 18, 2011 at 9:32 am
    Jan 18, 2011 at 6:03 pm
  • hello, i have just started using postgresql .i wanted to know if i can get lowlevel access to database tables.i want to see my contents in spreadsheet like tabels and columns and being able to modify ...
    Nima GhorbanyNima Ghorbany
    Jan 8, 2011 at 5:58 am
    Jan 8, 2011 at 9:03 am
  • I am designing a table which will have about 70 fields per record and I wonder if this is a big number. The data types are boolean, varchar(maxlength), time, integer, smallint and numeric mainly. I ...
    JORGE MALDONADOJORGE MALDONADO
    Jan 5, 2011 at 8:28 pm
    Jan 5, 2011 at 8:42 pm
  • Buenas tardes, tengan todos los que conforman el equipo de soporte del portal de PostgreSQL. Sres. Somos un equipo de estudiantes de Ingenier\xEDa en Sistemas (Jose Urdaneta y Deibis Velasquez) los ...
    Ljochoa3Ljochoa3
    Jan 28, 2011 at 6:39 pm
    Jan 28, 2011 at 6:39 pm
  • Hey all, I was wondering if someone could tell me how to interact with pgAgent through queries similar to what pgadmin does. I want to embed some of the basic functionality such as listing the ...
    Bastiaan OlijBastiaan Olij
    Jan 25, 2011 at 12:00 am
    Jan 25, 2011 at 12:00 am
  • Hi all, I am using ECPG with PostgreSQL 9.0.2. I have datestyle set in the postgresql.conf to be 'SQL, DMY' and I get unexpected (to me :) ) results selecting dates from the database into a variable ...
    Mark SmithMark Smith
    Jan 18, 2011 at 6:17 pm
    Jan 18, 2011 at 6:17 pm
  • I am testing backup and restore so I made a backup of my database using pgAdmin III and accepted the default parameters shown in the interface. Then, I tried to restore it (accepting the default ...
    JORGE MALDONADOJORGE MALDONADO
    Jan 18, 2011 at 5:21 pm
    Jan 18, 2011 at 5:21 pm
  • Hi, Using postgreSQL 8.4 and Postgis 1.4 in an Ubuntu 10.04 Server, when trying to create a table: CREATE TABLE observation ( (...) spatial_value geometry, ); I get this error message: ERROR: type ...
    Plata Martínez, Álvaro (KNMI)Plata Martínez, Álvaro (KNMI)
    Jan 17, 2011 at 5:48 pm
    Jan 17, 2011 at 5:48 pm
  • hi, i often get the following when doing concurrent lowrite() to the same block. is it an expected behaviour? at least it would be more helpful if it returns a little more specific error than ...
    YAMAMOTO TakashiYAMAMOTO Takashi
    Jan 17, 2011 at 12:00 am
    Jan 17, 2011 at 12:00 am
  • Hi all, I'm running Debian|Squeeze, postgresql8.4, snort and snort-pgsql. The documentation I have read to date suggests that when starting snort it is possible to pass the password for the snort ...
    RichardRichard
    Jan 12, 2011 at 10:34 pm
    Jan 12, 2011 at 10:34 pm
Group Navigation
period‹ prev | Jan 2011 | next ›
Group Overview
grouppgsql-novice @
categoriespostgresql
discussions36
posts147
users59
websitepostgresql.org
irc#postgresql

59 users for January 2011

Tom Lane: 15 posts Mladen Gogala: 9 posts YAMAMOTO Takashi: 7 posts Bill P.: 6 posts David Patricola: 6 posts Jasen Betts: 6 posts Didier Gasser-Morlay: 5 posts BASIL BOURQUE: 4 posts Jan Eden: 4 posts Lew: 4 posts A B: 3 posts Chris Browne: 3 posts Chris Campbell: 3 posts Devrim Gündüz: 3 posts Josh Kupershmidt: 3 posts Leon Starr: 3 posts Thomas Kellerer: 3 posts Trupti Ghate: 3 posts Vibhor Kumar: 3 posts Peter: 2 posts
show more
Archives