Re: [SQL] [GENERAL] How to update multiple rows

o = pd2.murabano from parcelsdata pd2 where id = pd2.id -- substitute for whatever your primary key/condition is and kasarano = '1' and murabano = '119' Yeah, I left out the geometry thing as I'm too lazy to figure out where your brackets start and end ;) Alban Hertroys

Re: [SQL] 7.3 how remove password valid until

Bruce Momjian wrote: > I think you have to specify the data as 'infinity'. > > test=> CREATE USER x WITH VALID UNTIL '2005-01-01'; > CREATE USER > test=> ALTER USER x WITH VALID UNTIL 'infinity'; > ALTER USER > Than

[SQL] 7.3 : how add user when last user have lost 'createuser' option

i have execute ALTER USER postgres WITH NOCREATEUSER; it's work very well but now, i cant add, drop, alter user, alter group... ALTER USER postgres WITH CREATEUSER; --> ERROR : ALTER USER : permission denied there is a solution ? Thank ALban ---(end of b

[SQL] 7.3 how remove password valid until

How remove a password validity ? CREATE USSER x WITH VALID UNTIL 'uu' ALTER USSER x WITH VALID UNTIL 'uu' but how remove password valid until ? Thank Alban ---(end of broadcast)--- TIP 7: don't for