[GENERAL] re: PgAdmin Location

1999-02-25 Thread Silvio Emanuel Barbosa de Macedo
Hello, >found a link to PgAdmin once but did not get the chance to download it. In the help about it reads: www.mindzone.demon.co.uk >most recent version they can send me? Also if anyone knows of some >Postgress~ friendly admin apps for Windows let me know. I use pgaccess on a X-window wi

Re: [GENERAL] Comments on tables, functions, etc.

1999-02-25 Thread Ross J. Reedstrom
Michael - I was just wondering this myself! I even dug into the source code, to see if I could find how the comments get in there. Couldn't find any existing SQL or psql command syntax, so I'm doing this: template1=> \d pg_description Table= pg_description +-

[GENERAL] Comments on tables, functions, etc.

1999-02-25 Thread Michael Davis
How can I add a comment to a table, function, etc. that will should up in a /dd comment in psql?

[GENERAL] Optimization - single / double key

1999-02-25 Thread Silvio Emanuel Barbosa de Macedo
Hi! I'm designing a database and I'm having some trouble selecting which optimizations should I implement (in Postgres and maybe Oracle) Can someone please give an opinion on the following ?: As an example of my doubt: Imagine two tables representing a trivial h

[GENERAL] Use of index with oid's

1999-02-25 Thread Adriaan Joubert
As I cannot return a complete row of a record from a function (written in PL), I return an oid. So the function looks like this CREATE FUNCTION task_next (int4) RETURNS oid AS ' DECLARE ... END; ' LANGUAGE 'plpgsql'; This function can return null. I then select the next row with tt> select * fr

[GENERAL] Q's: discussion group; pgsql authorization

1999-02-25 Thread Peter Blazso
Hi ! At first - if anyone knows - I'd like to know how & where to access the Postgresql discussion group (if exists)... My second question: How can I allow users in PgSQL to change their (and *only* their) password? (I have already tried to make a rule on pg_shadow & restrict access by updating

[GENERAL] Thanks for all your answers

1999-02-25 Thread Gilles Darold
Hi all, To many thanks for all your answer about ISP providing PostgreSQL account. I will study all this ISP and take a choice in the current of the next month. I very well surprise and happy that PostgreSQL is now part of professionnal offers all over the world. But the world is not France, or