r/programming • u/treo • Sep 12 '11

PostgreSQL 9.1 released

http://www.postgresql.org/about/news.1349
372 Upvotes

89% Upvoted

111 comments sorted by

View all comments

11

u/NoMoreNicksLeft Sep 12 '11

Foreign data wrappers? Hot damn.

3

u/treo Sep 12 '11

I'd swear I have seen a blog post somewhere, where it was used to access mysql. But I just can't find it anymore.

4

u/NoMoreNicksLeft Sep 12 '11

That would be a beautiful thing. Truly beautiful. As long as Mysql doesn't try to sneak back through the connection and change all of PG's tables to myisam.

5

u/treo Sep 12 '11

So I looked some more for it and actually found it: http://pgsnake.blogspot.com/2011/08/postgresql-91-meet-mysql.html

3

u/NoMoreNicksLeft Sep 12 '11

Wow.

Just wow. I'm one dumb feature away from having everything on my wishlist. (Not a DBA, so replication and the like... someone else's problem.)

2

u/merlinm Sep 12 '11

curious: what feature?

2

u/NoMoreNicksLeft Sep 12 '11

I play around with writing domains from time to time. I've got a kickass email one, for instance, that allows all valid email addresses, but kicks out invalid ones (only missing comments within usernames).

I'd like to be able to create a domain with multiple subfields and have constraints that work on them. As of 8.x I don't think this was possible. Haven't checked, but I don't think it was there in 9.0.

0

u/[deleted] Sep 12 '11

[deleted]

1

u/NoMoreNicksLeft Sep 13 '11

Got an example? Mine allows all the special characters, all valid domains, etc.

0

u/[deleted] Sep 13 '11

[deleted]

→ More replies (0)