[ADMIN] unsubscribe pgsql-advocacy

2003-10-21 Thread Jean-Luc Lachance
---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] unsubscribe pgsql-benchmarks

2003-10-21 Thread Jean-Luc Lachance
---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[ADMIN] unsubscribe pgsql-benchmarks

2003-10-21 Thread Jean-Luc Lachance
---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [ADMIN] How do I grant access to entire database at

2004-07-26 Thread Jean-Luc Lachance
I have been thinking about this problem for quite a while. Proper administration require creation of groups. Adding a new user to a database is as simple as adding the user to the group that has the required privileges to the database. But, I think one new command would be very usefull. CREATE GR

Re: [ADMIN] duplicates

2004-09-06 Thread Jean-Luc Lachance
If the reccord you are inserting do not depend on data in the record you want to delete, why not simply use a trigger? Before insert delete the record with the same key! Michael Paesold wrote: Tsirkin Evgeny wrote: one moer question ,how did you tested it? I have tested this here. I don't real

Re: [ADMIN] Useless index

2002-02-14 Thread Jean-Luc Lachance
Here is another peeve Having to specify the type of a constant in a SELECT DISTINCT 'foo'... I which I had more spare time to contribute... Jean-Luc Tom Lane wrote: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > In fact, I am unsure why you are specifying the primary column in the > > ORD

Re: [ADMIN] error during copying .txt file

2002-03-19 Thread Jean-Luc Lachance
Rama, Are psql and the postgres server on the same machine? If so, make sure the file is world readable (and the directories as well). If not, try: psql -h host -d database -c "copy hour from stdin delimiters ',';" < /home/staff/band.txt rama tulasi wrote: > > hi, > can you help me to solve th

Re: [ADMIN] indexes separate from data

2002-04-03 Thread Jean-Luc Lachance
Interesting... What happens when you drop and recreate the index??? Marin Dimitrov wrote: > > - Original Message - > From: "Judy Jecelin" > > > > > Hi, > > > > A relatively novice user of PostgreSQL but not > > of other databases... I'm trying to understand the > > use of initlocation.

Re: [ADMIN] command line client on windows?

2002-09-25 Thread Jean-Luc Lachance
Why not use telnet??? Laurette Cisneros wrote: > > I don't suppose anyone has this compiled for win2000 already as I don't > have MSVC++ available? > > L. > On Sat, 21 Sep 2002, Peter Eisentraut wrote: > > > Laurette Cisneros writes: > > > > > Is there a command line client to run sql against

Re: [ADMIN] list schema

2002-12-05 Thread Jean-Luc Lachance
How about \D for Domains... BTW, because many people ask how to do the equivalant in SQL of a \ command, why not be done with the \ commands which are criptic anyway and instead create global stored procedures like: sp_list_databases() sp_list_schemas() sp_list_{whatever}() sp_enable_{this}() sp_

Re: [ADMIN] [BUGS] 7.3 RMPS bugs ( pgdb.py and postgresql launch script

2002-12-09 Thread Jean-Luc Lachance
Lamar Owen wrote: >[...] > > 2) when postgres is launched the script do: > > echo " [ OK ] " > > but should be more correctly: > > echo_success > > Hmmm. I thought that used to work right let me check. It will work the same (if the format did not change), but I can mod

Re: [ADMIN] Extracting single coordinate from a box

2003-08-28 Thread Jean-Luc Lachance
I think you are forgetting that a box is an array of one dimension with two points. So, the first point is B[0] and the second is B[1]. Donald Fraser wrote: > > Thanks for the quick response. > > - Original Message - > > "Donald Fraser" <[EMAIL PROTECTED]> writes: > > > But when I try s