On Wed, Jan 27, 2016 at 6:24 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Wed, Jan 27, 2016 at 4:03 PM, Don Parris wrote:
>
>
> Parameter passing and variables are client-side considerations. You
> haven't told us how you plan to execute the SQL.
>
>
On Wed, Jan 27, 2016 at 4:03 PM, Don Parris wrote:
> On Wed, Jan 27, 2016 at 4:25 PM, Joshua Berkus wrote:
>
>>
>>
>> > Am I on the right track, or is there some better way to set this up? My
>> > understanding is that views really aren't meant for
Don Parris wrote:
I have several tables...
and want db users to be able to add or update ...
... in one step, and get all the information
into the correct tables.
I think I am ok with setting the privileges on the tables and columns as
appropriate to allow each group to select, insert and
On Wed, Jan 27, 2016 at 4:25 PM, Joshua Berkus wrote:
>
>
> > Am I on the right track, or is there some better way to set this up? My
> > understanding is that views really aren't meant for insert/update
> > operations, and I have seen on the web that using views to
On Wed, Jan 27, 2016 at 4:25 PM, Joshua Berkus wrote:
>
>
> > Am I on the right track, or is there some better way to set this up? My
> > understanding is that views really aren't meant for insert/update
> > operations, and I have seen on the web that using views to
I have several tables related to people and their contact information, and
want db users to be able to add or update a given person and their
respective contact information in one step, and get all the information
into the correct tables.
I think I am ok with setting the privileges on the tables
On this track (possibly unrelated)...can a view be used as part of the
multi table update
Just curious
On Wed, 2016-01-27 at 14:48 -0500, Don Parris wrote:
> I have several tables related to people and their contact information,
> and want db users to be able to add or update a given person
On Wed, Jan 27, 2016 at 1:28 PM, Bret Stern <
bret_st...@machinemanagement.com> wrote:
> On this track (possibly unrelated)...can a view be used as part of the
> multi table update
> Just curious
>
Never done so myself but - I believe so though doing so over a one-to-many
relationship can be
> Am I on the right track, or is there some better way to set this up? My
> understanding is that views really aren't meant for insert/update
> operations, and I have seen on the web that using views to insert/update is
> a bit tricky - and still requires a procedure with a rule on the view.