Re: [SQL] Postgres DB

2004-02-22 Thread Tom Lane
"Sumita Biswas" <[EMAIL PROTECTED]> writes: > But when I type the command "psql" and don't specify a DB name, it says > that: > psql: FATAL: Database "postgres" does not exist in the system catalog. Yes, because psql's default behavior is to try to connect to the DB with the same name as your use

Re: [SQL] Compiling pl/pgsql functions

2004-02-22 Thread Josh Berkus
Rod, > This is another one of those items where it would be nice if users > didn't need access to read the system tables, but instead could rely on > the information schema (with extensions) to see what they own or have > access to use -- but nothing else. Hmmm, that is a good question: can I, as

Re: [SQL] User defined types -- Social Security number...

2004-02-22 Thread Josh Berkus
Greg, > Anyone have a good pre-built user-defined type definition for creating / > maintaining / manipulating a SSN ... where valid chars are in the range > 000-00- through 999-99-. Actually, the range is more narrowly defined than that. I'm not sure of the exact rules, but you will nev