Argument name for sqlc.arg() can't be SQL keyword #2832

Activity

1. sgtsquiggs

   added

   bugSomething isn't workingSomething isn't working

   triageNew issues that hasn't been reviewedNew issues that hasn't been reviewed

   on Oct 11, 2023
2. sgtsquiggs commented on Oct 11, 2023

   

   sgtsquiggs

   on Oct 11, 2023

   Last edited by sgtsquiggs

   Author

   More actions

   I tried working around this by adding underscores to my parameter names, but the parameter names are used in the pgx CopyFrom statement instead of the proper column names.

   For example, if I use sqlc.arg(user_) it compiles fine, but the resulting code:

   func (q *Queries) StageUserData(ctx context.Context, arg []StageUserDataParams) (int64, error) {
   	return q.db.CopyFrom(ctx, []string{"user_data"}, []string{"id", "user_"}, &iteratorForStageUserData{rows: arg})
   }

   is incorrect - the insert statement defines the columns as id and user not id and user_.

   ☝️ this is a separate issue I will be filing here: #2833
3. kyleconroy

   removed

   triageNew issues that hasn't been reviewedNew issues that hasn't been reviewed

   on Oct 12, 2023
4. kyleconroy

   changed the title [-]Invalid argument to sqlc.arg() when the argument is `user`[/-] [+]Argument name for sqlc.arg() can't be SQL keyword[/+] on Oct 12, 2023
5. kyleconroy

   added

   📚 postgresql

   on Oct 12, 2023
6. kyleconroy commented on Oct 12, 2023

   

   kyleconroy

   on Oct 12, 2023

   Collaborator

   More actions

   user is a reserved keyword in PostgreSQL. To get around this limitation, put user in single quotes.

   -- name: StageUserData :copyfrom
   insert into "user_data" ("id", "user")
   values (sqlc.arg('id'), sqlc.arg('user'));

   https://play.sqlc.dev/p/9fa2777d8a0f6df949672259c122da0687e266745c84d2450bc291a9c701135f
7. sqlc-dev

   locked and limited conversation to collaborators on Oct 12, 2023
8. kyleconroy

   converted this issue into a discussion #2837 on Oct 12, 2023