[SQL] fix uuid contrib module for Windows 64

As the subject implies, has this been fixed and is it in a currently released GA build?   Best Regards -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax

Re: [SQL] strange issue with UUID data types

ramme been migrated from 32 bit? The program is a Win32 program Best Regards Mike Gould -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

[SQL] strange issue with UUID data types

ut 10 days now trying to figure out why it works in one location and not others. Best Regards Michael Gould   -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax

[SQL] placement of stored procedures and contrib modules

. We don't get any error messages however we also don't get the results we are looking for, namely case insensitive search results. However, if we move the contrib module to the public schema, everything appears to work fine. Best Regards Mike Gould -- Michael Gould, Managing Pa

Re: [SQL] Issue with insert

Tom, Thanks, that's exactly what it was. Best Regards Mike Gould "Tom Lane" wrote: > Michael Gould writes: >> Here is the table DDL, > > Can't really test this since you didn't supply the source code for > those triggers: > >> CREATE T

Re: [SQL] Issue with insert

Here is the table DDL, To test you can either use the record below or make up anything you want. I've changed the isscontrib.citext to varchar and text data types and the results are the same. Best Regards Michael Gould CREATE TABLE "iss"."citystateinfo" ( "

[SQL] Issue with insert

is a issue for us because we want the user to type in either the zipcode if known to bring back the city and state, or the city,state to bring back the zipcode. Any idea's on why this could be happening. I'm running on Windows 7 x64 using 8.4.2 Best Regards -- Michael Gould, Managing Pa

Re: [SQL] Proper case function

s > > /* Nothing fancy and nothing Microsoft! */ > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > -- Michael Gould, Managing Partner Intermodal Software Solutions, LLC 904.226.0978 904.592.5250 fax -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

[SQL] Proper case function

g the contrib module citext which makes searching very nice. Best Regards Michael Gould -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] Schema's, roles and privileges

Thanks Mike Gould "Adrian Klaver" wrote: > On Monday 30 November 2009 6:50:27 am Michael Gould wrote: >> I have a database with a schema called ISS. This is where all of our >> application definitions are stored. We did add 2 contribute modules >> (citext) and g

[SQL] Schema's, roles and privileges

d. We have a separate userid for the security administrator. All of the functions that the security administrator needs are provided by a application module and they will not be directly accessing the database via a SQL utility at all. Best Regards -- Michael Gould, Managing Partner Intermodal Sof