Hello,Today in our logs we received the following exception:Exception Message: EvaluateExpression failed: update category_product set product_is_active = p.is_active, product_status_code = p.status_code from product p where category_product.product_id = p.product_id and category_id = 1001415;Next
i did ps -aef | grep postmaster and i saw :
surabi 31787 28525 0 Apr24 pts/20 00:00:00
/usr/local/pgsql/bin/postmaster -D /homes/surabi/data/postgres
6603 1 0 01:42
? 00:00:00 /usr/bin/postmaster -p 5432
-D /var/lib/pgsql/datapostgres 10887 10638 0 11:39 pts/17
00:00:00
And all would be postgres or postgresql instead of "postgre? "
On 4/24/06, Richard Huxton wrote:
karthick muthu wrote:> hello guys,> what do u think about the near future of postgre?
Version 8.2 will be going into beta and then released. Details ofchanges already confirmed can be
On 24 Apr 2006 12:49:51 -0700, SunWuKung <[EMAIL PROTECTED]> wrote:
> I was trying to actually do a cast and trap the error but (beside not
> having succeeded in doing so) this is a much nicer way.
>
> Thanks.
> Balázs
>
>
in 8.1 you can use exception blocks
BEGIN
statements
EXCEPTION
WHE
After a long battle with technology, "Qingqing Zhou" <[EMAIL PROTECTED]>, an
earthling, wrote:
> ""Jim C. Nasby"" <[EMAIL PROTECTED]> wrote
>> On Mon, Apr 24, 2006 at 06:16:30PM +0800, Qingqing Zhou wrote:
>> > Is it possible to have a superuser who could do CHECKPOINT, BACKUP and
>> > whatever bu
Qingqing Zhou wrote:
>Basically I wonder if I can have a superuer that he has every priviliges as
>he does now (create language, rotate log files, create checkpoint and
>everything superuser can do) but one thing I want to make sure is that he
>could not see any user data for security reason (just
On Apr 24, 2006, at 6:31 PM, Qingqing Zhou wrote:
""Jim C. Nasby"" <[EMAIL PROTECTED]> wrote
On Mon, Apr 24, 2006 at 06:16:30PM +0800, Qingqing Zhou wrote:
Is it possible to have a superuser who could do CHECKPOINT,
BACKUP and
whatever but could not see any user data?
Not for backup. It'
On Tue, Apr 25, 2006 at 09:31:48AM +0800, Qingqing Zhou wrote:
>
> ""Jim C. Nasby"" <[EMAIL PROTECTED]> wrote
> > On Mon, Apr 24, 2006 at 06:16:30PM +0800, Qingqing Zhou wrote:
> > > Is it possible to have a superuser who could do CHECKPOINT, BACKUP and
> > > whatever but could not see any user da
"Andrus" <[EMAIL PROTECTED]> writes:
> My ODBC client uses single connection to Postgres 8.1.3 server in W2K
> In case of TCP error it closes connection and re-opens it.
> ...
> Is it possible to force postgres to close dead connections immediately, not
> after 6 hours ?
PG *will* close the conne
"Qingqing Zhou" <[EMAIL PROTECTED]> writes:
> Basically I wonder if I can have a superuer that he has every priviliges as
> he does now (create language, rotate log files, create checkpoint and
> everything superuser can do) but one thing I want to make sure is that he
> could not see any user data
""Jim C. Nasby"" <[EMAIL PROTECTED]> wrote
> On Mon, Apr 24, 2006 at 06:16:30PM +0800, Qingqing Zhou wrote:
> > Is it possible to have a superuser who could do CHECKPOINT, BACKUP and
> > whatever but could not see any user data?
>
> Not for backup. It'd be rather tricky to allow backing up data wi
Shane Ambler <[EMAIL PROTECTED]> writes:
> On 25/4/2006 6:47, "Tom Lane" <[EMAIL PROTECTED]> wrote:
>> Actually that's a misstatement --- AFAIK, Stonebraker and crew started
>> from scratch when they wrote Postgres,
> Bruce Momjiam say's "PostgreSQL's ancestor was Ingres" but I haven't found
> any
On Mon, Apr 24, 2006 at 07:15:12PM -0400, Bruce Momjian wrote:
> Jim C. Nasby wrote:
> > Some food for thought: http://sql-info.de/mysql/gotchas.html
> >
> > Something else to consider is that there's a number of options open to
> > you for getting commercial PostgreSQL support should you want it.
Jim C. Nasby wrote:
> Some food for thought: http://sql-info.de/mysql/gotchas.html
>
> Something else to consider is that there's a number of options open to
> you for getting commercial PostgreSQL support should you want it. AFAIK
> you're pretty much limited to Sybase or MySQL when it comes to s
On Mon, Apr 24, 2006 at 06:16:30PM +0800, Qingqing Zhou wrote:
> Is it possible to have a superuser who could do CHECKPOINT, BACKUP and
> whatever but could not see any user data?
Not for backup. It'd be rather tricky to allow backing up data without
being able to read it, afterall.
I believe CHE
Some food for thought: http://sql-info.de/mysql/gotchas.html
Something else to consider is that there's a number of options open to
you for getting commercial PostgreSQL support should you want it. AFAIK
you're pretty much limited to Sybase or MySQL when it comes to support
for their products. Plu
Bruce Momjiam say's "PostgreSQL's ancestor was Ingres" but I haven't found
anything concrete one way or the other on whether Postgres started from
scratch or from Ingres code
(the name comes from 'post' 'gres' - after Ingres)
My understanding is that we started from Ingres in the sense that we
David,
It appears that the problem is related to the
fact that MacOSX does not really use the libreadline
(checks and you will see that it is a symlink to
libedit.)
I asked this question a year or so ago and Tom
Lane said that when the history file was closed
that the libedit did not return the
On 25/4/2006 6:47, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Shane Ambler <[EMAIL PROTECTED]> writes:
>> If you look at the history of PostgreSQL you will find that the development
>> at Berkley started with Ingres and after the code was used to start
>> Relational Technologies/Ingres Corporation th
Shane Ambler <[EMAIL PROTECTED]> writes:
> If you look at the history of PostgreSQL you will find that the development
> at Berkley started with Ingres and after the code was used to start
> Relational Technologies/Ingres Corporation the Postgres project was born.
> A later version of Postgres was
2006/4/24, Dany De Bontridder <[EMAIL PROTECTED]>:
> and the "select count(*)" will be able to use index scan (faster) (in version
> 8.1 ?)
No, it won't.
--
Nicolas Barbier
http://www.gnu.org/philosophy/no-word-attachments.html
---(end of broadcast)-
Cool. I knew ADO could do transactions on Access's JET database
engine, but didn't know they could do so on another RDBMS like
PostgreSQL. So basically I can use the BeginTrans and CommitTrans to
do the work of PostgreSQL's BEGIN; and COMMIT;
On a adjacent topic, how does PostgreSQL know that Be
> > redirect_stderr = true
> > log_directory = 'pg_log'
> > log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
> > log_rotation_size = 10240
> > log_min_messages = info
> > log_line_prefix = '%t%%%d '
> >
> > These are the setting in my conf file.
>
> [EMAIL PROTECTED] root]# tail /var/log/pgsqll
On Monday 24 April 2006 10:43, Richard Huxton wrote:
(...)
> Do these two not solve your problem?
I knew those solutions, I was looking for a new one ;-) Because the " open in
execute" forces you to scan the whole table, that's what I wish to avoid, and
the "select count(*)" will be able to use i
On 24/4/2006 16:59, "IvoD" <[EMAIL PROTECTED]> wrote:
> For the first app I wanted to use MySQL, for the second one I wanted
> the Sybase SQL Anywhere. But now I am in doubt. I'm playing with the
> idea to substitute the Sybase SQL Anywhere by the PostgreSQL or MySQL.
> I need all the SQL decoratio
I was trying to actually do a cast and trap the error but (beside not
having succeeded in doing so) this is a much nicer way.
Thanks.
Balázs
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscr
On Mon, Apr 24, 2006 at 08:52:14AM -0700, P G wrote:
> I have recently switched to Kubuntu and I just installed Postgres on it. The
> installation was successful.
>
> When I try psql, I get this error message, though:
>
> % psql postgres
> Error: You must install at least one postgresql-client-
If you look through this mailing list, the PostgreSQL website, and Google
reviews of PostgreSQL, I think you will gain a very positive appreciation of
PostgreSQL. It is stable, robust, and well-supported. It is being
used in many mission-critical applications. Most recently, I've seen
me
P G <[EMAIL PROTECTED]> writes:
> Hello,
>
> I am hoping this is the right place.
>
> I have recently switched to Kubuntu and I just installed Postgres on it. The
> installation was successful.
>
> When I try psql, I get this error message, though:
>
> % psql postgres
> Error: You must install at
P G wrote:
Hello,
I am hoping this is the right place.
I have recently switched to Kubuntu and I just installed Postgres on
it. The installation was successful.
When I try psql, I get this error message, though:
% psql postgres
Error: You must install at least one postgresql-client- packag
karthick muthu wrote:
hello guys,
what do u think about the near future of postgre?
Version 8.2 will be going into beta and then released. Details of
changes already confirmed can be found in the TODO linked from here:
http://www.postgresql.org/developer/roadmap
what is the latest version o
On Sat, Apr 22, 2006 at 07:51:19PM -0700, Richard Broersma Jr wrote:
> > Is whitespace important? Tabs? The number of spaces?
> > Ohhhkyyy... so, what settings would be needed to get usable logs?
> > Set everything that has "log" in the name to "true"?
>
> --postgresql.conf
>
> redirect_std
On 24/4/2006 16:42, "karthick muthu" <[EMAIL PROTECTED]> wrote:
> hello guys,
> what do u think about the near future of postgre?
I think the near and distant future looks good.
> what is the latest version of postgre? and how it differ from the oldone?
Latest version is 8.1.3
The best place to
Hello,I am hoping this is the right place.I have recently switched to Kubuntu and I just installed Postgres on it. The installation was successful.When I try psql, I get this error message, though:% psql postgresError: You must install at least one postgresql-client- package.But I have installed p
On Mon, Apr 24, 2006 at 12:42:43 +0530,
karthick muthu <[EMAIL PROTECTED]> wrote:
> hello guys,
> what do u think about the near future of postgre?
Can you be more specific?
You can see some of the TODO items that have been done for 8.2 at:
http://www.postgresql.org/docs/faqs.TODO.html
Note that
On Sun, Apr 23, 2006 at 09:33:40PM -0400, David F. Johnson wrote:
> Greetings.
>
> Any ideas on how to resolve this problem:
> test=# \q
> could not save history to file "/usr/local/pgsql//.psql_history": Permission
> denied
I don't know about the platform, but shouldn't that refer to your hom
Hi,
does anyone know a good opensource tool to do datawarehousing,
(instead of having to manage an mssql server and so on,
so just sticking to postgres or another good os-db.)
it is client and serverside.
tnx,
---(end of broadcast)---
TIP 2: D
On Mon, Apr 24, 2006 at 05:31:46AM -0700, SunWuKung wrote:
> I am writing a pgsql function and I would need to create a condition
> based on the value of a text variable. I would need to check if
> text_var is convertable to numeric type and if yes do the conversion,
> if no do something else. I co
Hello all,
I created two web database applications - first one is the company news
system (as part of the company web pages), second one is the company
main data system (part of the company pages, too). All (unfortunately)
the M$ environment - 2003 server.
The first app is managed from the web in
2006/4/24, karthick muthu <[EMAIL PROTECTED]>:
> what do u think about the near future of postgre?
http://stoned.homeunix.org/~itsme/postgre/>
Apart from that, I think it will be bright :-).
> what is the latest version of postgre? and how it differ from the oldone?
http://www.postgresql.org/d
Karen Hill wrote:
>>From Access I'd like to run pass the following from MS Access to
> PostgreSQL 8.1 using VBA:
>
> BEGIN;
> UPDATE accounts SET balance = balance + 100.00 WHERE acctnum = 12345;
> UPDATE accounts SET balance = balance - 100.00 WHERE acctnum = 7534;
> COMMIT;
>
> It won't let me
Dany De Bontridder wrote:
If you have a look to the following code, I'm trying to work around
the limitation about execute, which doesn't accept "select into".
http://www.postgresql.org/docs/8.0/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
The results from SELECT commands
am 24.04.2006, um 12:42:43 +0530 mailte karthick muthu folgendes:
> hello guys,
> what do u think about the near future of postgre?
http://www.postgresql.org/about/
> what is the latest version of postgre? and how it differ from the oldone?
http://www.postgresql.org/ -> latest releases and
ht
Hello,
This is in regards to the FAQ 3.7 "When upgrading the installer says I
don't have permissions to install a service, but I'm logged in as
administrator". To fix the problem, I did,
sc stop pgsql-8.0
sc delete pgsql-8.0
After the installation was completed, the service failed to start
Greetings.
Any ideas on how to resolve this problem:
==
Welcome to psql 8.1.3, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
Florian G. Pflug wrote:
Do you see any other way via which I could archive my desired result?
(Apart from modifying every client in existence)
Could you modify pgpool to act as a wrapper for this?
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
Just a little followup on this problem.
We've moved the database to another server where it ran without problems.
HP just released new raid controller drivers for Suse and a firmware
update for the controller itself.
Until now the problem hasn't occurred anymore.
Thanks!
Jo.
Chris Travers w
My ODBC client uses single connection to Postgres 8.1.3 server in W2K
In case of TCP error it closes connection and re-opens it.
Unfortunately, in server status window I see a number of connections from
same IP address.
In log file I have lines like
2006-04-24 01:24:41 oksana 188.16.34.194 idle
Stephan Szabo wrote:
On Fri, 21 Apr 2006, Alban Hertroys wrote:
Stephan Szabo wrote:
SQL> CREATE TABLE ltree_test (path ltree PRIMARY KEY REFERENCES
ltree_test(path));
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"ltree_test_pkey" for table "ltree_test"
CREATE TABLE
SQL> INSE
On 2006-04-24, Andrus <[EMAIL PROTECTED]> wrote:
> After some time of working, Postgres 8.1.3 on W2K creates large a number of
> empty schemas in my database.
>
> Those schemas are named pg_temp_1 .. pg_temp_13 (some names are missing in
> sequence).
This is normal. The number of temp schemas cr
Hello Martijin,
I have one more doudt ..while building libpq.so we are not specifying
--enable-thread-safety
Will it make any difference..?
Thx,
Prasanna.
-Original Message-
From: Mavinakuli, Prasanna (STSD)
Sent: Friday, April 21, 2006 5:46 PM
To: 'Martijn van Oosterhout'
Subject:
I am writing a pgsql function and I would need to create a condition
based on the value of a text variable. I would need to check if
text_var is convertable to numeric type and if yes do the conversion,
if no do something else. I couldn't find out how to do that.
Something like:
IF isnumeric(text_
After some time of working, Postgres 8.1.3 on W2K creates large a number of
empty schemas in my database.
Those schemas are named pg_temp_1 .. pg_temp_13 (some names are missing in
sequence).
Some of them do not contain any objects. Some contain temp tables created by
my application.
Is it saf
Is it possible to have a superuser who could do CHECKPOINT, BACKUP and
whatever but could not see any user data?
Regards,
Qingqing
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
hello guys,
what do u think about the near future of postgre?
what is the latest version of postgre? and how it differ from the oldone?
who is the leading person on postgre?
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
55 matches
Mail list logo