On Tue, 2002-11-26 at 13:35, Baiju MP wrote:
> At present the all other database, providing an option to set
> developers own order with the order by statement.
> eg : SELECT ..
>FROM ..
> ORDER BY 1 like 'A%' like 'H%' like 'G%' like 'C%'
Can you elaborate on exactly
On Mon, 2002-11-25 at 11:22, Joshua Moore-Oliva wrote:
> While debugging with valgrind, I always receive the following error
> message.
>
> ==30439== Invalid free() / delete / delete[]
> ==30439==at 0x400448F9: free (vg_clientfuncs.c:180)
> ==30439==by 0x421136CD: (within /lib/i686/libc-2.
Stefanos Harhalakis <[EMAIL PROTECTED]> writes:
> I'm running postgresql 7.2.1 on linux.
> I cannot run vacuumm on a table in a database i'm running for about 7 months.
> I get:
> ERROR: No one parent tuple was found
> I've found an older posting about that but the poster said that after
> rest
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Harris Peter writes:
>> Workaround: I had to add the options to LDFLAGS and CPPFLAGS myself to get
>> readline noticed.
> As you should.
I agree, --prefix should not have anything to do with --with-includes/libs.
>> The makefile contains many rm. I
Rod Taylor <[EMAIL PROTECTED]> writes:
> Could it be because once the DELETE FROM A has run the tuple no longer
> exists in the view?
Precisely. OLD is only a macro for the view, and the first delete
changes what's in the view ...
regards, tom lane
--
Weber Gerhard <[EMAIL PROTECTED]> writes:
> we have a cobalt qube 3 with an old version 6.5 of postgresql. we use
> postgresql 7.2.3 on other platforms like windows.
> what we have to do for installing the mentioned, newest version on our
> cobalt qube 3? wich version we hav to download? how to ins
"Rison, Stuart" <[EMAIL PROTECTED]> writes:
> The first SELECT returns a 'timestamp', but the next two return a
> 'timestamptz' (presumably with timezone); is this inconsitent behaviour?
Yes. It's a transitional behavior in 7.2: timestamp without any quotes
is translated by the parser to timestam
[EMAIL PROTECTED] writes:
> upper() does not handle å, ä and ö correctly.
Sounds like you didn't set your locale correctly --- this is not an
encoding issue, it is a locale issue.
regards, tom lane
---(end of broadcast)---
T
Tamotsu Ebina writes:
> ebina@HAYAMA02 /usr/local/pgsql/postgresql-7.3rc1
> $ FATAL: invalid value for option 'LC_MESSAGES': 'ja_JP.EUC'
Set LC_MESSAGES to something that your system supports. (Since Cygwin
doesn't have locale support anyway, you might as well unset the locale
environment varia
Harris Peter writes:
> Workaround: I had to add the options to LDFLAGS and CPPFLAGS myself to get
> readline noticed.
As you should.
> The makefile contains many rm. I usually like to alias rm="rm -i" for
> safety, so I had to answer (y/n) a lot of times. Could the makefile please
> use rm -f?
Well, I think I found why.
Because OID is included in the selected fields list, the order by fields
number are off by one.
I rewrote the query using the field numbers instead of field names and
the function ran as expected.
It is a work around, but any ALTER to the table will force me to rewrite
t
Sir,
We are using postgreSQL for two years for our
projects.
It's fine and working well and meets all out
requirements.
But one think I could find when comparing with
other simple
databases is I am mentioning here . Hope your
developing team
will consider this also while releasing the n
Harris Peter wrote:
> Hi
>
> 1)
> configure fails too easily if your libraries and include files are in a
> funny place. When you specify --prefix=/somewhere, maybe it should use "-L
> /somewhere/lib" and "-I/somewhere/include" by default when checking if
> things exist.
> Workaround: I had to add
On Wed, 20 Nov 2002 [EMAIL PROTECTED] wrote:
> i was trying to back up db from the server.
> i found the error while i was trying to backup.
>
> bash$ /usr/local/pgsql/bin/pg_dumpall > db.out
>
> ERROR: MemoryContextAlloc: invalid request size 4294967293
I believe this probably means that you h
On Sun, Nov 24, 2002 at 06:37:09PM +0100, Adam Buraczewski wrote:
> Initdb fais with '-W' switch given in the command line.
Never mind, someone else found the bug as well, it is already removed
in CVS tree. :)
--
Adam Buraczewski <[EMAIL PROTECTED]> * Linux registered user #165585
GCS/TW d- s-:
On Tue, 26 Nov 2002 [EMAIL PROTECTED] wrote:
> Marcus Andersson ([EMAIL PROTECTED]) reports a bug with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> upper() does not handle å, ä and ö correctly.
>
> Long Description
> The function upper() just leaves the le
On Wed, 20 Nov 2002, Malcolm Hutty wrote:
> According to the manual you can stack multiple queries in a RULE:
>
> CREATE RULE name AS ON event
> TO object [ WHERE condition ]
> DO [ INSTEAD ] action
>
> where action can be:
>
> NOTHING
> |
> query
> |
> ( query ; query ... )
> |
> [ que
Confirmed this problem on cvs-tip.
Replacing the DO INSTEAD ( DELETE) with DO INSTEAD (INSERT...)
allows multiple insert statements which function fine using OLD.a_data
and OLD.b_data.
So it must be something else.
Could it be because once the DELETE FROM A has run the tuple no longer
exist
On Fri, 2002-11-22 at 15:51, Stefanos Harhalakis wrote:
> I'm running postgresql 7.2.1 on linux.
>
> I cannot run vacuumm on a table in a database i'm running for about 7 months.
> I get:
>
> ERROR: No one parent tuple was found
Your best bet, since you've crashed with fsync off, is to dump and
Here's an "interesting" timestamp related postgreSQL quirk:
testdb2=# select "timestamp"('now');
timestamp
2002-11-26 13:47:12.454157
(1 row)
testdb2=# select 'now'::timestamp;
timestamptz
--
2002-11-26 13:47:34.88358+00
hi,
i have been trying to get access postgres database from kylix..
i couldn't...
i think problem at installation itself..odbc driver is not eableing.
plz give me detaled steps with exaples...and possible errors...for geting
access to postgres.
thanks &Regds
srihari
---(e
While debugging with valgrind, I always receive the following error
message.
==30439== Invalid free() / delete / delete[]
==30439==at 0x400448F9: free (vg_clientfuncs.c:180)
==30439==by 0x421136CD: (within /lib/i686/libc-2.2.5.so)
==30439==by 0x4207F852: (within /lib/i686/libc-2.2.5.
Hi, i've installed Postgres 7.2.2, Tomcat 3.1 and
JDBC postgres 7.2. I'm trying to connect to a db that i've create (psql test
test). I
received the following error:
psql: FATAL 1: IDENT authetication failde for use
"test"
Can you help me?
Best regards
Paolo Manca
Name: Adam Buraczewski
Email address : [EMAIL PROTECTED]
System Configuration
-
Architecture : Intel Pentium II
Operating System : Linux 2.4.19, glibc 3.2.1 (i686-pc-linux-gnu)
PostgreSQL version: PostgreSQL 7.3 RC1
Compiler used
Hi,
2 possible bugs in pg_dump/pg_restore related to
large objects.
1. Large objects dumped, deleted then restored
do not retain their original OIDs. Big problem as we reference their OIDs
in tables.
2. The pg_restore command --list indicated no Blobs
in the dump file even when there ar
I forgot to add details of instalation:
I'm running linux kernel 2.2.22 and postgres PostgreSQL 7.2.1 on
i686-pc-linux-gnu, compiled by GCC 2.96
lmota
[EMAIL PROTECTED] wrote:
Luís Mota ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short De
system info:
Mac OS X v 10.2.2 (Darwin Kernel Version 6.2: Tue Nov 5 22:00:03 PST
2002; root:xnu/xnu-344.12.2.obj~1/RELEASE_PPC)
Java build 1.3.1_03-69, mixed mode
Ant version 1.5
gcc Apple Computer, Inc. GCC version 1161, based on gcc version 3.1
20020420 (prerelease)
postgres 7.3rc1
./conf
okk
U¿ytkownik "Tom Lane" <[EMAIL PROTECTED]> napisa³ w wiadomo¶ci
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Lars <[EMAIL PROTECTED]> writes:
> > Is that expected behavior in 7.3?
>
> It is if you initdb'd in a locale other than "C". Use pg_controldata
> to check.
>
> regards, tom lane
>
> --
I'm running postgresql 7.2.1 on linux.
I cannot run vacuumm on a table in a database i'm running for about 7 months.
I get:
ERROR: No one parent tuple was found
I've found an older posting about that but the poster said that after
restarting it was fixed. In my case this is not true. I've rest
I have the next table:
CREATE TABLE aenor_subexpediente (
id_aenor_subexpediente int4 DEFAULT
nextval('"aenor_subexpe_id_aenor_sube_seq"'::text) NOT NULL,
subexpediente varchar(30),
id_tecnico int4,
id_delegacion int4,
id_contacto int4,
id_cnae int4,
alcance_certificacion varch
Hi,
I think there is a problem with the timestamp types in postgresql
7.2.3.
In the documentation here http://www.postgresql.org/idocs/index.php?datatype.html the
table 3-1 says:
bash$ /usr/local/pgsql/bin/pg_dumpall > db.out
ERROR: MemoryContextAlloc:
invalid request size 4294967293
PQendcopy: resetting connection
SQL query to dump the contents of Table 't_oommain' did not execute
correctly. After we read all the
table contents from the backend, PQendcopy() failed
Hello
I am pati presently working iin research
oraganisation(Fraunhofer),Germany.Recently i ahve deployed a web application
connecting to the database postgre sql.
When i am connecting to the database i am getting the error of
postgresql.stream.flush and postgresql.stream.io some times.
please let
in the win2k environment, I would consider adding the path to the
Cygwin1.dll to the system path (for example, c:\cygwin\bin)
then, using command prompt shell, not the CYGWIN shell, cd to the folder
containing the ipc-daemon.
>From there, type ipc-daemon to run the daemon
or ipc-daemon --install-
i was trying to back up db from the
server.
i found the error while i was trying to
backup.
bash$ /usr/local/pgsql/bin/pg_dumpall >
db.out
ERROR:
MemoryContextAlloc: invalid request size 4294967293
PQendcopy: resetting connection
SQL
query to dump the contents of Table 't_oommain' did no
Hi
1)
configure fails too easily if your libraries and include files are in a
funny place. When you specify --prefix=/somewhere, maybe it should use "-L
/somewhere/lib" and "-I/somewhere/include" by default when checking if
things exist.
Workaround: I had to add the options to LDFLAGS and CPPFLAGS
Dear Sirs,
(B
(BI maked postgresql using postgresql-7.3rc1 on WindowsXPProfessional+CygWin,
(B
(B$ ./configure --enable-multibyte=EUC_JP --enable-locale --with-CXX --with-java
(B--enable-odbc
(B
(Bwith no error.
(B
(Binitdb finished also with no error.
(B
(BBut I can't start postmaster.
Your name : Hai-Chen Tu
Your email address : [EMAIL PROTECTED]
System Configuration
-
Architecture (example: Intel Pentium) :
Operating System (example: Linux 2.0.26 ELF) :
PostgreSQL version (example: PostgreSQL-7.3):
PostgreSQL-7.3
Title: version for sun cobalt qube 3
dear reader
we have a cobalt qube 3 with an old version 6.5 of postgresql. we use postgresql 7.2.3 on other platforms like windows.
what we have to do for installing the mentioned, newest version on our cobalt qube 3? wich version we hav to download? ho
According to the manual you can stack multiple queries in a RULE:
CREATE RULE name AS ON event
TO object [ WHERE condition ]
DO [ INSTEAD ] action
where action can be:
NOTHING
|
query
|
( query ; query ... )
|
[ query ; query ... ]
This seems to work provided 'query' is not "DELETE"; i
Marcus Andersson ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
upper() does not handle å, ä and ö correctly.
Long Description
The function upper() just leaves the letters å, ä, and ö unmodified. It should replace
them with Å,
41 matches
Mail list logo
