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 da
On Sat, Feb 27, 2010 at 10:14 AM, Michael Gould
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 Park,FL',
> '32065',
> '
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 isscon
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 TRIGGER "insertcitystateinfo" BEFORE INSERT OR UPDATE
> ON "iss"."citystateinfo" FOR EACH ROW
> EXECUTE PROCEDURE "iss"."insertcitystateinfofunc"();
> CREAT
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 TRIGGER "insertcitystateinfo" BEFORE INSERT OR UPDATE
>>