Search Discussions

80 discussions - 287 posts

  • Folks, Thanks so much for all your help. Many people quickly replied to my question with the information I needed. What I would like to do, use PostgreSQL and PHP, is list all the columns for a given ...
    Aug 22, 2005 at 8:47 pm
    Aug 28, 2005 at 2:48 am
  • I can't find a way to force a WAL to switch other than just generating a lot of changes in the database. I'd like to be able to switch to the next WAL before a hot backup, and then switch out one ...
    Walker, Jed SWalker, Jed S
    Aug 11, 2005 at 2:38 pm
    Aug 12, 2005 at 4:04 pm
  • Hi, In testing 8.1 I turned on the escape_string_warning. Now when I issue a COPY FROM / TO 'C:\\test' I am getting the "non standard.." warning since file paths in Windows use the \ character. I can ...
    Mike G.Mike G.
    Aug 30, 2005 at 4:22 pm
    Aug 30, 2005 at 11:24 pm
  • Thanks for the detailed response. I've forwarded this on to our network and server teams. There is one process that could be sending small queries/data back and forth that we are already working to ...
    Walker, Jed SWalker, Jed S
    Aug 26, 2005 at 7:19 pm
    Aug 26, 2005 at 10:06 pm
  • hi Bruno, the code is actually a single field. the reason it isn't just a numeric value is b/c i thought there would be value in making the code somewhat human readable. as it stands now, a person ...
    Aug 31, 2005 at 5:51 am
    Aug 31, 2005 at 6:04 pm
  • I have a situation where we have a timestamp column but in special cases we want to set the date to '01/01/0001' and leave the timestamp alone. For example, '11/04/2005 10:30:05' would become ...
    Walker, Jed SWalker, Jed S
    Aug 2, 2005 at 3:49 pm
    Aug 2, 2005 at 9:45 pm
  • I am using pgplsql on Windows 2003, PostgreSQL 8.0. I am trying to do some simple date arithmetic. All I wanted to do is take a timestamp (example: 2005-08-08 16:15:30) without a timezone, and ...
    Lane Van IngenLane Van Ingen
    Aug 8, 2005 at 8:26 pm
    Aug 31, 2005 at 9:55 pm
  • Hello, I have a table created with CREATE TABLE Current_academic_year ( year_id INT REFERENCES Academic_years, CONSTRAINT year_id CHECK(year_id IS NOT NULL), active BOOL NOT NULL, UNIQUE(year_id), ...
    Oliver KullmannOliver Kullmann
    Aug 16, 2005 at 4:43 pm
    Aug 19, 2005 at 6:41 am
  • Hi, I'm creating my first set up database's in postgres, my first db's every actually, and I have some questions about how to load data into one db in particular. The file i need to load is an USPS ...
    James NoblesJames Nobles
    Aug 9, 2005 at 11:58 pm
    Aug 11, 2005 at 9:31 pm
  • How can I see, such as MSSQL screen, all queries that are processing in real time? I want to monitor all the queries that are being processed by a user in real time. Thanks Flavio
    Flávio BritoFlávio Brito
    Aug 28, 2005 at 11:45 am
    Aug 28, 2005 at 2:23 pm
  • I'm trying to load a database ported from Oracle. The commands I was given to load data into the table are in alphabetical order; when I run them, I get errors because I'm violating RI rules (eg. ...
    Jim JarrettJim Jarrett
    Aug 8, 2005 at 1:49 pm
    Aug 15, 2005 at 5:38 pm
  • Hi, We have Postgres 7.3.2 installed for one of our internal softwares. The system configuration is: Red Hat Linux release 7.3 (Valhalla), 1 G RAM. The postmaster was running fine till last week and ...
    Saranya SivakumarSaranya Sivakumar
    Aug 15, 2005 at 2:10 pm
    Aug 15, 2005 at 5:22 pm
  • So far I've been relegated to phpPgAdmin to upload my data, but it has size limits, which I am exceeding. So I was told to ftp the backup files, and use PuTTY, which I've been trying to do. I'm ...
    Sean MontagueSean Montague
    Aug 7, 2005 at 11:37 pm
    Aug 14, 2005 at 11:13 pm
  • Hello. I have an instance of postgreSQL 7.4.7 with one database called dbmedia. We are moving to postgreSQL 8.1 running on windows2003 server. Can I just copy the entire $PGDATA directory to the new ...
    Adam O'TooleAdam O'Toole
    Aug 12, 2005 at 4:08 pm
    Aug 14, 2005 at 6:15 pm
  • Hi! I've got this message in the log of one of my software (message repeated every 3 minutes at least): "could not receive server response to SSL negotiation packet: Interrupted system call". What ...
    Vanessa ConchodonVanessa Conchodon
    Aug 11, 2005 at 10:11 am
    Aug 12, 2005 at 12:58 pm
  • I am writing a script and I need to output results to a file based on a table where the data to select is based on a 'last' date and an 'interval'. Essentially Name Last_date Interval Jed 2005-06-02 ...
    Walker, Jed SWalker, Jed S
    Aug 4, 2005 at 3:53 pm
    Aug 10, 2005 at 6:59 pm
  • Hello, I have a system converted from DB2 to PostGreSQL, running on eCS. The system has about 36 tables and maybe 10 views. I am writing a PGS backup procedure which includes a vacuumdb call. ...
    John J. UrbaniakJohn J. Urbaniak
    Aug 3, 2005 at 4:18 pm
    Aug 4, 2005 at 2:02 pm
  • Hi, Following on from my last question, I'm attempting to write a function that inserts periods. Periods are either bookings, available, or unavailable, each stored in a seperate table, and all have ...
    Neil SaundersNeil Saunders
    Aug 19, 2005 at 3:21 pm
    Aug 25, 2005 at 6:46 pm
  • Hello. I believe, any procedure language function is a transaction block, and I think, I even read this somewere in docs, but can not find where now, so, is it true, for all languages (SQL, PL/pgsql, ...
    Alexander KotelnikovAlexander Kotelnikov
    Aug 10, 2005 at 1:40 pm
    Aug 11, 2005 at 1:24 pm
  • Is there someone out there that can explain to us mortals how to get Postgresql 8.0.3 server successfully installed on Red Hat ES 3? I finally got 7.3.10 to install but no matter what other version I ...
    Aug 14, 2005 at 10:12 pm
    Sep 13, 2005 at 3:44 pm
  • Hello All, Does any one know how disable a specific trigger i know the following way to disable trigger but it disables system generated default triggers too. UPDATE pg_catalog.pg_class SET ...
    Prasad devPrasad dev
    Aug 30, 2005 at 3:00 am
    Aug 30, 2005 at 9:40 pm
  • Hello all, say for example I have a larger table T with 26 millions rows, one million associated with each letter of the alphabet. I have a long running process which does a 'SELECT ID FROM T'. The ...
    Alan StangeAlan Stange
    Aug 29, 2005 at 7:11 pm
    Aug 29, 2005 at 8:09 pm
  • hi list in ms-sql it is possible to specify the default order for an index (i.e. asc/desc). is this possible in pgsql as well, and if yes, how? i have some timestamp indices that i only use to sort ...
    Aug 27, 2005 at 3:34 pm
    Aug 27, 2005 at 7:46 pm
  • We are needing to cut-down network traffic between our PostgreSQL client and server. The network team says that PostgreSQL is transferring data in 256k packets with acks of around half that size. Is ...
    Walker, Jed SWalker, Jed S
    Aug 26, 2005 at 4:03 pm
    Aug 26, 2005 at 6:35 pm
  • Hi Guys, I'm trying to write my first stored procedure. The database keeps track of calendar entries for properties. I'm not a DB expert, so if you notice any flaws or improvements that could be made ...
    Neil SaundersNeil Saunders
    Aug 18, 2005 at 3:31 pm
    Aug 23, 2005 at 6:07 am
  • Hello, I'm super new to PostgreSQL, but not SQL or RDAs in general. I have inherited a system where no one knows anything about it. I'd like to start by just finding out what databases are on it, and ...
    Aug 22, 2005 at 7:00 pm
    Aug 22, 2005 at 7:47 pm
  • I am wondering how daylight savings is handled by PostgreSQL. We are timestamps with time zones, and are wondering if it's possible to specify a timezone as ET instead of EST or EDT. Do we have to ...
    Walker, Jed SWalker, Jed S
    Aug 4, 2005 at 7:55 pm
    Aug 4, 2005 at 9:36 pm
  • Use a string type, but only allow certain characters. Gord
    Gordon HaverlandGordon Haverland
    Aug 3, 2005 at 9:56 pm
    Aug 4, 2005 at 4:55 am
  • hi list for our discussion board i've successfully set up a trigger to have tsearch2 index the record every time it is updated. this works fine, but also triggers the reindex of the record every time ...
    Aug 30, 2005 at 12:47 am
    Sep 2, 2005 at 2:49 am
  • Hi list the following commandline query doesn`t work..... why? please help su - postgres -c 'psql --dbname database --command "UPDATE users SET pin=12345 WHERE login='admin';"' -- 5 GB Mailbox, 50 ...
    Aug 31, 2005 at 12:14 pm
    Aug 31, 2005 at 2:27 pm
  • Hello everybody! I'm so sorry to post this simple question but I don't know what to do anymore!!!, the thing is I need to install postgresql 8.0.3 in red hat 9 and I've tried so many things that I ...
    Ricardo GameroRicardo Gamero
    Aug 30, 2005 at 9:16 pm
    Aug 31, 2005 at 3:26 am
  • Hi folks, is it just me or are there a lot of dupes of mails coming from this list? Obviously noone else is complaining so it might be on my side though I can't think of a source. I've got simply ...
    Aug 29, 2005 at 8:28 pm
    Aug 30, 2005 at 6:58 pm
  • Hi all, I have this query that I am trying to optimize. SELECT c.countryid, r.regionid FROM ip_g ip LEFT OUTER JOIN country c ON (CASE WHEN ip.country='rom' THEN 'ROU' ELSE upper(ip.country) ...
    Saranya SivakumarSaranya Sivakumar
    Aug 25, 2005 at 8:25 pm
    Aug 28, 2005 at 9:19 pm
  • Hi - I'm very new to pgsql and still very stupid. Can someone point me in the right direction pls. I run server v8.0 on an XP box and when I create new schems and tables in a database with PGAdminIII ...
    Alex du PlessisAlex du Plessis
    Aug 23, 2005 at 1:06 am
    Aug 27, 2005 at 2:40 pm
  • I'm setting up PostgreSQL for a small academic lab, where I work. The host OS is Linux (Debian). I want to allow most users to connect to the database without having to supply a password, but I want ...
    Aug 25, 2005 at 7:31 pm
    Aug 26, 2005 at 4:34 am
  • Hi I am new to Postgres. I was trying to create a new data type. There is an eg for creating a type complex under src/tutorial. I went under the tutorial dir and tried doing a gcc -fpic -c complex.c ...
    Mogin MohandasMogin Mohandas
    Aug 22, 2005 at 6:46 pm
    Aug 23, 2005 at 6:09 am
  • Hi, We need to add an interval (from a row in a table) to the curren time. Basically, Table1 has the column offset_in_secs that is an integer. Select current_timestamp + '<offset_in_secs seconds' ...
    Walker, Jed SWalker, Jed S
    Aug 15, 2005 at 8:27 pm
    Aug 15, 2005 at 8:52 pm
  • Hi all, How can i check the postgresql is compiled with ssl or not. I mean i have already installed pgsql server, now i want an ssl connection,so how can i check whether i have compiled with ssl ...
    Aug 8, 2005 at 3:04 pm
    Aug 11, 2005 at 12:53 pm
  • (I'm sending this again, because the original somehow got split into two posts) I am writing a script and I need to output results to a file based on a table where the data to select is based on a ...
    Walker, Jed SWalker, Jed S
    Aug 4, 2005 at 7:24 pm
    Aug 4, 2005 at 8:21 pm
  • Hi Gang, I am trying to concatenate 2 values plus an asterisk in between them, like this: value1*value2. My function keeps breaking =( Please can someone show me the proper syntax to fix my function? ...
    Dane EnsignDane Ensign
    Aug 4, 2005 at 4:41 am
    Aug 4, 2005 at 5:16 am
  • I'm about to add another table to the project I'm working on and the suggested plan of action is to use arrays. Since performance is an issue, I'm wondering, what exactly is the difference? in other ...
    Oren MazorOren Mazor
    Aug 29, 2005 at 6:43 pm
    Aug 30, 2005 at 2:40 pm
  • Thank you for your reply. It helped me, but I need know some results. So I tryed use SELECT INTO in EXECUTE string and it do not work. Also I try this: CREATE OR REPLACE FUNCTION n(varchar) RETURNS ...
    Jaromír KamlerJaromír Kamler
    Aug 29, 2005 at 9:13 am
    Aug 30, 2005 at 3:18 am
  • Please, help me. I am new with PostgreSQL, I need create function in plpgsql where I use SQL question on the name of table whitch is given by variable in called function. Here is absolutly simple ...
    Jaromír KamlerJaromír Kamler
    Aug 28, 2005 at 9:43 pm
    Aug 28, 2005 at 9:56 pm
  • hi list we're lately migrating our MSSQL server to PGSQL 8. the performance is great and i'm more than happy with PG. still, i've found quite a lot of the following logfile entries: 2005-08-26 ...
    Aug 27, 2005 at 1:34 am
    Aug 27, 2005 at 5:19 am
  • Hi, I have a function that exists (I can call it and execute it) but does not appear in pgadmin. I issued an Alter function owner to postgres (the super user) which was successful to check if it was ...
    Mike G.Mike G.
    Aug 25, 2005 at 8:11 pm
    Aug 25, 2005 at 9:44 pm
  • Hi, I would like to write a PL/PGSQL function that would escape any occurence of single quotes in a string, and call this function before inserting the unescaped strings into some tables. Is this a ...
    Saranya SivakumarSaranya Sivakumar
    Aug 24, 2005 at 1:39 pm
    Aug 24, 2005 at 3:14 pm
  • Hi. I would like to be able to have a version of a database for production and one for development. How can I set things up to facilitate the process of updating the production database so that it ...
    Aug 21, 2005 at 3:20 pm
    Aug 21, 2005 at 4:58 pm
  • We have written a trigger on insertion which is supposed to update 3 tables with new data. We are seeing a weird thing happening with Postgres, i.e. If we have 4 records to be updated on insertion ...
    Venkatesh KrishnamurthyVenkatesh Krishnamurthy
    Aug 15, 2005 at 1:01 pm
    Aug 19, 2005 at 7:30 am
  • I want a column which is like a SERIAL, except that values can be changed after insertion without anything breaking. In other words, I don't want an error like this one to occur: database= CREATE ...
    Leif K-BrooksLeif K-Brooks
    Aug 17, 2005 at 1:01 am
    Aug 17, 2005 at 4:47 am
  • Hi there, I have a problem that I'm not even 100% certain of how to word: I'm writing a little postgres-app with a web-frontend. I was going to map users to actual postgres users, but someone on ...
    Andrej Ricnik-BayAndrej Ricnik-Bay
    Aug 15, 2005 at 6:35 pm
    Aug 15, 2005 at 7:58 pm
Group Navigation
period‹ prev | Aug 2005 | next ›
Group Overview
grouppgsql-novice @

84 users for August 2005

Tom Lane: 34 posts Operationsengineer1: 32 posts Michael Fuhr: 20 posts Walker, Jed S: 17 posts Bruno Wolff III: 16 posts Kretschmer Andreas: 9 posts Bruce Momjian: 7 posts Oliver Elphick: 6 posts Alexander Kotelnikov: 5 posts Saranya Sivakumar: 5 posts Me: 4 posts Adam O'Toole: 4 posts Cbraden: 4 posts Charley L. Tiggs: 4 posts Gnanavel S: 4 posts John DeSoi: 4 posts Mike G.: 4 posts Oliver Kullmann: 4 posts Philip Hallstrom: 4 posts Sean Davis: 4 posts
show more