[ADMIN] how i can restrict databaseusers ?

2008-05-20 Thread pronix pronix
hello how i can restrict dbusers ( user's db size, cpu time)? how i can monitoring this parameters

[ADMIN] character varying exceeded

2008-05-20 Thread Marc Fromm
WE have a db with a column/field of type "character varying" set to a length of 1000. A user attempted to enter data into this column/field breached the 1000 limit. When the user submitted the form the data was not entered into the database and no error or message was displayed. Is there a way to

Re: [ADMIN] Buggy PostgreSQL dotNET data providers

2008-05-20 Thread Vishal Mailinglist
> > > > > > I managed to find a data provider for PostgreSQL other than the > > npgsql. its Core Labs's PostgreSQLDirect .NET > > http://crlab.com/pgsqlnet/ > > What was wrong with npgsql? > > > nothing wrong with npgsql . Somehow its documentation did not help me a lot (I was a novice at VB.NET p

Re: [ADMIN] character varying exceeded

2008-05-20 Thread Chander Ganesan
Marc Fromm wrote: WE have a db with a column/field of type "character varying" set to a length of 1000. A user attempted to enter data into this column/field breached the 1000 limit. When the user submitted the form the data was not entered into the database and no error or message was displayed.

Re: [ADMIN] how i can restrict databaseusers ?

2008-05-20 Thread Travis Smith
how i can restrict dbusers ( user's db size, cpu time)? http://www.enterprisedb.com/documentation/kernel-resources.html#AEN32652 how i can monitoring this parameters perl & /proc maybe.. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of p

Re: [ADMIN] character varying exceeded

2008-05-20 Thread Andrew Sullivan
On Tue, May 20, 2008 at 08:19:56AM -0700, Marc Fromm wrote: > breached the 1000 limit. When the user submitted the form the data was > not entered into the database and no error or message was displayed. I think your application is broken. There was so an error message generated. It sounds like

Re: [ADMIN] how i can restrict databaseusers ?

2008-05-20 Thread Scott Marlowe
On Tue, May 20, 2008 at 7:57 AM, pronix pronix <[EMAIL PROTECTED]> wrote: > hello > how i can restrict dbusers ( user's db size, cpu time)? > how i can monitoring this parameters You can create table spaces for each user, and then create a db or schema or whatnot in that tablespace. If each table

[ADMIN] insert a -1 into a bigint ?

2008-05-20 Thread kevin kempter
Hi All: I have this table: # \d seg_id_tmp7 Table "public.seg_id_tmp7" Column |Type | Modifiers -+-+--- customer_srcid | bigint | show_srcid | bigint

Re: [ADMIN] insert a -1 into a bigint ?

2008-05-20 Thread kevin kempter
I forgot to mention - I'm running version 8.3.1 On May 20, 2008, at 12:14 PM, kevin kempter wrote: Hi All: I have this table: # \d seg_id_tmp7 Table "public.seg_id_tmp7" Column |Type | Modifiers -+

Re: [ADMIN] insert a -1 into a bigint ?

2008-05-20 Thread Shane Ambler
kevin kempter wrote: Hi All: I want to insert some data along with a -1 for two of the bigint columns. like this: insert into seg_id_tmp7 ( customer_srcid, show_srcid, show_name, season_srcid, season_name, episode_srcid, episode_name, segment_type_id, segme

Re: [ADMIN] insert a -1 into a bigint ?

2008-05-20 Thread kevin kempter
wow, good catch. Thanks for taking the time to look. On May 20, 2008, at 1:22 PM, Shane Ambler wrote: kevin kempter wrote: Hi All: I want to insert some data along with a -1 for two of the bigint columns. like this: insert into seg_id_tmp7 ( customer_srcid, show_srcid, show_n