[SQL] Issue with insert

I'm having a issue with a insert INSERT INTO iss.citystateinfo ( citystateinfoid, citystate, zipcode, cityname, statecode ) VALUES ( '31344342-3439-4135-2d32-3044462d3433', 'Orange Park,FL', '32065', 'Orange Park', 'FL' ); This inserts correctly, however when I view the

Re: [SQL] Issue with insert

On Sat, Feb 27, 2010 at 10:14 AM, Michael Gould mgo...@intermodalsoftwaresolutions.net wrote: I'm having a issue with a insert INSERT INTO  iss.citystateinfo (  citystateinfoid,  citystate,  zipcode,  cityname,  statecode ) VALUES (  '31344342-3439-4135-2d32-3044462d3433',  'Orange

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 ( citystateinfoid UUID DEFAULT

Re: [SQL] Issue with insert

Michael Gould mgo...@intermodalsoftwaresolutions.net writes: Here is the table DDL, Can't really test this since you didn't supply the source code for those triggers: CREATE TRIGGER insertcitystateinfo BEFORE INSERT OR UPDATE ON iss.citystateinfo FOR EACH ROW EXECUTE PROCEDURE

Re: [SQL] Issue with insert

Tom, Thanks, that's exactly what it was. Best Regards Mike Gould Tom Lane t...@sss.pgh.pa.us wrote: Michael Gould mgo...@intermodalsoftwaresolutions.net writes: Here is the table DDL, Can't really test this since you didn't supply the source code for those triggers: CREATE TRIGGER