Re: [GENERAL] Postresql RFD version 2.0 Help Wanted.

2004-11-13 Thread Brian {Hamilton Kelly}
ferent to mailing one person (as, sadly, can often be observed when mailing list participants use nasty habits picked up from using Outlook Express in inter-office memoranda). [1] Except, of course, where the poster uses X-No-Archive: Yes -- Brian {Hamilton Kelly}

Re: [GENERAL] I spoke with Marc from the postgresql mailing list.

2004-11-16 Thread Brian {Hamilton Kelly}
On Monday, in article <[EMAIL PROTECTED]> [EMAIL PROTECTED] "Tim Skirvin" wrote: > [EMAIL PROTECTED] (Brian {Hamilton Kelly}) writes: > > >(Personally, I blame the original authors of Netscape for incorporating a > >news "reader" that could

Re: [GENERAL] 3rd RFD: comp.databases.postgresql (was: comp.databases.postgresql.*)

2004-12-06 Thread Brian {Hamilton Kelly}
y that it was the best or the worst, only > the most straightforward. It doesn't address the question of what > happens if the czar disappears, for instance. Seventy-five years' rule by Soviet? -- Brian {Hamilton Kelly} [EMAIL PROTECTED]

Re: [GENERAL] psql(18967) malloc: *** vm_allocate(size=8421376)

2006-01-23 Thread Brian A. Seklecki
What about upping ulimt(3) via ulimit(1) in builtin(1) -- assuming you're running Bash. ~BAS On Mon, 9 Jan 2006, Ari Kahn wrote: I'm doing a query that really should be too taxing. But when I execute it I get the following error(s): psql(18967) malloc: *** vm_allocate(size=8421376) faile

Re: [GENERAL] Backup and Restore mechanism in Postgres

2006-01-24 Thread Brian A. Seklecki
On Tue, 20 Sep 2005, Lincoln Yeoh wrote: At 10:00 AM 9/20/2005 -0400, Vivek Khera wrote: On Sep 14, 2005, at 9:45 AM, vinita bansal wrote: I have a 4 proc. AMD Opteron machine with 32 GB RAM and ~400GB HDD Just curious what ever came of this? Also, were you reading the DB and writing the

Re: [GENERAL] Date Comparison Help

2004-04-09 Thread Brian C. Doyle
Perfect and thank you so much for the swift response; At 04:23 PM 4/8/2004, Mike Nolan wrote: > I need a query to get data that is 6 months older than "today" or when that > query is run. WHERE table.date < current_date-interval'6 months' -- Mike Nolan

[GENERAL] Postgres and C/C++

2001-07-08 Thread Brian C. Doyle
Hello all, Where would I find examples of some C files that connect to a postgresql db I am just starting out with c and know Postgresql rather well and have done a lot of development with PHP. So I need to know what else do I need to write a C program that will connect to a database in Pos

[GENERAL] Custom Insert function

2001-09-20 Thread Brian C. Doyle
Hello all, Is it possible to create a function that would look like this_function('file.csv'); and make it run COPY this_table FROM '/this/location/file.csv' USING DELIMITERS ','; Thus eliminating alot of repeated work each time??? if so what would I put on the returns --

[GENERAL] Function Help

2001-09-24 Thread Brian C. Doyle
Hello all, I am working on a function to determine the date of the first saturday of the month. Currently I have: CREATE FUNCTION first_saturday(date) RETURNS date AS ' Select CASE WHEN date_part(\'dow\',\'$1\'::DATE)=0 THEN date(\'$1\')+6 WHEN date_part(\'dow\',\'$1\'::DATE)=1 THEN date(\'$1\

[GENERAL] Perl and Postgres

2001-09-26 Thread Brian C. Doyle
Hello all, Where can I look to find out more about developing a web based interface via Perl.. Currently I do it all via PHP but do to resources available for a project I have I need to convert over to perl.. I check the Postgres Doc's and there were no examples to help get me started. Any th

[GENERAL] Function Help

2001-09-27 Thread Brian C. Doyle
DATE)=4 THEN date(\'$1\')+2 WHEN date_part(\'dow\',\'$1\'::DATE)=5 THEN date(\'$1\')+1 WHEN date_part(\'dow\',\'$1\'::DATE)=6 THEN date(\'$1\')+0 END'LANGUAGE 'sql' I get an error that $1 is not a

Re: [GENERAL] Function Help

2001-09-24 Thread Brian C. Doyle
That was it... I knew it was something simple.. Thanks Peter!!! At 11:06 PM 9/24/01 +0200, Peter Eisentraut wrote: >Brian C. Doyle writes: > > > CREATE FUNCTION first_saturday(date) > > RETURNS date > > AS ' > > Select CASE WHEN date_part(\'dow\'

Re: [GENERAL] Function Help

2001-09-24 Thread Brian C. Doyle
The main reason is that I am not quering a table with it as of yet... Ultimately it will before query that is a Month do date query that does not use a calender month At 05:29 PM 9/24/01 -0700, Randal L. Schwartz wrote: > >>>>> "Brian" == Brian C Doyle <[EMA

[GENERAL] A newbie question

2003-11-19 Thread Brian H Mayo
PERFORM and EXECUTE; no good.   Thanks Regards, Brian H Mayo [EMAIL PROTECTED]  

[GENERAL] Carrage Returns \ Line Breaks!

2000-12-18 Thread Brian C. Doyle
Hello all, I have a file that I am trying to import/copy into a table. The problem that I am having is that there are carriage returns through out the document. These carriage returns should be copied into the column it belongs to yet during the copy table from '/home/location/file.ext' usin

Re: [GENERAL] Carrage Returns \ Line Breaks!

2000-12-18 Thread Brian C. Doyle
Okay now I am an Idoit. How do I tell what is used for the carriage return? I know how to make the replacement I just can not tell they characters used. At 11:52 AM 12/18/00 -0500, Brett W. McCoy wrote: >On Mon, 18 Dec 2000, Brian C. Doyle wrote: > > > I have a file that I

[GENERAL] Table Creation on the Fly

2001-01-14 Thread Brian C. Doyle
Hello all, Is it at all possible to create a table on the fly from a CSV file?

[GENERAL] Sequence Help

2001-01-17 Thread Brian C. Doyle
Hello all, How would I setup a sequence that would reflect, for example, abc-0001?

[GENERAL] [General] Comments

2001-01-24 Thread Brian E. Pangburn
1. Is it documented anywhere that an apostrophe / single quote is bad news inside of a C-style /* */ comment? I just found out the hard way. Seems to be OK inside of the one line -- comment. 2. How does one view column comments created with COMMENT ON COLUMN? TIA. Brian E. Pangburn

[GENERAL] Win Nt setup help please

2001-03-19 Thread Brian C. Doyle
Hello all, I am having problems with the setup of postgres on NT. I do have MSVisual C++ I have done: copy include\config.h.win32 include\config.h nmake /f win32.mak And I get NMake : fatal error u1077: 'cd' : return code '0x1' Stop Can any one help. I am using Version 1.62.7022 of NMake an

Re: [GENERAL] Database Name Case Sensitivity

2001-04-05 Thread Brian T. Allen
I just ran into that too, and find it most undesirable. I don't know whether that is part of the SQL spec or not, but it seems very odd. The queries seem to be converted to lowercase before they ever reach the SQL engine. Brian + Flash web sites from $149/y

Re: [GENERAL] Re: Database Name Case Sensitivity

2001-04-05 Thread Brian T. Allen
ease the transition and point out the differences and gotchas would be very helpful. Thanks for the help, Brian + Flash web sites from $149/year w/ hosting http://www.eflashcash.com/er/websuccess/ + > On Thu, 5 Apr 2001, Brian T. Al

[GENERAL] Deadlock detected

2001-04-09 Thread Brian J. France
ND; and get the same results. System: Linux: 2.2.18 PostgreSQL: 7.0.3 gcc: 2.95.2 libc-2.1.3 Thanks, Brian BTW, on a different table I get this warning ever time I vacuum the database. It doesn't seem to cause a problem, but didn't know how to get rid of it. NOTICE: Index

[GENERAL] PostgreSQL/PHP Application Server

2008-01-24 Thread Brian A. Seklecki (Mobile)
All: Are there any frameworks / toolkits available, possibly as established F/OSS projects, for web applications using PHP+PostgreSQL? sf.net/google comes up short -- a few XML services and Perl+PgSQL hits. By 'application server', as a marketing wank-word gleaned from Oracle/IBM/BEA, essentiall

Re: [GENERAL] PostgreSQL/PHP Application Server

2008-02-02 Thread Brian A. Seklecki (Mobile)
On Thu, 2008-01-24 at 13:10 -0500, John DeSoi wrote: > . The user/login system is extensible, so you could write your own. I'm not sure if I follow: Are you suggestion that the CMS system, Drupal, is an example of an application server model because of its framework extension? ~BAS IMPORTAN

Re: [GENERAL] PostgreSQL/PHP Application Server

2008-02-04 Thread Brian A. Seklecki (Mobile)
> No, I was suggesting an approach that might address your requirement > for integration with other authentication systems. > Actually what I really need is the Oracle 9i + Oracle Directory Service functionality (e.g. nss_ldap for PostgreSQL). That combined with Oracle Label Security (OLS) --

Re: [GENERAL] LDAP Authentication

2008-07-02 Thread Brian A. Seklecki (Mobile)
On Sun, 2008-06-29 at 17:58 +0200, Magnus Hagander wrote: > This is not something you currently can do. We can only do LDAP > authentication, not authorization. There's no way to restrict it to a > particular group. We're very interested in this functionality (nss_ldap for PgSQL) -- so if there's

[GENERAL] PostgreSQL 32 bit DB on 64 bit machine

2010-10-26 Thread Martin, Brian D. (JSC-OD)[UNITED SPACE ALLIANCE LLC]
2 bit db to the 64 bit db, the PostgreSQL logs are saying the pg_control file has a checksum mis-match. When I backup and restore the 64 bit pg_control then the log files report a sys id mismatch. Thank you, Brian Martin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

[GENERAL] PostgreSQL 32 bit DB on 64 bit machine

2010-10-26 Thread Martin, Brian D. (JSC-OD)[UNITED SPACE ALLIANCE LLC]
2 bit db to the 64 bit db, the PostgreSQL logs are saying the pg_control file has a checksum mis-match. When I backup and restore the 64 bit pg_control then the log files report a sys id mismatch. Thank you, Brian Martin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

<    1   2   3   4   5   6