Hello all,
I get this error message at seemingly random times when sending a 'begin'
query to the database. I am using Postgres 7.0 beta 5. I have a web-based
system based on postgres and each hit is a transaction.
RelationClearRelation: relation 166124 deleted while still in use
The relati
Quite a few people (including me) have had problems with creating triggers.
Last week Jan gave us the definative answer.
No,
trigger procedures in Postgres are allways defined to take no
arguments and have a return type "opaque".
The main error above is, that the "sql" language c
I wrote:
>>> IpcMemoryCreate: shmget failed (Invalid argument) key=5432110,
>>> size=144, permission=700
> Hmm, that is odd. The thing that looks peculiar to me is that
> it seems to be calculating a different size for the segment than
> it did the first time through:
>> # ipcs -a
>> IPC statu
Okay... so I tried putting a test query "select 1" in front of the given query
and that fails also
> Problem is, after using pg_numrows to determine how many rows were selected,
it > returns 0 about 5-10% of the time. Weird, isn't it? When this happens the
> PHP script will return an error
Hello all,
I am experiencing a somewhat strange behavior with Postgres. I am running 7.0
beta 5 on Linux Slackware, and connecting to Postgres through php with the pg_*
function set. Everything seems to work fine, however A particular query fails
about 10% of the time.
The query is a simple tw
Thank you, I think that is what it is. I noticed that when the view
fails, it the values that are incorrect are sums of what should appear in
multiple records. Is there any obvious way around this problem?
Thanks,
Travis Bauer |
Lukasz Michalski <[EMAIL PROTECTED]> writes:
> I've got PostgreSQL 6.5.2 installed and strange things happens when I
> try to create temp table in transaction block.
Yes, that area is kinda broken in 6.5.*. Try it with 7.0 (RC1 or
later).
regards, tom lane
Hi,
I've got PostgreSQL 6.5.2 installed and strange things happens when I
try to create temp table in transaction block.
Here's SQL commands send to backend:
SELECT data FROM aukcje WHERE aukcja_id = '1'
SELECT reklama,logo_loid,logo_content,www,nazwa FROM domy WHERE dom_id =
'0'
BEGIN
SELECT *
I am creating a new table called patienttype with categories -
infant,pediatric, adult in the doctors table
for some reason it allows me to create a sequence but, when I create a
table that requires that sequence, I get the following.
create table patienttype (
id INT DEFAULT nextval ('category_
Thanks Again for the accurate
answers.
I'm translating some programs to the
Catalan
in the http://caliu.upc.es translation group.
I want to get more high level of experience
about the Linux. And more
practice.
Please, let me explain My Objectives
:
I want to develop a sample program wi
10 matches
Mail list logo