Hello,
I have 2 identical postgresql databases (both 7.0.3) on 2 different server
(1 on Debian, 1 on Mandrake).
I have the same insert trigger and function on both databases. On the first
server the trigger works as intended, on the 2nd it fails and gives me a the
following error:
NOTICE: plp
Hi having problems with postmaster Having su up to the postgres
superuser
postmaster -i -D /usr/local/pgsql/data
Responds with
Write to pid file failed
Please check the permission and try again
Any ideas
Cheers guys
---(end of broadcast)
On Sun, 11 Mar 2001, Russell Hires wrote:
> I have a question. I'm
> currently running version 7.0.3 (compiled myself using debuild) on
> debian-m68k potato. When I start psql, my prompt doesn't look like every
> example I've seen. The examples are like this: "mydb=>" My prompt looks like
> this:
Hi All
I need some advice.
I have installed PostgreSQL v7.0.2 on OS/2 v4
The OS/2 Installed & works Fine.. : )
However my Linux version is not installed as I
read on the Postgres site that v7.0.3-2 will install
on Caldera eServer 2.3 but not on Caldera eDesktop 2.4..
..as there are diffences bet
"Russell Hires" wrote:
>Hello all,
>
>I have a question. I'm
>currently running version 7.0.3 (compiled myself using debuild) on
>debian-m68k potato. When I start psql, my prompt doesn't look like every
>example I've seen. The examples are like this: "mydb=>" My prompt looks like
>t
Thanks for your interest,
I try also this but i receive the error :
ERROR: ProcedureCreate: sql functions cnnot return type "opaque"
ERROR: CreateTrigger: Function delartfather() does not exist
here is my code :
CREATE FUNCTION DelArtFather()
RETURNS opaque
AS '
DELETE FROM TArticles WHERE
> Presumably you're running vacuum analyze regularly (at least once a day I'd
> guess) so I can only suspect that something has tipped the balance in the
> cost estimations. Is there a particular query that's slow and can you post
> an EXPLAIN?
Oops, yes, sorry forgot to mention that. Vacuum anal
> Hm. As Richard remarks, 6M records is not an especially big table;
> there are people running larger ones. The leftover sorttemp files sound
> like you are suffering backend crashes --- but you didn't mention
> anything about unexpected disconnects.
I haven't noticed any myself, but the major
> Tom Lane wrote:
> >
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > There is no user-visible mapping, though the number is the process id.
> > > You could use that. I think you can get the backend process id somehow,
> > > but I am not sure how. Anyone?
> >
> > If you're using libpq, the
"Oliver Elphick" <[EMAIL PROTECTED]> writes:
> bray=# SELECT DISTINCT p.id, p.name, a.town
> bray-# FROM (
> bray(# SELECT id, name
> bray(# FROM customer
> bray(# UNION
> bray(# SELECT id, name
> bray(# FROM supplier
> bray(#) AS p
> bray-#
From: "Victor Muntes Mutero" <[EMAIL PROTECTED]>
> We have Postgres 7.0.2 .
>
> There is a query in TPC-H Benchmark that produces this execution plan:
>
> Aggregate (cost=698221486855.00..698221486855.00 rows=1 width=72)
> -> Nested Loop (cost=0.00..698221486855.00 rows=1 width=72)
>
Alex Howansky <[EMAIL PROTECTED]> writes:
> [ lots of bad stuff ]
Hm. As Richard remarks, 6M records is not an especially big table;
there are people running larger ones. The leftover sorttemp files sound
like you are suffering backend crashes --- but you didn't mention
anything about unexpecte
"Mark Gilmore" <[EMAIL PROTECTED]> writes:
> NOTICE: plpgsql: ERROR during compile of trigger_insert_customer near line
> 1
> "RROR: parse error at or near "
Change your CR/LF newlines to plain LF.
regards, tom lane
---(end of broadcast)---
A few days ago I read a very interesting doc about postgres' query
planner, how to read an EXPLAIN plan, how is a cost calculated, etc.
but I can't find it anymore.
Anyone has an idea ? Thanks in advance.
--
Jean-Christophe Boggio
[EMAIL PROTECTED]
Independant Consultant and Developer
Delphi, Li
Christopher Sawtell <[EMAIL PROTECTED]> wrote:
>a) Does VACUUMing ( with ANALYSE ) in effect perform a file consistency
>check on the database structure as a side effect?
As I understand it, it is more of a cleanup than a file consistency check.
>b) Is it ok to VACUUM while the database is aliv
On Mon, 12 Mar 2001, Scott Price wrote:
> To: Tom Lane, and Postgresql.org staff,
>
> This is a message in response to the one sent by Frank Miles on Tue 7 Nov 2000
>11:11:29 -0800 (PST).
>
> I have been experiencing the same problem as the gentleman, Frank Miles, when
>running Postgre SQL. I
Victor Muntes Mutero <[EMAIL PROTECTED]> writes:
> There is an xjoin (p_partkey = l_partkey)
Not in that form of the query. You have
WHERE ( ... ) OR ( ... ) OR ( ... )
If Postgres were to reduce the WHERE expression to CNF, it would discover
that the p_partkey = l_partkey clause is co
Alex Howansky <[EMAIL PROTECTED]> writes:
>> The postmaster log would be a good place to look for more info (if
>> you're not keeping one, turn it on).
> I have a debug level 2 log of almost the entire day's activity.
Oh good. Hang onto that.
> I scanned it
> briefly but found nothing (it's 18
Jean-Christophe Boggio <[EMAIL PROTECTED]> writes:
> A few days ago I read a very interesting doc about postgres' query
> planner, how to read an EXPLAIN plan, how is a cost calculated, etc.
> but I can't find it anymore.
If you're not thinking of the EXPLAIN tutorial in
http://www.postgresql.or
> More to the point, what would be a reason for not using bytea to
> replace BLOBs completely?
Does anybody know if bytea can be accessed by JDBC yet? I couldn't figure
out how to make it work (setBytes/getBytes) didn't work; only the OID sql
type was working for me with the byte routines.
Davi
Bruce Momjian wrote:
> > Tom Lane wrote:
> > >
> > > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > > There is no user-visible mapping, though the number is the process id.
> > > > You could use that. I think you can get the backend process id somehow,
> > > > but I am not sure how. Anyone?
I
Limin Liu <[EMAIL PROTECTED]> writes:
> If backend does not keep temp_table_name, this looks like somthing
> impossible to do (to me). (I hope my question makes sense.)
The backend does keep a temp table name mapping, but it's hidden in an
internal data structure that there's no way to read out.
> I am not sure what your exact purpose is, but in doing a lot of web
> work with pgsql, I usually just store the full path to the image in a
> varchar field and fetch that right into the IMG SRC attribute when I
> need to display the image.
Why would a full path in a IMG tag work? Doesn't your
David Wheeler wrote:
>Is there a way to get Posgres to assume that a '' insert should be a NULL
>insert? And if not, does anyone know of a way to get mod_perl to make that
>assumption instead?
You could write a rule for each table/column that would substitute
NULL for ''.
However, the conc
Hi All,
Apologies for cross-posting.
I've ported a mod_perl application from Oracle to PosgreSQL, but have run
into a difference that's significant for web work. When I get a form field
submitted, if it's empty, mod_perl assumes it to be an empty string ('').
When I inserted empty strings into O
25 matches
Mail list logo
