Re: [GENERAL] Transactions, Triggers and Error Messages

Ledina Hido wrote: Thinking about it, the EXCEPTION statement would be inside my user- defined function (where I raise the exception in the first place), so I cannot see how that would help. As far as I could understand, I cannot call "ROLLBACK" (which is what I want to do) inside a user d

Re: [GENERAL] Connect to a database in a .sql file

Assad Jarrahian wrote: Got it. I will be more careful with words. Thanks tom for getting 8.1! one more question. Where does the directory lie for psql (so I can put a .sql file in there and run it) for windows? I'm not familiar with the Windows version, but the psql.exe file should be with al

[GENERAL] PostgreSQL 8.1.0 RPMs are available for download

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 - - PostgreSQL New RPM Set 2005-11-08 Version: 8.1.0 Set labels: 8.1.0-2PGDG - - -

Re: [GENERAL] psql error on quitting...

Jerry LeVan <[EMAIL PROTECTED]> writes: > I just upgraded from 8.0.4 to 8.1.0 this afternoon and the only thing > "bad" I have noticed is that whenever I quit psql I get a message: > could not save history to file "/Users/jerry/.psql_history": Invalid > argument > This is on MacOS X 10.4.3 The P

Re: [GENERAL] clustering by partial indexes

"Keith C. Perry" <[EMAIL PROTECTED]> writes: > This might have been discussed before but I wanted to know if clustering > tables > by partial indexes will be availble in a later release of pgSQL? What in the world would it mean to do that? regards, tom lane -

[GENERAL] psql error on quitting...

Hi, I just upgraded from 8.0.4 to 8.1.0 this afternoon and the only thing "bad" I have noticed is that whenever I quit psql I get a message: could not save history to file "/Users/jerry/.psql_history": Invalid argument This is on MacOS X 10.4.3 Thanks for any info... Jerry ---

[GENERAL] PostgreSQL 8.1.0 Officially Released

8 November 2005, Frankfurt, Germany (OpenDBCon): The PostgreSQL Global Development Group proudly announces the release of PostgreSQL 8.1, further extending PostgreSQL's lead as the most advanced open source database management system. Designed, built, and tested by a large and thriving commu

Re: [GENERAL] psql error on quitting...

Some more info, the history is actually written! ( ' ' seems to be translated to \40 ) Still get the error message... Jerry Subject: psql error on quitting... Hi, I just upgraded from 8.0.4 to 8.1.0 this afternoon and the only thing "bad" I have noticed is that whenever I quit psql I get a

[GENERAL] Transactions, Triggers and Error Messages

Hi, I am trying to use triggers inside transactions to perform some multiplicity checking on the data inserted onto the tables but I am having some problems retrieving the error message. I have two tables declared as follows: > create table pers ( pid int not null primary

[GENERAL] clustering by partial indexes

This might have been discussed before but I wanted to know if clustering tables by partial indexes will be availble in a later release of pgSQL? For the record, this is the error I get in 8.1: iprism=# cluster hrs_idx on report; ERROR: cannot cluster on partial index "hrs_idx" hrs_idx is define

Re: [GENERAL] Transactions, Triggers and Error Messages

On Tue, Nov 08, 2005 at 11:03:50PM +, Ledina Hido wrote:> Quoting Tom Lane <[EMAIL PROTECTED]>:> > > What are you running this in?  ISTM this is a problem with bad  > structure> > of client-side code, not something to be fixed on the server side.> >> >                         regards, tom lane>

Re: [GENERAL] Programmatic method to determine currently installed Windows PostrgreSQL version

Thanks Magnus. Much appreciated. Will --- Magnus Hagander <[EMAIL PROTECTED]> wrote: > > > HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\{317D0ED1 > > > > -8845-40DD-A028-0A3EB8E24F2E} > > > > "Version"="8.1-beta4" > > > > > > > > So it looks like the version number is > underneath > >

Re: [GENERAL] Transactions, Triggers and Error Messages

That's great. Thank you very much for you help.LedinaOn Tue, Nov 08, 2005 at 11:03:50PM +, Ledina Hido wrote:> Quoting Tom Lane <[EMAIL PROTECTED]>:> > > What are you running this in?  ISTM this is a problem with bad  > structure> > of client-side code, not something to be fixed on the server s

Re: [GENERAL] Transactions, Triggers and Error Messages

On Tue, Nov 08, 2005 at 11:03:50PM +, Ledina Hido wrote: > Quoting Tom Lane <[EMAIL PROTECTED]>: > > > What are you running this in? ISTM this is a problem with bad > structure > > of client-side code, not something to be fixed on the server side. > > > > regards, tom la

Re: [GENERAL] Setting max_fsm_pages

On Tue, Nov 08, 2005 at 03:36:40PM -0500, Tom Lane wrote: > Marc Cousin <[EMAIL PROTECTED]> writes: > > If a cluster is restarted, is the fsm forgotten ? > > Given a normal postmaster shutdown, no. In a crash-restart situation, > yes. Does that include restarts due to things like failed asserts

Re: [GENERAL] Beyond the 1600 columns limit on windows

On Tue, Nov 08, 2005 at 02:14:58PM -0500, John D. Burger wrote: > Evandro's mailing lists (Please, don't send personal messages to this > address) wrote: > > >It has nothing to do with normalisation.? It is a program for > >scientific applications. > >Data?values are broken into column to allow

Re: [GENERAL] Transactions, Triggers and Error Messages

Quoting Tom Lane <[EMAIL PROTECTED]>: > What are you running this in? ISTM this is a problem with bad structure > of client-side code, not something to be fixed on the server side. > >regards, tom lane I'm using pgAdmin3. Basically when I run the query the first time it

Re: [GENERAL] Transactions, Triggers and Error Messages

Ledina Hido <[EMAIL PROTECTED]> writes: > Now when I run the following (after inserting person with id=5 into > pers table): > begin; > set constraints all deferred; > insert into tasks (pid, task) values (5, 'firstTask'); > insert into tasks (pid, task) values (5, 'secondTask'); > insert into t

[GENERAL] Transactions, Triggers and Error Messages

Hi all, Sorry for the trouble but I am trying to use triggers inside transactions to perform some multiplicity checking on the data inserted onto the tables but I am having some problems retrieving the error message. I have two tables declared as follows:> create table pers (   

Re: [GENERAL] [HACKERS] Troubles with array_ref

"Cristian Prieto" <[EMAIL PROTECTED]> writes: > Well, anyway, this is the Stored Function I've been workin on; it simply > take an array and an integer just to return this item from the array; The > array could have any kind of elements so I declare it as anyarray (the > parameter) and anyelement (

[GENERAL] Troubles with array_ref

Hi, sorry for the question but I still having serious troubles with the array_ref function. The function is not documented and I can't get a useful example inside the contrib directory. The function is defined as: Datum array_ref(ArrayType *array, int nSubscripts, int *indx, int

Re: [GENERAL] upgrading from backend version 811 to 812

Tom Lane wrote: DETAIL: The database cluster was initialized with PG_CONTROL_VERSION 811, but the server was compiled with PG_CONTROL_VERSION 812. Those are internal version numbers that no one normally ever sees, and certainly no one thinks about. You shouldn't try to outsmart us by referrin

Re: [GENERAL] Perl::DBI and interval syntax

On Nov 8, 2005, at 8:16 AM, Greg Sabino Mullane wrote: This is correct. Though generally not recommeded, you can switch it off with the pg_server_prepare attribute like so: $dbh->{pg_server_prepare} = 0; This will force DBD::Pg to do the quoting itself, with the subsequent penalty of speed

Re: [GENERAL] Connect to a database in a .sql file

Assad Jarrahian wrote: I converted your HTML message to plain text for you. > Where does the directory lie for psql (so I can put a .sql file in > there and run it) for windows? thanks. It's in the bin directory underneath wherever you install PostgreSQL. But you don't need to put your .sql scri

Re: [GENERAL] Connect to a database in a .sql file

On Tue, 2005-11-08 at 07:31, Assad Jarrahian wrote: > Hi, > Lets say the script is called myDBSetup.sql > > And the script contains: > > //CREATE DATABASE section > //CREATE USERS SECTION > //COnnect to db > //CREATE TABLES, FUNCTIONS etc. > > this script will be called from psql. The user w

Re: [GENERAL] autovacuum,8.1, Win

Wes Williams wrote: Correct, the default setting for PostgreSQL 8.1 W32 value in postgresql.conf is 'autovacuum' to 'on'. You can see this and more settings in pgAdmin III by visiting 'Tools', 'Server Configuration', then the config file of your choice. Now, if only I could setup my home to aut

Re: [GENERAL] upgrading from backend version 811 to 812

Alex Mayrhofer <[EMAIL PROTECTED]> writes: > Jim C. Nasby wrote: >> 811? 812? We don't have anything close to those version numbers... > I'm well aware that PostgreSQL itself is currently at 8.1.0 - however, i'm > upgrading from 8.1beta2, and it seems to me that the backend version was > modifie

Re: [GENERAL] Setting max_fsm_pages

Marc Cousin <[EMAIL PROTECTED]> writes: > If a cluster is restarted, is the fsm forgotten ? Given a normal postmaster shutdown, no. In a crash-restart situation, yes. regards, tom lane ---(end of broadcast)--- TIP 1: if pos

Re: [GENERAL] autovacuum,8.1, Win

Correct, the default setting for PostgreSQL 8.1 W32 value in postgresql.conf is 'autovacuum' to 'on'. You can see this and more settings in pgAdmin III by visiting 'Tools', 'Server Configuration', then the config file of your choice. Now, if only I could setup my home to autovaccum. -Origin

Re: [GENERAL] upgrading from backend version 811 to 812

Jim C. Nasby wrote: 811? 812? We don't have anything close to those version numbers... I'm well aware that PostgreSQL itself is currently at 8.1.0 - however, i'm upgrading from 8.1beta2, and it seems to me that the backend version was modified between those two versions - "811" and "812" seem

Re: [GENERAL] autovacuum,8.1, Win

Zlatko Matić wrote: What needs to be configured in order autovacuum process be active? I assume you are talking about the Windows version. If so, and if you used the installer, then you don't need to do anything. It appears (at least on my RC1 install) that autovacuum is enabled by default

Re: [GENERAL] Setting max_fsm_pages

As we're talking about fsm, I've got a question I've been asking myself for some time : If a cluster is restarted, is the fsm forgotten ? (so does it mean one should run a vacuum as soon as the database is restarted ?) Le Dimanche 06 Novembre 2005 03:44, Carlos Oliva a écrit : > Should I set the

Re: [GENERAL] upgrading from backend version 811 to 812

811? 812? We don't have anything close to those version numbers... If you're upgrading to 8.1 you need to dump/reload, unless you're comming from a recent RC or beta. You *might* be able to get away with a simple drop-in upgrade in that case. On Tue, Nov 08, 2005 at 08:25:31PM +0100, Alex Mayrhof

Re: [GENERAL] Best way to use indexes for partial match at beginning

Well, for starters, see if PostgreSQL is currently using any indexes via EXPLAIN. First rule of performance tuning: don't. If it's not (which is probably the case), then your best bet is to create functional indexes; ie: CREATE INDEX mytable__col1_4 ON mytable( substring( col1 for 4 ) ); You can

Re: [GENERAL] autovacuum,8.1, Win

On Tue, Nov 08, 2005 at 10:50:53AM +0100, Zlatko Mati? wrote: > What needs to be configured in order autovacuum process be active? http://www.postgresql.org/docs/8.1/interactive/runtime-config-autovacuum.html -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software

Re: [GENERAL] Beyond the 1600 columns limit on windows

Evandro's mailing lists (Please, don't send personal messages to this address) wrote: It has nothing to do with normalisation.  It is a program for scientific applications. Data values are broken into column to allow multiple linear regression and multivariate regression trees computations.

Re: [GENERAL] Setting max_fsm_pages

You might have to bump up shmmax, but fsm is completely unrelated to shared_buffers. On Mon, Nov 07, 2005 at 02:55:41PM -0500, Carlos Oliva wrote: > Hi Jim, > Thank you for your help. We are going to increase the max_fxm_pages > according to the test I have been running through out the week. > >

[GENERAL] upgrading from backend version 811 to 812

Hi, is there any way to upgrade an 811 backend version cluster to the current 812 version? Any "don't try at home"-type tricks? I'm willing to risk cluster corruption, because this is just a test database (but it is rather large). thanks, alex ---(end of broadca

Re: [GENERAL] Detect Locked Row Without Blocking

I see... For my purposes, I'd still rather notify the user up-front that the record is "in modify" (kind of like FileMaker does)... even though now I understand that a row lock is not the right mechanism for that. Is there a "best-practice" for this approach? What about using a field to flag

Re: [GENERAL] Connect to a database in a .sql file

Got it. I will be more careful with words. Thanks tom for getting 8.1! one more question. Where does the directory lie for psql (so I can put a .sql file in there and run it) for windows? thanks. -assad On 11/8/05, Richard Huxton wrote: Assad Jarrahian wrote:> Sorry, I am a li

Re: [GENERAL] Programmatic method to determine currently installed Windows PostrgreSQL version

> HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\{317D0ED1 > > > -8845-40DD-A028-0A3EB8E24F2E} > > > "Version"="8.1-beta4" > > > > > > So it looks like the version number is underneath > > a key that > > > changes with every new version (new Product > > number). And I > > > am therefore no

Re: [GENERAL] Connect to a database in a .sql file

Assad Jarrahian wrote: Sorry, I am a linux/OS X person. Was working on PGADMIN in windows and thought their query tool was the same as psql. Nope - psql is psql, pgadmin is pgadmin. All the backslash commands are psql-only rather than being part of the backend. Of course, pgadmin can duplicat

Re: [GENERAL] ident client authentication

Paul Hide wrote: Thanks for the reply. Is this right then? For ident to work could I, as Bruno Wolff III suggested, map the apache user to jim using pg_ident. I suppose if I do that it might be rather risky from a security point of view. Since any script running would then run as jim. Or *cou

Re: [GENERAL] Connect to a database in a .sql file

Sorry, I am a linux/OS X person. Was working on PGADMIN in windows and thought their query tool was the same as psql. Just ran the script in psql on my linux box and it worked. My apologies.    Tom, I am not leaping to silly conclusions. Calm down please. We are all trying to learn from people wit

Re: [GENERAL] Beyond the 1600 columns limit on windows

Evandro's mailing lists (Please, don't send personal messages to this address) wrote: Sorry, It has nothing to do with normalisation. It is a program for scientific applications. It has everything to do with normalisation. You appear to be pushing application presentation issues into the stru

Re: [GENERAL] Beyond the 1600 columns limit on windows

> >>> > >>>Well this screams random arbitrary limit to me. Why does this limit > >>>exist? What ever happened to the holy 0,1,infinity triumvirate? > >>> > >> > >>I guess it eases implementation and there is no reason to go so high > >>on columns either. The limit could even be lower w/o and hurts

Re: [GENERAL] ident client authentication

On Tue, Nov 08, 2005 at 17:18:32 +, Paul Hide <[EMAIL PROTECTED]> wrote: > Many thanks for your reply. > > The web server runs as what/whoever it does by default. I haven't changed > it. > > I understand what you are getting at, because Richard Huxton pointed out to > me that the script is

Re: [GENERAL] Programmatic method to determine currently installed Windows PostrgreSQL version

Thanks Richard, I will look into whether or not I will have access to the SELECT statement. Regards, Will --- Richard Huxton wrote: > Will Wright wrote: > > > > Hi Magnus, thanks for the quick response. > > Unfortunately I still have an issue with this > regsitry > > identification method bec

Re: [GENERAL] ident client authentication

Thanks for the reply. Is this right then? For ident to work could I, as Bruno Wolff III suggested, map the apache user to jim using pg_ident. I suppose if I do that it might be rather risky from a security point of view. Since any script running would then run as jim. Perhaps I shoulkd do as you

Re: [GENERAL] [ANNOUNCE] PostgreSQL 8.1.0 Release Candidate 1

Can I be removed from this mailing list. Thanks Gerard -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc G. Fournier Sent: 31 October 2005 04:48 To: pgsql-announce@postgresql.org Cc: pgsql-general@postgresql.org Subject: [ANNOUNCE] PostgreSQL 8.1.0

Re: [GENERAL] ident client authentication

Many thanks for your reply. The web  server runs as what/whoever it does by default. I haven't changed it. I understand what you are getting at, because Richard Huxton pointed out to me that the script is probably running as the web server user. The script runs as 'apache' (let us say), the conn

[GENERAL] Number of items in a cursor...

Is there any way to get the numbers of items inside a cursor?   ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Beyond the 1600 columns limit on windows

Sorry,   It has nothing to do with normalisation.  It is a program for scientific applications. Data values are broken into column to allow multiple linear regression and multivariate regression trees computations.   Even SPSS the most well-known statistic sw uses the same approach and data structu

Re: [GENERAL] Beyond the 1600 columns limit on windows

On 8 Nov 2005, at 16:06, Scott Marlowe wrote: On Tue, 2005-11-08 at 09:45, Tino Wildenhain wrote: Alex Stapleton schrieb: On 8 Nov 2005, at 12:50, Tino Wildenhain wrote: Evandro's mailing lists (Please, don't send personal messages to this address) schrieb: Hi guys, I would like

Re: [GENERAL] Perl::DBI and interval syntax [side question]

Tom Lane wrote: > MaXX <[EMAIL PROTECTED]> writes: >> Can this be the cause of a huge loss of perf? I have the following query >> in a Perl script using DBI + DBD::Pg, AutoCommit => 0: >> SELECT stats_put_sources(?, ?, int4(?), int4(?)) >> This syntax runs almost 10x faster than: >> SELECT stats_p

Re: [GENERAL] Beyond the 1600 columns limit on windows

On 8 Nov 2005, at 12:50, Tino Wildenhain wrote: Evandro's mailing lists (Please, don't send personal messages to this address) schrieb: Hi guys, I would like to know if it is possible to have more than 1600 columns on windows without recompiling postgres. I would like to know who on

Re: [GENERAL] Beyond the 1600 columns limit on windows

> "Evandro's" == Evandro's mailing lists (Please, don't send personal > messages to this address) <[EMAIL PROTECTED]> writes: [I would have replied to your personal address, but I'm not about to copy it from a footer.] Evandro's> I'm doing a PhD in data mining and I need more than 1600 c

Re: [GENERAL] odbc in postgresql and php

ODBC has nothing to do with this -- you compile postgreSQL support directly into PHP when you configure PHP just before the install...   ./Configure --with-postgres --without-mysql     After that -- you need to join a PHP newsgroup for PHP questions     ""Bob Powell"" <[EMAIL PROTECT

Re: [GENERAL] Beyond the 1600 columns limit on windows

On Tue, 2005-11-08 at 09:45, Tino Wildenhain wrote: > Alex Stapleton schrieb: > > > > On 8 Nov 2005, at 12:50, Tino Wildenhain wrote: > > > >> Evandro's mailing lists (Please, don't send personal messages to this > >> address) schrieb: > >> > >>> Hi guys, > >>> I would like to know if it is po

Re: [GENERAL] Beyond the 1600 columns limit on windows

Tino Wildenhain <[EMAIL PROTECTED]> writes: > Alex Stapleton schrieb: >> Well this screams random arbitrary limit to me. Why does this limit >> exist? What ever happened to the holy 0,1,infinity triumvirate? > I guess it eases implementation and there is no reason to go so high > on columns eith

Re: [GENERAL] Beyond the 1600 columns limit on windows

Alex Stapleton schrieb: On 8 Nov 2005, at 12:50, Tino Wildenhain wrote: Evandro's mailing lists (Please, don't send personal messages to this address) schrieb: Hi guys, I would like to know if it is possible to have more than 1600 columns on windows without recompiling postgres. I w

Re: [GENERAL] Beyond the 1600 columns limit on windows

Evandro's mailing lists (Please, don't send personal messages to this address) schrieb: I'm doing a PhD in data mining and I need more than 1600 columns. I got an error message saying that I can not use more than 1600 columns. It is happening because I have to change categorical values to bina

Re: [GENERAL] Detect Locked Row Without Blocking

Joe Lester <[EMAIL PROTECTED]> writes: > Is there a recommended "postgres way" to determine if a certain row is > locked... without blocking? 8.1 has a SELECT FOR UPDATE NOWAIT option. Alternatively, just do a wait while having a very short statement_timeout. > In my custom postgres client app

Re: [GENERAL] Beyond the 1600 columns limit on windows

"Evandro's mailing lists (Please, don't send personal messages to this address)" <[EMAIL PROTECTED]> writes: > I'm doing a PhD in data mining and I need more than 1600 columns. I don't think so --- consider redesigning your data model instead. For instance, maybe you could combine similar columns

Re: [GENERAL] Perl::DBI and interval syntax [side question]

MaXX <[EMAIL PROTECTED]> writes: > Can this be the cause of a huge loss of perf? I have the following query in > a Perl script using DBI + DBD::Pg, AutoCommit => 0: > SELECT stats_put_sources(?, ?, int4(?), int4(?)) > This syntax runs almost 10x faster than: > SELECT stats_put_sources(?, ?, ?::int4

Re: [GENERAL] Connect to a database in a .sql file

Assad Jarrahian wrote: \c does not work in .sql script run in psql. That sounds unlikely. What sort of error message are you getting? -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please s

[GENERAL] Detect Locked Row Without Blocking

Is there a recommended "postgres way" to determine if a certain row is locked... without blocking? In my custom postgres client app I'd like to be able to determine if another user is "modifying" a given record. If so, I would present a dialog to the user such as "Record Locked. Sam Smith is a

Re: [GENERAL] Connect to a database in a .sql file

Assad Jarrahian <[EMAIL PROTECTED]> writes: > \c does not work in .sql script run in psql. Nonsense. Try it again, and show us exactly what you did and what message you got, rather than leaping to silly conclusions. regards, tom lane ---(end of br

Re: [GENERAL] Beyond the 1600 columns limit on windows

Evandro's mailing lists (Please, don't send personal messages to this address) wrote: I'm doing a PhD in data mining and I need more than 1600 columns. I got an error message saying that I can not use more than 1600 columns. It is happening because I have to change categorical values to binary c

[GENERAL] WinXP - statistics collector errors

Hello, In my log files I have an error that occurs frequently : FATAL: could not read from statistics collector pipe and FATAL: could not write to statistics collector pipe: No connection could be made because the target machine actively refused it. The server release is 8.0.3 and is running o

Re: [GENERAL] database export problem

On Nov 8, 2005, at 19:13 , Shu Hung (Koala) wrote: I am in a strange trouble: I cannot export database in by postgres Postgres version - 7.2.3 Database in it: List of databases Name| Owner | Encoding ---+--+-- database | nsadmin | UNICODE template0

Re: [GENERAL] ident client authentication

On Tue, Nov 08, 2005 at 10:02:14 +, Paul Hide <[EMAIL PROTECTED]> wrote: > I have a problem with ident client authentication. > My server is debian sarge, pg version is 7.4.7, apache 2.0.54, mod_python > 2.3. A python script is placed on the server and runs under mod_python in > apache. > >

Re: [GENERAL] Perl::DBI and interval syntax

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > This seems to be an example of breakage caused by DBI switching from > "substitute params in client" to "use new protocol to substitute params > in server" (prepare/execute). > > AIUI, if you disable use of the new protocol, it should work as befor

Re: [GENERAL] Beyond the 1600 columns limit on windows

I'm doing a PhD in data mining and I need more than 1600 columns. I got an error message saying that I can not use more than 1600 columns.   It is happening because I have to change categorical values to binary creating new columns. Do you know if oracle can handle it?      -- Evandro M Leite Jr. P

[GENERAL] autovacuum,8.1, Win

What needs to be configured in order autovacuum process be active?

Re: [GENERAL] Perl::DBI and interval syntax [side question]

Martijn van Oosterhout wrote: > On Mon, Nov 07, 2005 at 05:58:04PM -0500, Tom Lane wrote: >> Allen <[EMAIL PROTECTED]> writes: >> > SELECT count(*) from post where post_ts >= current_date - interval ? >> This is not right, and never has been right, even though it may have >> accidentally failed to

[GENERAL] database export problem

Hello,I am in a strange trouble: I cannot export database in by postgresPostgres version - 7.2.3Database in it:    List of databases    Name    |  Owner   | Encoding ---+--+-- database  | nsadmin  | UNICODE  template0 | postgres | UNICODE template1 | postgres | UNICODE

Re: [GENERAL] Beyond the 1600 columns limit on windows

Evandro's mailing lists (Please, don't send personal messages to this address) schrieb: Hi guys, I would like to know if it is possible to have more than 1600 columns on windows without recompiling postgres. I would like to know who on earth needs 1600 columns and even beyond? Hint: you can

Re: [GENERAL] Beyond the 1600 columns limit on windows

Evandro's mailing lists (Please, don't send personal messages to this address) wrote: Hi guys, I would like to know if it is possible to have more than 1600 columns on windows without recompiling postgres. I don't think so. Are you sure you need more than 1600 columns? That's many more than I

Re: [GENERAL] Aggregates, group, and order by

On Nov 7, 2005, at 17:47 , David Fetter wrote: On Mon, Nov 07, 2005 at 05:12:05PM +0900, Michael Glaesmann wrote: I'm trying to concatenate strings in variable orders using a custom aggregate. However, I'm having a difficult time figuring out the SQL I need to use to accomplish this. How ab

[GENERAL] Beyond the 1600 columns limit on windows

Hi guys,   I would like to know if it is possible to have more than 1600 columns on windows without recompiling postgres.   Regards -Evandro-- Evandro M Leite JrPhD Student & Software developerUniversity of Southampton, UKPersonal website: http://evandro.orgAcademic website: http://www.soton.ac.uk

Re: [GENERAL] ident client authentication

Paul Hide wrote: I have a problem with ident client authentication. My server is debian sarge, pg version is 7.4.7, apache 2.0.54, mod_python 2.3. A python script is placed on the server and runs under mod_python in apache. However, if i have local all jim ident sameuser I get FATAL: IDENT aut

[GENERAL] ident client authentication

I have a problem with ident client authentication. My server is debian sarge, pg version is 7.4.7, apache 2.0.54, mod_python 2.3. A python script is placed on the server and runs under mod_python in apache. I make a request from firefox on a win 2k box to this server. If I have local  all  jim  tr

Re: [GENERAL] Perl::DBI and interval syntax

On Mon, Nov 07, 2005 at 05:58:04PM -0500, Tom Lane wrote: > Allen <[EMAIL PROTECTED]> writes: > > SELECT count(*) from post where post_ts >= current_date - interval ? > > This is not right, and never has been right, even though it may have > accidentally failed to fail with some client libraries.

[GENERAL] unsubscribe

Ramachandran.Chidambram 91(422)2496638 (Coimbatore.Res) 91(4923)262362 (Kollengode.Res) 91(4923)275576 (Kollengode.Works) Check Out the new free AIM(R) Mail -- 2 GB of storage and industry-leading spam and email virus pro

Re: [GENERAL] odbc in postgresql and php

Bob Powell wrote: Hello everyone, Has anyone installed the postgres php driver. I would like to know how to install it on Linux and then what the proper way to access it is from a php web page. I have been unable to find actual code for php and doing this. Please help. Thanks. Almost

Re: [GENERAL] Programmatic method to determine currently installed

Will Wright wrote: Hi Magnus, thanks for the quick response. Unfortunately I still have an issue with this regsitry identification method because I'd like to code my installer so that it can also identify the postreSQL versions that were not available at the time I authored my install check, i