hi,all
for example tableA
create table tableA (
id serial,
a integer,
b integer,
c integer
);
insert into tableA (a,b,c) values (12,34,56);
then,
select id from tableA where (a||b||c)=123456;
in postgresql version 8.2.11,it works.
Hi Tony,
Its not a bug - automatic casting was removed in 8.3. You should cast( a
as text)||cast(b ... = cast(123456 as text). Other option is to define
your own operators which is to be used only in case you can not fix
clients of your database...
Tony Liao rašė:
hi,all
for example
thanks,Julius.
2009/2/26 Julius Tuskenis jul...@nsoft.lt
Hi Tony,
Its not a bug - automatic casting was removed in 8.3. You should cast( a as
text)||cast(b ... = cast(123456 as text). Other option is to define your own
operators which is to be used only in case you can not fix clients of
hello,everybody
I want to create index for column ip1 and ip2.I know there is a
contrib name ip4r.but the column ip1(ip2) would be a ip address or ip range.
The query would do select ... where ip1='96.168.65.84' or
ip2='96.168.65.84'.
does anyone have ideas?
Hi,
I have some basic query in postgresql with storage, Please help me for
the following
1. What is the best practice to use postgresql with storage.
2. Which are the files and folders we can keep it in storage.
Regards
Karthikeyan.N
Tom Lane schrieb:
Peter Hinse l...@d0pefish.de writes:
More info: the statement is an INSERT with some huge subselects, running
every night on a PGSQL 8.3.6 on CentOS 4.7 x86_64. In 97% of all
occasions, the job terminates in about 1-2 minutes - however, sometimes
it just hangs. If terminated
Daniel J. Summers wrote:
Andrzej Zawadzki wrote:
Daniel J. Summers wrote:
Tony Liao wrote:
I try to explain analyze,but it doesn't work ,it use seq scan.
Generally speaking, LIKE doesn't use indexes.
?! That's not true at all!!
[...]
PostgreSQL (the great subject
Mónica, thanks for reply
I didn't install client, and i don't know how to check if it's instant or
complete. What I can do is:
[CODE]
tols...@heman:/opt/oraclegt; sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 26 14:40:01 2009
Copyright (c) 1982, 2005, Oracle. All rights
On Wed, Feb 25, 2009 at 5:05 AM, Lentes, Bernd
bernd.len...@helmholtz-muenchen.de wrote:
Hello ML,
I'm very new to Postgres.
In the log, i got messages concerning transaction ID wraparound.
I red the documentation and made a vaccum on that database.
In the documentation i also found the hint
Lee Azzarello wrote:
Sometimes the number grows by 5 in one second.
I'm also astonished about the fact that all databases grow
by the same amount.
Do you have any explanations for this behaviour ?
Why are the numbers growing so quickly ?
What kind of work load is on the database?
Amit Jain wrote :
Its a log analyzer tool through which you can trap the running
queries and have reports about update/delete/insterts which are
executing at database system.
http://pgfouine.projects.postgresql.org/
Lentes, Bernd
On Thu, Feb 26, 2009 at 7:02 AM, Nagalingam, Karthikeyan
karthikeyan.nagalin...@netapp.com wrote:
Hi,
I have some basic query in postgresql with storage, Please help me for the
following
1. What is the best practice to use postgresql with storage.
Depends on your workload. My workload has a
On Thu, Feb 26, 2009 at 5:33 AM, Tony Liao tonyl...@yuehetone.com wrote:
hello,everybody
I want to create index for column ip1 and ip2.I know there is a
contrib name ip4r.but the column ip1(ip2) would be a ip address or ip range.
The query would do select ... where
On Wed, Feb 25, 2009 at 3:05 AM, Lentes, Bernd
bernd.len...@helmholtz-muenchen.de wrote:
Hello ML,
I'm very new to Postgres.
In the log, i got messages concerning transaction ID wraparound.
What exact message did you get?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To
Hi Tom,
As per your advise I removed the old PG 8.3.6 installation and run again
configure and compiled the pg src.
here is my configure settings , mentioned the psql behavior have not
changed , I''m still not able to use history line from readline.
./configure --prefix=/opt/pgsql/
So, I got pretty close to my max_connections setting, and I had to up it
last night. I did so, and I issued a pg_ctl reload. Everything _seems_
happy.
However, the script I use to monitor this has the number hard-coded in it
(well, it looks it up from the conf file, anyway), and I'd rather get
On Thu, 2009-02-26 at 12:17 -0600, Scott Whitney wrote:
So, I got pretty close to my max_connections setting, and I had to up it
last night. I did so, and I issued a pg_ctl reload. Everything _seems_
happy.
However, the script I use to monitor this has the number hard-coded in it
(well, it
Hi,
On Fri, Feb 27, 2009 at 3:17 AM, Scott Whitney swhit...@journyx.com wrote:
So, I got pretty close to my max_connections setting, and I had to up it
last night. I did so, and I issued a pg_ctl reload. Everything _seems_
happy.
max_connections can only be set at server start.
Regards,
--
Scott Whitney swhit...@journyx.com wrote:
So, I got pretty close to my max_connections setting, and I had to
up it last night. I did so, and I issued a pg_ctl reload. Everything
_seems_ happy.
It's not. Note the comment:
# (change requires restart)
However, the script I use to monitor
Hi All,
I have installed Postgres 8.3.3 and Pgpool 2.2RC2 on two machines and* Both
*servers have the identical copy of the database running.
I have started postgres server on both machines and I have started pgpool on
both machines.
But for some reasons i am not able to connect to database
On Thu, 2009-02-26 at 01:08 +0300, Vladimir Rusinov wrote:
First of all, you might want to use yum overlay for RHEL/CentOS:
http://yum.postgresqlrpms.org/
http://yum.pgsqlrpms.org is a better URL (the other one is also valid,
but still...)
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org,
Thank you, but my problem is : psql can't make use of readline cmd line
history. I don't have a .psql_history file in my .~/ dir.
I installed/upgrade PG 8.3.6 from tarball as user postgress, psql will
conect to db but not history cmd line so far...any tips ?
OS: RHEL 5-64 bits
ldd
During the compilation of PostgreSQL 8.3.6 on Solaris 10 1/06
s10a_u1wos_19a, I received the following error:
Undefined symbol ldap_start_tls_s first referenced in file libpq/SUBSYS.o
Using the nm command against the /usr/lib/libldap.so file did not locate
the ldap_start_tls_s object.
I had
hi,lee
CIDR is only accept ipv4 but not ip range such as 192.168.1.0/24.
INET type is what I need,but I don't know how to create index.
does anyone have ideas?
2009/2/27 Lee Azzarello l...@dropio.com
On Thu, Feb 26, 2009 at 5:33 AM, Tony Liao tonyl...@yuehetone.com
I'm attempting to get warm standby up and running with a pair of servers
running ubuntu 8.04 and postgresql 8.3. Been following the docs:
http://www.postgresql.org/docs/8.3/static/warm-standby.html
http://www.postgresql.org/docs/current/static/pgstandby.html
Also, basically following the
25 matches
Mail list logo