Questions tagged [uuid]

A Universally Unique Identifier (UUID), GUID in Microsoft parlance.

15 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
7
votes
0answers
12k views

Generate UUID v4 automatically in MySQL

Is it possible to generate a UUID version 4 (completely random) in MySQL? I would like to use it as a primary key. Use Case Many systems will insert to the table, some may specify a UUID when ...
3
votes
1answer
4k views

How to fix issue uuid_generate_v1() does not exist in postgresql , actually i have the function under public schema

org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from da.test_get(cast(? as integer),cast(? as text),cast(? as text),cast(? as text),cast(? as text)...
3
votes
0answers
623 views

Which SQL Power Architect type to specify for [PostgreSQL] UUIDs/GUIDs in new column property template/UI?

I have inherited maintaining and extending SQL Power Architect projects in source control which are used to generate the DDL for project DB schemas. We are currently using PostgreSQL 9.5 and SQL Power ...
2
votes
0answers
145 views

ola hallengren Index Maintenance script - GUID Index

We been running ola hallengren Index Maintenance script and was ran into a problem with some indexes that have GUID as the Index Key, They are Frag and have a page count of 6,309, but they don’t get ...
1
vote
0answers
185 views

SQL Server Partition. How would splitting range with Guid work?

I have a very large table in my database, and it has a GUID column called Group_Id. This Group_Id has a pretty even split of data, and it would be beneficial to partition the table by this column. ...
1
vote
1answer
2k views

Cannot run 'uuid-ossp' functions even when it's activated

I want to generate a v4 uuid in PostgreSQL using the extension uuid-ossp, so in psql I ran: CREATE EXTENSION "uuid-ossp"; Then I ran SELECT uuid_generate_v1(); or SELECT uuid_generate_v4(); but I ...
1
vote
1answer
1k views

Convert SID string to varbinary(85)

My ssrs server was moved to a different domain because of which the Users table need to be updated with new SID current sid: S-1-5-21-39949945-591092532-1226208319-1007 I want to convert this sid ...
0
votes
0answers
25 views

UPDATE with UUID() sets all rows with the same value

Having a table t1 with the field f1 BINARY(16) the following command updates all rows with the same uuid value. UPDATE t1 SET f1 = UNHEX(REPLACE(UUID(), '-', '')); OK, somehow I must have totally ...
0
votes
1answer
32 views

About UUID and generators in PostgreSQL

I'm thinking to use UUID as PK for all tables into my new PostgreSQL database, for such a goal I will be using uuid_generate_v5 and uuid_ns_dns or uuid_ns_url functions, but I have some doubts: is ...
0
votes
1answer
1k views

generate array of unique uuid in postgreSQL

I would like to insert array of unique uuid values in table with uuid column as primary key. Table structure is CREATE TABLE Organisation (uuid id PRIMARY KEY DEFAULT uuid_generate_v4()); e.g. I ...
0
votes
1answer
55 views

NON-Random UUID keys in custom distributed DB

Is there any reason other than security for using random (or even semi-random) UUIDs as primary keys to database records? Is there any reason why I should not WANT to be able to use the UUID to ...
0
votes
0answers
1k views

How to pass array of UUIDs *OR* empty array and return implicit (inner join)?

How would I pass a list that is either full of UUIDs or empty, then return only joined records with those id values or all records if empty? This question (Casting an array of texts to an array of ...
0
votes
1answer
415 views

MySQL column that auto generates data, longer than UUID

My friend has the problem as shown below. He asked at StackOverFlow and there is no reply yet till now so I wish to help him to try the luck here. Thanks for everyone that helps. "I would like to ask ...
0
votes
1answer
959 views

MySQL is pretty slow after 50-100k rows whats happen?

i have trying now a lots of time, and i try to find a way there make sense to find out of my problem, but this problem stil make a lot perfumes issues. i testing it of on a developer server ( 2 cores,...
-2
votes
1answer
172 views

Difference between UUID UUID + Id

what is the difference between these 2 solutions: UUID as primary key VS auto-increment ID as primary key + new UUID field