[GENERAL] RE: [ADMIN] Alternate database locations

> Fear not, we're used to this. It beats having the lists inundated by > spam, which is what would happen if Marc weren't filtering nonmember > postings :-( Thanks, I figured it was something like that! T. ---(end of broadcast)--- TIP 3: if post

RE: [GENERAL] Specifying psql password on command line

> > I've read the documentation for the psql commands as well as > the createdb > > and dropdb commands. It looks like there is no way to specify > the password > > on the command line. The password is always provided in the > form of a stdin > > prompt. > > Quite deliberately ... if passwords w

Re: [GENERAL] Specifying psql password on command line

"Tauren Mills" <[EMAIL PROTECTED]> writes: >> Quite deliberately ... if passwords were provided on the command line, >> then anyone else on your machine could read them off with 'ps'. > I was actually wondering if that was the reason. I know that with MySQL, > the mysql program immediately chang

Re: [GENERAL] Specifying psql password on command line

"Tauren Mills" <[EMAIL PROTECTED]> writes: > I've read the documentation for the psql commands as well as the createdb > and dropdb commands. It looks like there is no way to specify the password > on the command line. The password is always provided in the form of a stdin > prompt. Quite delib

[GENERAL] Database Size

Hello EveryBody   How could I get the size(MB) of the Database

Re: Re[2]: [GENERAL] How to Alter tables with ARRAY? Help PLease

Igor <[EMAIL PROTECTED]> writes: > Well, i have a field OSTV which has dimention [1:9][1:6] > when i'm trying: > "update mytable set ostv [10][3]=333.00" You can't extend an array unless you specify values for all the new entries required to fill a rectangular array value (which in practice mean

Re[2]: [GENERAL] How to Alter tables with ARRAY? Help PLease

Hello, Thank you for replay , but i still having problems with aray.. Well, i have a field OSTV which has dimention [1:9][1:6] (i can see it in "SELECT array_dims(ostv) FROM mytable") when i'm trying: "update mytable set ostv [10][3]=333.00" i got: "Error while executing the query (non-fatal)

Re: [GENERAL] Specifying psql password on command line

preety simple.. In ur shell script use psql -h localhost ur_db -U ur_user_name and dropdb commands. It looks like there is no way to specify the password >on the command line. The password is always provided in the for

Re: [GENERAL] Sequences in transaction context

On Tue, Jun 05, 2001 at 10:33:08PM -0500, Erik Pearson wrote: > One last followup question -- what's MVCC? http://www.postgresql.org/idocs/index.php?mvcc.html Cheers, Neil ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [GENERAL] ORDER BY Problem

Severin Olloz <[EMAIL PROTECTED]> writes: > Why does Postgresql order the uppercase letters first? That is locale dependent - if you don't use a proper locale but use straight ASCII, A...Za...d would be correct. If you set a locale, you'll get (Aa)(Bb) etc instead, which is the correct way to so

Re: [GENERAL] Sequences in transaction context

On Tue, 5 Jun 2001, Erik Pearson wrote: > I searched through mailing list archives but was unable to find full > coverage of this question -- my apologies if this is a reposted question. > > As in the FAQ, I am trying to retrieve the value of a sequence value from a > newly inserted row. So, fi

Re: [GENERAL] Sequences in transaction context

On Tue, Jun 05, 2001 at 09:22:43PM -0500, Erik Pearson wrote: > I searched through mailing list archives but was unable to find full > coverage of this question -- my apologies if this is a reposted question. > > As in the FAQ, I am trying to retrieve the value of a sequence value from a > newly

Re: [GENERAL] ORDER BY Problem

On Wed, Jun 06, 2001 at 03:17:36AM +0200, Severin Olloz wrote: > Hello... > > Why does Postgresql order the uppercase letters first? Because all uppercase letters come before the lowercase letters. Maybe "ORDER BY lower()" will work? This should also be locale dependent ... -- Eric G. Miller

[GENERAL] Sequences in transaction context

I searched through mailing list archives but was unable to find full coverage of this question -- my apologies if this is a reposted question. As in the FAQ, I am trying to retrieve the value of a sequence value from a newly inserted row. So, first I call something like: insert into foobar

Re: [GENERAL] Vacuum problems ... HELP !!!

On Fri, Jun 01, 2001 at 02:17:17PM +0200, kavoos wrote: [snip] > /usr/local/progs/pgsql/bin/postmaster: reaping dead processes... > /usr/local/progs/pgsql/bin/postmaster: CleanupProc: pid 25501 exited > with status 139 > Server process (pid 25501) exited with status 139 at Fri Jun 1 13:58:47 > 20

[GENERAL] ORDER BY Problem

Hello... Why does Postgresql order the uppercase letters first? I have e.g. a table with one row an in this row there are follow values: row1 ADC aa ABC With this select-syntax select * from table order by row1 I become this output ABC ADC aa but I want this ouptut: aa ABC ADC What

[GENERAL] Specifying psql password on command line

I've read the documentation for the psql commands as well as the createdb and dropdb commands. It looks like there is no way to specify the password on the command line. The password is always provided in the form of a stdin prompt. This makes it very difficult to use the commands from a shell

RE: [GENERAL] XML question

If you're asking how to get XML data into PostgreSQL, for perl users: Matt Sergeant's DBIx::XML_RDB module looks handy. (I think it just got added to the FreeBSD ports collection too). http://www.xml.com/pub/a/2000/12/13/perlxmldb.html Or use any XML parser module (XML::Simple!) and pump the d

Re: [GENERAL] outer joins take forever

I believe Tom mentioned this sometime ago. If you are picking most of the rows then a seq_scan is preferable to a lookup through the index. In your case you are touching 100% of customer and almost 100% of neicstats, or at least that's what the optimizer thinks. Try vacuum_analyzing the tables

[GENERAL] FWD: 2nd OSDN DB Summit Call For Papers

Here is the CFP for OSDN's next Open Source Database get-together. The first one, held last fall in San Jose, seemed pretty successful. Note that although the published abstract submission deadline is past, they still seem to be hungry for speakers... feel free to send in a talk proposal if the m

[GENERAL] Re: [ADMIN] Limiting simultaneous connections

I don't believe its possible to do that at this time. Tim - Original Message - From: "Tauren Mills" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 05, 2001 12:30 PM Subject: RE: [ADMIN] Limiting simultaneous connections > I don't mean to be a pest, but I haven't heard

Re: [GENERAL] Current database name

Alexander Solianic <[EMAIL PROTECTED]> writes: > Hi, Posgres Gurus! > > Does anybody know if there's a way to get name of the current > session's database in stored procedure, i.e. something like > CURRENT_USER variable? what's wrong with current_user? create function my_user() returns text as

Re: [GENERAL] timeout for a transaction

HYip <[EMAIL PROTECTED]> writes: > I have a connection opened, and begin a transaction. If tomcat or web > server dies for no reasons, I found that in the backend, there is a > postgresql server process waiting for the transaction to complete. It > blocks all my database calls because of this w

Re: [GENERAL] setting PGDATESTYLE

Stephan Richter <[EMAIL PROTECTED]> writes: > So here my question: Is there any other way of globally changing the > DATESTYLE to SQL (at compile time or DB creation time)? You can set it via an environment variable in the postmaster's environment. See the docs. It ought to be settable via pos

Re: [GENERAL] PostgreSQL and TPC benchmarks

[EMAIL PROTECTED] (ak) writes: > Has PostgreSQL ever been featured in TPC benchmarks? There are no formal TPC benchmarks of PG. (Doing a TPC-approved benchmark takes an amazingly large amount of time and hardware; so far no one's cared to invest the work.) However, Great Bridge did run an inter

Re: [GENERAL] Vacuum problem on large table

mordicus <[EMAIL PROTECTED]> writes: > vacuum verbose analyse record_blob; > NOTICE: --Relation record_blob-- > NOTICE: Pages 62437: Changed 0, reaped 0, Empty 0, New 0; Tup 1005540: Vac > 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 80, MaxLen 2032; Re-using: > Free/Avail. Space 0/0; EndEmpty/A

Re: [GENERAL] setting PGDATESTYLE

Hi Tom. I basically set it as environment variable now... >It ought to be settable via postgresql.conf, but currently isn't. Yeah, that would be the right place. This way I only have to provide this one file...even can make it part of the installation process... Regards, Stephan -- Stephan R

Re: [GENERAL] PostgreSQL and TPC benchmarks

I think there is a hefty amount ($$$) involved in getting your results evaluated by their committee/judges. You can get a nice graph about TPC-C from: http://www.greatbridge.com/download/gbpg70wp1.pdf cheers, thalis On 30 May 2001, ak wrote: > Hi > > Has PostgreSQL ever been featured in TPC

Re: [GENERAL] One question about postgresql

Yes. PostgreSQL has a COPY command that you can use to import data from a delimited text file. You will have to create the table prior to using the copy command. The text file should have only one delimiter. Many text files use quotes to enclose text values in addition to having a delimiter be

Re: [GENERAL] postgres 7.1 security problem?

What does your pg_hba.conf say? On Wed, 30 May 2001, Marcel Gsteiger wrote: > My postgres 7.1 now runs for several weeks without problems. Today I > suddenly got aware of the fact that no passwords are needed anymore to > login to any database. > > Seems that the security system has been defea

Re: [GENERAL] Help with: my bits moved right off the end of the world!

Martin Weinberg <[EMAIL PROTECTED]> writes: > Folks, we have been getting: > FATAL 1: my bits moved right off the end of the world! >Recreate index pg_attribute_relid_attnam_index. Oh, that old thing :-(. If you have a way to reproduce this from a standing start (virgin database) I'd be

Re: [GENERAL] Text data type doesn't accept newlines?

on 6/5/01 12:00 PM, Bryan White at [EMAIL PROTECTED] wrote: >> I have a logging database that logs errors. The error messages contain >> newlines. Pgsql doesn't accept them on insert in a text data field. > > I have never had a problem storing newlines in a text field. What interface > are you

[GENERAL] turning off stderr message for postmaster

I'm using syslog logging. Right now, I've altered the startup script to tell postmaster to log to /dev/null instead of stderr, since the information is duplicated. is this the correct way to shut up the postmaster or is there some other option I missed? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Re: [GENERAL] Text data type doesn't accept newlines?

> I have a logging database that logs errors. The error messages contain > newlines. Pgsql doesn't accept them on insert in a text data field. I have never had a problem storing newlines in a text field. What interface are you using? The only ascii character that I have found I have to escape is

[GENERAL] Calling external programs

Hello, I would like to call an external program from Pg. Specifically, I'd like to send an email every time a row with certain attribute values is inserted into a table. I already have a trigger that fires upon insertion into the table. Is the preferred method to have a trigger call a procedu

Re: [GENERAL] Postgresql and W98

I'm sure I'll be corrected if I'm mistaken; but I think that you'll suffer decreases in performance whenever you use resources to run a GUI. I use Win98 and Access 97 as a front-end to data warehouses in PostgreSQL; but the PostgreSQL databases are on separate machines: 1 x Linux, 1 x FreeBSD.

[GENERAL] Text data type doesn't accept newlines?

I have a logging database that logs errors. The error messages contain newlines. Pgsql doesn't accept them on insert in a text data field. MySQL has the 'blob' data type which does accept newlines. Do I have to convert all newlines to '\n' to use them in Pgsql? -- Randy Perry sysTame Mac Consu

[GENERAL] XML question

hello, Just a couple of questions: - what is the _most popular_ way of storing XML data in posgresql? - what is the _best_ way of stocking XML data in postgresql? Quick and nasty opinion poll... Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/l

Re: [GENERAL] psql , stored procedure, triggers and errors

Penguin <[EMAIL PROTECTED]> writes: > I have added support of procedural language 'plpgsql' in > postgres system table pg_language. Now when I try to insert a record > in the emp table : > insert into emp(empname, salary) values( 'test', 1000 ); > from psql I get the following error : > psql:re

[GENERAL] Postgresql and W98

Hello! I am using postgresql on linux and I am pretty satisfied with it. A friend has proposed me to migrate an application using Access 9.0 as database desktop to postgresql on W98. The database has about 30 tables and some of them have 50 rows and some blobs. Does postgresql work ok und

Re: [GENERAL] How to Alter tables with ARRAY? Help PLease

Igor <[EMAIL PROTECTED]> writes: > Tell me please, how to alter tables with arrays > (in other words - to change the dimension of array ) Just assign a new array value to the column. PG doesn't actually consider the dimensionality of an array to be part of the type specification; any size array

[GENERAL] return value of a version-1 C function (Solved)

[This message refers to my previous post '[GENERAL] return value of a version-1 C function'] Ooops, I didn't read the docs very carefully! I solved the problem, by declaring cod as a proper structure and then returning it with PG_RETURN_BPCHAR_P(cod): BpChar *cod = (BpChar *)SPI_palloc(VARHDRS

[GENERAL] psql , stored procedure, triggers and errors

Hi, I am new to this mailing list. Sorry if my question sounds silly. I have compiled postgres 7.0.3 from sources and installed on our server. I wanted to try out the feature of triggers in postgres. Hence I took one example from the manual. Here it is: -

[GENERAL] How to Alter tables with ARRAY? Help PLease

Hi, Tell me please, how to alter tables with arrays (in other words - to change the dimension of array ) I'm running PG 7.1.2 Thanks for any suggestions . Igor ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregiste