FAQ

PostgreSQL > pgsql-general > July 2004

Search Discussions

254 discussions - 962 posts

  • Hi folks, I'm new to Postgres and trying to get up to speed on the security issues. There seems to be remarkably little Postgres specific stuff on preventing SQL injection attacks. Most of the online ...
    Geoff CaplanGeoff Caplan
    Jul 19, 2004 at 7:14 pm
    Jul 29, 2004 at 3:38 pm
  • I need to be able to build postgres (7.4.3) with a given --prefix, but then pack up the installation directory and deploy it in another directory (as part of a product install, for instance). I ...
    David ParkerDavid Parker
    Jul 15, 2004 at 8:05 pm
    Aug 31, 2004 at 10:23 am
  • Dear my friends... I am using SuSE Linux 9.1 and postgres. I am a beginner in postgres, usually I use MySQL. I have 3 tables : appointment, appointment0 and appointment1. the fields of table ...
    Prabu SubrotoPrabu Subroto
    Jul 27, 2004 at 11:58 am
    Jul 29, 2004 at 6:35 am
  • Yesterday, while attempting to access a database, I received errors saying that the database was innaccessible. After investigating a little, I found the following in the PostgreSQL log files: ...
    Christopher CashellChristopher Cashell
    Jul 1, 2004 at 12:57 am
    Jul 4, 2004 at 8:44 am
  • Hi, i am using PostgreSQL 7.3.2 there's a bug for the date '2005-03-27' !!!!!!!!!!!!!!!!!!!!!!!!!!! SELECT to_char('2005-03-27'::date,'DD/MM/YYYY'); to_char ------------ 26/03/2005 (1 row) I get the ...
    Najib Abi FadelNajib Abi Fadel
    Jul 1, 2004 at 6:50 am
    Jul 7, 2004 at 6:15 am
  • Dear my friends... I am using postgres 7.4 and SuSE 9.1. I want to use auto_increment as on MySQL. I look up the documentation on www.postgres.com and I found "serial" . But I don't know how to ...
    Prabu SubrotoPrabu Subroto
    Jul 28, 2004 at 3:24 am
    Jul 29, 2004 at 7:15 am
  • Please CC me: If I create the user 'web_user' with password 'password' I can connect using 'psql' just fine. If I create the user 'D1Khb2g5m7FGk_web_user' with password 'password' I CANNOT connect ...
    Dennis GearonDennis Gearon
    Jul 3, 2004 at 7:08 pm
    Jul 4, 2004 at 1:50 am
  • Hi folks, The thread on injection attacks was very instructive, but seemed to run out of steam at an interesting point. Now you guys have kindly educated me about the real nature of the issues, can I ...
    Geoff CaplanGeoff Caplan
    Jul 31, 2004 at 9:09 am
    Aug 14, 2004 at 9:13 am
  • Hi: I'm getting this error when accessing a table with certain WHERE condition: "server closed the connection unexpectedly This probably means the server terminated abnormally before or while ...
    RubenRuben
    Jul 5, 2004 at 11:43 pm
    Jul 18, 2004 at 8:31 pm
  • I am trying to figure out if there is a way to determine the timezones supported in postgresql from within the database. If you look at ...
    Robert TreatRobert Treat
    Jul 14, 2004 at 7:17 pm
    Jul 15, 2004 at 2:03 pm
  • To begin with I am not sure this is a correct place to post this, if not please let me know. The PostgreSQL traditionally refuses to run under root account on Unix (for security reasons). On win32 ...
    NobodyNobody
    Jul 7, 2004 at 1:28 pm
    Jul 12, 2004 at 12:20 pm
  • Hi, I tried to install phpopenchat but I can't create this table: poc= CREATE TABLE poc_user_account ( poc( USER varchar(255) NOT NULL, poc( PASSWORD varchar(255), poc( CONFIRM_CODE char(32), poc( ...
    Thomas MuellerThomas Mueller
    Jul 7, 2004 at 9:01 pm
    Jul 9, 2004 at 7:27 am
  • If I bought one of these boxes/OS combos as a postgresql database server, would postgresql be able to make the best use of it with a huge (e.g. 40GB) database? Box: HP ProLiant DL585, with 4 AMD64 ...
    Andy BAndy B
    Jul 1, 2004 at 12:44 pm
    Jul 6, 2004 at 8:52 pm
  • Hi.. I am newbe in postgresql so please help me though the question may be very easy to answer.. Is there any formatting function to get output with fix lengths..for example my query is.. schema is: ...
    Vinay JainVinay Jain
    Jul 5, 2004 at 5:19 am
    Jul 6, 2004 at 4:14 pm
  • Hi everyone, I'm trying to calculate an output column which is the difference of two other columns in the query output; the first column is an aggregate of items in stock, while the second column is ...
    Mark Cave-AylandMark Cave-Ayland
    Jul 16, 2004 at 2:31 pm
    Aug 23, 2004 at 4:59 pm
  • Imagine i have a table A with primary key "p" and another attribute called "data": SELECT * from A, A, B; here, i will have 2 columns "data", PQftable tells me that they are from A, but which of the ...
    Michal MaruškaMichal Maruška
    Jul 16, 2004 at 1:38 am
    Jul 20, 2004 at 6:38 am
  • Hi, I am seeing a different sorting behaviour for varchar columns in Postgres 7.4.2. postgres 7.4.2 is ignoring case for varchar columns for "ORDER BY" commands where as 7.2.2 is not. I am in a ...
    Gunasekaran BalakrishnanGunasekaran Balakrishnan
    Jul 20, 2004 at 12:14 pm
    Aug 5, 2004 at 6:31 am
  • Hi, i searched the docs and the archives and was really wondering that i have not found anything searching for "functional index primary key". i would like to have a table of members with nicknames ...
    Janning VygenJanning Vygen
    Jul 31, 2004 at 1:51 pm
    Aug 2, 2004 at 4:58 pm
  • Hi everyone at the list, Some months ago i asked you some questions about 7.2 - 7.4.3 migration. Then i switched to the performance list to complain about postgres 7.2 poor performance and discussed ...
    Christophe MusielakChristophe Musielak
    Jul 30, 2004 at 12:34 pm
    Jul 30, 2004 at 4:46 pm
  • Hi, I have my database stoping by itself during a vacuum full analyse; Impossible to restart it ... I have this message : Jul 17 22:03:09 stats-ugc postgres[7239]: [2-1] LOG: database system was shut ...
    Hervé PiedvacheHervé Piedvache
    Jul 17, 2004 at 8:05 pm
    Jul 18, 2004 at 2:58 am
  • I looked through the docs and contrib, but didn't see anything related to storing and using latitude and longitude values. I have data in the form of 12° 34' N, 12° 34' W. Would any of the geometric ...
    CSNCSN
    Jul 12, 2004 at 6:53 pm
    Jul 13, 2004 at 8:03 pm
  • I can't seem to get right the regular expression for parsing data like these four sample rows (names and addresses changed to ficticious values) from a text-type column: Yolanda Harris, 38, of 40 ...
    BtoberBtober
    Jul 6, 2004 at 12:38 am
    Jul 10, 2004 at 4:03 am
  • I've been running a postgres server on a Mac (10.3, 512MB RAM) with 200 clients connecting for about 2 months without a crash. However just yesterday the database and all the clients hung. When I ...
    Joe LesterJoe Lester
    Jul 31, 2004 at 4:26 pm
    Aug 19, 2004 at 4:20 pm
  • Hi: I'm running a large database on PostgreSQL 7.1.3. 20 days ago the database failed with a threatening and not too descriptive error like: pg_exec() query failed: server closed the connection ...
    RubenRuben
    Jul 27, 2004 at 8:01 am
    Aug 6, 2004 at 11:30 pm
  • I have 2 questions. 1. What is the best way to back up a production box running Postgres nightly? 2. I thought the best way was to create a script that would use pg_dump to create a dump every night ...
    Jason TesserJason Tesser
    Jul 29, 2004 at 4:09 pm
    Jul 30, 2004 at 6:57 pm
  • Hi Postgressers! I really like Postgres. Thanks for all your work on it. I just have a problem with the way it's handling my flat file's timestamp columns. I have a flat file with a column with dates ...
    Kevin BartzKevin Bartz
    Jul 28, 2004 at 10:16 pm
    Jul 29, 2004 at 7:23 am
  • Just asking in case anyone has this info... Does anyone have a complete and working data model that allows Postfix v2 to lookup domain/user lookups (including virtual domains and users). I've got ...
    John Sidney-WoollettJohn Sidney-Woollett
    Jul 27, 2004 at 7:34 am
    Jul 28, 2004 at 9:49 am
  • Hi, I am pretty new to the postgresql community. My question may seem a little bit strange but I'd like to know if it is possible to run 2 postgresql processes with 2 separate databases on the same ...
    Jean-Guillaume LALANNEJean-Guillaume LALANNE
    Jul 22, 2004 at 12:56 pm
    Jul 23, 2004 at 1:15 pm
  • I'm just wondering if anyone has ever inserted images into a Postgres DB through ASP. If so, could you please give me a snippet of code to show me how to do it. I can't seem to get it working. ...
    Dylan MilksDylan Milks
    Jul 16, 2004 at 1:21 pm
    Jul 21, 2004 at 3:31 pm
  • Hi! Sorry to bother you, but I just don't know how to get tsearch2 configured correctly for my setup. I've got a 7.4.3 database-cluster initdb'ed with de_DE@euro as locale, the database is with ...
    Markus WollnyMarkus Wollny
    Jul 20, 2004 at 4:52 pm
    Jul 21, 2004 at 3:07 pm
  • If max_fsm_pages is too small and I have space not reclaimed by vacuum, if I increase max_fsm_pages and restart postmaster, will the next VACUUM ANALYZE relcaim all overlooked pages or must I do a ...
    WespvpWespvp
    Jul 1, 2004 at 5:44 pm
    Jul 10, 2004 at 6:03 am
  • This question may seem trivial but how do I rebuild a database with the wal logs?
    Jason TesserJason Tesser
    Jul 29, 2004 at 9:43 pm
    Jul 30, 2004 at 4:40 pm
  • Hi, In my database, I created a lot of tables before I found out about schemas. It's a mess! Suppose I want to get organised, and create a couple of schemas. How do I move existing tables into my ...
    M E BrucheM E Bruche
    Jul 30, 2004 at 9:28 am
    Jul 30, 2004 at 10:48 am
  • PostgreSQL 7.4.2 - I'm having some serious problems dumping and reloading a database with utilizes TSearch2. I've followed the directions to-the-letter for dumping and reloading a DB that uses ...
    Chris GamacheChris Gamache
    Jul 28, 2004 at 4:43 pm
    Jul 29, 2004 at 3:13 pm
  • I have a before insert trigger that updates a value in another table. It appears that I cannot depend upon that update having taken place in an after insert trigger on the first table. (The one with ...
    Mike NolanMike Nolan
    Jul 28, 2004 at 3:22 am
    Jul 28, 2004 at 2:42 pm
  • First of all, my apologies for posting it to 3 lists: I'm not sure if this is an admin question, or I only have this question because I'm a novice, or some combination thereof. I have a table which ...
    Si ChenSi Chen
    Jul 22, 2004 at 7:17 pm
    Jul 26, 2004 at 4:43 pm
  • I have a table with column1, column2, column3 and column4. How do I get all records, sorted by column4 that have the same column1,column2 and column3? TIA Joost
    Joost KraaijeveldJoost Kraaijeveld
    Jul 20, 2004 at 9:38 am
    Jul 20, 2004 at 11:22 am
  • This bug? feature? caused a bit of havoc for us yesterday...A reproducible example follows. Essentially, if you have a table with a primary key called "id", and you create a temp table (via a "select ...
    Timothy PerrigoTimothy Perrigo
    Jul 8, 2004 at 1:16 pm
    Jul 8, 2004 at 10:48 pm
  • I've just noticed in the regular profiling information from our web application that a particular query on a fairly small database is taking about 15 seconds. The query is generated from software on ...
    Chris SmithChris Smith
    Jul 2, 2004 at 9:06 pm
    Jul 6, 2004 at 7:41 pm
  • Hello. We are currently facing a design issue, which I am a bit stuck with. We are talking about row-level access regulation. I'll make it clear with an example. Let there be a table of products: ...
    Michal TaborskyMichal Taborsky
    Jul 2, 2004 at 2:11 pm
    Jul 2, 2004 at 5:37 pm
  • Is there any way to grant user access at the row level? Or maybe some way to simulate it? Alex
    Alexander CohenAlexander Cohen
    Jul 1, 2004 at 9:09 pm
    Jul 2, 2004 at 3:59 am
  • So, I'm recording the timestamp from some unix files. Any opinions as to whether it's best to use a "bigint" (which matches the file system data) or a "timestamp" (which might be easier to manipulate ...
    Mark HarrisonMark Harrison
    Jul 30, 2004 at 9:08 pm
    Jul 31, 2004 at 12:20 am
  • hi people, i have been trying to connect to the database using php. but i am not able to do so .i am getting the following errors *Warning*: pg_connect(): Unable to connect to PostgreSQL server: ...
    JayJay
    Jul 28, 2004 at 6:12 pm
    Jul 28, 2004 at 9:30 pm
  • Hi everyone, I have a customer table (17518 records) and an orders table (88393 records). One of the columns of orders is customerid, containing the customerid (what else, but it is not a foreign key ...
    Joost KraaijeveldJoost Kraaijeveld
    Jul 28, 2004 at 10:08 am
    Jul 28, 2004 at 10:59 am
  • When I run: vacuumdb --full --all --analyze --quiet on my database cluster it will complete in < 2 minutes (this cluster is a few million total rows and ~2GB). After testing, I set this up as an ...
    Steve CrawfordSteve Crawford
    Jul 26, 2004 at 8:23 pm
    Jul 27, 2004 at 1:00 am
  • Hi. I understand from lurking on Hackers that 7.5 is nearing beta. What is the typical timeframe for a postgres beta? It's understood, of course, that beta might take longer depending on problems ...
    David ParkerDavid Parker
    Jul 26, 2004 at 5:42 pm
    Jul 26, 2004 at 8:23 pm
  • Hello. Explain. I have table "traf_raw" contains field "sip_id" (integer). This field indexed with "CREATE INDEX traf_raw_sip ON traf_raw (sip_id)". Question. When I try to get different rows ...
    Anton MaksimenkovAnton Maksimenkov
    Jul 21, 2004 at 5:02 am
    Jul 21, 2004 at 8:22 am
  • I'm helping manage a postgres installation that continually consumes a considerable amount of disk space, and I'm hoping to learn a bit more about both treating the symptoms and addressing the ...
    Thomas F.O'ConnellThomas F.O'Connell
    Jul 13, 2004 at 10:56 pm
    Jul 18, 2004 at 4:43 pm
  • I have a int4 coloumn, and I want to change the last bit the the number in this column to 0. How can I do it? Thanks, John
    HomecurrHomecurr
    Jul 12, 2004 at 6:29 pm
    Jul 17, 2004 at 4:30 am
  • Hi, why does everyone write CREATE FUNCTION foo() RETURNS INTEGER AS ' blah blah ' LANGUAGE 'plpgsql'; I've never seen for example: CREATE FUNCTION foo() RETURNS INTEGER LANGUAGE 'plpgsql' AS ' blah ...
    Markus BertheauMarkus Bertheau
    Jul 9, 2004 at 5:16 pm
    Jul 14, 2004 at 8:25 pm
Jul 2004
123456
Group Navigation
period‹ prev | Jul 2004 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions254
posts962
users285
websitepostgresql.org
irc#postgresql

285 users for July 2004

Tom Lane: 84 posts Bruce Momjian: 33 posts Mike G: 32 posts Bruno Wolff III: 20 posts Dennis Gearon: 19 posts Peter Eisentraut: 19 posts Scott Marlowe: 19 posts Stephan Szabo: 18 posts Alvaro Herrera Munoz: 14 posts Prabu Subroto: 14 posts Doug McNaught: 13 posts Andy B: 11 posts Jerry LeVan: 11 posts Jim Seymour: 11 posts Markus Wollny: 11 posts Bill Moran: 10 posts David Parker: 10 posts Pierre-Frédéric Caillaud: 10 posts CSN: 9 posts Geoff Caplan: 9 posts
show more
Archives