[GENERAL] Happy Holidays

2005-12-24 Thread Andy Astor
To the PostgreSQL Community:   All of us at EnterpriseDB want to thank the community for creating an amazing base upon which to build our new company. It’s been a busy year for us, going from zero to 70 people, raising venture capital, and working hard to promote both PostgreSQL itself an

[GENERAL] Merry Christmas!

2005-12-24 Thread Joshua D. Drake
Hello, Just a small thank you to all the developers of PostgreSQL for making 2005 another incredible year for Command Prompt, Inc. Command Prompt hopes to continue increasing it's community contributions next year. Merry Christmas everyone! Sincerely, Joshua D. Drake President Command Prompt,

[GENERAL] Trigger Behavior in Transactions

2005-12-24 Thread Joshua Kramer
Greetings, Where in the documentation can I find information on the low-level behavior of triggers that fire as a result of insert/update statements inside of transactions? Do the triggers fire at the point the transaction is COMMITted? Or as soon as the statements are encountered? (If th

Re: [GENERAL] Login username char length

2005-12-24 Thread Mark Constable
On Saturday 24 December 2005 23:13, Tino Wildenhain wrote: > > Please excuse my naivety as I have never used postgresql. Could > > anyone please let me know if there is any char length limit for the > > username that logs into the database itself ? > ... > "name 64 bytesinternal type for ob

Re: [GENERAL] Login username char length

2005-12-24 Thread Tino Wildenhain
[EMAIL PROTECTED] schrieb: > Please excuse my naivety as I have never used postgresql. Could > anyone please let me know if there is any char length limit for the > username that logs into the database itself ? > experiment=# \d pg_user View "pg_catalog.pg_user" Column| Type | Modi

[GENERAL] Login username char length

2005-12-24 Thread markc
Please excuse my naivety as I have never used postgresql. Could anyone please let me know if there is any char length limit for the username that logs into the database itself ? --markc ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] newbie : setting access for users in a web enviroment

2005-12-24 Thread robert mena
Hi, thanks for the reply. I've already read the docs. I am using 8.0.5 btw. One of the things I am confused is how can I give the privileges to the database without having to know the specific tables. The grant command when applied to a database simply mentions CREATE so the user can create ta