William Yu <[EMAIL PROTECTED]> writes:
> Unfortunately, I can't tell you how the exact problem ocurred. All I
> know is after checking my logs, I see the following:
Looks pretty ugly, but there's little hope of learning anything just from
these log entries. Do you still have the broken database,
Mikko Vierula <[EMAIL PROTECTED]> writes:
> I'm running PostgreSQL 7.2b4. I got similar results with 7.1.2. And I
> know that on both cases the transaction should fail but the error
> message is wrong.
What would you have it do differently? Accept the insert and then give
some random error messa
"Tony Nicol" <[EMAIL PROTECTED]> writes:
> i.e. the DEBUG's are indicative of something not right...
No, all those debug messages are perfectly normal.
> when I try using psql I get...
> $ psql
> psql: connectDBStart() -- connect() failed: Connection refused
> Is the postmaster running l
Paul Vixie <[EMAIL PROTECTED]> writes:
> lartomatic=# select (host(relay)||'/18')::cidr from spam limit 5;
> ERROR: Cannot cast type 'text' to 'cidr'
> lartomatic=# select (host(relay)||'/18')::inet from spam limit 5;
> ERROR: Cannot cast type 'text' to 'inet'
Your wish is our command ;-). It
Hi all,
I am using the PostGIS to do research. Here I
think that I found a bug with PostGreSQL /
PostGIS.
PostgreSQL 7.1.3/ PostGIS 0.6.2
There is a function called "Astext" in PostGIS,
defined as below.
-- Function:
astext(geometry) CREATE FUNCTION "astext"("geometry")
RETURNS "
Hi there,
I am running windows 2000 (service pack 2) with
latest version of cygwin and cygipc installed.
when running initdb I get the following (this is
for installation of brand new database with postgreSQL not installed prior to
this install):
PGDATA=/PGDATA
$ initdbThis database sys
Tom and Stephan, thank you so much for the prompt reply. cheers, Luby
> Stephan Szabo <[EMAIL PROTECTED]> writes:
> > We're going to need some additional information for this to be a
> > complete report.
>
> It doesn't really require investigation. pg_dump pulls the entire
> schema befo
Unfortunately, I can't tell you how the exact problem ocurred. All I
know is after checking my logs, I see the following:
ERROR: DeleteTypeTuple: type "tmp_clm_empl" does not exist
Server process (pid 18240) exited with status 256 at Fri Dec 21 23:00:01
2001
Terminating any active server process
Hello.
I'm using debian on i386 with postgresql 7.1.3.
I'm writing an interface libary to postgresql which uses libpq, and
I've stumbled across a weird problem and i'm having problems tracking
down.
Oh and sorry about bad code formating, evolution an't giving me as much
room as i want.
main()
POSTGRESQL BUG REPORT TEMPLATE
Your name : Paul Vixie
Your email address : [EMAIL PROTE
I have some problems in serializable access. Either I have miss
understood the documentation or there is a bug in PostgreSQL.
I have two examples. On both of them I have two psql windows open. I
start two transactions simultaniously. I shouldn't be able to see any
results (except the message 'E
When a program uses JDBC to call a stored procedure
written in PL/pgSQL and that procedure causes a referential integrity violation,
a java.sql.Exception isn’t thrown. When a subsequent, unrelated call is
made on the same connection, it will fail with a referential integrity
exception.
St
Is there any known problems by using triggers in 6.5.3 as opposed to 7.1.3?
Was there a maximum number of lines of code for a given trigger?
The problem is as follows (on 6.5.3 not 7.1.3):
I have made a function called to_text which is called from the trigger in
order to convert different kinds o
The installation instructions for client-only say to do this:
gmake -C src/bin install
gmake -C src/interfaces install
gmake -C doc install
However, this leaves you with incomplete headers. The following
should be added to the instructions. This was true for 7.1.1, 7.1.2,
and 7.
> I have verified that killing the postmaster after a few nextval's
> leaves things in a bad state after restart.
>
> I think I see the problem: in nextval(), the sequence data written to
> the WAL log is different from that written to the data page. Isn't
> that bogus?
It was made to avoid WAL
15 matches
Mail list logo
