""Sudhakar"" <[EMAIL PROTECTED]> wrote
>
>
> we are getting the following error while execute select querry.
>
> airlinklive=# select * from ctcasetrack;
> ERROR: Invalid page header in block 1391 of ctcasetrack
>
Page #1391 is corrupted. Check out the following thread to see if you can
save som
I encounter a server(8.1.1) problem like this:
create table tt(id int);
prepare p1(int) as insert into tt values($1);
execute p1(3);
alter table tt alter id type char(10);
execute p1(999);
select * from tt;
^ server core dumps here
Command "execute p1(999)" wor
This documentation bug has been fixed. We currently have:
=> SELECT * FROM a;
x
---
1 -- no rows in a (0) + 1
(1 row)
=> INSERT INTO a VALUES (execq('SELECT * FROM a', 0) + 1);
INFO: EXECQ: 1
INSERT 0 1
"Jim Fitzgerald" <[EMAIL PROTECTED]> writes:
> Yes, what your suggesting would make sense WRT the ri_triggers however it
> doesn't explain the results that are actually appearing using the given code
> in the bug report.
It entirely does, since the given code is missing SPI_finish().
Moreover,
"Tim Kordas" <[EMAIL PROTECTED]> writes:
> During Greenplum's ongoing effort to expand support for postgres datatypes
> in Bizgres-MPP; we discovered some issues with int2vectorrecv() and
> oidvectorrecv().
Yeah, seems I broke them while changing these datatypes to be regular
arrays :-(. Fix comm
Bruce Momjian writes:
> Uh, I see MemoryContextSwitchTo in 8.1. I think the problem might be
> that the function is not marked with DLLIMPORT for XP.
No, the problem is it's a macro (actually inline, but effectively a
macro) in 8.1.
regards, tom lane
---
"Jim Fitzgerald" <[EMAIL PROTECTED]> writes:
> It is notable, however, that Postgres is not emitting the following:
> WARNING: transaction left non-empty SPI stack
> HINT: Check for missing "SPI_finish" calls.
Well, no, because control isn't going to get that far before the
mis
Adriaan van Os <[EMAIL PROTECTED]> writes:
> The manual is simply taking an old prejudice as a fact.
No, it is stating a fact as as fact. The existence of one
counterexample does not disprove the generalization.
regards, tom lane
---(end of broadc
"tomek" <[EMAIL PROTECTED]> writes:
> I was trying to install libpgxml addon with 8.1.0 distribution. Afer hours
> of searching i've discovered that libxml is trying to call (or is linked) to
> function MemoryContextSwitchTo witch should be in postgres.exe.
You need to recompile libpgxml, apparen
tomek wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2295
> Logged by: tomek
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.1.0.5309
> Operating system: WIN XP
> Description:MemoryContextSwitchTo missing
> Details:
>
> I was tryi
Hi Alvaro -
Yes, your right that SPI_finish() should be called. It was being called
in my original program where this issue was discovered.I did not include
a call to SPI_finish() in my bug exercising example just to eliminate
extraneous stuff. I have just modified the submitted test_trig
The following bug has been logged online:
Bug reference: 2296
Logged by: Sudhakar
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.3.4
Operating system: Linux
Description:select query error.
Details:
Hi,
we are getting the following error while execute select
Bruno Wolff III wrote:
Adriaan van Os <[EMAIL PROTECTED]> wrote:
Section 32.9.5. Writing Code of the 8.1 docs says:
While it may be possible to load functions written in languages
other than
C into PostgreSQL, this is usually difficult (when it is possible at
all)
because other languages,
Por favor,
Qual a extensão de um arquivo Postgresql???
Assim como o MsAccess, possui a extensão ".mdb", a extensão de uma Base de Dados no Firebird possui a extensão ".fdb".
E no Postgresql??? Ainda não consegui identificar a minha base de dados fora do comando "psql".
Sds,
Josemir Castro
The following bug has been logged online:
Bug reference: 2295
Logged by: tomek
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.0.5309
Operating system: WIN XP
Description:MemoryContextSwitchTo missing
Details:
I was trying to install libpgxml addon with 8.1
15 matches
Mail list logo
