Tom Lane wrote:
> "Pavel Stehule" <[EMAIL PROTECTED]> writes:
> > 2008/9/1 Oleg Serov <[EMAIL PROTECTED]>:
> >> ERROR: structure of query does not match function result type
> >> CONTEXT: PL/pgSQL function "buggy_procedure" line 3 at RETURN QUERY*/
>
> > this isn't bug, it's feature.
>
> No, i
"Shaun Crampton" <[EMAIL PROTECTED]> writes:
> I tried to dump the 7.4.13 database using pg_dumpall from 8.3.1 and restore
> into 8.3.5 on my local test machine. I get the following errors at restore
> time:
> ERROR: missing FROM-clause entry for table "icc_countries"
> LINE 2: ...de, icc_member
Hi,
I'm trying to upgrade my server from Ubuntu Feisty to a later version and I
think I've found a bug in pg_dumpall. The version of Postgres from Feisty
is not supported in later versions so I want to dump the DB and restore
after upgrade.
On the server machine I have
- Postgres 7.4.13 runn
>Calling this a "bug" isn't a good way to start a discussion about it.
sorry, didn't want to insult anyone
All your comments are certainly valid.
I had to inspect and maintain a database which was not designed by me and has
tables with some 20-30 columns - no way to understand which columns are
That was the short form exhibiting the bug. Selecting the complex
column from a table into a value results in the same error.
BEGIN;
CREATE TYPE timestamp_with_precision AS
( timestamp timestamp with time zone
, timestamp_precision varchar
);
CREATE TABLE timetest(t timestamp_with_precision);
I
On Wed, Nov 26, 2008 at 06:44:11AM -0800, John R Pierce wrote:
> Tom Lane wrote:
>> Whatever strchrnul is, it isn't very portable --- the buildfarm is
>> breaking out in red too. Please change that.
>
> sigh, more gnuish code
Fixed. Sorry, didn't notice that it still is a GNU extension as GNU
Tom Lane wrote:
Whatever strchrnul is, it isn't very portable --- the buildfarm is
breaking out in red too. Please change that.
sigh, more gnuish code
— Function: char * *strchrnul* (const char *string, int c)
|strchrnul| is the same as |strchr| except that if it does not find
"Clemens A. Fischer" <[EMAIL PROTECTED]> writes:
> Hallo Michael,
> thanks for the patch, but ...
> compiling ecpg fails:
> type.c: In function `ECPGdump_a_simple':
> type.c:356: warning: implicit declaration of function `strchrnul'
> type.c:356: invalid type argument of `unary *'
Whatever strchrn
Hallo Michael,
thanks for the patch, but ...
compiling ecpg fails:
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline
-fno-strict-aliasing -Wno-error -I../include
-I../../../../src/interfaces/ecpg/include -I. -DMAJOR_VERSION=4
-DMINOR_VERSION=4 -DPATCHLEVEL=1 -I../../../../src/include -D
Hallo Michael,
Am Mittwoch, den 26.11.2008, 14:49 +0100 schrieb Michael Meskes:
> On Tue, Nov 25, 2008 at 12:28:38PM +, Clemens Fischer wrote:
> > The copy command can't be used with a hostvar.
>
> This is essentially the answer. The major difference between the ecpg version
> of PostgreSQL 8
On Tue, Nov 25, 2008 at 12:28:38PM +, Clemens Fischer wrote:
> The copy command can't be used with a hostvar.
This is essentially the answer. The major difference between the ecpg version
of PostgreSQL 8.2 and 8.3 is that the 8.3 version uses the backend supplied
prepare/execute facility inste
劉大維 wrote:
> Dear Sir,
>
> I try to make gammu-svn2643.
You're having issues with `cmake' configuration of a project other than
PostgreSQL. This is unlikely to be a PostgreSQL bug.
> "Cmake error: invalid escape sequence \p"
> "Syntax error in cmake code at
> D:/gammu-svn2643/cmake/FindPostgres
Dear Sir,
I try to make gammu-svn2643. I run Cmakesetup.exe and then change
the following setting:
where is the source code: d:\gammu-svn2643
where to build the binaries: d:\gammu-svn2643\win32\gammu-library\bcc06.mak
GETTEXT_MSGFMT_EXECUTABLE: C:\GETGNUWIN32\bin
GETTEXT_MSGMERGE_EXECUTABLE: C:\GE
On Tue, Nov 25, 2008 at 10:44:32AM +, Clemens Fischer wrote:
> Using ecpg and gcc generates the following output:
> ecpg -t -o ecpgtest-multidim.c ecpgtest-multidim.pgc
> cc -c -I/usr/local/pgsql/include ecpgtest-multidim.c
> ecpgtest-multidim.pgc: In function `main':
> ecpgtest-multidim.pgc:30
Gregory Stark wrote:
John R Pierce <[EMAIL PROTECTED]> writes:
oracle has had an option for some time that uses read/only page protection for
each page of the shared buffer area... when oracle knows it wants to modify a
page, it un-protects it via a system call. this catches any wild w
John R Pierce <[EMAIL PROTECTED]> writes:
> Alexandra Nitzschke wrote:
>> BTW... how about a block checksum that is checked just before writing a block
>> and just after reading it? I know this would degrade performance, but I think
>> we can afford that. Would it be possible to incorporate such
16 matches
Mail list logo
