Hi Nigel,
It all seems to work as expected for me using this code:
https://play.golang.org/p/QGBT6kqxHBS
I'm using Postgres 9.5.12.
Can you distill your problem into some self-contained code that
demonstrates the issue?
cheers,
rog.
On 7 October 2013 at 10:46, Nigel Vickers <rhed...@gmail.com> wrote:
>
> The fields in the database, apart from the bytea, are being correctly
> inserted. The []byte array is being populated and passed but the bytea field
> remains empty. The db log file records no error. There are signs that insert
> is being carried out twice, once with the correct payload and a second time
> with an empty []byte. I have as yet been unable to isolate this second call
> if it exists.
>
>
> // type Attachment
>
> type MsgAttachment struct{
> Mattachmentnr sql.NullInt64
> Messagefk sql.NullInt64
> Aname sql.NullString
> Mblob []byte
> }
>
>
> // DML vom db
>
> CREATE TABLE msgattachment
>
>
> (
>
> mattachnr serial NOT NULL,
>
> messagefk int,
>
> aname text,
>
> ablob bytea
>
> )
>
>
>
> //call after declaration and population
>
>
> msga.InsertAttachment()
>
>
> func (a MsgAttachment) InsertAttachment() error {
>
> rhediledb, err := sql.Open("postgres", connectString)
> if err != nil {
> fmt.Println("in InsertAttachment sql.Open failed",
> err)
> }
>
> defer rhediledb.Close()
>
> stmt, err := rhediledb.Prepare("INSERT INTO msgattachment (
> messagefk, aname, ablob) Values($1,$2,$3)")
>
> if err != nil {
> fmt.Println("in InsertAttachment prepare error:", err)
> }
> res, err := stmt.Exec(a.Messagefk, a.Aname, a.Mblob)
> if err != nil {
> fmt.Println("in InsertAttachment exec error:", res, err)
> }
> return err
> }
>
> --
> You received this message because you are subscribed to the Google Groups
> "golang-nuts" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to golang-nuts+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
--
You received this message because you are subscribed to the Google Groups
"golang-nuts" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to golang-nuts+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
