Postgresql Upgrade Problem?

Rick Harrison harrison at all-auctions.com
Thu Feb 2 23:05:29 EST 2012


Hi there,

I tried to use a program that I put together
several months ago with Livecode which used to work
just fine with the following default value in the database.

nextval('mytable1_assignedrecnum_seq'::regclass)

I changed nothing since I ran it last, and now
this same line throws a permissions error.

Is this problem as a result of an upgrade on OnRev
by runrev to a newer version of Postgresql?

Has the syntax for this statement changed as a result?
Or has someone forgotten to set access privileges for such
functions?

Any insight you folks can offer would be very welcome.

(I really hate it when upgrades break my code!  It's
very difficult to build a nice computer program when
seemingly everyone around you is hitting your working
program with a wreaking ball all the time.  Sorry, I 
just had to vent a little frustration here.  I'll be better
once this thing has been fixed.)  ;-)

Thanks in advance!

Rick





More information about the use-livecode mailing list