Re: [SQL] uniqueidentifier datatype for 7.3.X

2002-11-03 Thread Dmitry G. Mastrukov
÷ ÷ÓË, 03.11.2002, × 19:08, Tom Lane ÎÁÐÉÓÁÌ: > "Dmitry G. Mastrukov" =?koi8-r?Q?=E4=CD=C9=D4=D2=C9=CA_?= >=?koi8-r?Q?=E7=C5=CE=CE=C1=C4=D8=C5=D7=C9=DE_?= >=?koi8-r?Q?=ED=C1=D3=D4=D2=C0=CB=CF=D7?= <[EMAIL PROTECTED]> writes: > > In this release there is additional

[SQL] uniqueidentifier datatype for 7.3.X

2002-11-03 Thread Dmitry G. Mastrukov
Hi All! I've ported uniqueidentifier datatype to upcoming PostgreSQL 7.3. It's available at http://www.taurussoft.org/files/uniqueidentifier-0.1.9.3.tar.gz In this release there is additional function uniqueidentifier_text() which converts uniqueidentifier to text datatype. Thanks to Hussein Patni

Re: [SQL] GUID in postgres

2001-10-26 Thread Dmitry G. Mastrukov
On ðÔÎ, 2001-10-26 at 21:14, [EMAIL PROTECTED] wrote: > Hi > > I think most of you are missing the point here. > I'm missing nothing :) "uniqueidentifier" (128-bit unique value) data type fot PostgresSQL exists and is used at least by me. It utilizes functionality of uuid library from widely use

Re: [SQL] GUID in postgres

2001-10-26 Thread Dmitry G. Mastrukov
On óÒÄ, 2001-10-24 at 09:55, Dinesh Parikh wrote: > Hi, > Is there any concept of sys_Guid in postgres. > If yes what is that ?? > As i am using GUID in sql and oracle, then what is counterpart of this in postgres. >It is urgent. > > Thanks in advance > Bye > Dinesh Parikh > Look at http://www

Re: [SQL] Execute permsissions on fuctions

2001-08-24 Thread Dmitry G. Mastrukov
23 Aug 2001 11:52:25 -0700, Zot O'Connor > Other SQL servers have the concept of stored procedures having different > permissions. > > For instance a procedure that can update a table. > > Since a web site typically connects as the webuser (or equiv postgres > user), I do not want to offer

Re: [SQL] Creating foreign key constraint to child table?

2001-08-05 Thread Dmitry G. Mastrukov
05 Aug 2001 13:49:22 +0100, Allan Engelhardt > I would like to create a FOREIGN KEY constraint to an inherited column, like: > > test=# CREATE TABLE foo(id INTEGER PRIMARY KEY); > test=# CREATE TABLE bar() INHERITS (foo); > test=# CREATE TABLE baz (bar INTEGER, CONSTRAINT fk_bar

[SQL] GRANT EXECUTE

2001-06-10 Thread Dmitry G. Mastrukov
Hi, All! IMHO it will be useful to have EXECUTE privilege on procedures. It may be realized through GRANT SELECT ON [procedure] since we cannot directly execute procedure in SQL. But anyway ability to restrict access to procedures seems good thing. What do you think about it? Dmitry -