Re: MS SQL Server compatibility functions - Mailing list pgsql-hackers

From Pollard, Mike
Subject Re: MS SQL Server compatibility functions
Date
Msg-id 6418CC03D0FB1943A464E1FEFB3ED46B01B220DD@im01.cincom.com
Whole thread Raw
In response to MS SQL Server compatibility functions  (Fredrik Olsson <fredrik.olsson@treyst.se>)
List pgsql-hackers
If you're referring to my procedure for newid(), then it was just
because of pure laziness; it was an internal proof of concept project,
and I was still concentrating on getting it working.

Mike Pollard
SUPRA Server SQL Engineering and Support
Cincom Systems, Inc.
--------------------------------Better to remain silent and be thought a fool than to speak out and
remove all doubt.        Abraham Lincoln

-----Original Message-----
From: Christopher Kings-Lynne [mailto:chriskl@familyhealth.com.au]
Sent: Thursday, November 24, 2005 5:57 AM
To: Mario Weilguni
Cc: pgsql-hackers@postgresql.org; Pollard, Mike; Bill Bartlett; Fredrik
Olsson
Subject: Re: [HACKERS] MS SQL Server compatibility functions

> Why do you use "GRANT ALL" and not "GRANT SELECT, UPDATE"? All means
everybody
> can do bad things with those sequences.

GRANT ALL on a sequence IS GRANT SELECT & UPDATE.

Chris


pgsql-hackers by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: NVL vs COALESCE
Next
From: Tom Lane
Date:
Subject: Re: PL/php in pg_pltemplate