FAQ

Search Discussions

115 discussions - 328 posts

  • I am going to buying a sun server to run postgres on as a backend database server for a www site. Does anyone have suggestions on what to buy? Does anyone have advice on running postgres on solaris ...
    Eric EnocksonEric Enockson
    Apr 26, 1999 at 2:42 am
    Apr 28, 1999 at 6:32 am
  • These are the steps I used to compile and run PostgreSQL on Windows NT. Notice that I have not verfied it after 24-3-99. In the coming week I hope to update my webpage. 1. Install the Cygwin package ...
    Joost KraaijeveldJoost Kraaijeveld
    Apr 13, 1999 at 7:04 am
    Jul 11, 1999 at 5:06 pm
  • subscribe end
    Igor V. KruchinskyIgor V. Kruchinsky
    Apr 12, 1999 at 6:40 am
    Apr 30, 1999 at 11:18 am
  • Hi all, I don't want to create a polemic, but is it possible to make a recovery of the previous WWW interfaces of the postgreSQL.org site? What does an elephant do on the home page? Probably you have ...
    DaroldDarold
    Apr 15, 1999 at 2:50 pm
    Apr 17, 1999 at 4:02 am
  • Hi, I've an elementary question. What's wrong with the following : dbtest= select * from testusers limit 10; ERROR: parser: parse error at or near "10" dbtest= select version(); version ...
    Martin WongMartin Wong
    Apr 29, 1999 at 3:09 am
    Apr 29, 1999 at 6:50 pm
  • This seems like a simple SQL command, but I'm getting errors. Running 6.5.0 under RedHat 5.2: db= select count(distinct customer_username) from customerdata; ERROR: parser: parse error at or near ...
    Aaron HoltzAaron Holtz
    Apr 28, 1999 at 3:50 pm
    Apr 29, 1999 at 3:08 pm
  • Hi all, Trying to build pg on unixware...hacked configure as follows to create a Makefile: change TEMPLATE=template/`uname -s | tr A-Z a-z` to TEMPLATE=template/univel Downloaded flex-2.3pl7.tar.Z ...
    Thomas GoodThomas Good
    Apr 28, 1999 at 2:04 pm
    Apr 29, 1999 at 1:56 pm
  • I got the following error after trying to copy the example at: http://www.postgresql.org/mhonarc/pgsql-sql/1999-04/msg00076.html ---------------------------------------------------------- test= ...
    Andy LewisAndy Lewis
    Apr 28, 1999 at 1:43 pm
    Apr 29, 1999 at 2:14 am
  • Hi, Is there a DBI driver for Postgres available somewhere? Thanks, Anand.
    Anand SureliaAnand Surelia
    Apr 28, 1999 at 12:13 am
    Apr 28, 1999 at 4:06 pm
  • It appears that there is a 9k (8,991) limit on queries ... I have text files that need to go in TEXT fields that are much longer than this. Does anyone have any suggestions as to how to add them to ...
    Justin LongJustin Long
    Apr 22, 1999 at 8:21 pm
    Apr 27, 1999 at 7:22 pm
  • I am looking for a freeware tool to document my postgres database tables, indices, etc. A friend of mine uses ERwin, but this is a licensed package his company had to buy. I Are there any free ...
    Sarah OfficerSarah Officer
    Apr 21, 1999 at 11:44 pm
    Apr 26, 1999 at 5:10 pm
  • Actually, I think the number of rows inserted is returned from the insert, or an error code (a negative number). But the OID can be obtained by $oid = sth- {'pg_oid_status'}; -- Karl DeBisschop ...
    Karl DeBisschopKarl DeBisschop
    Apr 15, 1999 at 12:57 pm
    Apr 21, 1999 at 1:25 pm
  • Why not use Java in stead of SWIG - TCL/TK - PHP? Or is java not free in your opinion? Regards Wim Ceulemans - wim.ceulemans@nice.be Nice Software Solutions - http://www.nice.be Eglegemweg 3, 2811 ...
    Wim CeulemansWim Ceulemans
    Apr 14, 1999 at 8:23 am
    Apr 14, 1999 at 3:28 pm
  • Is it just me, or is there no way to do a left join in postgresql? Is there any way to do this, I have checked the documentation, looked through the src, and there doesnt seem to be a reference to it ...
    M SimmsM Simms
    Apr 23, 1999 at 5:53 pm
    Apr 28, 1999 at 4:03 pm
  • Hello! It is definitely FAQ, but I haven't found an answer in docs or mailing list. How do I create indicies? (No, no, I know CREATE INDEX syntax :) But how do I plan my indicies that optimizer will ...
    Oleg BroytmannOleg Broytmann
    Apr 16, 1999 at 1:05 pm
    Apr 21, 1999 at 10:29 am
  • I have a sequence in a table that increments upon insert. After doing the insert, is their a way (function maybe?) to get the sequences value without having to do another select? Brian ...
    BrianBrian
    Apr 14, 1999 at 9:00 pm
    Apr 20, 1999 at 5:43 pm
  • No; your query on aaa* will return only field a, although it will include all rows from aaa, bbb and ccc. This is in line with standard OO treatment of inherited classes. Class aaa only has a single ...
    Oliver ElphickOliver Elphick
    Apr 16, 1999 at 1:28 pm
    Apr 17, 1999 at 9:22 am
  • Hi all, Seems that PostgreSQL checks for leap day only before 1902. prova= select date '0001-02-29'; ERROR: date_in: day must be limited to values 1 through 28 in '0001-02-29' prova= select date ...
    José SoaresJosé Soares
    Apr 12, 1999 at 8:29 am
    Apr 13, 1999 at 4:19 pm
  • Hey folks, still looking for a little help on this. I can insert data and (obviously create tables). Further, I've discovered PHP with pg support yields an unknown symbol 'lo_unlink' when Apache ...
    JP RosevearJP Rosevear
    Apr 24, 1999 at 10:28 pm
    Apr 29, 1999 at 11:42 am
  • Is there a way, or is it possible to open two databases at the same time to retrieve information from one database and store it in the other?
    De Leersnijder FredericDe Leersnijder Frederic
    Apr 13, 1999 at 4:12 pm
    Apr 16, 1999 at 7:42 am
  • valter
    ValterValter
    Apr 15, 1999 at 11:50 am
    Apr 15, 1999 at 5:30 pm
  • Hi all - I am porting a PROGRESS database to PostgreSQL. I've had success previously doing a port - but from FoxPro which allows one to dump data delimited by tabs. Unfortunately, PROGRESS dumps ...
    Thomas GoodThomas Good
    Apr 27, 1999 at 1:37 pm
    Apr 29, 1999 at 11:34 am
  • Hi Has anyone any experience whether it is possible to build with a PostgreSQl database and a linux box a search engine for a portal? Regards Wim Ceulemans - wim.ceulemans@nice.be Nice Software ...
    Wim CeulemansWim Ceulemans
    Apr 28, 1999 at 4:00 pm
    Apr 28, 1999 at 9:44 pm
  • Has any tentative date been set for the 6.5 release? I have just about convinced my company to replace their current plans to use a HUGE Oracle 8 database on NT with PostgreSQL on Linux. We will need ...
    Len MorganLen Morgan
    Apr 22, 1999 at 2:25 pm
    Apr 28, 1999 at 10:22 am
  • Hi, With mSQL I used to perform queries like below from within PHP: select field1, field2 from table1 where field1 like '%$some_variable%' where the '%' in the LIKE clause matches 0 or more ...
    Paulo ParolaPaulo Parola
    Apr 23, 1999 at 8:01 pm
    Apr 23, 1999 at 11:04 pm
  • 3

    FAQ

    I've just read through the FAQ on the postgresql.org homepage and I can't seem to find any reference to my problem so I'm resorting to asking the question here. If the answer to my question is found ...
    Louis Zirkel IIILouis Zirkel III
    Apr 21, 1999 at 9:46 pm
    Apr 22, 1999 at 3:48 pm
  • I've seen this question elsewhere on the list, but no good answer. I am exporting large databases from MS Access to PG, but the table and column names come out as case-sensitive in PG and I need to ...
    Glenn WaldronGlenn Waldron
    Apr 15, 1999 at 12:09 pm
    Apr 15, 1999 at 8:18 pm
  • Hi all, I have a question about dates. The Gregorian reform of calendar skiped 10 days on Oct, 1582. This reform was accepted by Great Britain and Dominions (including what is now the USA) only in ...
    José SoaresJosé Soares
    Apr 12, 1999 at 8:45 am
    Apr 14, 1999 at 3:41 pm
  • I have just started to experiment with the new 6.5 beta. When trying to reload the databases I got an error on what is a pretty simple SQL command. The pg_dump was from 6.3.1 I did psql < db.out The ...
    AGRE Enterprises LimitedAGRE Enterprises Limited
    Apr 10, 1999 at 5:18 am
    Apr 14, 1999 at 2:01 am
  • Thanks to all who responded! As you mentioned Xbase really makes life easy cf.http://www.startech.keller.tx.us/xbase/xbase.html Knocked something together using it, and it looks uncannily like ...
    Patrick WelchePatrick Welche
    Apr 9, 1999 at 6:39 pm
    Apr 12, 1999 at 9:58 pm
  • PostgreSQL 6.3.2 said: NOTICE: BlowawayRelationBuffers(places, 322): block 336 is referenced (private 0, last 0, global 1) FATAL 1: VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2 And now I ...
    Richard LynchRichard Lynch
    Apr 25, 1999 at 2:13 am
    May 24, 1999 at 5:45 pm
  • How does one compile or add PL/pgSQL if it doesn't already exist? I've searched the DOCS and mailing list and the best that I can come up with is an enable script that complains about the missing ...
    Andy LewisAndy Lewis
    Apr 27, 1999 at 3:58 am
    Apr 27, 1999 at 1:38 pm
  • This should do the trick: update pg_group set grolist = '{uid1, uis2, uid3}' where grosysid = 1; update pg_group set grolist = '{uid4, uis5, uid6}' where grosysid = 2; where uid1,uid2,uid3 is ...
    Michael J DavisMichael J Davis
    Apr 25, 1999 at 10:30 pm
    Apr 25, 1999 at 11:24 pm
  • I'm experiencing a weird problem with pgdump_all trying to dump a database running under PostGreSQL v6.4.2 I'm attaching the dump to this message (it's not that big because it gets struck almost ...
    Valerio SantinelliValerio Santinelli
    Apr 13, 1999 at 2:14 pm
    Apr 20, 1999 at 10:03 am
  • Hi! We are having some problems with trying to run one of the examples that are in the manuale. This is the output that we get and we can't find any library that contains these functions. ...
    Maria KlingMaria Kling
    Apr 19, 1999 at 12:54 pm
    Apr 19, 1999 at 1:35 pm
  • With respect to my previous query, I'd like to clarify that the FETCHes I am doing are subsets of the full results (hence I cannot use PQntuples). For instance, I am FETCHing 25 records out of a ...
    Mike FrischMike Frisch
    Apr 10, 1999 at 4:33 pm
    Apr 12, 1999 at 6:35 pm
  • Hiho ... I'd really like to know if anyone has any good suggestions for performing case insensitive searches on data in a 6.3 server using Perl. If there's some really obvious solution I'm missing, ...
    Mike BarnesMike Barnes
    Apr 12, 1999 at 1:40 pm
    Apr 12, 1999 at 1:57 pm
  • I'm pretty sure someone already answered this, but the mail archive isn't very searchable at the moment. How can you if(update row fails because doesn't exist, ie. returns 0)then(insert row) in SQL? ...
    Patrick WelchePatrick Welche
    Apr 10, 1999 at 3:47 pm
    Apr 11, 1999 at 11:34 am
  • Folks, I have a very large table (10Gb, 20 million records each with 54 fields) with both float, integer and text values. If I submit a query such as: select * from mytable where x=3.14 and y=6.28; ...
    Martin WeinbergMartin Weinberg
    Apr 23, 1999 at 1:41 pm
    May 10, 1999 at 4:21 pm
  • I'm trying to port my 6.3.2 to a 6.4.2. I've done a pg_dump myDB out.sql and then do a psql mynewDB -e < out.sql . I've also tried a \i out.sql in the psql command line. I've got the following ...
    Martin WongMartin Wong
    Apr 30, 1999 at 7:28 am
    Apr 30, 1999 at 7:44 am
  • After commented the line with "ecpg" (there is only one such line) from the GNUmake file, the make all didn't go very far but ended with the following message: make -C utils all make[1]: Entering ...
    Jun ZhangJun Zhang
    Apr 29, 1999 at 2:45 pm
    Apr 29, 1999 at 8:56 pm
  • Hi Herouth! How goes it? I'm assuming you got Solaris and PG happy. I'm wrestling with UnixWare now - just got the backend to compile, now fighting with ecpg...(Bruce M is probably rather weary of me ...
    Thomas GoodThomas Good
    Apr 29, 1999 at 12:39 pm
    Apr 29, 1999 at 1:28 pm
  • i've noticed that one of our databases looks a bit strange: -rw------- 1 pgsql pgsql 2147483648 Apr 28 23:06 gt -rw------- 1 pgsql pgsql 171073536 Apr 29 08:28 gt.1 is there some strange thing that ...
    Jim MercerJim Mercer
    Apr 29, 1999 at 12:48 pm
    Apr 29, 1999 at 1:11 pm
  • Hi all, I'd like to know how secure PostgreSQL is. (its user authentication methods, its permissions and rules) Is it easily breakable/hackable or not? (I suppose it greatly depends on any other ...
    Peter BlazsoPeter Blazso
    Apr 26, 1999 at 4:31 pm
    Apr 28, 1999 at 4:20 pm
  • I find that it is actually faster to do a SELECT from a single record set, then fetch each individual row and do additional SELECTS to find additional pieces of data from other databases, rather than ...
    Justin LongJustin Long
    Apr 27, 1999 at 4:32 pm
    Apr 27, 1999 at 7:18 pm
  • Hi!! I am student from a university from Brazil. And i need some material about Perl and PostgreSQL in the Web. Could you help me,please?A tutorial... It's very important to my course and my work. I ...
    Oseas RodriguesOseas Rodrigues
    Apr 26, 1999 at 5:20 pm
    Apr 27, 1999 at 6:24 am
  • -rw------- 1 postgres postgres 983040 Apr 26 20:33 si_tmpverifyaccountbalances -rw------- 1 postgres postgres 18137088 Apr 20 13:03 si_tmpverifyaccountbalances_pke = select count(*) from ...
    Michael J DavisMichael J Davis
    Apr 27, 1999 at 3:40 am
    Apr 27, 1999 at 5:00 am
  • Can anyone tell me how to store jpeg fies in a Postgres table? What field type to use? I am doing some develpment with VB and ODBC.
    Rick BourassaRick Bourassa
    Apr 22, 1999 at 5:42 am
    Apr 26, 1999 at 7:17 pm
  • Is it possible to create a text field (<16k) that is searchable using regular expressions? I see there's a 4096 character limitation to the 'varchar' data type. Thanks, Mike. ...
    Mike FrischMike Frisch
    Apr 26, 1999 at 2:21 am
    Apr 26, 1999 at 2:51 am
  • I'm developing a java applet with JDBC using the Postgresql driver. Apparently, the only browsers that are compatible with my java code compiled under Sun JDK 1.1.X is Netscape Communicator 4.5 and ...
    Bob VonMossBob VonMoss
    Apr 26, 1999 at 1:09 am
    Apr 26, 1999 at 2:03 am
Group Navigation
period‹ prev | Apr 1999 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions115
posts328
users128
websitepostgresql.org
irc#postgresql

128 users for April 1999

Chris Bitmead: 18 posts Bruce Momjian: 11 posts José Soares: 11 posts The Hermit Hacker: 11 posts Oleg Broytmann: 10 posts Dustin Sallings: 8 posts Michael J Davis: 8 posts Aaron Holtz: 7 posts Andy Lewis: 7 posts Brett W. McCoy: 7 posts Guo Ge: 7 posts Karl DeBisschop: 7 posts Adriaan Joubert: 6 posts Herouth Maoz: 6 posts Jackson, DeJuan: 6 posts Jim Mercer: 5 posts K.T.: 5 posts Martin Wong: 5 posts Thomas Good: 5 posts Thomas Good: 5 posts
show more
Archives