Improved wording that doesn't telegraph, "Look at me!":
Each declaration and each statement within a block is terminated by a
semicolon, though the final END that concludes a
function does not require one.
-
Andrew Grillet <[EMAIL PROTECTED]> writes:
> Original bug I was trying to report is that 7.4.5 builds OK on Freebsd
> 4.10 and runs fine, but if you try "createlang" (eg to install plpgsql)
> it fails because of undefined symbol "downcase_truncate_identifier".
I think you are trying to load a 7.
The following bug has been logged online:
Bug reference: 1275
Logged by: Marcio
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.5
Operating system: Seleção de Dados
Description:Perda de velocidade na consulta com join.
Details:
Quando executo um select
Folks,
I'm hoping that this is "already fixed" somewhere:
webmergers=# select version();
version
-
PostgreSQL 7.4.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.3 (Su
Hi
Bug category serious:
The bug report link as www.postgresql.org/bugs/bugs.php is not working.
Original bug I was trying to report is that 7.4.5 builds OK on Freebsd
4.10 and runs fine, but if you try "createlang" (eg to install plpgsql)
it fails because of undefined symbol "downcase_truncat
Michael Fuhr <[EMAIL PROTECTED]> writes:
> PQdb() is returning NULL, which causes fprintf() to dump core.
It is actually documented that a failed connection might return NULL for
this, so the example code is wrong. I've corrected the examples to not
assume PQdb can be used on a failed connection.
On Fri, Oct 01, 2004 at 02:46:33PM +0600, Alexander Zhiltsov wrote:
> Executing the following query return an error 'ERROR: unrecognized node type: 656'.
> SELECT pg_get_expr(i.indexprs, i.indrelid) AS expr
> FROM pg_index i
> INNER JOIN pg_class c ON i.indrelid = c.oid
> WHERE c.relname = 'art
"Alexander Zhiltsov" <[EMAIL PROTECTED]> writes:
> Executing the following query return an error 'ERROR: unrecognized node ty=
> pe: 656'.
> SELECT pg_get_expr(i.indexprs, i.indrelid) AS expr
> FROM pg_index i
> INNER JOIN pg_class c ON i.indrelid =3D c.oid
> WHERE c.relname =3D 'art'
I'm not c
Patrick Clery <[EMAIL PROTECTED]> writes:
> Here's the query plan:
> ...
> -> Seq Scan on people_locations (cost=0.00..20.00
> rows=1000 width=122)
The query planner evidently does not know that the people_locations
table is large. A VACUUM or ANALYZE on it would help a lo
On Wed, Sep 29, 2004 at 05:59:37PM +0100, Trevor Inns wrote:
> version 7.4.5
>
> using postgresql-7.4.5/src/test/examples/testlibpq as follows
>
> "testlibpq hostname=shouldHaveUsedHostNotHostname"
>
> fails with coredump
>
> SunOS pluto 5.9 Generic_117171-07 sun4u sparc SUNW,Ultra-5_10
Confir
Hello,
When i do:
pg_dumpall -D --disable-dollar-quoting -U postgres -h hostname > cluster.backup
the following error occurs:
pg_dump.exe: [archiver (db)] connection to database "example" failed: could not
translate host name
"'hostname'" to address: Unknown host
pg_dumpall.EXE: pg_dump failed
Hello,
I downloaded and install postgresql-8.0.0beta3.tar.gz
I create the following table:
CREATE OR REPLACE FUNCTION "ayz"."my_lower" (text)
RETURNS text AS'BEGIN return lower($1);END;'LANGUAGE
'plpgsql' IMMUTABLE RETURNS NULL ON NULL INPUT SECURITY INVOKER;
CREATE TABLE public.art( a
Your name : Patrick Clery
Your email address : [EMAIL PROTECTED]
System Configuration
-
Architecture (example: Intel Pentium) : Intel
Operating System (example: Linux 2.4.18) : FreeBSD 4.10-stable
PostgreSQL version (example: PostgreSQL-8
Dear Postgres!
Sorry my bad English first.
I'm found a bug in the PSQL 8 Beta2 Devel 3, and 7.4.x (x=2,3,4,5) too:
- The PSQL 8 is working on Win XP.
- The PSQL 7.4.x is working on SuSE and Yoper Linux distros.
I have 8900 users is in 4 group.
1. I'm maked a 'pg_dumpall -c >full_dump.sql'
2. I make
> IIRC, b2 was before Tom changed the code for doing triggers between
> function statements, current sources have that code. So, b3 should have
> the change I mentioned which makes the above work (for immediate
> constraints).
You're right!
Cases 2 and 3 are processed correctly by b3. Thanks a lot
version 7.4.5
using postgresql-7.4.5/src/test/examples/testlibpq as follows
"testlibpq hostname=shouldHaveUsedHostNotHostname"
fails with coredump
SunOS pluto 5.9 Generic_117171-07 sun4u sparc SUNW,Ultra-5_10
---(end of broadcast)---
TIP 9: the plann
Sorry,
I believe it is bug in pgadmin II.
First you get no amount and when you press refresh on table or query
result is OK.
I found out this 10 min after I have posted bug and did not know where to reply to my
bug report.
Damjan
> -Original Message-
> From: Tom Lane [mailto:[EMAI
In my logs I'm getting queries like this:
SELECT t0_userprofile.user_profile_id FROM user_profiles t0_userprofile
WHERE (t0_userprofile.user_id = $1)
Where $1 was actually something like 'BSHO-XITLLH-LTDHF7-V3-ETFQ'. In
a query where there are several parameters they appear as $1, $2, $3,
...
Using PostgreSQL OBDC driver 7.02.00.02, installed with PostgreSQL 8.0 Beta
2 dev 3.
I am getting errors using a Client-Side Cursor and Adding and Updating
records.
Insufficent base table information for updating and refreshing.
If I change the CursorLocation to Server-Side, this error goes awa
PostgreSQL 8.0 Beta 2 OS: Windows 2000/XP
Run: pg_dumpall -U dba
Output:
...
ALTER USER dba WITH PASSWORD '111'
CREATEDB CREA
TEUSER;
\connect monk
pg_dump.exe: [archiver (db)] connection to database "monk" failed:
FATAL: user "'dba'" does not exist
pg_dumpall.exe:
hello all!
i have installed the postgresql 8.0 beta2, the
native version for windows. I dont have any problem in
executing commands in the shell. the only thing i
could not get to work is the "make" command. I have a
Makefile in the current working directory. Can anyone
help me in this context.
Hello,
I noticed in plpgsql that a semi colon is not always required after
the END statement. A contrived example:
CREATE sequence foo;
CREATE OR REPLACE FUNCTION bar() RETURNS VOID AS '
DECLARE
bar int;
BEGIN
SELECT INTO bar nextval(''foo'');
RETURN;
END
' LANGUAGE plpgsql;
--hussein
> And in current sources, functions 2 and 3 error with foreign key
> violations rather than unique constraint violations. If the constraint
> was deferred you'd still get the unique violations, but we're still
> looking to see which error is correct in that case.
Does it mean that scripts that i
23 matches
Mail list logo
