Durumdara wrote:
[client_encoding is switched to WIN1250]
And what happening what DB recognize not win1250 character in SQL?
Is it converted to ? or an exception dropped?
And if the UTF db contains non win1250 character?
Is it replaced in result with ? or some exception dropped?
What you
Hi every body
there is some way to delete or rename an index only if this index exists?
something like
alter index index rename to pepe if exists
thanks
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent Villar
Universitat
2009/12/22 Scott Marlowe scott.marl...@gmail.com
Ahh, right, it's about visibility. Hadn't caught that part.
While it appears that the docs and utility are logically consistent, this is
SO counter-intuitive.
I was just scanning the man page from top to bottom, looking for a way to
show all
Hi
Not sure what I am doing wrong.
I am not getting all the required rpms for the Postgres version 8.4.2.
=
http://rpm.pbone.net/
Your query postgresql-devel-8.4.2 did not match any entry in database.
Your query postgresql-server-8.4.2 did not match any entry in database.
In response to Phoenix Kiula :
Hi
Not sure what I am doing wrong.
I am not getting all the required rpms for the Postgres version 8.4.2.
http://yum.pgsqlrpms.org/reporpms/repoview/letter_p.group.html
I hope you can find your rpm's there, i'm a debian-user...
Andreas
--
Andreas
-Original Message-
From: Filip Rembiałkowski [mailto:plk.zu...@gmail.com]
Sent: Monday, December 21, 2009 6:51 PM
To: Wappler, Robert
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL]
2009/12/21 Wappler, Robert rwapp...@ophardt.com
Hello,
when defining
2009/12/22 Pau Marc Munoz Torres paum...@gmail.com
Hi every body
there is some way to delete or rename an index only if this index exists?
something like
alter index index rename to pepe if exists
for drop - yes:
DROP INDEX IF EXISTS name;
for rename - there is no simple solution.
Phoenix Kiula wrote:
I am not getting all the required rpms for the Postgres version 8.4.2.
What should I be doing?
Using http://yum.pgsqlrpms.org/8.4/ maybe?
It's been a long time since I found either rpbone.net or rpmfind.net to
be very useful, might as well use Google instead to find
On Tuesday 22 December 2009 5:46:25 am Wappler, Robert wrote:
Assuming we could pass a bulk of rows as a table, the update could be
performed as follows:
CREATE OR REPLACE FUNCTION update_tpl(measurements SETOF sensor_data)
RETURNS void VOLATILE AS $$ UPDATE temperature_per_location AS tpl
Does it write data to data files to make buffer clean?if it
does ,but I can not find open files from the result of lsof -p
PID.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi.
We have installed Postgresql 8.3.3. When we see the output of atop-d, we
see just such a string
db0: ~ # atop 15
ATOP - db0 2009/12/22 12:14:29 15 seconds elapsed
DSK | sda | busy 50% | read 72 | write 207 | avio 27 ms |
PID RDDSK WRDSK WRDSK_CANCEL DSK CMD 1 / 2
11296 0K 185.0M 185.0M
On Tue, Dec 22, 2009 at 10:19 AM, Thomas freebsd...@gmail.com wrote:
Does it write data to data files to make buffer clean?if it
does ,but I can not find open files from the result of lsof -p
PID.
writer actually takes care about writing pages down, from shared
memory. It is the central
On 19/12/2009, at 16:32, John DeSoi wrote:
If I execute with a row limit of 1000, and I know there are more than 1000
rows, I get the portalSuspended as described.
But, If a issue a new Execute, postgresql says that myPortal doesn't exist
anymore.
How I can get those 1000 rows ?
Hello again,
Now that I have working the Extended Query using the Front End Protocol 3.0,
I'm getting better results with simple queries than extended queries.
table comptes:
Simple query:
select * from comptes WHERE codi_empresa = '05' AND nivell=11 and clau_compte
like '05430%' =
I'm working on a client library, written in C, and am using:
COPY sometable TO STDOUT WITH BINARY
followed by calls to 'PQgetCopyData' to retrieve data from the table as a
postgres binary stream.
All my DB interaction is synchronous.
I've had things working for some time, but recent
Nathaniel Trellice napt...@yahoo.co.uk writes:
So, even though the manual states that it's obsolete, do I need to issue a
call to 'PQendcopy' to tell the server that the copy is complete?
No, but did you do a PQgetResult? See the description of PQgetCopyData.
regards,
Tom Lane wrote:
No, but did you do a PQgetResult? See the description of PQgetCopyData.
Oops! Thanks Tom. Even after many re-reads, I missed that final paragraph in
the manual, and have wasted ages on this.
Nathaniel
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Raimon Fernandez co...@montx.com writes:
But the portal isn't destroyed after a sync ?
Not directly by a Sync, no.
I'm getting a Portal 'myPortal' doesn't exist when sending the next
Execute ...
End of transaction would destroy portals --- are you holding a
transaction open for this? It's
Hello,
A customer of mine is running 8.3.8. We are attempting to take a backup,
but whenever we issue pg_start_backup() it always says that we need to first
run pg_stop_backup() - Even when I run the stop backup command right before
trying to start the backup. I have restarted PostgreSQL
Hi,
I installed Postgresql 8.4.2 on Centos
5.4 64 bit.
I migrated data from postgres 8.3 to
8.4.2 using PgAdmin 1.10 backup and
restore functions.
We access the data using ODBC.
For some reports, we need to create a
temporal table, fill it and then drop
it.
This kind of
On Tue, Dec 22, 2009 at 10:30, Лев Ласкин laski...@gmail.com wrote:
Hi.
We have installed Postgresql 8.3.3. When we see the output of atop-d, we see
just such a string
db0: ~ # atop 15
ATOP - db0 2009/12/22 12:14:29 15 seconds elapsed
DSK | sda | busy 50% | read 72 | write 207 | avio 27 ms
Hi, hoping someone can tell me how to get this running again.
I have pitr running and noticed that the slave is far out of date with wal logs.
Upon investigation I see that on the master that /data/pgsql/backups/wal_logs
has over 6000 logs that haven't been moved
to the
On 22/12/2009, at 18:15, Tom Lane wrote:
Raimon Fernandez co...@montx.com writes:
But the portal isn't destroyed after a sync ?
Not directly by a Sync, no.
ok,
I'm getting a Portal 'myPortal' doesn't exist when sending the next
Execute ...
End of transaction would destroy portals
Hi Chris,
Assuming the error condition is resolved, the process should
restart automatically. However, one issue we have found is that there appears
to be an upper limit to how many files `test` can actually check for existence.
We found that it was returning 1 in error and
Database contains CHAR(7) type column which must be NOT NULL and must be in
the format
mm.
where:
mm - month number, always two digits in range 01 .. 12
. - separator must be point always.
- must be four digits in range approx. 1980 .. 2110 .
How to add column validation to table
Hi Andrus,
How to add column validation to table column which forces this ?
You're looking for a constraint - I presume you know what conditions you want
to check for - I've done a similar thing recently ensuring the first character
in a column is a decimal point, or that if one column's
On Dec 22, 2009, at 15:03 , Andrus wrote:
Database contains CHAR(7) type column which must be NOT NULL and
must be in the format
mm.
where:
mm - month number, always two digits in range 01 .. 12
. - separator must be point always.
- must be four digits in range approx. 1980 ..
A. Kretschmer writes:
http://yum.pgsqlrpms.org/reporpms/repoview/letter_p.group.html
Only up to 8.4.1 there.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
They also used to be at ftp.postgresql.org:/pub/binary.
There are only rpms up to 8.4.1
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Easy mistake to make
The repo RPM version is 8.4-1 -- note the hyphen. This is the repo for
all 8.4 versions, including 8.4.2.
Install the proper repo RPM for your platform and then you can just yum
install (or upgrade) PostgreSQL 8.4.2.
To browse the files in the 8.4 repo, try:
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of Andrus
Sent: Tuesday, December 22, 2009 12:03 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] How to add month.year column validation
Database contains
On Tue, 2009-12-22 at 15:10 -0500, Francisco Reyes wrote:
Only up to 8.4.1 there.
Which os/distro are you looking for? I hope it is not Fedora 11 -
x86_64.
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
Michael,
Thank you very much.
I have very few knowledge on rexexps.
CHECK (val ~ $re$^(19|20|21)[0-9]{2}.[01][0-9]$$re$)
1. I tried
create temp table test5 ( tmkuu char (7) CHECK (tmkuu ~
$re$[01][0-9].^(19|20)[0-9]{2}$re$) ) on commit drop;
insert into test5 values('01.2009');
but got
CREATE DOMAIN Nasty_Month_year AS CHAR(7)
CHECK ( SUBSTR(VALUE, 1, 2) IN ('01', '02', '03', '04', '05', '06',
'07', '08', '09', '10', '11', '12') AND SUBSTR(VALUE, 3, 1) = '.' AND
SUBSTR(VALUE, 4, 4)::int BETWEEN 1980 and 2110 );
CREATE TABLE foo (bar Nasty_Month_year );
This Works:
INSERT INTO
On Tue, Dec 22, 2009 at 1:47 PM, Andrus kobrule...@hot.ee wrote:
Michael,
Thank you very much.
I have very few knowledge on rexexps.
CHECK (val ~ $re$^(19|20|21)[0-9]{2}.[01][0-9]$$re$)
1. I tried
create temp table test5 ( tmkuu char (7) CHECK (tmkuu ~
On Dec 22, 2009, at 16:11 , Scott Marlowe wrote:
alter table test add constraint test_a_check check (a ~
$r$^(0[1-9]|1[0-2]).(19[89][0-9]|20[0-9]{2}|210[0-9]|2110)$$r$);
However, I strongly recommend using a date column with, perhaps, a
restriction that the day field is always 1 or some
- Dann Corbit dcor...@connx.com wrote:
CREATE DOMAIN Nasty_Month_year AS CHAR(7)
CHECK ( SUBSTR(VALUE, 1, 2) IN ('01', '02', '03', '04', '05', '06',
'07', '08', '09', '10', '11', '12') AND SUBSTR(VALUE, 3, 1) = '.' AND
SUBSTR(VALUE, 4, 4)::int BETWEEN 1980 and 2110 );
CREATE TABLE foo
On Tue, Dec 22, 2009 at 1:18 PM, Antonio Sobalvarro a...@estrategicas.com
wrote:
This kind of programs get the error message “relation pg_autovacumm does not
exist”.
what programs are failing?
anyway, the error is that those programs are accesing a catalog that
doesn't exist anymore
Devrim GÜNDÜZ writes:
On Tue, 2009-12-22 at 15:10 -0500, Francisco Reyes wrote:
Only up to 8.4.1 there.
Which os/distro are you looking for? I hope it is not Fedora 11 -
x86_64.
CentOS x86_64
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Thank you Jaime for your support.
I will ask the developers to check on
the software and locate which programs
are trying to access pg_autovacuum
catalog.
Also will try to create the
pg_autovacuum table.
Regards,
Antonio Sobalvarro
Soluciones Estrategicas S.A.
Avenida Reforma 6-39 zona 10
Howdy all
I changed the default port for Postgresql.
Now, when I want to access postgresql via psql (on the db server),
is there a way to make it default to the new port without using -p
or a .psqlrc file?
I sort of assumed that psql connected via a local pipe and not a port.
Thanks
Dave
On Tue, Dec 22, 2009 at 4:57 PM, David Kerr d...@mr-paradox.net wrote:
Howdy all
I changed the default port for Postgresql.
Now, when I want to access postgresql via psql (on the db server),
is there a way to make it default to the new port without using -p
or a .psqlrc file?
You can set
On Tue, 2009-12-22 at 15:57 -0800, David Kerr wrote:
Howdy all
I changed the default port for Postgresql.
Now, when I want to access postgresql via psql (on the db server),
is there a way to make it default to the new port without using -p
or a .psqlrc file?
Not that I know of.
I
On Tue, Dec 22, 2009 at 05:01:45PM -0700, Scott Marlowe wrote:
- On Tue, Dec 22, 2009 at 4:57 PM, David Kerr d...@mr-paradox.net wrote:
- Howdy all
-
- I changed the default port for Postgresql.
-
- Now, when I want to access postgresql via psql (on the db server),
- is there a way to make
On Tue, 2009-12-22 at 16:08 -0800, David Kerr wrote:
- export PGPORT=5433
-
- etc...
ok thanks, that might be an easier way to handle my scripts.
can you export PGHOST as well?
The manual provides a list:
http://www.postgresql.org/docs/8.3/static/libpq-envars.html
Joshua D. Drake
On Tue, Dec 22, 2009 at 04:17:05PM -0800, Joshua D. Drake wrote:
- On Tue, 2009-12-22 at 16:08 -0800, David Kerr wrote:
-
- - export PGPORT=5433
- -
- - etc...
-
- ok thanks, that might be an easier way to handle my scripts.
-
- can you export PGHOST as well?
-
- The manual provides a
On 12月22日, 下午11时26分, gryz...@gmail.com (Grzegorz Jaśkiewicz) wrote:
On Tue, Dec 22, 2009 at 10:19 AM, Thomas freebsd...@gmail.com wrote:
Does it write data to data files to make buffer clean?if it
does ,but I can not find open files from the result of lsof -p
PID.
writer actually takes
On Tue, Dec 22, 2009 at 6:56 PM, Thomas freebsd...@gmail.comote:
And could you give me some info about postgres internals? Such as
ebooks or online articles.
I'm not sure if you've already reviewed this part of the PostgreSQL docs or not:
On Tue, 2009-12-22 at 18:34 -0500, Francisco Reyes wrote:
Which os/distro are you looking for? I hope it is not Fedora 11 -
x86_64.
CentOS x86_64
As written before:
http://yum.pgsqlrpms.org/8.4/redhat/rhel-5-x86_64/repoview/
Regards,
--
Devrim GÜNDÜZ, RHCE
Command Prompt -
The video archive for the 11/10 SFPUG meeting, Continuent Tungsten
with PostgreSQL, is now available:
http://thebuild.com/blog/2009/12/22/sfpug-continuent-tungsten-with-postgresql/
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list
Hi Christophe,
Thanks for posting the video, but the linked video appears to be Josh Berkus
lecturing on GUCS, which I believe was the previous month.
BTW, since doing the Tungsten talk in early November we have also implemented
support for clusters using Londiste. We'll do some talks about
Ah, you think you have all the links in an entry corrected... :) It's
fixed now, thanks!
On Dec 22, 2009, at 10:14 PM, Robert Hodges wrote:
Hi Christophe,
Thanks for posting the video, but the linked video appears to be
Josh Berkus lecturing on GUCS, which I believe was the previous
Looks great. Thanks again! Robert
On 12/22/09 10:17 PM PST, Christophe Pettus x...@thebuild.com wrote:
Ah, you think you have all the links in an entry corrected... :) It's fixed
now, thanks!
On Dec 22, 2009, at 10:14 PM, Robert Hodges wrote:
Hi Christophe,
Thanks for posting
Hi all,
We have a PostgreSQL server with ASCII data. We have a requirement for
the db to support UTF also. Which is the best approach -
1) Make a new installation, move data
2) There is some way of doing an 'in-place' conversion and changing the
character set of the existing installation
2009/12/23 Jayadevan M jayadevan.maym...@ibsplc.com
Hi all,
We have a PostgreSQL server with ASCII data. We have a requirement for the
db to support UTF also. Which is the best approach -
1) Make a new installation, move data
2) There is some way of doing an 'in-place' conversion and
Jayadevan M wrote:
We have a PostgreSQL server with ASCII data. We have a
requirement for the db to support UTF also. Which is the best
approach -
1) Make a new installation, move data
This is the only and hence the best approach.
It doesn't have to be a new installation, a new database
A customer of mine is running 8.3.8. We are attempting to
take a backup, but whenever we issue pg_start_backup() it
always says that we need to first run pg_stop_backup() - Even
when I run the stop backup command right before trying to
start the backup. I have restarted PostgreSQL
57 matches
Mail list logo