Title: SQL update statements are dying in the query planner
POSTGRESQL BUG REPORT TEMPLATE
Your name
Hi,
I'm not quite sure where I should be asking the following questions so
if this is the wrong place please let me know where I should send it.
I'm using PostGre on Windows N/T (sp6). I'm connecting to it via
the Borland Database Engine which is in turn using an ODBC.
It's a web application usin
Here are operational details:
RedHat Linux 7.0:
Linux version 2.2.17-14 ([EMAIL PROTECTED]) (gcc version
egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)) #1 Mon Feb 5 15:25:12 EST
2001
PostgreSQL Version info:
postgresql-7.0.2-17
postgresql-server-7.0.2-17
postgresql-devel-7.0.2-17
tbs=# SEL
Thanks! That did it:
tbs=# SELECT DATE_PART('DAY', CAST('04/1/2001' AS DATE)) as dayofmonth;
dayofmonth
31
(1 row)
tbs=# SET TIMEZONE = 'GMT' ;
SET VARIABLE
tbs=# SELECT DATE_PART('DAY', CAST('04/1/2001' AS DATE)) as dayofmonth;
dayofmonth
1
(1 r
Hi,
Re. Making Pgsql on SCO Open Server
Version 7.1.1
Firstly, "make" blows with undefined symbol "NOFILE" in
"src/backend/storage/file/fd.c". I temporarily changed this
to a hard-coded value.
After correcting this the Make actually completes; howev
POSTGRESQL BUG REPORT TEMPLATE
Your name : Tomasz Wegrzanowski
Your email address : [EM
22 May 2001
Dear Sir;
First, thank you for PostGres. It is great!
Second, I am puzzled by repeated, apparently pointless calls to memmove() in
the function pqReadData, which is in `src/interfaces/libpq/fe-misc.c'.
I am running and looking at PostGres version 7.1.1 built on a Al
Brent Ewing <[EMAIL PROTECTED]> writes:
> Second, I am puzzled by repeated, apparently pointless calls to memmove() in
> the function pqReadData, which is in `src/interfaces/libpq/fe-misc.c'.
Hm. That was never a problem back when we had an 8K row-size limit ;-)
but I can see that it might get t
Paul-Andre Panon <[EMAIL PROTECTED]> writes:
> SQL update statements are failing, possibly in the query planner. A copy
> of the -d3 postgres log is attached. The error returned by psql when
> submitting this query is
> ERROR: Relation 2699531655 does not exist
Could you set a breakpoint at el
