Search Discussions

56 discussions - 160 posts

  • I have used Postgres a bit and actually use it as the back end for a program we use at my office. Truth is that it has worked so well that I have not had to mess with it for years at a time and then ...
    Mar 23, 2011 at 1:59 pm
    Mar 26, 2011 at 1:22 pm
  • Hi there, I have been having problems using the pg_dumpall function. I am trying to dump all the information on my database onto a file or view it. Actually what am trying to achieve is by using the ...
    Mar 30, 2011 at 1:22 am
    Mar 30, 2011 at 3:24 pm
  • LINUX UBUNTU 10.10 new installation I installed Postgres 8.4.7 using the openscg distribution packages/postgres-8.4.7-1.i386.openscg.deb The first problem was that the unix_socket_directory assumes ...
    Mar 21, 2011 at 3:32 pm
    Mar 27, 2011 at 7:00 pm
  • Hello, im trying to get postgresql working on iPhone. Everything builds fine, ./configure no flags. I have all binaries compiled, but when running initdb I get the familiar problem with "Bad System ...
    Andrew HoytAndrew Hoyt
    Mar 18, 2011 at 11:52 am
    Mar 26, 2011 at 1:22 pm
  • Hello everyone, I'm a postgres n00b and I'm trying to configure my installation to work with certificate authentication. It is not working for me, and it seems that the sysadmin community doesn't ...
    Marc-André LaverdièreMarc-André Laverdière
    Mar 28, 2011 at 5:09 am
    Apr 25, 2011 at 6:15 pm
  • Hi there, My name is Aaron and i am new to this forum. I am after a couple of things but would like to take it step by step. Firstly i have never used PostgreSQL which complicates matters, i have ...
    Mar 16, 2011 at 6:35 pm
    Mar 20, 2011 at 9:41 pm
  • In my application, I receive large blocks of external data that needs to be extracted / translated / loaded into the db, and many of these data are duplicates of what's already there. Consequently, I ...
    Robert PoorRobert Poor
    Mar 16, 2011 at 2:32 pm
    Mar 16, 2011 at 4:38 pm
  • Hello, I'm using postgreSQL and python (PyGreSQL) and face a strange problem. I have a double precision column in my DB (it's the time at which an image was taken expressed in second from UNIX ...
    Mathieu DuboisMathieu Dubois
    Mar 23, 2011 at 8:57 pm
    Mar 24, 2011 at 1:21 pm
  • I have switched to Postgres 9.0.3 runing on an Ubuntu server (latest version) Now when I try to use psql it does not accept the password for postgres or for any other user. The database is running OK ...
    Francisco LeoveyFrancisco Leovey
    Mar 10, 2011 at 6:02 pm
    Mar 15, 2011 at 1:22 am
  • Hi, I am looking for a solution to deal with a distributed database, using postgresql. (I know it can be done with Oracle, but the idea is to use an open/free alternative). I did quite a few searches ...
    Mar 8, 2011 at 10:20 am
    Mar 9, 2011 at 6:35 am
  • Hello to all! (Please excuse me if this is too noob and if it has already been asked/answered, in that case would you please point me towards the corresponding post or documentation? - TIA) I have a ...
    Barbara FigueiridoBarbara Figueirido
    Mar 1, 2011 at 2:03 am
    Mar 5, 2011 at 7:40 pm
  • I've pored over the syntax for UPDATE but I think I'm missing something. Assuming a schema such as: Column | Type | Modifiers ...
    Robert PoorRobert Poor
    Mar 29, 2011 at 8:42 pm
    Mar 30, 2011 at 6:16 pm
  • Hi vibhor, If there is no difference between functions and stored procedures, my doubt i show does the server know whether we are writing a function or stored procedure. As per my knowledge in oracle ...
    Siva kiran balijepalliSiva kiran balijepalli
    Mar 11, 2011 at 5:09 am
    Mar 14, 2011 at 6:29 am
  • I have PostgreSQL 9.0.1 correctly installed and working for a while. Now, I am facing the need of getting some tasks running automatically and I thought about using pgAgent, so, I downloaded version ...
    Mar 9, 2011 at 5:16 pm
    Mar 11, 2011 at 5:46 am
  • Hello every one, is it possible to migrate postgresql database from 8.3 to 8.4 version ? what about 8.3 to 9 ? 8.2 to 8.3 ? thanks regards .
    Mike lanMike lan
    Mar 30, 2011 at 6:50 pm
    Apr 4, 2011 at 12:21 pm
  • Assume this schema (looks best with fixed width font): # \d service_bills Table "public.service_bills" Column | Type | Modifiers ...
    Robert PoorRobert Poor
    Mar 29, 2011 at 5:03 pm
    Mar 29, 2011 at 5:18 pm
  • Greetings! All of the examples I can find for adding a number of minutes to a timestamp show the number of minutes being hard-coded in the query. I have a table that has a column containing a ...
    Rob RichardsonRob Richardson
    Mar 28, 2011 at 1:06 pm
    Mar 28, 2011 at 1:36 pm
  • Postgresql Dear Sirs: I have just downloaded Your latest database version. It is x86. My server is x64. Do You have a 64bit version. I didn't see one, but I can't believe You don't. Thanks, Mark T. ...
    Mark T. EvansMark T. Evans
    Mar 19, 2011 at 3:44 pm
    Mar 19, 2011 at 10:04 pm
  • Hi, We are contemplating some migrations to PostgreSQL, but I am having a hard time figuring out how to use the Continuous Archiving feature on the instance for our databases. We would like to have, ...
    Dem Fra Hedehusene i DanmarkDem Fra Hedehusene i Danmark
    Mar 11, 2011 at 9:14 am
    Mar 11, 2011 at 3:31 pm
  • Hi, I'm trying to create a function that updates fields according to the current date. One of the fields needs to be a numeric UTC value. So, I'm trying something like this: -- This rounds a ...
    Mar 10, 2011 at 9:52 pm
    Mar 11, 2011 at 2:52 am
  • Hi guys. Do we have a feature in postgresql so that we can schedule some activities? or we should use other tools. I want to add a job so that it creates a new table as a partition of main table each ...
    Majid AzimiMajid Azimi
    Mar 10, 2011 at 5:44 pm
    Mar 10, 2011 at 5:49 pm
  • Hi all, Can any one of u please tell me the diunction and a stored procedure?? In postgresql there is no command like "create or replace procedure"?? we haev to use "create function " for creating ...
    Siva kiran balijepalliSiva kiran balijepalli
    Mar 10, 2011 at 9:15 am
    Mar 10, 2011 at 9:58 am
  • Hi i am novice postgr sql user. I have created a table named customer in my data base. also i have inserter some of the rows into my table. when i try to execute this command to select object id's ...
    Siva kiran balijepalliSiva kiran balijepalli
    Mar 10, 2011 at 7:08 am
    Mar 10, 2011 at 9:56 am
  • Hey all, I was wondering if something ran into this before and has some answers to what may have gone wrong here. I set up my local little test server to allow for SSL connections only as I was ...
    Bastiaan OlijBastiaan Olij
    Mar 1, 2011 at 3:12 am
    Mar 1, 2011 at 5:58 am
  • Hello, I am having problem with PostgreSQl syntax. setting values anf how to call stored procedures with output parameteres. From what I have seen by googling the subject it seems that PostgreSQL ...
    Mar 18, 2011 at 12:05 pm
    Apr 5, 2011 at 6:22 pm
  • Hi, I am experimenting on postgresql 9.0 windows I am using CreateNamedPipe in windows I am using the command (with an corresponding custom win32 console app that opens and sends data) copy table ...
    Trent GeorgeTrent George
    Mar 26, 2011 at 11:31 pm
    Mar 27, 2011 at 6:16 pm
  • Hello, Has anyone downloaded and used the OSX 9.0.2 PostgresPlus installer package from EnterpriseDB? I have done this and having issues trying to edit the postgresql.conf file as well as the ...
    Bill P.Bill P.
    Mar 23, 2011 at 3:23 pm
    Mar 23, 2011 at 9:03 pm
  • Hi all, I just installed PG 9 on my Macbook (enterprisedb) just to start playing around with it. My Postgres 8.4 installation won't start now anymore, it is complaining about shared memory already ...
    Bastiaan OlijBastiaan Olij
    Mar 22, 2011 at 9:52 pm
    Mar 22, 2011 at 10:30 pm
  • Hi all, I'm attempting to use two tables and do the following in query: Return all instances where a unique rpt_id does not contain an fname entry of 'useOnlyMostRecentScan'. This should not return ...
    Mar 19, 2011 at 4:15 am
    Mar 19, 2011 at 10:16 pm
  • Hello, I want try localize your program into my native language, but I cannot find .pot or .po file and gettext dont process source files in my W7 instalation, because they dont contain error string ...
    Roman StasakRoman Stasak
    Mar 19, 2011 at 6:37 am
    Mar 19, 2011 at 12:37 pm
  • This query was working fine until I added another set of nested conditions... I've added three (3) asterisks (*) in front of each bit that I added before this error appeared, these are not in the ...
    Mar 19, 2011 at 4:55 am
    Mar 19, 2011 at 5:11 am
  • How to make a foreign key in pgAdmin ? I want to make a foreign key that references a primary key. A primary key is of type "serial", does that mean that foreign key should be "integer" or some other ...
    Mar 16, 2011 at 2:05 pm
    Mar 18, 2011 at 5:24 am
  • Dear all: Here is what I am trying to do. Suppose that I have a table called 'table_1' as follows id_no | FirstName ------------------------ 1111 | John 2222 | Joe 3333 | Susan 4444 | Eli Now a want ...
    Rex HuRex Hu
    Mar 17, 2011 at 4:06 am
    Mar 17, 2011 at 4:19 am
  • postgres 9.0.3 I am unable to connect from DBD::Pg 2.17.2 I have switched to Postgres 9.0.3 runing on an Ubuntu server 10.10 (latest version) I tried to changed all the pg_hba.conf host and local to ...
    Mar 16, 2011 at 5:06 pm
    Mar 16, 2011 at 10:01 pm
  • Hi every body What i sthe difference between these two sql statements? select * from function-name(); select function-name(); The outputs of these will be same but when should we use particular one. ...
    Siva kiran balijepalliSiva kiran balijepalli
    Mar 16, 2011 at 6:48 am
    Mar 16, 2011 at 2:22 pm
  • I'm getting syntax errors in what (I thought) is a simple query. This query works in SQLite, but in psql 8.3.14 gets: ERROR: syntax error at or near "WHERE" Here's the query: SELECT (d4.digit * 10000 ...
    Robert PoorRobert Poor
    Mar 15, 2011 at 11:44 pm
    Mar 16, 2011 at 12:15 am
  • Hi all, can anybody explain with simple example regarding the function valatality categories such as VOLATILE/STABLE/IMMUTABLE I have gone throught the documnetation but didn't had better ...
    Siva kiran balijepalliSiva kiran balijepalli
    Mar 14, 2011 at 8:56 am
    Mar 15, 2011 at 6:06 am
  • Hi. I set the database encoding to utf-8 (Croatian collation and character type) and when I try to add a new record via html form (the web page is also utf-8) I get, for example, &#273 instead of ...
    Mar 9, 2011 at 6:31 pm
    Mar 9, 2011 at 6:37 pm
  • Hi. Assuming I have a function like: CREATE FUNCTION f () RETURNS SETOF INTEGER LANGUAGE PLPgSQL AS $$ BEGIN RETURN QUERY SELECT * FROM t; END; $$; And I call: SELECT * FROM f LIMIT 10; Is Postgres ...
    Dan CastidoDan Castido
    Mar 8, 2011 at 5:15 pm
    Mar 8, 2011 at 5:50 pm
  • I have a DB created through my client program (the create script is ran upon installation) on linux server (Ubuntu) running PG 8.2.4 when I try to perform any action like running a script via psql I ...
    Lukasz BrodziakLukasz Brodziak
    Mar 8, 2011 at 10:42 am
    Mar 8, 2011 at 2:20 pm
  • I have several PostgreSQL databases in a server. Please recommend a procedure to get a backup of each one of them automatically. I would like to run a backup process from Monday to Sunday so I can ...
    Mar 7, 2011 at 6:19 pm
    Mar 7, 2011 at 6:54 pm
  • I've received a couple of spam messages that seem to be originating from this list. The To: field is undisclosed-recipients:, but all the headers seem to indicate it's coming from this list serve. I ...
    Brent DombrowskiBrent Dombrowski
    Mar 2, 2011 at 7:05 pm
    Mar 2, 2011 at 7:14 pm
  • Hi, Can i use anonymous function for creating trigger ? Best Regards, Rody
    Erwan TanajayaErwan Tanajaya
    Mar 2, 2011 at 6:01 am
    Mar 2, 2011 at 3:05 pm
  • I have an SSL enabled Redhat postgres box running. I'm trying to connect to it via remote client running ColdFusion 8, which is basically Java. I inserted root.crt into the Java cacerts storage and ...
    David PatricolaDavid Patricola
    Mar 30, 2011 at 2:27 pm
    Mar 30, 2011 at 2:27 pm
  • I set up server.crt, root.crt and servery.key in postgresql (using <http://howtoforge.com/postgresql-ssl-certificates http://howtoforge.com/postgresql-ssl-certificates for instructions), set ssl = on ...
    David PatricolaDavid Patricola
    Mar 24, 2011 at 8:02 pm
    Mar 24, 2011 at 8:02 pm
  • Hi all, i get the following error when attempting to do what's described in the title: mytest= \copy "public"."mytable4" ("my_int", "my_string") FROM data.dump DELIMITER E'\t' NULL 'NULL' CSV HEADER ...
    Antha LamusAntha Lamus
    Mar 24, 2011 at 7:57 pm
    Mar 24, 2011 at 7:57 pm
  • Hi, Can anyone explain what the FunctionCall2 and DirectFunctionCall2 do in fmgr.c? Regards, Raj
    Nick RajNick Raj
    Mar 24, 2011 at 7:04 am
    Mar 24, 2011 at 7:04 am
  • Out of root.crt, server.crt and server.key, which files do I need for a client connection to a remote postgresql server? I have these 3 files currently stored in C:\Documents and ...
    David PatricolaDavid Patricola
    Mar 22, 2011 at 8:06 pm
    Mar 22, 2011 at 8:06 pm
  • Hi every one can we combine composite and scalar variables in the same FETCH statement in cursors concept? thanking you, regards siva kiran.B
    Siva kiran balijepalliSiva kiran balijepalli
    Mar 17, 2011 at 5:05 am
    Mar 17, 2011 at 5:05 am
  • Is it possible to use Windows Task Scheduler (instead of pgAgent) to run automated batch files containing pg_dump commands? What is the difference between them? Respectfully, Jorge Maldonado
    Mar 14, 2011 at 5:39 pm
    Mar 14, 2011 at 5:39 pm
Group Navigation
period‹ prev | Mar 2011 | next ›
Group Overview
grouppgsql-novice @

65 users for March 2011

Tom Lane: 12 posts Aaronenabs: 9 posts Robert Poor: 9 posts Vibhor Kumar: 9 posts Chetan Suttraway: 7 posts Siva kiran balijepalli: 6 posts Barbara Figueirido: 4 posts David Patricola: 4 posts Francisco Leovey: 4 posts Leo: 4 posts Rob Richardson: 4 posts Thomas Kellerer: 4 posts Bastiaan Olij: 3 posts Brent Dombrowski: 3 posts Dem Fra Hedehusene i Danmark: 3 posts JORGE MALDONADO: 3 posts Joshua Tolley: 3 posts Mathieu Dubois: 3 posts Raghu ram: 3 posts Serge: 3 posts
show more