Hi All,
In Postgresql we can use savepoint and rollback to savepoint in transaction.
But we cannot use savepoint in function.
Currently I am doing migration from Informix to Postgresql 8.4.
In Informix they used Savepoint.
Please advice how to use Savepoint and rollback to savepoint in function.
I
Now, I'm using my dev machine.
With the tests I'm doing, I can see the following:
If I use:
select 'seléct' as "seléct";
column name returns ok as expected.
If I do:
select 'seléct' as seléct;
This is the sequence of bytes I receive from postgresql:
byte1 - 115 UTF-8 for s
byte2 - 101 UTF-
On 3/15/2011 12:02 PM, Igor Neyman wrote:
-Original Message-
From: Bill Thoen [mailto:bth...@gisnet.com]
Sent: Monday, March 14, 2011 11:31 PM
To: pgsql-general@postgresql.org
Subject: Partitioned Database and Choosing Subtables
I've got a ver 8.4.5 partitioned data base with records
On Mar 16, 2011, at 3:15 AM, Alexander Farber wrote:
> And same for a simple select-query from1 table (w/o join):
>
> # select id from pref_match where sum(completed) > 30 group by id;
> ERROR: aggregates not allowed in WHERE clause
> LINE 1: select id from pref_match where sum(completed) > 30
On Mar 16, 2011, at 3:12 AM, Alexander Farber wrote:
> Unfortunately I get:
>
> # select u.id, u.first_name, sum(m.completed) from pref_users u,
> pref_match m where u.id=m.id and u.id like 'DE%' and sum(m.completed)
>> 30 group by u.id, u.first_name order by sum desc limit 3;
> ERROR: aggregat
And same for a simple select-query from1 table (w/o join):
# select id from pref_match where sum(completed) > 30 group by id;
ERROR: aggregates not allowed in WHERE clause
LINE 1: select id from pref_match where sum(completed) > 30 group by...
^
--
Sent v
Unfortunately I get:
# select u.id, u.first_name, sum(m.completed) from pref_users u,
pref_match m where u.id=m.id and u.id like 'DE%' and sum(m.completed)
> 30 group by u.id, u.first_name order by sum desc limit 3;
ERROR: aggregates not allowed in WHERE clause
LINE 1: ...f_match m where u.id=m.i
On Mar 16, 2011, at 3:03 AM, Alexander Farber wrote:
> # select u.id, u.first_name, sum(m.completed)
> from pref_users u, pref_match m
> where u.id=m.id and u.id like 'DE%' and
> sum > 30 group by u.id, u.first_name
> order by sum desc limit 3;
>
> ERROR: column "sum" does not exist
> LINE 4: .
Thank you all for the replies!
On Wed, Mar 9, 2011 at 7:01 PM, David Johnston wrote:
> SELECT username, count(username) FROM phpbb_users
> GROUP BY username
> HAVING count(username) > 1;
>
> If anything shows up then (phpbb_users .username) is not a unique field but
> you are trying to insert it
On Mar 16, 2011, at 2:31 AM, Andy Chambers wrote:
> Is it a big no-no to enable/disable triggers by manually setting
> pg_trigger.tgenabled to 'D'?
Not recommended to do anything with catalog tables. At the place of this use
following command:
ALTER TABLE DISABLE TRIGGER [ trigger_name | AL
On Tue, Mar 15, 2011 at 05:01:50PM -0400, Andy Chambers wrote:
> Is it a big no-no to enable/disable triggers by manually setting
> pg_trigger.tgenabled to 'D'?
No, but I seem to recall having seen corner cases where it didn't
work. (This was the reason that in older versions of slony, slony
fo
Hello,
I have a table holding number of games per week for each user:
# select id,completed,yw from pref_match limit 3;
id | completed | yw
+---+-
OK2650139676 | 10 | 2011-03
OK513367704098 | 20 | 2011-03
OK513367704098 |
Hi All,
Is it a big no-no to enable/disable triggers by manually setting
pg_trigger.tgenabled to 'D'?
--
Andy Chambers
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
What it probably means is that this:
svc:/application/database/postgresql_83:default_64bit
is pointing at a different instance of Postgres than this:
pg_ctl -D /var/lib/pgsql/data -l postmaster.log start
indeed.
# svcprop svc:/application/database/postgresql_83:default_64bit | grep data
On Tuesday, March 15, 2011 1:33:48 pm general_lee wrote:
> Guys,
>
> Thanks for your help.
>
> When I saw that netstat was not listening as *.5432 I decided to;
>
> svcadm disable svc:/application/database/postgresql_83:default_64bit
>
> Then;
>
> pg_ctl -D /var/lib/pgsql/data -l postmaster.lo
Guys,
Thanks for your help.
When I saw that netstat was not listening as *.5432 I decided to;
svcadm disable svc:/application/database/postgresql_83:default_64bit
Then;
pg_ctl -D /var/lib/pgsql/data -l postmaster.log start
This fixed the problem.
You guys were right on the money, looks like
H,
What would change the encoding of the identifiers?
Because on my dev machine which unfortunately isn't with me right now
I can't get the identifier returned correctly :(
I remember that it returns:
test=*# select 'tést' as tést;
tst
--
tést
Is there any config I can change
We recently upgraded from 8.3.something to 9.0.1. With 9.0.1, we have a
huge spike in vacuums every 8 days only on one of our DB servers. We go
from approx 20 vacuums every 5 minutes to 350 per 5 minutes. This lasts for
several hours, then stops. I have attached a graph that shows the
occurren
Francisco Figueiredo Jr. wrote:
>
> What happens if you remove the double quotes in the column name identifier?
the same:
test=*# select 'tést' as tést;
tést
--
tést
(1 Zeile)
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effec
On 03/15/11 11:26 AM, Raymond O'Donnell wrote:
On 15/03/2011 18:14, general_lee wrote:
To confirm, the below would indicate PM is not listening on *.5432
How do I change this?
Did you restart Postgres after changing listen_addresses in
postgresql.conf?
he indicated he did, via 'svcadm rest
On 03/15/2011 11:14 AM, general_lee wrote:
To confirm, the below would indicate PM is not listening on *.5432
How do I change this?
Are you sure you are looking at the correct configuration files? Is it
possible there is more than one set on the machine and the cluster you
are restarting is
This is the query our user sent as one of the problems:
select "zurück" as zurück3_103_ from "Tabelle" tabellenhib0_
And here is the link to our bug report:
http://pgfoundry.org/tracker/index.php?func=detail&aid=1010988&group_id=1000140&atid=590
I didn't test putting double quotes in the colum
> Explains why locahost is OK, but how do I get PM to listen on *.5432
Well, you believe you already have, by telling PostgreSQL to
listen on '*'. There might be a few different reason why it's
not:
1) Are you editing the correct postgresql.conf file? Do you have
multiple ones on the filesy
On 15/03/2011 18:14, general_lee wrote:
To confirm, the below would indicate PM is not listening on *.5432
How do I change this?
Did you restart Postgres after changing listen_addresses in postgresql.conf?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general
Francisco Figueiredo Jr. wrote:
> Hi all!
>
> I received a bug report about problems with identifiers.
>
> If I do the following select:
>
> select 1 as tést
>
> The column name returned contains strange chars.
>
> If I do:
>
> select 'tést' as tést
>
> the select value returned is ok but
To confirm, the below would indicate PM is not listening on *.5432
How do I change this?
# netstat -a | grep LISTEN
localhost.5999 *.*0 0 49152 0 LISTEN
*.ssh*.*0 0 49152 0 LISTEN
*.telnet *
Here you go.
Explains why locahost is OK, but how do I get PM to listen on *.5432
Thanks for your help
# netstat -a | grep LISTEN
localhost.5999 *.*0 0 49152 0 LISTEN
*.ssh*.*0 0 49152 0 LISTEN
*.telnet
Hi all!
I received a bug report about problems with identifiers.
If I do the following select:
select 1 as tést
The column name returned contains strange chars.
If I do:
select 'tést' as tést
the select value returned is ok but the column name is not. :(
Is there any configuration I need to
Doesn't matter I'l try reinstallin the Windows anyway
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PostgreSQL-for-Holdem-Manager-could-not-be-installed-tp3700954p3712964.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via p
On 03/15/11 10:24 AM, general_lee wrote:
Hi,
I've checked IP Filter is disabled...
Also this is Solaris 10 - netstat -lnp is not recognised. Here is netstat
-np without my macs :)
netstat -an
shows listening ports.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To m
On 03/15/2011 10:37 AM, general_lee wrote:
To confirm, 10.3.55.182 is the Postgres Server
$ telnet 10.3.55.182 5432
Trying ...
telnet: Unable to connect to remote host: Connection refused
$ telnet localhost 5432
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
$ psql -h 1
> -Original Message-
> From: Bill Thoen [mailto:bth...@gisnet.com]
> Sent: Monday, March 14, 2011 11:31 PM
> To: pgsql-general@postgresql.org
> Subject: Partitioned Database and Choosing Subtables
>
> I've got a ver 8.4.5 partitioned data base with records
> organized by US state, so
Depending on whether the vendor or user is expected to install and setup
PostgreSQL the issue is that the vendor should be contacting the list and
asking for help with one of their users/setups as opposed to the end-user
asking directly for help. The end-user shouldn't be expected to have the
skil
Hi,
I've checked IP Filter is disabled...
Also this is Solaris 10 - netstat -lnp is not recognised. Here is netstat
-np without my macs :)
I'm using vnet3 so looks like I'm using the wrong netmask, tried editing
pg_hba.conf to 255.255.255.255 instead but still no joy...
Device IP Address
To confirm, 10.3.55.182 is the Postgres Server
$ telnet 10.3.55.182 5432
Trying ...
telnet: Unable to connect to remote host: Connection refused
$ telnet localhost 5432
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
$ psql -h 10.3.55.182 -U post_owner -d post_db
psql:
> I'm trying to allow a remote host on our 10.3.55.X network remote access
> to
> a Postgres Database on the same network.
>
> We're running Solaris 10 with Postgres 83
>
> My postgresql.conf looks like this;
>
>
> listen_addresses = '*' # what IP address(es) to listen
> on;
>
On 03/15/11 10:33 AM, Raymond O'Donnell wrote:
Don't you need to have a host in there? - e.g.
$ psql -h 127.0.0.1
$5 gets you $20, the OP was obfuscating his hosts/IPs.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.po
On 15/03/2011 16:36, general_lee wrote:
Both the below were ran on the Postgres Server.
$ telnet 5432
Trying ...
telnet: Unable to connect to remote host: Connection refused
$ psql -h -U post_owner -d post_db
psql: could not connect to server: Connection refused
Is the server runn
On 03/15/2011 09:36 AM, general_lee wrote:
Both the below were ran on the Postgres Server.
$ telnet 5432
Trying ...
telnet: Unable to connect to remote host: Connection refused
$ psql -h -U post_owner -d post_db
psql: could not connect to server: Connection refused
Is the server r
Manos Karpathiotakis writes:
> Hi all,
> I am using postgres 9.0 under CentOS 5.5 (Dual Xeon Quad Core @ 2,44 GHz,
> 64GB RAM, 2TB RAID 5). In my case, postgres is used as a backend for the RDF
> store Sesame.
> I am trying to store a dataset that consists of approximately 900.000.000
> insertions
Adrian Klaver wrote:
> On Tuesday, March 15, 2011 9:31:17 am Merlin Moncure wrote:
> > On Tue, Mar 15, 2011 at 11:04 AM, Bruce Momjian wrote:
> > > The larger question is whether these forums should be used to help
> > > people get support for commercial products that embed Postgres.
> >
> > I ha
can you post output of netstat -lnp when run on the machine
running postgresql server ?
On Tue, Mar 15, 2011 at 9:54 PM, general_lee wrote:
> Hi,
>
> Thanks for the reply.
>
> Nope, not a Firewall problem.
>
> I also get connection refused if I telnet by IP address on the Postgres
> server.
>
> I
Adrian Klaver writes:
> On Tuesday, March 15, 2011 8:50:34 am general_lee wrote:
>> But I get a "connection refused" if I try and telnet to port 5432 from a
>> remote host.
> Is this a "connection refused" from Postgres or telnet?
Postgres doesn't ever emit an error message spelled like that. T
Hi,
Thanks for the reply.
Nope, not a Firewall problem.
I also get connection refused if I telnet by IP address on the Postgres
server.
I can telnet localhost 5432
But not telnet 5432
Anything else I can try here? I'm not sure my pg_hba.conf is correct, what
do you think?
--
View this mess
Both the below were ran on the Postgres Server.
$ telnet 5432
Trying ...
telnet: Unable to connect to remote host: Connection refused
$ psql -h -U post_owner -d post_db
psql: could not connect to server: Connection refused
Is the server running on host "" and accepting
TCP/IP
On Tuesday, March 15, 2011 9:31:17 am Merlin Moncure wrote:
> On Tue, Mar 15, 2011 at 11:04 AM, Bruce Momjian wrote:
> > The larger question is whether these forums should be used to help
> > people get support for commercial products that embed Postgres.
>
> I have no particular philosophical ob
On 03/15/11 9:26 AM, Bruce Momjian wrote:
I think we should make sure they have checked the vendor help system
first or point them to that.
well, the OP did mention a troubleshooting session with the HM support
folks using teamviewer. if they couldn't fix it, well, I dunno how
we're going
On Tuesday, March 15, 2011 9:26:44 am Bruce Momjian wrote:
> Adrian Klaver wrote:
> > On Tuesday, March 15, 2011 9:04:30 am Bruce Momjian wrote:
> > > The larger question is whether these forums should be used to help
> > > people get support for commercial products that embed Postgres.
> >
> > Th
On Tue, Mar 15, 2011 at 11:04 AM, Bruce Momjian wrote:
>
> The larger question is whether these forums should be used to help
> people get support for commercial products that embed Postgres.
I have no particular philosophical objection to helping people using
Holdem Manager -- I'd venture most p
On Tuesday, March 15, 2011 8:50:34 am general_lee wrote:
> Hi Guys,
>
> I'm trying to allow a remote host on our 10.3.55.X network remote access to
> a Postgres Database on the same network.
>
> We're running Solaris 10 with Postgres 83
>
> My postgresql.conf looks like this;
>
>
> listen_addr
Adrian Klaver wrote:
> On Tuesday, March 15, 2011 9:04:30 am Bruce Momjian wrote:
> > The larger question is whether these forums should be used to help
> > people get support for commercial products that embed Postgres.
> >
>
> The eternal Open Source dilemma. Once it is released into the wild
On Mon, Mar 14, 2011 at 9:48 AM, Jo wrote:
> I set the work_mem to 100MB and the shared buffers are 2 GB
>
> The query plans are long and complex. I send the beginning of the
> two plans. Hope this helps to understand the differences.
> I assume the join strategy in 8.3 differs from the one in 8.4
Sorry Alban , For the late update.
Yep John,
I am talking about the tar'ring of pgdatadir only excluding the pg_xlog
dir.
We have set up our full backup system in accordance to the admin guide.
Even the guide puts forward the limitation of tar in producing
distinguishing exit codes.
My doubt
On Tuesday, March 15, 2011 9:04:30 am Bruce Momjian wrote:
> The larger question is whether these forums should be used to help
> people get support for commercial products that embed Postgres.
>
The eternal Open Source dilemma. Once it is released into the wild are we
responsible for it? In a
On 03/15/11 8:50 AM, general_lee wrote:
svcadm restart svc:/application/database/postgresql_83:default_64bit
But I get a "connection refused" if I try and telnet to port 5432 from a
remote host.
firewall?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
Hi Guys,
I'm trying to allow a remote host on our 10.3.55.X network remote access to
a Postgres Database on the same network.
We're running Solaris 10 with Postgres 83
My postgresql.conf looks like this;
listen_addresses = '*' # what IP address(es) to listen on;
On Tuesday, March 15, 2011 9:01:50 am Alphadion wrote:
> Quote: "Is all of this happening locally or is there a remote component?"
>
> I dont know how to define that...
Are HM and the database both on the same machine or is the connection happening
over the network?
--
Adrian Klaver
adrian.kla
Merlin Moncure-2 wrote:
>
> Check your event viewer application log for interesting details.
> Confirm if any postgres processes are running in task manager. Look
> and see if postgres services is installed in service control manager,
> and if it is not running, try and start it.
>
> My money i
The larger question is whether these forums should be used to help
people get support for commercial products that embed Postgres.
---
Alphadion wrote:
> Quote: "Is all of this happening locally or is there a remote componen
I am ready to conclude that the commercial software, Holdem Manager, is
basically trying to farm out their database support to us. However,
Holdem Manager has extensive help topics about getting Postgres working:
http://faq.holdemmanager.com/categories/Frequently+Asked+Questions/Postgre
Quote: "Is all of this happening locally or is there a remote component?"
I dont know how to define that...
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PostgreSQL-for-Holdem-Manager-could-not-be-installed-tp3700954p3708753.html
Sent from the PostgreSQL - general mail
On Tuesday, March 15, 2011 8:55:33 am Alphadion wrote:
> I tried to install any of the versions but it always gives that message
> "Could not connect to the database server, please check port 5432 and
> 127.0.0.1" or something like that. I've opened a range of ports on my
> router's page, and also
On Tue, Mar 15, 2011 at 10:55 AM, Alphadion wrote:
> I tried to install any of the versions but it always gives that message
> "Could not connect to the database server, please check port 5432 and
> 127.0.0.1" or something like that. I've opened a range of ports on my
> router's page, and also op
I tried to install any of the versions but it always gives that message
"Could not connect to the database server, please check port 5432 and
127.0.0.1" or something like that. I've opened a range of ports on my
router's page, and also opened one in my computer through the firewall.
Holdem Manage
test
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Mar 15, 2011 at 10:58:52AM -0400, Tom Lane wrote:
> hubert depesz lubaczewski writes:
> > while I understand it, and will pass this information to client, one
> > thing bugs me - one the problem happens only sometimes, with relatively
> > low count of backends?
> > we saw database running
Hi all,
I am using postgres 9.0 under CentOS 5.5 (Dual Xeon Quad Core @ 2,44 GHz,
64GB RAM, 2TB RAID 5). In my case, postgres is used as a backend for the RDF
store Sesame.
I am trying to store a dataset that consists of approximately 900.000.000
insertions (organized in either 10 tables, or in an
On Tuesday, March 15, 2011 5:09:27 am Alphadion wrote:
> Hi,
>
> I was using Holdem Manager and Postgres database server until a month ago
> when it just stopped. Whatever I did didn't help, incl. a teamviewer
> session with one of the HM administrators.
>
> I've already read and done everything
>
> Please help! I am using Windows 7 64, I've also tried with/without
> firewalls, opened all local ports... Using Nod32 atm and Spybot that runs
> in
> the background, when ununstalled (both of them) postgres doesn' t work
> too
Hi.
I really don't know what a Holdem Manager is, but have yo
hubert depesz lubaczewski writes:
> while I understand it, and will pass this information to client, one
> thing bugs me - one the problem happens only sometimes, with relatively
> low count of backends?
> we saw database running normally with 1200 connections, yet sometimes,
> it has 500 connecti
On Tue, Mar 15, 2011 at 10:20:38AM -0400, Tom Lane wrote:
> hubert depesz lubaczewski writes:
> > On Tue, Mar 15, 2011 at 12:13:21AM -0400, Noah Misch wrote:
> >> What is a typical lifespan for a backend in this system? What sort of
> >> connection pooling are you using, if any?
>
> > quite long
hubert depesz lubaczewski writes:
> On Tue, Mar 15, 2011 at 12:13:21AM -0400, Noah Misch wrote:
>> What is a typical lifespan for a backend in this system? What sort of
>> connection pooling are you using, if any?
> quite long, but:
> we have n (~ 40 i think) web servers. each webserver has it'
Hello everyone
Our system:
Windows Server 2008 R2 Foundation
PostgreSQL 9.0.1 64 bits
Days ago, the following message began to appear in the logs every 50
seconds:
2011-03-15 00:07:06 BRT AVISO: pgstat wait timeout
I searched the mailing lists. but couldn't find any useful information.
Som
Hi,
I was using Holdem Manager and Postgres database server until a month ago
when it just stopped. Whatever I did didn't help, incl. a teamviewer session
with one of the HM administrators.
I've already read and done everything about that in FAQ, forums,net etc. and
nothing helps.
Please help
On Tue, Mar 15, 2011 at 12:54 PM, Raymond O'Donnell wrote:
> On 15/03/2011 11:41, Tore Halvorsen wrote:
>>
>> Who maintains the Slony-version that is accessible from Application
>> Stack Builder on windows?
>
> It's maintained by EnterpriseDB as part of the one-click installers.
Ok, I'll post to
On 15/03/2011 11:41, Tore Halvorsen wrote:
Hi,
Who maintains the Slony-version that is accessible from Application
Stack Builder on windows?
Would be nice to get the version (for pg 8.4) updated to Slony 2.0.6...
It's maintained by EnterpriseDB as part of the one-click installers.
Ray.
--
R
Hi,
Who maintains the Slony-version that is accessible from Application
Stack Builder on windows?
Would be nice to get the version (for pg 8.4) updated to Slony 2.0.6...
--
Eld på åren og sol på eng gjer mannen fegen og fjåg. [Jøtul]
2011 Tore Halvorsen || +052 0553034554
--
Sent via pgsql-g
Thanks alexander
The on_error_rollback setting was exactly the switch I was looking for, thanks.
However I tried to set this setting via the jdbc driver (connection object) or
jdbc properties, but couldnt find a switch to enable this option.
How can i set this setting from my java app?
Regards
On Tue, Mar 15, 2011 at 12:13:21AM -0400, Noah Misch wrote:
> What is a typical lifespan for a backend in this system? What sort of
> connection pooling are you using, if any?
quite long, but:
we have n (~ 40 i think) web servers. each webserver has it's own
pgbouncer (in session pooling).
appl
On 03/15/11 12:30 AM, Alban Hertroys wrote:
On 15 Mar 2011, at 7:46, Alban Hertroys wrote:
On 15 Mar 2011, at 3:06, Rajesh Kumar Mallah wrote:
Dear Friends,
While taking online basebackup we ignore tar exit codes of 1 .
However under certain circumstances tar exits we code '2' which
stands f
On 15 Mar 2011, at 7:46, Alban Hertroys wrote:
> On 15 Mar 2011, at 3:06, Rajesh Kumar Mallah wrote:
>
>> Dear Friends,
>>
>> While taking online basebackup we ignore tar exit codes of 1 .
>> However under certain circumstances tar exits we code '2' which
>> stands for 'Fatal Errors' . Eg in c
81 matches
Mail list logo
