Re: [GENERAL] Postgres users/groups

2001-02-03 Thread Richard Huxton
Adam Lang wrote: > > Postgres can only do authentication with its internal scheme correct? It is > not possible to plug in another "module"? it can use a file similar to /etc/passwd or kerberos detail in the html docs (administrator section) > Example: I have windows desktops and run samba fo

[GENERAL] CygIPC 1.08 Source Code : Where ?

2001-02-03 Thread Eric Nicolas
I don't find that nowhere on the net. I only have a broken 1.07 binary. THe official site for it (cygutils.netpedia.org) is password protected !!! Help. Eric

Re: [GENERAL] trying to back up a database

2001-02-03 Thread Peter Eisentraut
Adam Haberlach writes: > Sorry--I mean that when I type "pg_dumpall -h, it connects", but I guess > that is because it is a simple script. Nobody ever said that '-h' prints a help screen. > > pg_dumpall must be run by postgres, it may well have problems if you > > are running it as an unp

Re: [GENERAL] trying to back up a database

2001-02-03 Thread Oliver Elphick
Peter Eisentraut wrote: >> > pg_dumpall must be run by postgres, it may well have problems if you >> > are running it as an unprivileged user. > >Nope Seeing that the unprivileged user may not have SELECT permission on some of the tables, he ought to have problems! -- Oliver Elphick

RE: [GENERAL] GIS-type databases using PostgreSQL

2001-02-03 Thread Ken Mort
This would be a great addition to PG. I queried about this many years ago (I think to Tom Lockhart) but I think there were other priorities at that time. I spoke to two groups (PostgreSQL Inc and GreatBridge) at this year's Linux Expo in New York about this topic. I will forward your project'

[GENERAL] Re: CygIPC 1.08 Source Code : Where ?

2001-02-03 Thread Fred Yankowski
http://www.neuro.gatech.edu/users/cwilson/cygutils/V1.1/cygipc/index.html -- Fred Yankowski [EMAIL PROTECTED] tel: +1.630.879.1312 Principal Consultant www.OntoSys.com fax: +1.630.879.1370 OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA

Re: [GENERAL] PostgreSQL profiling?

2001-02-03 Thread Tom Lane
Alex Pilosov <[EMAIL PROTECTED]> writes: > Have someone made effort to do profiling of pgsql during execution of > certain things (inserts, selects, sorting, indices)? Yes ... > I have a feeling (based on stopping postgres from gdb periodically), that > a lot of time is used in strcoll() (if ta

[GENERAL] php & postgresql data type

2001-02-03 Thread Denni
hi I'm newbie here, I've a little knowledge about postgresql. I'm planning to make a project for my school's assignment about php using PostgreSQL as the database server. I'm planning to use arrays data type and inheritance in PostgreSQL. My question is can php3/php support this feature? Tha

Re: [GENERAL] Query plan: varchar vs char indexes

2001-02-03 Thread Tom Lane
"Richard Huxton" <[EMAIL PROTECTED]> writes: > With indexed varchar fields the explain changes - performing a seq-scan on > users rather than using the index. > Is this because the estimator guesses costs differently for char vs varchar > or is it because I'm not explicitly casting the id fields?

Re: [GENERAL] 7.0 configuration

2001-02-03 Thread Tom Lane
"Belcher, Jim" <[EMAIL PROTECTED]> writes: > When the system boots, and Postgres is attempting to > start, I get the following error: 564, unary operator expected. I don't believe any part of Postgres itself issues such an error code. Perhaps the message is coming out of your shell, which would

Re: [GENERAL] DEBUG strings

2001-02-03 Thread Tom Lane
Ferruccio Zamuner <[EMAIL PROTECTED]> writes: > Then I've restored some db dumps from (A) to (B) without any > problem, Just exactly how did you do the restore? It looks to me like your pg_log (transaction commit info) might be out of sync with transaction numbers in the database ...

Re: [GENERAL] Postgres SQL 7.1 a thank you and a possible bug

2001-02-03 Thread Tom Lane
"Nic Ferrier" <[EMAIL PROTECTED]> writes: > The synopsis of the problem is that date columns don't seem to be > working as dates when they're selected through a union view. No, the problem is that restriction clauses applied to views that contain unions are busted in beta4 :-(. Thanks for the bu

[GENERAL] automatic type cast to numeric ?

2001-02-03 Thread Peter Vazsonyi
Gretings! I try to change from using of float8 to numeric... For quantitative calculations and storage the float8 wasn't the best choice;) For some reasons i need automatic or explicit type cast from text to numeric and vice versa. But: test=# select '123'::text::numeric; ERROR: Cannot cast type