Search Discussions

52 discussions - 165 posts

  • Is it possible to lock a database user in 8.4 after several failed login attempts? I looked through the docs, but couldn't find anything about this. Thanks, Mike
    Mike ThomsenMike Thomsen
    Jun 29, 2011 at 1:54 pm
    Jul 1, 2011 at 10:51 pm
  • Hello list, Using PostgreSQL 9.0.2 I'm trying to write a sql statement to extract specific rows from the following data set. I've looked at the documentation that talks about the Max() function but ...
    Chris CampbellChris Campbell
    Jun 30, 2011 at 10:01 pm
    Jul 1, 2011 at 1:28 pm
  • I need to get the latest entry of a large table matching a certain criteria. This is my query: SELECT * FROM "data" WHERE "data"."fk" = 238496 ORDER BY "data"."id" DESC LIMIT 1 This query is quite ...
    Odd HogstadOdd Hogstad
    Jun 29, 2011 at 1:56 pm
    Jun 30, 2011 at 10:01 am
  • Hello In our project table we have a column with costs, using data typ "money". By default PostgreSQL always applys '$', but we would like to have '€'. How can I change the data type "money" ...
    Mäggi HieberMäggi Hieber
    Jun 30, 2011 at 4:11 pm
    Jul 1, 2011 at 12:12 am
  • Hello, I'm having some trouble trying to use postgresql locks. After trying several options and reading the postgresql online documentation, I still can't figure out what I'm doing wrong. Here's the ...
    Vincent FicetVincent Ficet
    Jun 29, 2011 at 3:12 pm
    Jul 5, 2011 at 7:14 am
  • Dear all, I want to make a primary key for my table based upon a few other columns. I do this with the following code: ALTER TABLE camdengps2 ADD COLUMN camdencrimes_link varchar; UPDATE camdengps2 ...
    James David SmithJames David Smith
    Jun 17, 2011 at 11:12 am
    Jun 18, 2011 at 6:01 pm
  • Working on my dev system, I did a web site last year using PHP and PostgreSQL 8.4. All went great and the site has been up and running with no problems for over a year now. The want some ...
    Carlos BrooksCarlos Brooks
    Jun 28, 2011 at 4:13 pm
    Jun 28, 2011 at 7:49 pm
  • Hi list, I've got an query which contains || inside the select statement and I'm not sure, what this is doing. Can you help me out a bit or send me a link to documentation where I can find this? ...
    Frank LanitzFrank Lanitz
    Jun 27, 2011 at 1:08 pm
    Jun 27, 2011 at 1:18 pm
  • Hi list, I've got some questions about this function: ============================= DROP FUNCTION tsttst(TEXT, TEXT, BOOLEAN, INT8, INT8, TEXT[]); CREATE FUNCTION tsttst(TEXT, -- FQTN TEXT, -- ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Jun 22, 2011 at 7:30 pm
    Jun 22, 2011 at 9:55 pm
  • Hi, Is there a better PL/pgSQL editor/debugger than pgAdmin III available anywhere? Thank's -- *Ing. Erasmo Zottola* /R & D: Software and Network Engineer/ *ELMAN S.r.l.* Via di Valle Caia, km 4,700 ...
    Erasmo Zottola - ElmanErasmo Zottola - Elman
    Jun 8, 2011 at 2:46 pm
    Jun 19, 2011 at 8:21 pm
  • Hi I have a table defined as follows: CREATE TABLE mytable ( seqnumber BIGSERIAL; ... ) and I have multiple threads inserting into the table. If multiple threads insert at the same time, will the ...
    Jun 14, 2011 at 7:01 pm
    Jun 15, 2011 at 12:34 pm
  • Hi list, [Don't feed the troll: images *will stay* in table(s)] I've need to store many images (BYTEA): items pictures, items datasheets PDFs and documents PDFs (suppliers & clients.) The logical way ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Jun 12, 2011 at 7:34 pm
    Jun 12, 2011 at 9:41 pm
  • Hello, I recognised this problem already some years ago using FreeBSD and Debian - but I ran into it again yesterday and I am not sure if this is psql related or not postgresql related at all. Let me ...
    Susanne EbrechtSusanne Ebrecht
    Jun 29, 2011 at 6:44 am
    Jun 29, 2011 at 10:24 am
  • Hi list, Is there a possibility for a dbA to immediately terminate a working user connection? JY --
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Jun 28, 2011 at 6:16 pm
    Jun 29, 2011 at 5:07 am
  • I am going to be setting up OTRS, a help desk application, and the backend is going to be Postgres, along with this I need to create a separate application to track whether or not a customer has a ...
    Matty jonesMatty jones
    Jun 16, 2011 at 12:50 pm
    Jun 27, 2011 at 3:19 pm
  • How can I search a multidimensional array for an EXACT "subarray" match? The following produces true when I want it to produce false. Obviously, I would only want it to produce true for ARRAY[1,2], ...
    Arthur M. KangArthur M. Kang
    Jun 10, 2011 at 4:00 pm
    Jun 10, 2011 at 8:49 pm
  • Hi folks I have the following function in a file called deletescript.sql. CREATE OR REPLACE FUNCTION delete_items() RETURNS integer AS ' DECLARE m RECORD; n RECORD; BEGIN FOR m in SELECT item_id from ...
    Saqib IlyasSaqib Ilyas
    Jun 6, 2011 at 3:58 pm
    Jun 6, 2011 at 4:34 pm
  • Hi, I have a remote server with PostgreSQL on it. When I try to connect via python/pygresql, I get: pg.InternalError: could not connect to server: Connection refused Is the server running on host ...
    Daniel WeitzenfeldDaniel Weitzenfeld
    Jun 30, 2011 at 2:08 am
    Jun 30, 2011 at 11:05 am
  • Hi list, As of '39.5: plpgsql-statements', it is said that using '$n' instead of a named variable is prefered and less sensitive to a SQL injection. Does it really mean if I use $n I don't have to ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Jun 22, 2011 at 1:49 pm
    Jun 22, 2011 at 7:05 pm
  • Hello, I have created a job in pgAdmin III, but it is not running. The job suppose to do an insert into a table. It seems like it is not running at all. First I thought there is something with ...
    Leon MatchLeon Match
    Jun 21, 2011 at 8:11 pm
    Jun 21, 2011 at 9:45 pm
  • hello ! I having an issue with my postgres database installed on a windows xp. For some reason, I can no longer start the postgres service through pgadmin or the services window. I get the following ...
    Roman IsituaRoman Isitua
    Jun 20, 2011 at 6:39 am
    Jun 20, 2011 at 7:09 pm
  • Hi, I have a table with following sample data. Village_name Date Label A 1991-01-31 0 A 1991-04-28 0 A 1991-07-15 0 B 2000-02-15 0 B 2000-04-13 0 B 2001-09-13 0 C 1995-07-12 0 C 1995-10-13 0 I need ...
    Jun 17, 2011 at 10:17 am
    Jun 17, 2011 at 11:32 am
  • I have installed 9.1beta2 in Ubuntu, the 9.1 folder under /etc/postgresql is missing, what could i be doing wrong.
    Sindile BidlaSindile Bidla
    Jun 15, 2011 at 3:42 pm
    Jun 16, 2011 at 7:56 am
  • i'm sorry, but this is nothing but the immediate expression of my frustration with pgAdmin III: i thought this tool was quasi the "official" postgres GUI and tried to use it to edit larger text ...
    Matthias LeopoldMatthias Leopold
    Jun 9, 2011 at 3:50 pm
    Jun 10, 2011 at 8:17 am
  • Hi everyone, A bit of help please. This query works for me, and gives me 332,000 rows of records out of my table of 400,000 rows. It takes about a minute to run. SELECT vehicle.* FROM vehicle, ...
    James David SmithJames David Smith
    Jun 8, 2011 at 9:58 pm
    Jun 9, 2011 at 4:27 pm
  • Hi list, I noticed that creating an index against a BYTEA is possible; shall I assume I must index NULL value and exclude others, otherwise they'll be replicated into the index file? JY -- The number ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Jun 1, 2011 at 10:09 pm
    Jun 4, 2011 at 4:15 pm
  • Hi All I am fairly newbie to Postgresql and need to have the following done. ---- There have been a lot of data loads onto one of the databases and has resulted in some of the day to day queries to ...
    Machiel RichardsMachiel Richards
    Jun 29, 2011 at 10:20 am
    Jul 4, 2011 at 3:12 pm
  • I want to trap this exception... ERROR: nextval: reached maximum value of sequence ...and print a user friendly message. But I can't figure out what exception code to test for. Example: exception ...
    Leon StarrLeon Starr
    Jun 22, 2011 at 4:13 am
    Jun 22, 2011 at 8:13 pm
  • Hi list, I'm trying to test CHECK constraints on command line but I miss something: SELECT '1234567890123' ~ 'CHECK(char_length(VALUE) = 13)'; always return FALSE :( JY -- "What did you do when the ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Jun 17, 2011 at 4:12 am
    Jun 21, 2011 at 9:53 pm
  • Hi list, Is there an easy way to discard Pg default md5 password hashing and replace it by SHA256 (or SHA512) + salt? JY -- Psychiatry is the care of the id by the odd.
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Jun 17, 2011 at 7:56 am
    Jun 21, 2011 at 9:48 pm
  • i am getting the following error when i try to run 'createdb' command from within the bin directory .. /bin$ ./pg_ctl -D ...
    Jun 21, 2011 at 4:56 am
    Jun 21, 2011 at 7:33 am
  • Hi, I have two machines that have the same database with the same table and indexes (definitions are exactly the same). I compared the postgresql.conf and they are the same. Still the SQL query plan ...
    Ron ArtsRon Arts
    Jun 19, 2011 at 5:48 pm
    Jun 19, 2011 at 6:14 pm
  • Hi, I have following table data: site_id village_name Date depth flag W001 Akoli 1991-01-31 3.5 W001 Akoli 1991-03-31 3.7 W001 Akoli 1991-05-31 4.35 W001 Akoli 1992-01-31 2.9 W001 Akoli 1992-03-31 4 ...
    Jun 18, 2011 at 6:32 pm
    Jun 18, 2011 at 7:10 pm
  • Hi, I have a table with following sample data: site_id village_name Date depth flag W001 Akoli 1991-01-31 3.5 W001 Akoli 1991-03-31 3.7 W001 Akoli 1991-05-31 4.35 W001 Akoli 1991-09-23 1 W001 Akoli ...
    Jun 18, 2011 at 11:38 am
    Jun 18, 2011 at 1:35 pm
  • I am using the following formatting function for a date field and I get the name of the month in English language. How can I get it in Spanish? to_char(sea_fecha,'MONTH DD, YYYY') as sea_fecha_aux ...
    Jun 17, 2011 at 5:18 pm
    Jun 17, 2011 at 5:27 pm
  • Hi all, I'm using a PostgreSQL + PostGIS database for a large project at the moment, and would like advice on the best way to back it up incase something goes wrong or I delete something by accident ...
    James David SmithJames David Smith
    Jun 16, 2011 at 1:46 pm
    Jun 16, 2011 at 1:56 pm
  • Hello, Is it possible to pass the name of the table to update to a given function ? For example, how can I do something like: CREATE FUNCTION compute_ipaddr(CHARACTER VARYING, INET) AS $_$ DECLARE ...
    Vincent FicetVincent Ficet
    Jun 14, 2011 at 7:27 am
    Jun 14, 2011 at 1:43 pm
  • Hi, I am currently doing a vacuum once a week. But i still see something called autovacuum that runs during peak hour which is causing high load. Is it possible to run this autovacuum during a ...
    Maalini SamuganardanMaalini Samuganardan
    Jun 14, 2011 at 8:59 am
    Jun 14, 2011 at 9:43 am
  • Hi list, The DB owner created a function as: CREATE FUNCTION mysch.testaddint(int, int) RETURNS int AS $$ SELECT $1+$2 $$LANGUAGE sql; When usr1 is granted usage on domain mysch he can execute this ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Jun 14, 2011 at 12:39 am
    Jun 14, 2011 at 2:24 am
  • Hi list, I intend to recover domains type (I/O) and their constraints from my DB in order to simplify the program that access the DB (so, using types & constraints to auto-implement them into my ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Jun 12, 2011 at 5:05 am
    Jun 13, 2011 at 7:22 pm
  • Hello group Using Postgres 9.0.3 I need a SQL statement that will tell me if a given table is defined WITH (OIDS=TRUE) I am able to get column names, data types, etc but this eludes me. Thank you
    Francisco LeoveyFrancisco Leovey
    Jun 13, 2011 at 11:58 am
    Jun 13, 2011 at 1:28 pm
  • Hello, Is there a good tool that allows to indent PLPGSQL code easily ? Thanks for your help Vincent
    Vincent FicetVincent Ficet
    Jun 10, 2011 at 7:18 am
    Jun 10, 2011 at 1:24 pm
  • Hello all, I would need advice regarding upgrade. I have a small server running RHEL 5.2 32bit / Postgresql 8.3.3. I would like to upgrade Postgres to 9.0 on a new server running RHEL 5.5 but 64bit. ...
    Jun 3, 2011 at 10:17 am
    Jun 3, 2011 at 5:33 pm
  • Hi all, I have a simple problem, but don't know any simple solution for it. I have a list of (millions) of couple (url1, url2), where url1 and url2 are strings. I have imported this list in a table ...
    Vincent MichelVincent Michel
    Jun 30, 2011 at 4:47 pm
    Jun 30, 2011 at 4:47 pm
  • Hello, Let's cut to the chase: I need to select,*for each residential building* in my table *that has say at least 2 pharmacies and 2 education centers* within a radius of X km, all POIs (pharmacies, ...
    Jun 25, 2011 at 12:49 pm
    Jun 25, 2011 at 12:49 pm
  • I can not be the first person to have this problem but can't find any definitive info that seems to address this. I'm using Visual Studios C++ Express 2008 on Windows 7 with the "standard" ...
    Roy's EmailRoy's Email
    Jun 25, 2011 at 7:05 am
    Jun 25, 2011 at 7:05 am
  • Hi list, I wonder if it is possible to do so? eg: security definer function checks session_user privileges against a table (or whatever) and call another function to create a prepared statement AS if ...
    Jean-Yves F. BarbierJean-Yves F. Barbier
    Jun 22, 2011 at 1:54 pm
    Jun 22, 2011 at 1:54 pm
  • I am trying to set up a sequence that assigns values within a specific range, say 1-99. But, for my particular application, I need the ability to de-allocate a number that was previously assigned, ...
    Leon StarrLeon Starr
    Jun 21, 2011 at 7:04 pm
    Jun 21, 2011 at 7:04 pm
  • I'm using 8.4 and read these docs: http://www.postgresql.org/docs/8.4/static/ssl-tcp.html 1. Are root.crl and root.crt optional when using self-signed certificates? 2. I'm using RHEL 5. Should ...
    Mike ThomsenMike Thomsen
    Jun 21, 2011 at 12:45 pm
    Jun 21, 2011 at 12:45 pm
  • Hi Everybody ! I'm just wondering what is really better in terms of performance ... I have a large function that makes many things, and I must control the exception of some parts of the code ... ...
    Charles N. CharottiCharles N. Charotti
    Jun 9, 2011 at 4:10 pm
    Jun 9, 2011 at 4:10 pm
Group Navigation
period‹ prev | Jun 2011 | next ›
Group Overview
grouppgsql-novice @

64 users for June 2011

Jean-Yves F. Barbier: 30 posts Merlin Moncure: 13 posts Thom Brown: 9 posts James David Smith: 6 posts Vincent Ficet: 5 posts Andreas Kretschmer: 4 posts LALIT KUMAR: 4 posts Mike Thomsen: 4 posts Odd Hogstad: 4 posts Alan Hodgson: 3 posts Carlos Brooks: 3 posts Chris Campbell: 3 posts Josh Kupershmidt: 3 posts Michael Wood: 3 posts Oliveiros d'Azevedo Cristina: 3 posts L1: 2 posts Arthur M. Kang: 2 posts Charles N. Charotti: 2 posts Erasmo Zottola - Elman: 2 posts Francisco Leovey: 2 posts
show more