On Monday, February 28, 2011 2:39:07 pm Alan Acosta wrote: > But i have a new problem there, i have no rows for update, i create new > rows when the seats are sold, cause rarely the database knows the capacity > of the bus, number of seats, even some bus doesn't have seat number 4 for > example So how does the customer know what seat to choose? Or to put it another way, when the INSERT is done where does the seat number come from? > > :p. So i cannot SELECT FOR UPDATE no existent rows, but i still need to > :lock > > in some way in order to check if seat number X was already sold or is free > ! > > Alan Acosta -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
