[GENERAL] Default UUID in Postgres

Hello, I created a Postgres table with a UUID. I want the UUID to be populated by default. Sample table: CREATE TABLE "t" ( token uuid NOT NULL, CONSTRAINT unique_token UNIQUE (token) ); I tried out this post: http://archives.postgresql.org/pgsql-general/2006-08/msg01452.php CREATE TABLE t (

Re: [GENERAL] Using tables in other PostGreSQL database

I am fairly new to Postgres. However, I have to say that I agree with Barry's comments. The community's response is technically valid; they do talk about a better way of 'designing' things, and what the company 'should' be doing. However, coming from a MS-Sql world, people want multiple databases f

[GENERAL] NauckIT PostgreSQL provider working with Mono?

Hello, I was about to start on Forms Authentication with Postgres in .NET on Mono. I found this message from Kevin: http://www.mail-archive.com/[EMAIL PROTECTED]/msg23395.html but didn't find any responses. I was wondering whether anyone got this working, and has any documentation that can help.

[GENERAL] Cross database joins feature request

Thanks for telling me that Postgres doesn't support cross-database joins. I know MS Sql Server does. And one of the companies I worked for used it, to sometimes have a secure database with sensitive info behind a firewall join queries with a less secure database. Is this something worth considerin

Re: [GENERAL] Unicode comment on Postgres vs Sql Server

I didn't have proper knowledge about the UTF8 format, thanks. I originally meant nvarchar & nchar, which is basically varchar & char that supports Unicode regardless of the database encoding. On 3/2/08, Tino Wildenhain <[EMAIL PROTECTED]> wrote: > > Swaminathan Saikumar

[GENERAL] Design suggestion of multiple databases vs multiple schemas within the database

I am building a web app with Postgres, that also uses Drupal with Postgres. I am new to all these frameworks. There is some data that I'll need to cross-reference between the two databases. Can I do a cross-schema/catalog join? Or is a cross-database join better? Are there any gotchas for the cro

[GENERAL] Unicode comment on Postgres vs Sql Server

I am familiar with MS Sql Server & just started using Postgres. For storing Unicode, Sql Server uses nvarchar/char for unicode, and uses char/varchar for ASCII. Postgres has this encoding setting at the database level. I am using UTF8 Unicode for most of my data, but there is some data that I know

Re: [GENERAL] Is PostGreSql's Data storage mechanism "inferior"?

Thanks everyone. After all the good things I heard about Postgres, I was surprised to see this article; and the point on storage concerned me. I am glad to see that the article was wrong, not only on the storage engine count, but also on others. Thanks for the feedback. On 1/30/08, Erik Jones <[EM

[GENERAL] Is PostGreSql's Data storage mechanism "inferior"?

Hi all, I'm new to PostGreSql. http://searchyourwebhost.com/web-hosting/articles/insight-database-hosting-using-sql Check out the link. I am starting out on a new personal project & had zeroed in on PostGreSql with Mono-ASP.NET as ideal for my needs, mainly owing to a PostGreSql whitepaper. Now,