[GENERAL] to know

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

[GENERAL] How to have a blind-superuser

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

[GENERAL] How to avoid empty temp schemas

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

[GENERAL] isnumeric - checking if text variable is convertable to numeric

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_

Re: [GENERAL] HUGE Stack space is gettiing consumed

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:

Re: [GENERAL] How to avoid empty temp schemas

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

Re: [GENERAL] A few questions about ltree

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

[GENERAL] How to close dead connections immediately

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

Re: [GENERAL] invalid page header

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

Re: [GENERAL] Automatically assuming a specific role after connecting

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)---

[GENERAL] "save history" problem

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

[GENERAL] Upgrade of Windows MSI installations (version 8.0)

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

Re: [GENERAL] to know

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

Re: [GENERAL] Postgreql 8.0.3 temporary Table Strange behaviour

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

Re: [GENERAL] Transactions, PostgreSQL and MS Access front end.

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

Re: [GENERAL] to know

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

[GENERAL] Database Selection

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

Re: [GENERAL] isnumeric - checking if text variable is convertable to numeric

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

[GENERAL] DatawareHousing

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

Re: [GENERAL] "save history" problem

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

Re: [GENERAL] to know

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

[GENERAL] Install issue on Kubuntu

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

Re: [GENERAL] to know

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

Re: [GENERAL] Problems logging in

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

Re: [GENERAL] to know

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

Re: [GENERAL] Install issue on Kubuntu

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

Re: [GENERAL] Install issue on Kubuntu

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

Re: [GENERAL] Database Selection

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

Re: [GENERAL] Install issue on Kubuntu

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-

Re: [GENERAL] isnumeric - checking if text variable is convertable to numeric

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

Re: [GENERAL] Database Selection

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

Re: [GENERAL] Postgreql 8.0.3 temporary Table Strange behaviour

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

Re: [GENERAL] Problems logging in

> > 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

Re: [GENERAL] Transactions, PostgreSQL and MS Access front end.

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

Re: [GENERAL] Postgreql 8.0.3 temporary Table Strange behaviour

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)-

Re: [GENERAL] Database Selection

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

Re: [GENERAL] Database Selection

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

Re: [GENERAL] "save history" problem

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

Re: [GENERAL] Database Selection

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

Re: [GENERAL] Database Selection

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

Re: [GENERAL] How to have a blind-superuser

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

Re: [GENERAL] Database Selection

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

Re: [GENERAL] Database Selection

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.

Re: [GENERAL] Database Selection

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

Re: [GENERAL] How to have a blind-superuser

""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

Re: [GENERAL] How to have a blind-superuser

"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

Re: [GENERAL] How to close dead connections immediately

"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

Re: [GENERAL] How to have a blind-superuser

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

Re: [GENERAL] How to have a blind-superuser

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'

Re: [GENERAL] How to have a blind-superuser

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

Re: [GENERAL] How to have a blind-superuser

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

Re: [GENERAL] isnumeric - checking if text variable is convertable to numeric

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

Re: [GENERAL] to know

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

[GENERAL] remove another version of postgreSQL

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

[GENERAL] invalid memory alloc request size 1684370054

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