[GENERAL] Data type recommendation

1999-08-04 Thread Thomas Lim
According to the user guide, it is mentioned that TEXT data type is recommended over CHAR or VARCHAR. Does anyone know why? I thought the access time for TEXT is slower. Shouldn't CHAR be used for key fields? Is there some sort of overheads for CHAR or VARCHAR that TEXT is recommended? Hope th

[GENERAL] Re: [SQL] referential integrity

1999-08-04 Thread Howie
On Wed, 4 Aug 1999, Ramanika wrote: > I did not see this in the documentation anywhere. Does postgresql > support referential integrity? like when creating a table REFERENCES > table(column_id)? not directly, no. at least not yet :) 6.6 is rumoured to have full support. for now you can use

Re: [GENERAL] ElephantWear Now Available...

1999-08-04 Thread Stuart Rison
At 6:53 pm +0300 4/8/99, Herouth Maoz wrote: >At 17:32 +0300 on 04/08/1999, Clark C. Evans wrote: > > >> I don't get image #2 "Leave's em big" could >> someone explain this one? Also, having the version >> number on the T-Shirt kinda dates it... > >I think you're right. And I thought that "l

[GENERAL] libpq.so open failed

1999-08-04 Thread Ximo Domenech
Hi to everyone !! I'm sorry, my last message have arrived to the mailing list with bad subject. I dont know why. :-| Here my problem: I'm tring to migrate Postgres from Linux to Solaris. (2.7) The C source code (cgi's) is running ok in linux, but when execute from solaris I obtain the next error

Re: [GENERAL] ElephantWear Now Available...

1999-08-04 Thread Daniel Lundin
The Hermit Hacker writes: > How about a T-SHIRT with some of the above slogans, > perhaps this one: > > "It has taken a while to get moving... but > nothing is stopping it now. PostgreSQL, > stable, solid, dependable, and on its way > to a production server near you." Suggestions and id

Re: [GENERAL] ElephantWear Now Available...

1999-08-04 Thread The Hermit Hacker
On Wed, 4 Aug 1999, Daniel Lundin wrote: > The Hermit Hacker writes: > > > How about a T-SHIRT with some of the above slogans, > > > perhaps this one: > > > > > > "It has taken a while to get moving... but > > > nothing is stopping it now. PostgreSQL, > > > stable, solid, dependable

Re: [GENERAL] ElephantWear Now Available...

1999-08-04 Thread Daniel Lundin
The Hermit Hacker writes: > > * GNU style donation field on the order form. It's convenient (and > >seductively easy) to add an amount of cash for donation while > >purchasing merchandise. > > Basically, combine the 'contribute' page with the 'merchandise' one? Or > leave them sep

Re: [GENERAL] ElephantWear Now Available...

1999-08-04 Thread Michael Simms
> Oh, I like this one too...Daniel? Jeff? T-Shirt #3? If you want to send > in suggestions, feel free to send them to [EMAIL PROTECTED] Not saying > we'll do everything and anything, but diversity is cool... Hows about: Postgres - We didnt need to consult an oracle to know it would be great!

[GENERAL] Re: types inheritance

1999-08-04 Thread Bruce Momjian
> Dear Bruce, > > many thanks for your answer. > > Yes, I wanted to know if it is / will be also possible to have types inherited > from other primitive types. This is, for instance, what happens in Oracle and > SpatialWare. In these databases I am able to write different types of > geometric pr

Re: [GENERAL] libpq.so open failed

1999-08-04 Thread Charles Tassell
I've never used Solaris, but I know you get a similar error in Linux if you don't have the dir libpq.so is in the /etc/ld.so.conf file. If you have an /etc/ld.so.conf file, add the line: /usr/local/pqsql/lib to it and run ldconfig. Hope it's that simple. :) At 05:04 PM 8/4/99, Ximo Domenech w

Re: [GENERAL] libpq.so open failed

1999-08-04 Thread Mario Haza
Try to put these two lines on the /etc/profile: LD_LIBRARY_PATH=/usr/lib:/usr/local/lib:/usr/local/pgsql/lib export LD_LIBRARY_PATH Mario "Mago" Haza Technological Research / Research Center for Educational Computing e-mail: [EMAIL PROTECTED] [EMAIL PROTECTED] Tel. (5) 627-021

[GENERAL] Problem with pgaccess

1999-08-04 Thread Héctor Morales
Hi , i am novate in postgres and i want run de pgaccess but when i run bash$ pgaccess return the follow errors Xlib: connection to "0.0" refused by server Xlib: Invalid MIT-MAGIC-COOKIE-1 key Application initialization failde: couldn't connect to display "0.0" Error in startup script: invalid

Re: [GENERAL] ElephantWear Now Available...

1999-08-04 Thread The Hermit Hacker
On Wed, 4 Aug 1999, Daniel Lundin wrote: > The Hermit Hacker writes: > > > * GNU style donation field on the order form. It's convenient (and > > >seductively easy) to add an amount of cash for donation while > > >purchasing merchandise. > > > > Basically, combine the 'contribute'

Re: [GENERAL] Problem with pgaccess

1999-08-04 Thread Bruce Momjian
This is a problem with your X server authorization configuration. Try xhost command. > Hi , i am novate in postgres and i want run de pgaccess but when i run > > bash$ pgaccess > > return the follow errors > > Xlib: connection to "0.0" refused by server > Xlib: Invalid MIT-MAGIC-COOKIE-1 key

Re: [GENERAL] ElephantWear Now Available...

1999-08-04 Thread Thomas Good
I like the ballcap, believe I'll order one... BTW, Scrappy - I expect I have one cd remaining on my sub. Are you planning on burning any copies of 6.5.1 for the sub recipients? Thanks, Tom Still hoping to see that pachyderm on the cover of an O'Reilly book someday... --- North Richmond Com

Re: [GENERAL] ElephantWear Now Available...

1999-08-04 Thread The Hermit Hacker
On Wed, 4 Aug 1999, Thomas Good wrote: > I like the ballcap, believe I'll order one... > > BTW, Scrappy - I expect I have one cd remaining on my sub. > Are you planning on burning any copies of 6.5.1 for the sub > recipients? It was my opinion (please feel free to correct me if I'm wrong) that

Re: [GENERAL] PHP with Postgres

1999-08-04 Thread Simeó
El dia 04-Aug-99 en Kevin Heflin va escriure : > Go to www.php.net in the online manual, it shows all the pg_ functions of > php. > > If you are looking for an acutal book, I've recently bought a PHP > programming books from amazon.com, I didn't find that it went into any > more detail than the

[GENERAL] Problem with pgaccess

1999-08-04 Thread Héctor Morales
Thanks for the command xhost the problem terminate. Now when i run pgaccess result: Error in startup script: coudn't load file "libpgtcl.so": /usr/lib/libpgtcl.so: undefined symbol: crypt while executing "load libpgtcl.so" (procedure "main" line 6) invoked from within "main $argc $argv" (file "/u

[GENERAL] PQsendQuery

1999-08-04 Thread Michael Simms
Hi I have a query regarding PQsendQuery that doesnt seem to be well explained in the docs. My basic situation is that I want to run a series of queries quickly, and I dont care what the result of them is (it is an insert). 1 ) When I run PQsendQuery(), can I then immediately run PQexec() or do I

[GENERAL] "group, by", problem, when, combined, with, "insert, into"

1999-08-04 Thread sam smith
Hi All I'm pretty new to postgres and I'm finding soemthing baffling. I can perform the following query without a problem - select loser,count(*) from moves group by loser; but when i combine it with an insert into - insert into losses select loser,count(*) from moves group by loser; I get E