Re: [GENERAL] Spot the error in my plpgsql...

2001-01-16 Thread Adam Haberlach
On Tue, Jan 16, 2001 at 12:58:41PM +0100, Mirko Zeibig wrote: > On Mon, Jan 15, 2001 at 07:54:26PM -0800, Adam Haberlach wrote: > > I've got the following procedure... > > > > DROP FUNCTION "blank_referring_devices" (); > > CREATE FUNCTION "blank_referring_devices" () RETURNS opaque AS > > ' > >

[GENERAL] Unknown Type 'ame' [urgent]

2001-01-16 Thread Mike Miller
I was having problems with AME in 7.0.3 running initdb so I figured I would try to install 7.1beta3 and see if it is fixed. I get the following error: "ERROR: Error: unknown type 'ame'." still with this version. Clearly something is wrong. Does anyone have any ideas? -- Mike [postgres pgs

Re: [GENERAL] INIT DB FAILURE

2001-01-16 Thread Tom Lane
"Mike Miller" <[EMAIL PROTECTED]> writes: > Fixing permissions on pre-existing data directory /usr/pgsql/data > Creating database system directory /usr/pgsql/data/base > Creating database XLOG directory /usr/pgsql/data/pg_xlog > Creating template database in /usr/pgsql/data/base/template1 > ERROR:

[GENERAL] Re: Unknown Type 'ame' [urgent]

2001-01-16 Thread Fred Yankowski
That message could be generated by bootstrap.c. It looks like that would happen if the bootstrap scanner/parser thought it saw a clause like "something = ame" in some config file, which looks awfully close to the "something = name" clause that appears many times in the *.bki.source files. Perhap

[GENERAL] Re: INIT DB FAILURE

2001-01-16 Thread Mike Miller
mv global.bki global.bki.old; mv template1.bki template1.bki.old cat global.bki.old | sed s/" ame"/" name"/ > global.bki cat template1.bki.old | sed s/" ame"/" name"/ > global.bki Solution is pretty simple actually (did figure this one out). I did find other people complaining about this, but n

[GENERAL] Re: Unknown Type 'ame' [urgent]

2001-01-16 Thread Fred Yankowski
I see that the genbki.sh file in backend/catalog has some sed strings like these: -e "s/[ ]NameData/\ name/g" \ -e "s/^NameData/\name/g" \ Those look bogus to me. I wonder if that '\n' becomes newline for some versions of shell and/or sed? -- Fred Yankowski [EMAIL PROTEC

[GENERAL] pg_shadow permission denied for pgAdmin!!!

2001-01-16 Thread Niral Trivedi
All, Thank you all for your help and guidance for my previous questions regarding ERWin problem. Now that I have started playing with pgAdmin, I am having a new problem. Problem 1: --- When I am trying to change 'privilages' by it is giving me error 'pg_shadow permission denied'

[GENERAL] postgres 7.0.3 core dumps

2001-01-16 Thread Joseph Shraibman
Postgres has core dumped on me a few in the last few weeks. For complete details of the problem: http://www.selectacast.net/~jks/postgres/ I think it is a problem with select from cursor, but I don't really know. -- Joseph Shraibman [EMAIL PROTECTED] Increase signal to noise ratio. http://www.t

[GENERAL] MySQL file system

2001-01-16 Thread Ned Lilly
Anyone heard about this? http://no.spam.ee/~tonu/mysqlfs.html -- Ned Lilly e: [EMAIL PROTECTED] Vice Presidentw: www.greatbridge.com Evangelism / Hacker Relationsv: 757.233.5523 Great Bridge, LLC

Re: [GENERAL] MySQL file system

2001-01-16 Thread Dominic J. Eidson
On Tue, 16 Jan 2001, Ned Lilly wrote: > http://no.spam.ee/~tonu/mysqlfs.html Can I puke now? Please. -- Dominic J. Eidson "Baruk Khazad! Khazad ai-menu!" - Gimli --- http://www.t

Re: [GENERAL] MySQL file system

2001-01-16 Thread Alex Pilosov
Hehe, very amusing. (albeit vaporware for now) I guess they want to it with KOrbit, and some software translating cobra->mysql (mysql doesn't have corba bindings yet, to my knowledge). The same should be possible with postgres, and it actually DOES have corba bindings (albeit they are broken AFA

Re: [GENERAL] MySQL file system

2001-01-16 Thread Ned Lilly
more on slashdot: http://slashdot.org/article.pl?sid=01/01/16/1855253&mode=nested Alex Pilosov wrote: > Hehe, very amusing. (albeit vaporware for now) > > I guess they want to it with KOrbit, and some software translating > cobra->mysql (mysql doesn't have corba bindings yet, to my knowledge)

Re: [GENERAL] MySQL file system

2001-01-16 Thread Karl DeBisschop
Ned Lilly wrote: > > Anyone heard about this? > > http://no.spam.ee/~tonu/mysqlfs.html I was bout to copy about 3000 RFCs onto my hard drive last night. Bowsing them online was just too painfully slow. Then I realized that although I had the disk space for the total file size, they were mostly

Re: [GENERAL] Re: Unknown Type 'ame' [urgent]

2001-01-16 Thread Bruce Momjian
> I see that the genbki.sh file in backend/catalog has some sed strings > like these: > > -e "s/[ ]NameData/\ name/g" \ > -e "s/^NameData/\name/g" \ > > Those look bogus to me. I wonder if that '\n' becomes newline for > some versions of shell and/or sed? What is that \n doing in the

Re: [GENERAL] Re: Unknown Type 'ame' [urgent]

2001-01-16 Thread Bruce Momjian
> I see that the genbki.sh file in backend/catalog has some sed strings > like these: > > -e "s/[ ]NameData/\ name/g" \ > -e "s/^NameData/\name/g" \ > > Those look bogus to me. I wonder if that '\n' becomes newline for > some versions of shell and/or sed? I have just removed the bac

[GENERAL] Why is there so much MySQL bashing???

2001-01-16 Thread Philip Hallstrom
Hi all - I'm not here to start a war, but it seems to me that there is a fairly large amount of MySQL bashing in this group. Why? What's the point? It seems to me that if PostgreSQL wants an enemy to fight it should be Microsoft SQLServer and Oracle. It seems to me that it's PostgreSQL

[GENERAL] Waiting for postmaster to be completely started

2001-01-16 Thread Wade D. Oberpriller
Hello, I have a script with the following code: $(PGSQL)/bin/pg_ctl -D $(PGSQL)/data start ;\ $(PGSQL)/bin/createlang -L $(PGSQL)/lib plpgsql template1 Sometimes I get an error from createlang, and it appears that postmaster has not completely been started and is not ready to ac

RE: [GENERAL] Why is there so much MySQL bashing???

2001-01-16 Thread Craig L. Ching
Take your own advice and keep it professional. Drop the part about whining losers and people might not take this as a troll. ;-) Sorry to everyone, but I just couldn't resist answering this. Cheers, Craig > -Original Message- > From: Philip Hallstrom [mailto:[EMAIL PROTECTED]] > Sent:

Re: [GENERAL] Re: Unknown Type 'ame' [urgent]

2001-01-16 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: >> -e "s/[ ]NameData/\ name/g" \ >> -e "s/^NameData/\name/g" \ > What is that \n doing in there? It is certainly wrong. I am just > wondering what is should be. It's been like that since 1996, according to the CVS logs. I'm surprised we have not

[GENERAL] Postgres Warning - index 1

2001-01-16 Thread Abe
Hey Guys, I am using PHP to process this query - I get the error shown below: I can't see why I should get this error as I have other similar queries that work fine. $sql = "insert into projects values('$number', '$description', '$date', '$deadline', '$manager', '$csindex', '$status', '$datae

Re: [GENERAL] Waiting for postmaster to be completely started

2001-01-16 Thread Tom Lane
[EMAIL PROTECTED] (Wade D. Oberpriller) writes: > Does > the pg_ctl script wait until postmaster has been started and is ready to > accept connections? Not without the -w option, as a moment's inspection of either the docs or the script itself would've told you ... regard

[GENERAL] pg_log

2001-01-16 Thread Andrew W. Nosenko
Question: what is logged in pg_log table and how I can cleanup it? (And is this possible at all?) PostgreSQL version: 7.0.3 -- Andrew W. Nosenko([EMAIL PROTECTED])

Re: [GENERAL] postgres 7.0.3 core dumps

2001-01-16 Thread Tom Lane
Joseph Shraibman <[EMAIL PROTECTED]> writes: > Postgres has core dumped on me a few in the last few weeks. For complete > details of the problem: > http://www.selectacast.net/~jks/postgres/ Unfortunately, those core dump files are of no value anywhere except on your machine, since they are (a) pl

Re: [GENERAL] MySQL file system

2001-01-16 Thread Brett W. McCoy
On Tue, 16 Jan 2001, Ned Lilly wrote: > Anyone heard about this? > > http://no.spam.ee/~tonu/mysqlfs.html That only confirms the criticisms that some have leveled at MySQL of being an SQL interface to a filesystem and not a true relational database management system. -- Brett

Re: [GENERAL] pg_log

2001-01-16 Thread Oliver Elphick
"Andrew W. Nosenko" wrote: >Question: what is logged in pg_log table and how I can cleanup it? (And >is this possible at all?) Don't touch it !!! It records the status of all your tuples. If you wipe it, you destroy your data. Developers: I've seen this question several times; wouldn't it

Re: [GENERAL] pg_log

2001-01-16 Thread Tom Lane
"Andrew W. Nosenko" <[EMAIL PROTECTED]> writes: > Question: what is logged in pg_log table and how I can cleanup it? Transaction commit-status bits, and don't even *think* of touching it. Easiest way to hose your database that I know of :-( If it gets big enough to be really annoying, you can du

Re: [GENERAL] pg_log

2001-01-16 Thread Tom Lane
"Oliver Elphick" <[EMAIL PROTECTED]> writes: > Developers: > I've seen this question several times; wouldn't it be better to rename > pg_log to pg_tuplestatus? Calling something ...log is asking for it > to be wiped. In 7.1 it'll have a numeric filename ($PGDATA/global/1269, actually) which shou

Re: [GENERAL] postgres 7.0.3 core dumps

2001-01-16 Thread Joseph Shraibman
Look at http://www.selectacast.net/~jks/postgres/gdb2.txt and gdb3.txt It looks like script put some garbage in the file where I used file completion in the shell, so just ignore that. Tom Lane wrote: > > Joseph Shraibman <[EMAIL PROTECTED]> writes: > > Postgres has core dumped on me a few in t

Re: [GENERAL] Re: Unknown Type 'ame' [urgent]

2001-01-16 Thread Bruce Momjian
> Bruce Momjian <[EMAIL PROTECTED]> writes: > >> -e "s/[]NameData/\ name/g" \ > >> -e "s/^NameData/\name/g" \ > > > What is that \n doing in there? It is certainly wrong. I am just > > wondering what is should be. > > It's been like that since 1996, according to the CVS logs. I'm > surpri

[GENERAL] pg_hba.conf edit

2001-01-16 Thread Uro Gruber
Hi! I want to know how to edit this file. Because is only for reading. Is there any program to edit this. For now i chmod it to 600 end edit with my editor. Any comments. -- Uroš

Re: [GENERAL] pg_hba.conf edit

2001-01-16 Thread Brett W. McCoy
On Wed, 17 Jan 2001, Uro Gruber wrote: > I want to know how to edit this file. Because is only for reading. Is > there any program to edit this. For now i chmod it to 600 > end edit with my editor. That's the way you are supposed to do it! Just make sure you make it read-only after you are done

[GENERAL] FW: Porting PostgreSQL to Windows 2000 notes

2001-01-16 Thread Sam and Lisa Snow
Hello All-- Maybe someone here can benefit from what I noticed-- and/or answer my new problem I have run into. Thanks, Sam -Original Message- From: Sam and Lisa Snow [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 14, 2001 2:20 PM To: '[EMAIL PROTECTED]' Subject: Porting PostgreSQL to W