Re: Subject: Re: [GENERAL] A book for PgSQL? A need? yes? no?

1999-02-12 Thread dustin sallings
On Thu, 11 Feb 1999, Stephan Doliov wrote: So, are we serious about this? Should we start up a list for details? // // > Since we are tossing ideas around, here is my two cents. // > .1c In order not to worry about royalties we can donate proceeds to // > PostgreSQL. // Amen/Bravo! T

Re: Subject: Re: [GENERAL] A book for PgSQL? A need? yes? no?

1999-02-12 Thread The Hermit Hacker
On Thu, 11 Feb 1999, dustin sallings wrote: > On Thu, 11 Feb 1999, Stephan Doliov wrote: > > So, are we serious about this? Should we start up a list for > details? Like, [EMAIL PROTECTED] :) How much of what is already done by the Docs Team pertinent to all this, and, if not, w

Re: Subject: Re: [GENERAL] A book for PgSQL? A need? yes? no?

1999-02-12 Thread dustin sallings
On Fri, 12 Feb 1999, The Hermit Hacker wrote: // Like, [EMAIL PROTECTED] :) How much of what is already // done by the Docs Team pertinent to all this, and, if not, why not? // If our existing manuals don't make good documentation, then why not, // and shouldn't those be fixed too?

Re: Subject: Re: [GENERAL] A book for PgSQL? A need? yes? no?

1999-02-12 Thread Rudy Gireyev
Additionally manuals tend to be more of a reference whereas a book is primarily a tutorial, then at the end it can contain reference type material. If the book were to be written it would need complete and working examples followed by the exact result for example. Therefore I think it's a whole

[GENERAL] Re: Problems compiling

1999-02-12 Thread Felix Morley Finch
> configure: error: installation or configuration problem: C++ compiler cannot create >executables. My memory of the last couple of egcs/glibc installs is that the /lib/cpp symlink is not updated, and root had better have umask 022 or permissions don't get set right. Even with umask 022, /usr/l

Re: [GENERAL] Problem with table,field names.

1999-02-12 Thread Blashko Alexander
Thank you for your fast answer. On Thu, 11 Feb 1999, Oleg Broytmann wrote: > On Thu, 11 Feb 1999, Blashko Alexander wrote: > > create table TEST ( NAME text) > > create table "TEST" ( "NAME" text) > >Use double quotations - it is standard SQL feature. We use russian names of tables,fiel

Re: [GENERAL] Conditioned access to a database

1999-02-12 Thread Anatoly K. Lasareff
> "PdS" == Paulo da Silva <[EMAIL PROTECTED]> writes: PdS> Hello, PdS> I'm evaluating sql/postgresql for the following purpose: PdS> I need to have a database with lots of "records". PdS> I need to allow groups of users to access sets of PdS> those records grouped by the contents of one

Re: [GENERAL] Problems compiling

1999-02-12 Thread Gilles Darold
Hi, Part II (translation) : You need C++ compiler installed on you Linux box. See your log : > checking for c++... no > checking for g++... no This is the reason. Regard, Gilles. Jonathan Scott wrote: > Hello fellow PostgreSQL users.:) > > I am having trouble with the configure file for vers

Re: [GENERAL] Problems compiling

1999-02-12 Thread Stuart Rison
>Hi, > >Part II (translation) : You need C++ compiler installed on you Linux box. > >See your log : >> checking for c++... no >> checking for g++... no >This is the reason. > >Regard, > >Gilles. > Does this mean you cannot compile PG 6.4.2 without a C++ compiler or just that if you don't have a C

Re: [GENERAL] Problems compiling

1999-02-12 Thread Oleg Broytmann
On Thu, 11 Feb 1999, Jonathan Scott wrote: > checking whether the C++ compiler (gcc ) works... no > configure: error: installation or configuration problem: C++ compiler cannot create >executables. > > Any ideas? I cannot figure it out. Please help, this is for a senior > project I am working

[GENERAL] pg_dump query about views

1999-02-12 Thread Colin Price (EML)
Again, apologies if this is a duplication from the past but I can't it in pgsql-questions : --- In the reference section, it states there are problems with dumping views and rules. A pg_dumpall/pg_dump stores the view as a table with a rule. Therefore, when loaded back

Re: [GENERAL] Problems compiling

1999-02-12 Thread Gilles Darold
Hi stuart, It means that (as I know) you don't need C++ compiler to compile and run PostgreSQL on your machine. But you will not be able to link C++ application with PostgreSQL. Why? This is because you will not have Libpq++ compiled. Ok, I promise you to be more efficient next time :-))) Regar

Re: [GENERAL] A mistake generates strange result

1999-02-12 Thread jose' soares
  Stéphane Dupille ha scritto:     Hi ! "Ricardo J.C.Coelho" <[EMAIL PROTECTED]> writes: > Just for PgSQL's development group think about > I made a mistake typing a query that generates a strange result > (Very strange). > The query: select text('12345678'::float8); > It returns a date i

Re: [NOVICE] Re: Subject: Re: [GENERAL] A book for PgSQL? A need? yes? no?

1999-02-12 Thread Bill Sneed
The Hermit Hacker wrote: > > On Thu, 11 Feb 1999, dustin sallings wrote: > > > On Thu, 11 Feb 1999, Stephan Doliov wrote: > > > > So, are we serious about this? Should we start up a list for > > details? > > Like, [EMAIL PROTECTED] :) How much of what is already > done by the Do

Re: Subject: Re: [GENERAL] A book for PgSQL? A need? yes? no?

1999-02-12 Thread The Hermit Hacker
On Thu, 11 Feb 1999, dustin sallings wrote: > On Fri, 12 Feb 1999, The Hermit Hacker wrote: > > //Like, [EMAIL PROTECTED] :) How much of what is already > // done by the Docs Team pertinent to all this, and, if not, why not? > // If our existing manuals don't make good documentation, then

Re: Subject: Re: [GENERAL] A book for PgSQL? A need? yes? no?

1999-02-12 Thread The Hermit Hacker
On Thu, 11 Feb 1999, Rudy Gireyev wrote: > Additionally manuals tend to be more of a reference whereas a book is > primarily a tutorial, then at the end it can contain reference type material. > If the book were to be written it would need complete and working examples > followed by the exact r

Re: Subject: Re: [GENERAL] A book for PgSQL? A need? yes? no?

1999-02-12 Thread tc lewis
On Fri, 12 Feb 1999, The Hermit Hacker wrote: > > Like, [EMAIL PROTECTED] :) How much of what is already > done by the Docs Team pertinent to all this, and, if not, why not? If our > existing manuals don't make good documentation, then why not, and > shouldn't those be fixed too? > sin

Re: Subject: Re: [GENERAL] A book for PgSQL? A need? yes? no?

1999-02-12 Thread Clark Evans
The Hermit Hacker wrote: > On Thu, 11 Feb 1999, dustin sallings wrote: > > On Fri, 12 Feb 1999, The Hermit Hacker wrote: > > //Like, [EMAIL PROTECTED] :) How much of what is already > > // done by the Docs Team pertinent to all this, and, if not, why not? > > // If our existing manuals don't

[GENERAL] Re: [NOVICE] A book for PgSQL? A need? yes? no?

1999-02-12 Thread Clark Evans
Rich Shepard wrote: > > So, what I do is print out the docs, punch holes in them and put them > in a loose-leaf binder. Those folks who want to make the extra effort put > their docs out in .pdf format and I print them from Acrobat. Except that > my laser printer doesn't do duplex printing, i

Re: Subject: Re: [GENERAL] A book for PgSQL? A need? yes? no?

1999-02-12 Thread Stephan Doliov
On Fri, 12 Feb 1999, The Hermit Hacker wrote: > On Thu, 11 Feb 1999, dustin sallings wrote: > > On Thu, 11 Feb 1999, Stephan Doliov wrote: > > So, are we serious about this? Should we start up a list for > > details? > Like, [EMAIL PROTECTED] :) How much of what is already > done by th

Re: Subject: Re: [GENERAL] A book for PgSQL? A need? yes? no?

1999-02-12 Thread Clark Evans
Stephan Doliov wrote: > The efforts of the docs teams has been tremendous and valuable beyond > description. The existing docs are the right place to start. It's > certainly worth it however to expand some sections, create new ones, and > edit existing ones. From my point of view, the docs give

[GENERAL] Book recommendation

1999-02-12 Thread Simon Drabble
I'm looking for a really good book on SQL (not Postgres particularly) to include such arcanery as Triggers Stored procedures Query optimisation Examples illustrating these concepts will be a big bonus. Any recommendations? Si. -- Simon Drabble [EMAIL PROTECTED]

[GENERAL] Booleans and Casting

1999-02-12 Thread Paul Ramsey
I have the following SQL statement, which doesn't work (though I wish it did): select sum(value * ( plulabel = 'FO' )) from btmm group by gis_tag; PG quite correctly complains that: ERROR: There is more than one possible operator '*' for types 'float4' and 'bool' You will have to retype t

Re: Subject: Re: [GENERAL] A book for PgSQL? A need? yes? no?

1999-02-12 Thread Stephan Doliov
On Fri, 12 Feb 1999, Gene Selkov Jr. wrote: > > On Thu, 11 Feb 1999, Stephan Doliov wrote: > > [snip likes holding books in hand and sniffing moldy pages] > > Good point, but for any argument there are counter-arguments, and it is > sometimes so tempting to throw in a few good ones! > [snip litan

[GENERAL] Postgres Connection with postmaster

1999-02-12 Thread Dinesh Patil
Hi, Can you tell me how the Postmaster communicates with postgres database functions like Createdb, Destroydb, and createuser etc.. As i am trying to establish a connection betn postmaster & postgres but everytime following message is coming createdb: not found destroydb:not found FATAL: Stream