Skip to content

Valid struct fields getting ignored #2036

Description

@pWoLiAn
package main

import (
	"context"
	"log"

	"github.com/go-pg/pg/v10"
	"github.com/go-pg/pg/v10/orm"
)

type TestStruct struct {
	Foo string `pg:"bar"`
	Bar string `pg:"-"`
}

func main() {
	db := pg.Connect(&pg.Options{
		Addr:     "localhost:30892",
		User:     "dbUser",
		Password: "dbPassword",
		Database: "postgres",
	})
	defer db.Close()

	// Enable query logging to see what SQL is generated
	db.AddQueryHook(queryLogger{})

	// Create table
	err := db.Model((*TestStruct)(nil)).CreateTable(&orm.CreateTableOptions{
		Temp: true,
	})
	if err != nil {
		log.Printf("Create table error: %v", err)
	}

	// Try to insert
	test := &TestStruct{Foo: "value1", Bar: "value2"}
	_, err = db.Model(test).Insert()
	if err != nil {
		log.Printf("Insert error: %v", err)
	}
}

// Query logger to see generated SQL
type queryLogger struct{}

func (q queryLogger) BeforeQuery(ctx context.Context, event *pg.QueryEvent) (context.Context, error) {
	query, err := event.FormattedQuery()
	log.Printf("SQL: %s", query)
	return ctx, err
}

func (q queryLogger) AfterQuery(ctx context.Context, event *pg.QueryEvent) error {
	return nil
}

Expected Behavior

2025/11/15 17:18:10 SQL: CREATE TEMP TABLE "test_structs" ("bar" text, PRIMARY KEY ("bar"))
2025/11/15 17:18:10 SQL: INSERT INTO "test_structs" ("bar") VALUES ('value1')

Current Behavior

2025/11/15 17:17:23 SQL: CREATE TEMP TABLE "test_structs" ()
2025/11/15 17:17:23 SQL: INSERT INTO "test_structs" () VALUES ()
2025/11/15 17:17:23 Insert error: ERROR #42601 syntax error at or near ")"

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions