PostgreSQL version: 8.0.3
OS: Win32 (Win 2003 Server)
There is something strange and counterintuitive about the way that
multiple-action PostgreSQL rules work. In the following rule definition
CREATE RULE _rulename_ AS ON _event_ TO _table_
WHERE _condition_
DO (
_
> -- Now I add to the "upd_if" rule
> -- a condition that checks if a similar record already exists
> CREATE OR REPLACE RULE upd_if AS ON UPDATE TO test.view1
>WHERE ((SELECT count(*) AS count1 FROM test.table1 WHERE table1.data1 =
> new.data1)) = 0
>DO (
>UPDATE tes
On 2005-08-04, "Eugene Shekhtman" <[EMAIL PROTECTED]> wrote:
> PostgreSQL version: 8.0.3
> OS: Win32 (Win 2003 Server)
>
> There is something strange and counterintuitive about the way that
> multiple-action PostgreSQL rules work.
The absolute first thing you must learn about using rules in postgr
The following bug has been logged online:
Bug reference: 1807
Logged by: Janet Hempstead
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Solaris 9 (sparc)
Description:cannot build postgresql: libascii_and_mic.so.0.0: No
such file or direct
The following bug has been logged online:
Bug reference: 1804
Logged by: Mario Reiley
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Windows 2000
Description:Installations Problems
Details:
My installation failure when registering pgole
The following bug has been logged online:
Bug reference: 1806
Logged by:
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.8-0.6
Operating system: Suse Linux Enterprise Server 9
Description:Postmaster takes uses 99% of CPU
Details:
The Prozess Postmaster tak
System:
server: RH 9 with latest updates (Intel Celeron 1,7 GHz, RAM 512) PSQL 8.0.3
clients: RH 9 with latest updates on PIII 500 RAM 256, PIII400 RAM 128,
PI 166 RAM 64) PSQL 8.0.3 with installed postgresql-libs 7.4.8 (the
postgresql-libs 8.0.3 needs libraries from this older package)
compil
The following bug has been logged online:
Bug reference: 1803
Logged by: DKnoto
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Linux 2.6.11.10
Description:Incomplete table list in psql
Details:
Hi,
I have database with two schemas: S1 a
The following bug has been logged online:
Bug reference: 1799
Logged by: HAUSERMANN Laurent
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Windows 2000
Description:Auto Creation of Strong Password fails
Details:
I ran the Postgresql 8.0
The following bug has been logged online:
Bug reference: 1805
Logged by: Vahe
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8
Operating system: windows XP
Description:FATAL: invalid command-line arguments for server process
HINT: Try "postgres --help" for more
My theory is "select;" incurs a parse error and this error message is
supposed to be translated into your encoding, but unfortunately not every
UTF8 character is necessarily be encoded as GB18030, which will cause an
infinite recursive elogs just like this:
1:elog(parse_error)// contain u
"Janet Hempstead" <[EMAIL PROTECTED]> writes:
> I am trying to build postgresql 8.0.3 on a Sun Ultra 5 running Solaris 9.
> ...
> export LDFLAGS='-L /usr/lib -L /usr/local/lib -L /usr/local/ssl/lib'
> ...
> gcc -shared -h libascii_and_mic.so.0 ascii_and_mic.o
> -L../../../../../../src/port -L -L -
Hi YL,
You may also want to check that EOModeler is not quoting strings
with double quotes (") rather than single-quotes (') in ODBC, say by
auditing the same call to MySQL. And maybe check out which ODBC version
calls EOModeler is calling, and sounds like it could potentially(!) be
using
I all , kindly I have had an problem with
the db postgresql 7.2 (arranges optimal) but job on a auentiicazione table
and now this table is delete. The manager asks nfoomatiion
on this happened to me. I would not want to give the impression of a human
error bcause that job single on this ta
Just tested it with build 312 and the original problem went away. Now
I am seeing a new problem with null BLOBs only:
java.sql.SQLException: ERROR: column "blob_col" is of type bytea but
expression is of type oid
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse
(QueryExec
The following bug has been logged online:
Bug reference: 1801
Logged by: Peter Valach
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Linux (Gentoo)
Description:pg_dump dumps tables in alphabetical order, not as
created
Details:
When usi
Personally I cancelled this bug report:
The code contains a number of malloc() avoidance hacks for speedup, but
it seems to
be correct:
The speed optimizations confused me.
It seems, that only free(options[i].var) will be freed, if "var" is not
NULL.
Also free(options) will be freed. So this see
The following bug has been logged online:
Bug reference: 1802
Logged by: Jenny Wang
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.3.10
Operating system: RedHat 8
Description:index is not a btree
Details:
1 $ cd
$ cd bin
2 $ ./postmaster -D data &
$ ./
I've used EOModeler with odbc for MS SQL Server,
MySQL and MS Access with no problem. But got
problem with postgre odbc driver.
EOMOdeler cannot get postgresql column types' info
through odbc. Also,
It cannot interact with EOModeler
for very simple query:
SQLExecDirectin - [ODBCChanne
The following bug has been logged online:
Bug reference: 1800
Logged by: Aaron Harsh
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.6
Operating system: RedHat ES release 3, x86_64
Description:"unexpected chunk number" during pg_dump
Details:
Our regular pg
Hi,
I posted this to pgsql-performance a month ago, but have yet to receive a
response, so I am trying this list instead.
I am using PostgreSQL 7.4.7
I have a query looking something like this:
SELECT * FROM tbl WHERE (n = 0::smallint AND (string = 'Hello' OR string =
'Pineapple' OR string = 'K
Hi,
I use PostgreSQL 7.3.2.
Choosing selection for a table I get Segmentation fault.
Namely:
1.=> \d aer_trips
uin | integer | default nextval('aer_trips_seq'::text)
l | integer |
l_type| integer |
name | text|
descr | text|
foto_trip | text|
d
The following bug has been logged online:
Bug reference: 1798
Logged by: neeraj
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.2.1
Operating system: redhat linux 9
Description:incomplete installation
Details:
hello everyone,
after configuring the pgsql on re
Michael Fuhr wrote:
> On Thu, Jul 28, 2005 at 03:56:14PM +0100, Sean Burlington wrote:
>
>>Michael Fuhr wrote:
>>
>>>On Thu, Jul 28, 2005 at 12:48:35PM +0100, Sean Burlington wrote:
>>>
>>>
Description:inheritance removes permissions from the parent table
>>>
>>>I think a more accurate
I all , kindly I have had an problem with the
db postgresql 7.2 (arranges optimal) but job on a auentiicazione table
and now this table is delete. The manager asks nfoomatiion
on this happened to me. I would not want to give the impression of a human
error bcause that job single on this ta
25 matches
Mail list logo
