On 24 April 2014 05:32, David Fetter da...@fetter.org wrote:
On Wed, Apr 23, 2014 at 08:27:52PM -0400, Tom Lane wrote:
David Fetter da...@fetter.org writes:
Is there any good reason not to roll native UUID generation into
our standard distribution?
It's already there (as of 9.4) in
On Thu, Apr 24, 2014 at 3:59 PM, Simon Riggs si...@2ndquadrant.com wrote:
On 24 April 2014 05:32, David Fetter da...@fetter.org wrote:
Since contrib/pgcrypto is a module that might well not be installed,
people can't just build software for PostgreSQL and have UUIDs
available, certainly not in
On Wed, Apr 23, 2014 at 11:26 AM, David Rowley dgrowle...@gmail.com wrote:
but for a long time I've thought that it would be nice if
PostgreSQL came with an example database that had a number of tables,
perhaps that mock up some easy to relate to real-world application. These
would be very
2014-04-24 15:40 GMT+02:00 Marti Raudsepp ma...@juffo.org:
On Wed, Apr 23, 2014 at 11:26 AM, David Rowley dgrowle...@gmail.com
wrote:
but for a long time I've thought that it would be nice if
PostgreSQL came with an example database that had a number of tables,
perhaps that mock up some
Simon Riggs si...@2ndquadrant.com writes:
On 24 April 2014 05:32, David Fetter da...@fetter.org wrote:
Since contrib/pgcrypto is a module that might well not be installed,
people can't just build software for PostgreSQL and have UUIDs
available, certainly not in the sense that, for example,
On Thu, Apr 24, 2014 at 11:21 AM, Pavel Stehule pavel.steh...@gmail.comwrote:
2014-04-24 15:40 GMT+02:00 Marti Raudsepp ma...@juffo.org:
On Wed, Apr 23, 2014 at 11:26 AM, David Rowley dgrowle...@gmail.com
wrote:
but for a long time I've thought that it would be nice if
PostgreSQL came
On 04/24/2014 04:57 PM, Tom Lane wrote:
Simon Riggs si...@2ndquadrant.com writes:
On 24 April 2014 05:32, David Fetter da...@fetter.org wrote:
Since contrib/pgcrypto is a module that might well not be installed,
people can't just build software for PostgreSQL and have UUIDs
available,
Hannu Krosing ha...@2ndquadrant.com writes:
On 04/24/2014 04:57 PM, Tom Lane wrote:
The reason why there's no generation function in core is that there is no
standardized, guaranteed-to-produce-a-universally-unique-value generation
algorithm. That was the reason for not putting something in
On Thu, Apr 24, 2014 at 11:30:15AM -0400, Tom Lane wrote:
Hannu Krosing ha...@2ndquadrant.com writes:
On 04/24/2014 04:57 PM, Tom Lane wrote:
The reason why there's no generation function in core is that
there is no standardized,
guaranteed-to-produce-a-universally-unique-value generation
David Fetter da...@fetter.org writes:
On Thu, Apr 24, 2014 at 11:30:15AM -0400, Tom Lane wrote:
Essentially, that would mean carrying around our own implementation
of libuuid --- which includes a bunch of not-terribly-portable
stuff, such as discovering the machine's MAC address(es). That's
Tom Lane wrote:
This is not our fault, and I don't want us to get caught up in trying
to fix a fundamentally broken concept --- which is what a generic
uuidserial API would be. If you try to paper over the difficulties
here, they'll just bite you on the rear someday.
But we have
On 04/24/2014 08:00 PM, Alvaro Herrera wrote:
Tom Lane wrote:
This is not our fault, and I don't want us to get caught up in trying
to fix a fundamentally broken concept --- which is what a generic
uuidserial API would be. If you try to paper over the difficulties
here, they'll just bite you
On 04/24/2014 10:00 AM, Alvaro Herrera wrote:
Tom Lane wrote:
This is not our fault, and I don't want us to get caught up in trying
to fix a fundamentally broken concept --- which is what a generic
uuidserial API would be. If you try to paper over the difficulties
here, they'll just bite
Heikki Linnakangas wrote:
On 04/24/2014 08:00 PM, Alvaro Herrera wrote:
Tom Lane wrote:
This is not our fault, and I don't want us to get caught up in trying
to fix a fundamentally broken concept --- which is what a generic
uuidserial API would be. If you try to paper over the difficulties
Alvaro Herrera wrote:
Heikki Linnakangas wrote:
On 04/24/2014 08:00 PM, Alvaro Herrera wrote:
Tom Lane wrote:
This is not our fault, and I don't want us to get caught up in trying
to fix a fundamentally broken concept --- which is what a generic
uuidserial API would be. If you try
On 04/24/2014 08:23 PM, Alvaro Herrera wrote:
Alvaro Herrera wrote:
Heikki Linnakangas wrote:
On 04/24/2014 08:00 PM, Alvaro Herrera wrote:
Tom Lane wrote:
This is not our fault, and I don't want us to get caught up in trying
to fix a fundamentally broken concept --- which is what a generic
Alvaro Herrera alvhe...@2ndquadrant.com writes:
Oh, I think I see your point: it's that no matter what we do here, there
would be no way to guarantee that a value we generate does not collide
with any other value elsewhere (either on other uuidserial columns, or
on other servers).
Not that
On Thu, 2014-04-24 at 13:45 -0400, Tom Lane wrote:
Having said that, though, the argument around whether such facilities
belong in core seems to devolve to whether you want to buy into
maintaining libuuid for ourselves (in fact worse than that: it's not
clear
that libuuid ever has worked on
We start with a database called Postgres and a schema called Public.
Yet we don't start up with any usable tables.
I propose we add a single table called Postgres when we Initdb
CREATE TABLE Postgres (Id Integer, Data Jsonb);
COMMENT ON TABLE Postgres IS 'Single table for quick start usage -
Simon Riggs si...@2ndquadrant.com writes:
By now, some of you will be doubled over laughing as if this is an
April fool joke.
Indeed.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
On 04/23/2014 02:11 PM, Simon Riggs wrote:
I propose we add a single table called Postgres when we Initdb
CREATE TABLE Postgres (Id Integer, Data Jsonb);
Without particular comment on the need for the table, I'd be concerned
about calling it postgres.
My personal impression from Stack
Hello
if you are thinking about this direction, then store there some demo
project.
I am don't think so isolated table has significant price.
Regards
Pavel
2014-04-23 8:45 GMT+02:00 Craig Ringer cr...@2ndquadrant.com:
On 04/23/2014 02:11 PM, Simon Riggs wrote:
I propose we add a single
Simon Riggs wrote:
I propose we add a single table called Postgres when we Initdb
CREATE TABLE Postgres (Id Integer, Data Jsonb);
COMMENT ON TABLE Postgres IS 'Single table for quick start usage -
design your database';
The purpose of this is to make the database immediately usable.
On 04/23/2014 03:20 PM, Albe Laurenz wrote:
Good that you mention that! I have wondered what to do with it.
When I first connected to PostgreSQL, I created a sample table, but the
senior developer from the other office told me that this is the postgres
database and that I shouldn't create any
On 23 April 2014 07:14, Tom Lane t...@sss.pgh.pa.us wrote:
Simon Riggs si...@2ndquadrant.com writes:
By now, some of you will be doubled over laughing as if this is an
April fool joke.
Indeed.
I do like to share the odd joke now and then, it has to be said. So
I'm glad I enriched your day.
Craig Ringer wrote:
Good that you mention that! I have wondered what to do with it.
When I first connected to PostgreSQL, I created a sample table, but the
senior developer from the other office told me that this is the postgres
database and that I shouldn't create any objects there.
What
On Wed, Apr 23, 2014 at 6:11 PM, Simon Riggs si...@2ndquadrant.com wrote:
I propose we add a single table called Postgres when we Initdb
CREATE TABLE Postgres (Id Integer, Data Jsonb);
COMMENT ON TABLE Postgres IS 'Single table for quick start usage -
design your database';
The purpose
On 04/23/2014 08:11 AM, Simon Riggs wrote:
We start with a database called Postgres and a schema called Public.
Yet we don't start up with any usable tables.
I propose we add a single table called Postgres when we Initdb
CREATE TABLE Postgres (Id Integer, Data Jsonb);
COMMENT ON TABLE
On 23 April 2014 09:26, David Rowley dgrowle...@gmail.com wrote:
On Wed, Apr 23, 2014 at 6:11 PM, Simon Riggs si...@2ndquadrant.com wrote:
I propose we add a single table called Postgres when we Initdb
CREATE TABLE Postgres (Id Integer, Data Jsonb);
COMMENT ON TABLE Postgres IS 'Single
This seems like a much better idea - whereas a single table, related to
nothing - on the other hand, is at best not very helpful (and it could
be argued, might contribute to teaching poor data data design).
Regards
Mark
On 23/04/14 19:13, Pavel Stehule wrote:
Hello
if you are thinking
* Simon Riggs (si...@2ndquadrant.com) wrote:
+1 to the idea of an example database, used throughout the docs
Sounds like a summer of code project.
Agreed. I'll add it to the GSoC ideas page.
Since we don't have that now, it won't work for 9.4.
None of this is on the table for 9.4 as far as
On 04/23/2014 03:28 PM, Stephen Frost wrote:
* Simon Riggs (si...@2ndquadrant.com) wrote:
+1 to the idea of an example database, used throughout the docs
Sounds like a summer of code project.
Agreed. I'll add it to the GSoC ideas page.
I don't think this is a good GSoC project.
On 23 April 2014 13:46, Heikki Linnakangas hlinnakan...@vmware.com wrote:
On 04/23/2014 03:28 PM, Stephen Frost wrote:
* Simon Riggs (si...@2ndquadrant.com) wrote:
+1 to the idea of an example database, used throughout the docs
Sounds like a summer of code project.
Agreed. I'll add it to
Heikki,
* Heikki Linnakangas (hlinnakan...@vmware.com) wrote:
On 04/23/2014 03:28 PM, Stephen Frost wrote:
Agreed. I'll add it to the GSoC ideas page.
I don't think this is a good GSoC project. Documentation-only
projects are not eligible for GSoC
On Wed, Apr 23, 2014 at 10:11 AM, Simon Riggs si...@2ndquadrant.com wrote:
We start with a database called Postgres and a schema called Public.
Yet we don't start up with any usable tables.
I propose we add a single table called Postgres when we Initdb
CREATE TABLE Postgres (Id Integer,
On Wed, Apr 23, 2014 at 4:50 AM, Simon Riggs si...@2ndquadrant.com wrote:
On 23 April 2014 07:14, Tom Lane t...@sss.pgh.pa.us wrote:
Simon Riggs si...@2ndquadrant.com writes:
By now, some of you will be doubled over laughing as if this is an
April fool joke.
Indeed.
I do like to
On 04/23/2014 07:43 AM, Alexander Korotkov wrote:
I can propose contrib PostgreNoSQL providing following:
1) Table postgres as you proposed.
2) Functions: get_postgres(id intgeger) returns jsonb, set_postgres(id
integer, data jsonb) returns void, search_postgres(query jsonb) returns
setof
Josh Berkus wrote:
On 04/23/2014 07:43 AM, Alexander Korotkov wrote:
I can propose contrib PostgreNoSQL providing following:
1) Table postgres as you proposed.
2) Functions: get_postgres(id intgeger) returns jsonb, set_postgres(id
integer, data jsonb) returns void, search_postgres(query
On Wed, Apr 23, 2014 at 02:26:50PM -0300, Alvaro Herrera wrote:
Josh Berkus wrote:
On 04/23/2014 07:43 AM, Alexander Korotkov wrote:
I can propose contrib PostgreNoSQL providing following:
1) Table postgres as you proposed.
2) Functions: get_postgres(id intgeger) returns jsonb,
On Wed, Apr 23, 2014 at 12:24:21PM -0700, David Fetter wrote:
On Wed, Apr 23, 2014 at 02:26:50PM -0300, Alvaro Herrera wrote:
Josh Berkus wrote:
On 04/23/2014 07:43 AM, Alexander Korotkov wrote:
I can propose contrib PostgreNoSQL providing following:
1) Table postgres as you
David Fetter da...@fetter.org writes:
Is there any good reason not to roll native UUID generation into our
standard distribution?
It's already there (as of 9.4) in pg_crypto.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To
On Wed, Apr 23, 2014 at 08:27:52PM -0400, Tom Lane wrote:
David Fetter da...@fetter.org writes:
Is there any good reason not to roll native UUID generation into
our standard distribution?
It's already there (as of 9.4) in pg_crypto.
Sorry I wasn't clear enough.
Since contrib/pgcrypto is
42 matches
Mail list logo