[GENERAL] Fwd: Postgres update

2000-10-28 Thread Denis Perchine
Any comments? This is vacuum... And it happends several time. PostgreSQL 7.0.2 -- ðÅÒÅÓÌÁÎÎÏÅ ÓÏÏÂÝÅÎÉÅ -- Subject: Postgres update Date: Fri, 27 Oct 2000 23:00:01 -0500 (EST) From: [EMAIL PROTECTED] (WebmailStation User) To: [EMAIL PROTECTED] psql:/home/www/www.webmailstation

Re: [GENERAL] Postgresql doesn't understand the unary plus

2000-10-28 Thread Tom Lane
Martijn van Oosterhout <[EMAIL PROTECTED]> writes: > I definitly consider this a bug but other people may disagree with me. What > I want to know is if it's excluded for any particular reason. Nobody's bothered to write the operators. Are you volunteering? regards, tom l

[GENERAL] Postgresql doesn't understand the unary plus

2000-10-28 Thread Martijn van Oosterhout
I definitly consider this a bug but other people may disagree with me. What I want to know is if it's excluded for any particular reason. => select -1; ?column? -1 => select +1; ERROR: Unable to identify a left operator '+' for type 'int4' You may need to add parentheses o

[GENERAL] Conversion MySql -> PostgresSQL

2000-10-28 Thread William H. Geiger III
Hi, I am new to PostgreSQL and I am trying to convert a MySQL database over. There are a couple of basics I need to clear up: On the numeric INT types can they be set to unsigned? I have 32-bit & 64bit unsigned integers that I need to store in the majority of the tables in the database. All the

Re: [GENERAL] Time Difference

2000-10-28 Thread Richard Huxton
From: "Mike E" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 27, 2000 12:13 PM Subject: [GENERAL] Time Difference > I have the following setup: > > appt=# select * from availability \g > emp_id |date| start_time | end_time > +++---

Re: [GENERAL] newbie question: ERROR: getattproperties: no attribute tuple 1259 -2

2000-10-28 Thread Robert Vogt IV
Mr. Lane, >> Why is this? We're running 7.0.2 and have not performed any of these >> compile-time gymnastics...and we're not having any problems > > Did you compile from source? If so I'd expect things to be fine. It's > just the PPC RPMs that are (or, shortly, were) on our FTP server

Re: [GENERAL] problem with views

2000-10-28 Thread hubert depesz lubaczewski
On Fri, Oct 27, 2000 at 01:50:05PM +0200, cp wrote: > I received answer: "... Rule string too big" > Is the problem with the limitation of the NUMBER of the fields or LENGTH of > the string describing the rule ??? > Is it possible to get through this limitation however??? this is the common probl

Re: [GENERAL] newbie question: ERROR: getattproperties: no attribute tuple 1259 -2

2000-10-28 Thread Tom Lane
"Robert Vogt IV" <[EMAIL PROTECTED]> writes: >>> Postgres 7.0.* doesn't work on PPC unless compiled -O0. The above is >>> a typical symptom of being compiled with higher optimization settings. >>> Unfortunately, it seems that our PPC RPMs for 7.0.2 were compiled with >>> the wrong -O level :-(.

Re: [GENERAL] newbie question: ERROR: getattproperties: no attribute tuple 1259 -2

2000-10-28 Thread Larry Rosenman
* Robert Vogt IV <[EMAIL PROTECTED]> [001028 12:10]: [SNIP] > By the way- does anybody know of any resources related to securing > databases. We'd like to only allow certain users access to each database, > but cannot find the appropriate section in any of the documentation pages. Look at pg_

Re: [GENERAL] newbie question: ERROR: getattproperties: no attribute tuple 1259 -2

2000-10-28 Thread Robert Vogt IV
Isaac and Tom, > Awesome, thanx. I thought i was doing something wrong. I suggest that some > sort of warning about this go on the pgsql website (and other places where > us PPC types will notice it) so no one else has to beat their head on the > wall over this. > >> Postgres 7.0.* doesn't wo

[GENERAL] finding dependencies with altered table

2000-10-28 Thread Marcin Mazurek
Hi, lets say I'm changing a table with alter. Of course related views etc are broken, how can I find all tables etc. depended on that table ? tia mazek Marcin Mazurek -- Kierownik Działu Systemowego MULTINET SA o/Poznan http://www.multinet.pl/

Re: [GENERAL] newbie question: ERROR: getattproperties: no attribute tuple 1259 -2

2000-10-28 Thread Tom Lane
Isaac <[EMAIL PROTECTED]> writes: > ERROR: getattproperties: no attribute tuple 1259 -2 Postgres 7.0.* doesn't work on PPC unless compiled -O0. The above is a typical symptom of being compiled with higher optimization settings. Unfortunately, it seems that our PPC RPMs for 7.0.2 were compiled w

Re: [GENERAL] 7.1 release date ?

2000-10-28 Thread Bruce Momjian
> > Is it possible to obtain a list of new features which are coming with > > 7.1 ? > > I *believe* that the todo list that Bruce maintains has those features > coming in the new release, that are finished, marked appropriately ... at > least it used to be that way, Bruce? Yes, marked with a das

[GENERAL] set digest pgsql-general

2000-10-28 Thread Radhakrishnan R.
set digest pgsql-general