FAQ

PostgreSQL > pgsql-general > October 2005

Search Discussions

304 discussions - 1,907 posts

  • http://lnk.nu/prnewswire.com/4dv.pl -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: ...
    Jim C. NasbyJim C. Nasby
    Oct 7, 2005 at 6:18 pm
    Oct 23, 2005 at 6:00 am
  • Just so I know (and am armed ;) ), are there any new comparable features in MySQL 5.0 that aren't in PostgreSQL up to the forthcoming 8.1? AFAIK, PG just lacks updatable views (which are on the ...
    CSNCSN
    Oct 6, 2005 at 1:37 am
    Oct 31, 2005 at 6:06 am
  • http://sql-info.de/postgresql/postgres-gotchas.html Any comments from folks on the list ? Cheers, Aly. -- Aly S.P Dharshi aly.dharshi@telus.net "A good speech is like a good dress that's short enough ...
    Aly S.P DharshiAly S.P Dharshi
    Oct 6, 2005 at 6:07 pm
    Oct 18, 2005 at 1:35 am
  • Yesterday computer running Postgres re-boots suddenly. After that, select * from firma1.klient returns ERROR: invalid page header in block 739 of relation "klient" I have Quantum Fireball IDE drive, ...
    AndrusAndrus
    Oct 26, 2005 at 3:28 pm
    Oct 31, 2005 at 8:02 am
  • Hello There... I am new to PostgreSQL. I usually check out negative sides of any software or system, before implementing it or using it. I would like to know the limitations of PostgreSQL. Also, I ...
    Denis G DudhiaDenis G Dudhia
    Oct 3, 2005 at 12:01 pm
    Oct 19, 2005 at 6:11 am
  • http://www.oracle.com/technology/software/products/database/xe/index.html http://news.zdnet.com/2100-3513_22-5920796.html 'Oracle intends to release a free version of its database, a reaction to the ...
    Nikolay SamokhvalovNikolay Samokhvalov
    Oct 30, 2005 at 6:24 pm
    Nov 7, 2005 at 10:17 am
  • Hi all, I'm currently trying to build a defence against SQL INJECTION, after reading some material on it I arrived to few possible solutions and I would like to know if anyone can comment anything ...
    Yonatan Ben-NesYonatan Ben-Nes
    Oct 31, 2005 at 5:56 pm
    Nov 4, 2005 at 11:41 am
  • I would like to secure Postgres completly. Some issues that I don't know you to fix: 1. User postgres can use psql (...) to do anything. 2. User root can su to postgres and thus do anything. 3. ...
    L van der WaltL van der Walt
    Oct 5, 2005 at 1:37 pm
    Oct 6, 2005 at 12:23 pm
  • I have a database of e-mail addresses. I want to select the email addresses which are not valid: do not contain exactly one @ character, contain ; < " ' , characters or spaces etc. What is the WHERE ...
    AndrusAndrus
    Oct 19, 2005 at 6:24 pm
    Oct 25, 2005 at 7:12 pm
  • Guys, I was interested in researching a few items regarding bug reports in PostgreSQL, but I can't seem to find what the project uses as a bug tracker. I see the web form and mailing list, but I ...
    J BJ B
    Oct 10, 2005 at 11:59 pm
    Oct 14, 2005 at 12:17 am
  • I did a quick search on the mailing list and didn’t really find my answer, so I am posting it to this list… I’d like to apologize for my lack in understanding all this license stuff. I am not an open ...
    Aaron SmithAaron Smith
    Oct 4, 2005 at 2:49 pm
    Oct 12, 2005 at 10:06 am
  • Hi, I'm looking for some help in regards to letting Posresql use more memory. It fails to start with this message: shmat(id=65536) failed: Cannot allocate shared bufers Max buffers I can start it ...
    VladVlad
    Oct 31, 2005 at 3:30 am
    Oct 31, 2005 at 10:59 pm
  • Does postgresql have any facility to dump anything more fine grained than a database to a text file? For example, to mention a bad word, MySQL's dump command allows you to specify individual tables ...
    Dan ArmbrustDan Armbrust
    Oct 11, 2005 at 4:20 pm
    Oct 18, 2005 at 2:37 pm
  • I'm stuck on a brain-teaser with CONSTRAINT: Imagine a table like "lineitems" in a bookstore - where you don't need an ISBN to be unique because a book will be in buying history more than once. But ...
    Miles KeatonMiles Keaton
    Oct 9, 2005 at 5:36 am
    Oct 12, 2005 at 1:12 pm
  • i have a stored procedure insert_table(integer) which does "insert into table (x) value ($1)"; now in my client i call the stored procedure as select insert_table("3"); it works fine and inserts 3 ...
    Surabhi.ahujaSurabhi.ahuja
    Oct 21, 2005 at 6:02 am
    Oct 27, 2005 at 10:30 am
  • Richard_D_Levine@raytheon.com; Oracle cast('a ' about I suppose that there may be some value in having 'J&^% ' be different from 'J&^% '. I would expect to insert a password with trailing blanks to ...
    Dann CorbitDann Corbit
    Oct 19, 2005 at 9:38 pm
    Oct 20, 2005 at 9:38 pm
  • Hi all What is the first thing you would do, when you find that your system has been losing information? Information is there at one stage, and later it's not. I tried checking the logs, but there ...
    Rory BrowneRory Browne
    Oct 31, 2005 at 3:33 pm
    Nov 3, 2005 at 6:00 am
  • Is it possible to dump an entire database but to skip one or two tables? Or, conversely, to restore an entire dump except for one or two tables? (Although I'd prefer the first version.) The only ...
    WireSpotWireSpot
    Oct 6, 2005 at 10:59 am
    Oct 9, 2005 at 1:04 am
  • I'm having difficulty installing 8.0.4. Server is SuSE 8.2 without PG installed. However some client libraries are Yast installed due to dependency reconciliation. I'm doing the standard install ...
    Steve CrawfordSteve Crawford
    Oct 28, 2005 at 11:44 pm
    Nov 29, 2005 at 9:13 pm
  • In MySQL, I can use the replace statement which either updates the data there or inserts it. Is there a comporable syntax to use in postgreSQL? I need to do an insert and don't want to have to worry ...
    Blackwater devBlackwater dev
    Oct 29, 2005 at 1:57 am
    Nov 3, 2005 at 10:09 am
  • Oh my god!.... DB is pg 7.4.6 on linux 2005-10-27 05:55:55 WARNING: some databases have not been vacuumed in 2129225822 transactions HINT: Better vacuum them within 18257825 transactions, or you may ...
    John Sidney-WoollettJohn Sidney-Woollett
    Oct 30, 2005 at 8:44 am
    Oct 31, 2005 at 6:46 pm
  • Hi All, I have downloaded an extension for PostgreSql. It contains stored procedures written in C. I compiled the neccessary files into an so file and I tried to use the functions, but it gives an ...
    Zoltán DudásZoltán Dudás
    Oct 24, 2005 at 9:33 am
    Oct 26, 2005 at 3:18 am
  • So I was finally able to get a compiled binary for the code in this thread(thanks Magnus): http://archives.postgresql.org/pgsql-general/2005-06/msg00709.php So everything seemed to be fine with my ...
    Steve VSteve V
    Oct 22, 2005 at 8:30 pm
    Oct 24, 2005 at 4:52 am
  • PSQL has the option to output the result of queries in several different formats, including HTML. Suggestion: have an option to output query results in XML format. Suggested format: <row ...
    Dean Gibson (DB Administrator)Dean Gibson (DB Administrator)
    Oct 20, 2005 at 5:50 am
    Oct 21, 2005 at 2:21 pm
  • I'm looking for a quick way to find the number of bits that are different between two bitmasks of the same size. I'll be doing this a lot, so speed is desirable.... some kind of indexing would be ...
    BenBen
    Oct 2, 2005 at 2:12 am
    Oct 3, 2005 at 12:16 am
  • PostgreSQL 7.4 ... Essentially, I've written a function in C for use with PostgreSQL. The debugger shows that the program is hanging on the part of the program that is writing data into it's own ...
    CGCG
    Oct 28, 2005 at 1:38 pm
    Oct 28, 2005 at 9:04 pm
  • I was trying to search a array with a GTE to value and it doesn't work. Is this supported? Or am I missing something? SELECT * FROM sal_emp WHERE 10000 = ALL (pay_by_quarter); Yahoo! Music Unlimited ...
    Matthew PeterMatthew Peter
    Oct 16, 2005 at 8:04 pm
    Oct 17, 2005 at 7:28 pm
  • You will most likely run into problems *if* you enable SSL connections. As long as you don't use SSL connections, you should be fine. It's for just tihs reason that the instlaler proceeds even though ...
    Magnus HaganderMagnus Hagander
    Oct 15, 2005 at 2:27 pm
    Nov 1, 2005 at 8:25 am
  • Hi, We've developed an automatic email mapping capability from Google Maps API. To try it out, we mapped origins of emails to this group from October 2, 2005 2 pm (EST) through October 14th, 9 am ...
    Claire McListerClaire McLister
    Oct 24, 2005 at 6:47 pm
    Oct 28, 2005 at 10:10 pm
  • I was trying this: IF (OLD.value != NEW.value) THEN -- END IF; and couldn't get the condition to evaluate to true at all if OLD.value was NULL. I also tried: IF (OLD.value NOT LIKE NEW.value) THEN -- ...
    CSNCSN
    Oct 20, 2005 at 6:04 am
    Oct 21, 2005 at 2:32 am
  • Hello Everyone, Does anyone know if PostgreSQL supports running on dual processors, and will efficiently utilize the dual processors for performance? More specifically, will PostgreSQL utilize the ...
    OnyxOnyx
    Oct 18, 2005 at 9:35 pm
    Oct 19, 2005 at 10:55 pm
  • Dear friends, i've been using postgresql quiet some time now, but i don't find any really good clients for "dummies" to this database. When i look at pgadmin: an anoying feature: it closes when u do ...
    Wim BertelsWim Bertels
    Oct 18, 2005 at 1:49 pm
    Oct 19, 2005 at 10:25 am
  • Hello all, I am writing an app in PHP that uses a PostGres database. One thing i have noticed is that what should/could be a single line of SQL code takes about 6 lines of PHP. This seem wasteful and ...
    SmorreySmorrey
    Oct 9, 2005 at 6:15 am
    Oct 10, 2005 at 11:48 pm
  • It occurs to me that I don't know how to define unsigned integer datatypes. I'm making a schema to describe network packets and I need columns to contain values from 0-255, etc. I can't seem to find ...
    Jeff sackstederJeff sacksteder
    Oct 15, 2005 at 8:42 pm
    Oct 19, 2005 at 5:44 am
  • For pg_dump minimum privilages is to have select right on tables. For vacuumdb, one must be owner of tables or a superuser. What are minimum rights for user that is trying to execute pg_autovacuum ? ...
    Zlatko MatićZlatko Matić
    Oct 11, 2005 at 10:35 am
    Oct 14, 2005 at 10:30 am
  • I am receiving the following error and cannot understand what it means. Please let me know if this makes sense to you. ERROR: could not open relation 1663/3364852/7973197: No such file or directory ...
    Sim ZacksSim Zacks
    Oct 10, 2005 at 2:24 pm
    Jan 21, 2006 at 5:50 am
  • Having been surprised a few times myself by EXPLAIN showing a sequential scan instead of using an index, and having seen so many others surprised by it, I hope I am not asking a similar question. We ...
    FelixFelix
    Oct 24, 2005 at 9:57 pm
    Nov 28, 2005 at 11:49 pm
  • I need a database capable of storing at least 12 million records per table, mostly used for batch queries. Basically an invoice database. Some tables could potentially store 100 million records. ...
    JanJan
    Oct 24, 2005 at 8:37 pm
    Oct 25, 2005 at 7:50 pm
  • I have an application that makes heavy use of foreign keys all over the tables. This is very nice since the data is very consistent. There also this "central" table which holds "sites" in it. A site ...
    WireSpotWireSpot
    Oct 24, 2005 at 9:59 pm
    Oct 25, 2005 at 5:15 pm
  • If integer's range is -2147483648 to +2147483647, why is serial's range only 1 to 2147483647 instead of 1 to about 4294967294? CSN Yahoo! Music Unlimited Access over 1 million songs. Try it free. ...
    CSNCSN
    Oct 11, 2005 at 2:37 am
    Oct 11, 2005 at 11:32 pm
  • This is weird. I set up a table with a serial id field and created a primary key on it. Then I imported data. Running an app against it, I got periodic errors stating "duplicate key violates unique ...
    CSNCSN
    Oct 9, 2005 at 7:46 pm
    Oct 10, 2005 at 10:32 pm
  • Hi all, I sent the following email to the php mailing list also but maybe this is a more appropriate mailing list. I wrote a php script which is running very long queries (hours) on a database. I ...
    Ben-Nes YonatanBen-Nes Yonatan
    Oct 2, 2005 at 8:56 am
    Oct 3, 2005 at 2:55 pm
  • I am attempting to create a new trigger through the "new Trigger" interface on version 8 installed on Windows. The following is the sql that the interface generates CREATE TRIGGER trig1 AFTER INSERT ...
    Bob PawleyBob Pawley
    Oct 26, 2005 at 8:48 pm
    Oct 27, 2005 at 4:38 am
  • Are there known limits to how many rows can be inserted by one transaction, or does that just reflect the already documented row, table and database limits?
    Jeff sackstederJeff sacksteder
    Oct 21, 2005 at 7:32 am
    Oct 21, 2005 at 9:55 pm
  • hi all i am facing a problem and here it is: i install the following (postgres) rpms as root postgresql-libs-8.0.0-1PGDG.i686.rpm postgresql-8.0.0-1PGDG.i686.rpm and ...
    Surabhi.ahujaSurabhi.ahuja
    Oct 18, 2005 at 11:18 am
    Oct 20, 2005 at 2:12 pm
  • Hi you all, His there any SW that can do reverse engineering on postgreSQL databases? I need something that can create entity-relationship models from an already made db, and something that can ...
    Bruno CochofelBruno Cochofel
    Oct 19, 2005 at 3:11 am
    Oct 20, 2005 at 10:14 am
  • I am getting division by zero on a calculated field ( sum(sales) is 0 ) and I can't find a way around this. I figured out you can't use an aggregate in a where, and using having the parser must ...
    Tim NelsonTim Nelson
    Oct 19, 2005 at 12:26 pm
    Oct 19, 2005 at 2:53 pm
  • Hello, We have a table of people with a date-of-birth and a surname, both indexed. We have queries like this: select report from table where dateofbirth = '1966-12-12' and surname like 'boer%' The ...
    Han HollHan Holl
    Oct 7, 2005 at 1:21 pm
    Oct 13, 2005 at 8:49 pm
  • Hello Group: Is there any 'portable' version of PostgreSQL for Windows? By 'portable' I mean, I can just unzip files, run the initdb and then run the postmaster and I get a temporary database server ...
    Samik RaychaudhuriSamik Raychaudhuri
    Oct 2, 2005 at 4:35 pm
    Oct 3, 2005 at 11:47 pm
  • I know that there are some Visual FoxPro developers on this list who use PostgreSQl as their back-end. My question to them is... VFP will run in WINE up to VFP version 8. But the people I talk to ...
    MargaretgillonMargaretgillon
    Oct 24, 2005 at 6:10 pm
    Oct 31, 2005 at 8:02 am
Oct 2005
12345…7
Group Navigation
period‹ prev | Oct 2005 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions304
posts1,907
users371
websitepostgresql.org
irc#postgresql

371 users for October 2005

Tom Lane: 141 posts Jim C. Nasby: 64 posts Martijn van Oosterhout: 64 posts Scott Marlowe: 55 posts Richard Huxton: 51 posts Michael Fuhr: 48 posts Dann Corbit: 35 posts Chris Travers: 33 posts Joshua D. Drake: 33 posts Douglas McNaught: 32 posts Andrew Sullivan: 31 posts Andrus: 28 posts CSN: 26 posts Bruce Momjian: 25 posts Magnus Hagander: 24 posts Marc G. Fournier: 24 posts David Fetter: 23 posts Tino Wildenhain: 23 posts Zlatko Matić: 23 posts Alex Turner: 21 posts
show more
Archives