hi ,
i'm workin with rh9 (just a beginner).
I'v installed postgreSQL 7.3.6 on location
/usr/local/pgsql
but there is also a default pgsql (i think of rh9)
at location
/var/lib/pgsql (this is 7.3.2)
what i did
--
[EMAIL PROTECTED] root]# cd /usr/local/pgsql/bin
Subject : psql: relocation error: psql: undefined
symbol: PQgetssl
hi ,
platform : redhat linux 9
---
Is postgreSQL 7.3.2 already installed on
rh9(by-default)
I have tried using both the postgresql-7.3.2.t
If PostgreSQL failed to compile on your computer or you found a bug that
is likely to be specific to one platform then please fill out this form
and e-mail it to [EMAIL PROTECTED]
To report any other bug, fill out the form below and e-mail it to
[EMAIL PROTECTED]
If you not only found the problem
Hi,
I had postgresql 7.3 rpm installed on redhat 9 platform. i removed it
and downloaded and installed following rpm's from ur ftp site:-
[EMAIL PROTECTED] postgresql-7.4]# rpm -qa |grep postgre
postgresql-debuginfo-7.4-0.5PGDG
postgresql-libs-7.4-0.5PGDG
postgresql-contrib-7.4-0.5PGDG
postgresq
I have a table with an integer column with about 10M rows in it.
This column has an index (btree).
When I try to select a row using this column with an integer, e.g. select *
from table where id=4, it always uses the index. However, if I select try
to select a row using this column with a decim
Hello.
I use PostgreSQL 7.4.2 on i386-portbld-freebsd5.2, compiled by GCC cc (GCC) 3.3.3
[FreeBSD] 20031106
Description:
It seems that renaming tables with columns of type "serial" leaves
"orphaned" implicit sequences which breaks pg_restore.
How to reproduce:
1. Create a table
CREATE DATA
Dear sir,
I installed mapserver a cgi using libpq client
library under win2K within tomcat. I tried to display postgis layers stored on
another host but I got the error message "unknown host name". I don't have any
skill in C programming. Could you tell me how I have to patch fe-connect.c f
Tom Lane wrote:
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
If I call "psql -h localhost" it is very slow
compared to "psql -h 127.0.0.1" since for "localhost"
the nameservice is consulted.
This is not a bug; it's supposed to do that. If you don't like it,
reconfigure your name service (
Alan Stange <[EMAIL PROTECTED]> writes:
> There's memory corruption occuring causing the malloc routines to
> SIGBUS.
> ...
> Sadly, we have no reproducible test case right now.
Without a test case there's not much we can do :-(. The backtrace you
show is during client query collection, which i
On Monday 29 March 2004 02:51 am, rahul wrote:
> I had postgresql 7.3 rpm installed on redhat 9 platform. i removed it
> and downloaded and installed following rpm's from ur ftp site:-
> An old version of the database format was found.\nYou need to upgrade
> the data format before using PostgreSQL
rahul wrote:
> An old version of the database format was found.\nYou need to upgrade
> the data format before using PostgreSQL.\nSee
> /usr/share/doc/postgresql-7.4/README.rpm-dist for more information.
>
> could u please let me know, how to get rid of this problem.
Follow the instructions in
/u
Johan Duflost wrote:
> I installed mapserver a cgi using libpq client library under win2K
> within tomcat. I tried to display postgis layers stored on another
> host but I got the error message "unknown host name". I don't have
> any skill in C programming. Could you tell me how I have to patch
> f
I got bitten by this one also. Perhaps it would be possible to change
pg_dump so that it dumps the create table statement with the explicit
sequence, rather than the original SQL used to create the table? (This
would preserve old dumps and the syntactical sugar which I would not
want to forego.)
Pa
Bug in 7.4.2.. Concern with handling of Double Quotation Marks (").
Escape of double quotation marks can't solve the problem.
--
CREATE TABLE public.test
(
my_column varchar NOT NULL,
CONSTRAINT my_primary PRIMARY KEY (my_column)
) WITHOUT OIDS;
---
CREATE TABLE public.ref_tes
On Wed, 31 Mar 2004, Alexander S wrote:
> Bug in 7.4.2.. Concern with handling of Double Quotation Marks (").
> Escape of double quotation marks can't solve the problem.
>
> --
> CREATE TABLE public.test
> (
> my_column varchar NOT NULL,
> CONSTRAINT my_primary PRIMARY KEY (my_colum
Alexander S <[EMAIL PROTECTED]> writes:
> Instead I can only insert:
> insert into ref_test values (' {here \\"some_text\\"} '); -- but
> this is not exactly that i want to have.
Unfortunately, that is what the syntax of array literals requires you to
say.
You might find it easier to work
16 matches
Mail list logo
