Operating system:
Linux (PLD), kernel 2.2.20
Hardware:
$ cat /proc/cpuinfo | grep -E "^(vendor_id|model name|cpu MHz)"
vendor_id : GenuineIntel
model name : Pentium III (Coppermine)
cpu MHz : 871.474
$ free
total used free sharedbufferscac
Gerald Vogt ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
\d in psql does not show triggers
Long Description
When using \d in psql to find details of a table, occasionally
triggers will not be listed although the table does
[EMAIL PROTECTED] writes:
> This is due to a bug in bin/psql/describe.c line 793
> < if (!error && tableinfo.hasrules)
> should probably be
> > if (!error && tableinfo.triggers)
Looks like this is already fixed in 7.2 sources. But thanks for the
report!
regards, tom lan
On Fri, 1 Feb 2002, hubert depesz lubaczewski wrote:
> Operating system:
> Linux (PLD), kernel 2.2.20
>
> Hardware:
> $ cat /proc/cpuinfo | grep -E "^(vendor_id|model name|cpu MHz)"
> vendor_id : GenuineIntel
> model name : Pentium III (Coppermine)
> cpu MHz : 871.474
>
> $ fr
This is definitely not a problem with the server Tom Lane has told me
and I have verified the with my sources. It seems to be in the JDBC driver.
It only seems to happen when the JDBC client and the postgresql server
are on seperate machines and possibly on different networks.
I have further talk
I test postgresql-7.2rc2 with the following configuration:
AMD1.3Ghz on ASUS A7, 512MB RAM, 3Ware Raid0
SuSE 7.3, 2.4.10-4GB, gcc 2.95.3
postgresql.jar is unusable with suns forte4j v3. most calls from the database
explorer to the DatabaseMetaData fails with exceptions.
postgresql.jar ( vers 7.
Hi,
My server is a postgres v7.1.3.
I have a database with OID and to backup my database i use this syntaxe :
pg_dump -Ft -b -o -f mydb.tar mydb
when i want restore my database i use this command line:
pg_restore -o -d mydb mydb.tar
and i have this error :
Archiver(db): Could not execute query. N
hello sir,
I have written a function. The language used
is sql. I am not getting error if I assign an alias to a variable or if I try to
declare any of the variable.
I could figure out that I require support if
plpgsql, but I am not able to get the suppor of this language. I have
tried
It used to be the case that psql could be run thus:
psql -U summer -h numbat template1 <
ZZ
which is very convenient in scripting.
Now, it writes a password prompt (successfully in my case) and tries to
read the password (presumably from the tty) which fails.
Here is the entire script that f
This is a two-part bug report. The first part is something that I feel is
an obscure bug, the other would be considered 'optimizer acrobatics'
I have 3 tables: TABLEA, TABLEB, TABLEC
TABLEA has integer columns XID and AID, with a unique index on (XID,AID)
and a regular index on AID
TABLEB
Hi,
I've installed Postgres
7.0.3.
The bug I founded was
very weird.
I've this query that I run in
my app. For example, give a list of all sales from all my stores around the
country. The query runs very fast and I get the result I want. Later, I try to
reduce the search and
I am trying to use postgres with the CYGWIN
binaries for WIN/2000. I started initdb with '--debug' and it got as far
as
postgres -boot -x! -C -F -DDatabase -d
template1
and then just sat there with 'postgres' consuming
CPU, but not appearing to do anything.
Has something similar been
POSTGRESQL BUG REPORT TEMPLATE
Your name : Mark Jeacocke
Your email address : [EMAIL PROTECTED]
System Configuratio
Simply use an array_dims() on any non-array type, the messages vary from:
SIS=# select array_dims(datdba) from pg_database;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The
On Tue, 29 Jan 2002, Nagasubramanya L wrote:
> I have even tried
> CREATE LANGUAGE 'plpgsql'
>
> But I am not able to set it. What is that I should do to set up this language
>support.
Use the shell script createlang
createlang plpgsql
should add it to the database in question.
hello,
i have downloaded all the packages through cygwin setup and installed it
(including supplied postgresql) and when i run the command:
/usr/bin/postmaster -i -D /database
it outputs:
$ 0 [main] postmaster 404 fixup_mmaps_after_fork: base address fails
to match requested address 0x3B
=?utf-8?Q?[EMAIL PROTECTED]?= wrote:
> Hi,
>
> My server is a postgres v7.1.3.
> I have a database with OID and to backup my database i use this syntaxe :
> pg_dump -Ft -b -o -f mydb.tar mydb
> when i want restore my database i use this command line:
> pg_restore -o -d mydb mydb.tar
> and i have
All CYGWIN users, make sure that cygipc is on your machine and running before
doing anything with Postgres.
Michaele Holtman wrote:
[EMAIL PROTECTED]">
I am trying to use postgres with the CYGWIN
binaries for WIN/2000. I started initdb with '--debug' and it got as far
as
postgr
John Summerfield <[EMAIL PROTECTED]> writes:
> It used to be the case that psql could [ read a password from stdin ]
> Now, it writes a password prompt (successfully in my case) and tries to
> read the password (presumably from the tty) which fails.
This was a deliberate change. I wasn't that h
"Carlos Atencio" <[EMAIL PROTECTED]> writes:
> I've installed Postgres 7.0.3.
Consider upgrading to something current (7.1.3, or better 7.2 which
should be out Monday).
> None has known how to repair this. In some queries, duplicating some se=
> nteces makes it work. In other queries, it
"Michaele Holtman" <[EMAIL PROTECTED]> writes:
> I am trying to use postgres with the CYGWIN binaries for WIN/2000. I start=
> ed initdb with '--debug' and it got as far as
> postgres -boot -x! -C -F -DDatabase -d template1
> and then just sat there with 'postgres' consuming CPU, but not appearin
"Riendeau, Mike" <[EMAIL PROTECTED]> writes:
> rpath is the same (at least in all Makes in the source root)
> Both config runs have the same parameters. So, something other
> than the setting of rpath is going on here.
Have you set LD_LIBRARY_PATH to point to whereever libreadline liv
Your name : Mike Riendeau
Your email address : [EMAIL PROTECTED]
System Configuration
-
Architecture (example: Intel Pentium) : Sun Sparc 20
Operating System (example: Linux 2.0.26 ELF) : Solaris 2.5.1
PostgreSQL version (example: PostgreSQ
Marc Lavergne <[EMAIL PROTECTED]> writes:
> Simply use an array_dims() on any non-array type,
There is not a lot to be done about that, I'm afraid, since our type
system doesn't have a concept of "any array type". The only way we
have to declare array_dims() is as a function taking any type at a
"Mark Jeacocke" <[EMAIL PROTECTED]> writes:
> select DISTINCT TABLEID, '' AS ALIAS from TABLE; :FAILS
We get this type of complaint regularly. Perhaps DISTINCT should
resolve unknown-type inputs to "text", much as we do with CASE
and UNION constructs when we see an untyped literal. Thoughts?
i am seeing postgre 6.4 return the following error message when performing
a JDBC update with executeUpdate(). any ideas what it means?
ava.sql.SQLException: results returned
at java.lang.Throwable.(Compiled Code)
at java.lang.Exception.(Compiled Code)
at java.sql.SQLExce
26 matches
Mail list logo
