"Mattias Kregert" <[EMAIL PROTECTED]> writes:
> SELECT id FROM pics WHERE
> (file='3a76h3gd873kmn7ckd76' AND archived IS NULL) OR
> (file='jj38kmc983lmn2547cx0' AND archived IS NULL) OR
> ...
Could we see EXPLAIN ANALYZE results for this query from both the 7.4
and 8.1 systems? Since you haven't
"Slavcho Ivanov" <[EMAIL PROTECTED]> writes:
> The query was as simple as possible
> "select * from data where "SensorID" = 18",
> and the result had a couple of rows where SensorID was NOT 18, but 3.
That's not too surprising if the index had gotten corrupted somehow,
but since you haven't pr
Mario <[EMAIL PROTECTED]> writes:
> I have a problem with connection if the postgresql 8.1.3
> Comand Line: postmaster -S -o -i -D data (Unix - Solaris OS)
^
-i is not a valid switch to use within -o. I think you probably meant
for -i to be a postmaster swit
TODO has:
* %Disallow changing default expression of a SERIAL column
so we know it is a bug.
---
Chris Mair wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2336
> Logged by:
On Mon, 2006-03-20 at 14:27 +0530, Dhanaraj M - Sun Microsystems wrote:
> I have fixed a bug which was reported in our mailing group ealier. Can
> anybody tell me how i could test my code and then put back?
I'm not sure what you mean; if you're asking "how do I submit patches
that fix bugs?", sen
The following bug has been logged online:
Bug reference: 2342
Logged by: Mattias Kregert
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Linux
Description:Extremely bad performance on a specific query, compared
to 7.4
Details:
Query:
-
The following bug has been logged online:
Bug reference: 2341
Logged by: Slavcho Ivanov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.2
Operating system: slackware
Description:Wrong results when using index
Details:
It happend so that a query started retu
Hi,
I have a problem with connection if the postgresql 8.1.3
Comand Line: postmaster -S -o -i -D data (Unix - Solaris OS)
PostgreSql starter...normal
Error:
Command Line Console: psql template1
Message Error: psql: FATAL: invalid command-line arguments for server
process
HINT: Try "
I hope I'm not overstepping here, and not sure if I'm allowed to
reply, but here goes:
It looks like there are two approaches to this:
1) Unify the init scripts so they work all the time everywhere.
2) Generate the scripts as needed per distribution and risk being out
of date.
Option 1 seems l
The following bug has been logged online:
Bug reference: 2336
Logged by: Chris Mair
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: MacOS X 10.3.9
Description:will not drop implicitly created sequence
Details:
Ok, so this is probably not
Hi
I have fixed a bug which was reported in our mailing group ealier. Can
anybody tell me how i could test my code and then put back?
Please tell me where i could get the test code for testing..
Thanks
Dhanaraj
---(end of broadcast)---
TIP 9: I
The following bug has been logged online:
Bug reference: 2337
Logged by: rama krishna
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.0
Operating system: linux fedora
Description:database connection
Details:
[java] 2006-03-20 13:05:50,465 INFO
org.dspace.s
*doh*
Someone had installed v7.4 from rpm which placed psql in /usr/bin (preceding
v8.1/bin in PATH), causing the 7.4 version to be run instead of the 8.1 version.
Sorry for that.
-Original Message-
From: Peter Eisentraut [mailto:[EMAIL PROTECTED]
Sent: den 20 mars 2006 12:45
To: pgsql
Mikael Carneholm wrote:
> This seems to be a psql(?) bug:
It seems you're using an older version of psql.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map set
This seems to be a psql(?) bug:
test.sql
create or replace function test1() returns void as $$
declare
var1 integer;
var2 integer;
var3 integer;
begin
end;
$$ language plpgsql;
miano=> \i test.sql
psql:test.sql:3: ERROR: unterminated dollar-quoted string at or near "$$
declar
15 matches
Mail list logo
