[SQL] serial column vs. explicit sequence question

2002-06-13 Thread Charlie Toohey
I'm having a problem and there seems to be 2 solutions. It is simple and straighforward, but will take several paragraphs to explain. I have a schema with a master-detail design. The master table does not have an expicit id, so I have a column of type serial. Lets say I need to insert a row i

Re: [SQL] serial column vs. explicit sequence question

2002-06-13 Thread Charlie Toohey
quence may have been incremented by another session ? On Thursday 13 June 2002 02:06 pm, Stephan Szabo wrote: > On Thu, 13 Jun 2002, Charlie Toohey wrote: > > I'm having a problem and there seems to be 2 solutions. It is simple and > > straighforward, but will take several paragra

Re: [SQL] serial column vs. explicit sequence question

2002-06-13 Thread Charlie Toohey
iving your message, I posted a reply basically asking how currval would work if there were concurrent updates --- please ignore that response. thanks everyone --- I now feel "empowered" to carry on with my project On Thursday 13 June 2002 03:01 pm, Jason Earl wrote: > Charlie T

[SQL] schema-qualified permission problem

2003-05-29 Thread Charlie Toohey
Why can't my primary user (ttvuser) access tables (owned by owneruser) for which they've been granted access? I can describe the table, but can't read it. === Here's what I'm getting: ttvdev=> \c - owneruser Password: You are now connected as new user owneruser. ttvdev=> \d