[GENERAL] Updating a view

2001-08-15 Thread Ryan C. Bonham
Hi, Ok i know this is something stupid, somebody mind explaining it to me? Also sorry if this gets posted twice, i got a error back the first time.. I have a Visual Basic Project that access a PostgreSQL Datbase. One Form pulls information from a View in postgres. If teh user changes anything on

RE: [GENERAL] why no stored procedures?

2001-08-15 Thread roypgsqlgen
> -Original Message- > From: Jan Wieck [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 14, 2001 10:51 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: [GENERAL] why no stored procedures? > > [EMAIL PROTECTED] wrote: > > Hey guys, > > > > Is there any reason why there a

[GENERAL] PostgreSQL Article on tucows

2001-08-15 Thread Justin Clift
Hi all, Branden has written an "Introduction to PostgreSQL" article for the Tucows network (another high profile group of sites): http://news.tucows.com/ http://news.tucows.com/linux/40605.html :-) Regards and best wishes, Justin Clift -- "My grandfather once told me that there are two kind

Re: [GENERAL] do I have a reserved word here or something???

2001-08-15 Thread Peter Haworth
On Tue, 14 Aug 2001 12:25:54 -0400 (EDT), Jeremy Hansen wrote: > > INSERT into env_info > (username,useremail,servicelevel,accountmanager,company) values > ('$env_array{User}','$env_array{UserEmail}','$env_array{ServiceLevel}' > ,'$env_array{AccountManager}','$env_array{Company}' > > I sometim

Re: [GENERAL] Re: nextval, sequences and sequencenames

2001-08-15 Thread Martijn van Oosterhout
On Wed, Aug 15, 2001 at 10:49:38AM +0200, Wieger Uffink wrote: > Hi, > > First of all thanks for the reactions, but I think I have probably not > made my problem clear enough. > > I know the sequence name will be some combination, usually as > 'tablename_columnname_seq', > when implicitly create

Re: [GENERAL] Re: nextval, sequences and sequencenames

2001-08-15 Thread Wieger Uffink
Hi, First of all thanks for the reactions, but I think I have probably not made my problem clear enough. I know the sequence name will be some combination, usually as 'tablename_columnname_seq', when implicitly created during table creation. But when I create my table 'maincompetencies' with ser

Re: [GENERAL] Re: nextval, sequences and sequencenames

2001-08-15 Thread Martijn van Oosterhout
On Wed, Aug 15, 2001 at 12:14:02PM +1000, Chris wrote: > >If it is very difficult finding that sequence name (I'm not sure) > >You may want to create the sequence yourself instead of using SERIAL. > >Then you would know the name. > > Not hard at all. > > csmith=# create table test (testid serial