Dr Use
Dr Use
Explore posts from servers
SSolidJSTSDThe Swift DenDTDrizzle Team
PostsComments
DTDrizzle Team
Created by Dr Use on 1/10/2025 in #help
define where query outside
I have this error 
PostgresError: invalid reference to FROM-clause entry for table "orders"
    at ErrorResponse
    at handle
    at Socket.data 
    at Socket.emit (node:events:514:28)
    at addChunk (node:internal/streams/readable:376:12)
    at readableAddChunk (node:internal/streams/readable:349:9)
    at Readable.push (node:internal/streams/readable:286:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)
    at TCP.callbackTrampoline (node:internal/async_hooks:130:17) {
  severity_local: 'ERROR',
  severity: 'ERROR',
  code: '42P01',
  hint: 'Perhaps you meant to reference the table alias "ordersTable".',
  position: '2218',
  file: 'parse_relation.c',
  line: '3597',
  routine: 'errorMissingRTE'
}
PostgresError: invalid reference to FROM-clause entry for table "orders"
    at ErrorResponse
    at handle
    at Socket.data 
    at Socket.emit (node:events:514:28)
    at addChunk (node:internal/streams/readable:376:12)
    at readableAddChunk (node:internal/streams/readable:349:9)
    at Readable.push (node:internal/streams/readable:286:10)
    at TCP.onStreamRead (node:internal/stream_base_commons:190:23)
    at TCP.callbackTrampoline (node:internal/async_hooks:130:17) {
  severity_local: 'ERROR',
  severity: 'ERROR',
  code: '42P01',
  hint: 'Perhaps you meant to reference the table alias "ordersTable".',
  position: '2218',
  file: 'parse_relation.c',
  line: '3597',
  routine: 'errorMissingRTE'
}
It was working before I changed the const name of my table from const orders = pgTable("orders"...) to const ordersTable = pgTable("orders"...)
2 replies