Tom Lane wrote:
> "Daniel Caune" <[EMAIL PROTECTED]> writes:
> > I'm facing a strange behaviour with a statement SELECT ... LIMIT n FOR
> > UPDATE in PostgreSQL 8.1. The number of rows returned is actually (n -
> > 1). I'm trying to find whether this is an identified issue with
> > PostgreSQL 8.1
"Daniel Caune" <[EMAIL PROTECTED]> writes:
> I'm facing a strange behaviour with a statement SELECT ... LIMIT n FOR
> UPDATE in PostgreSQL 8.1. The number of rows returned is actually (n -
> 1). I'm trying to find whether this is an identified issue with
> PostgreSQL 8.1 that might have been fixe
On Nov 27, 2007, at 21:04 , Gera Mel Handumon wrote:
I encounter an error if i use NULLIF with timestamp with time zone.
eq. dbtime=nullif(mytime,'')
i want to null the value of field DBTIME if the variable mytime=" "
DBTIME ="timestamp with time zone" datatype
error: column DBTIME is of typ
HELLO,
I encounter an error if i use NULLIF with timestamp with time zone.
eq. dbtime=nullif(mytime,'')
i want to null the value of field DBTIME if the variable mytime=" "
DBTIME ="timestamp with time zone" datatype
error: column DBTIME is of type timestamp with time zone but expression is
of t
Hi,
I'm facing a strange behaviour with a statement SELECT ... LIMIT n FOR
UPDATE in PostgreSQL 8.1. The number of rows returned is actually (n -
1). I'm trying to find whether this is an identified issue with
PostgreSQL 8.1 that might have been fixed in a later version such as
8.2; I don't have
Dear Gerardo and Pgsql-List,
>When executing a VACUUM, i have this msg:
>gse_new_version=# VACUUM ;
>ERROR: could not access status of transaction 118
>DETAIL: could not open file "pg_clog/": No existe el fichero o el
I had a similar problem. I decided one day to "clean" out
The pg_clog/ d
Gregory Stark wrote:
"Gerardo Herzig" <[EMAIL PROTECTED]> writes:
Hi all. Well, im having this problem for the first time.
When executing a VACUUM, i have this msg:
gse_new_version=# VACUUM ;
ERROR: could not access status of transaction 118
DETAIL: could not open file "pg_clog/": No
"Gerardo Herzig" <[EMAIL PROTECTED]> writes:
> Hi all. Well, im having this problem for the first time.
> When executing a VACUUM, i have this msg:
> gse_new_version=# VACUUM ;
> ERROR: could not access status of transaction 118
> DETAIL: could not open file "pg_clog/": No existe el fichero
Hi all. Well, im having this problem for the first time.
When executing a VACUUM, i have this msg:
gse_new_version=# VACUUM ;
ERROR: could not access status of transaction 118
DETAIL: could not open file "pg_clog/": No existe el fichero o el
directorio
Ok, wtf, i will create the file. So
