Re: [GENERAL] row numbering

2000-05-10 Thread Marcin Inkielman
Hi! thanks for your respose! sorry if i was not very clear with my question... On Wed, 10 May 2000, Peter Eisentraut wrote: > Marcin Inkielman writes: > > > how may i easyly obtain row numbers in a query: > > In the SQL data model, rows don't have numbers, because rows aren't > ordered -- a

RE: [HACKERS] Re: [GENERAL] Problems compiling version 7

2000-05-10 Thread Culberson, Philip
This reminds me of a problem I once had. I was trying to "make" the documentation, but zcat kept failing because the Solaris version does not work the same as the GNU version. So I installed the GNU zcat, ran configure again, but still make was failing because of zcat... I found that once confi

[GENERAL] Need for Developer

2000-05-10 Thread Stuart Scott
All, I hope you folks will not flame me for posting this here. I tried to send this yesterday but I don't think it got posted since my membership in this list had not cleared yet. But especially excuse me if it is a double post. I am part of a team doing a web startup venture. We are incorpor

Re: [HACKERS] Re: [GENERAL] Problems compiling version 7

2000-05-10 Thread Peter Eisentraut
Tom Lane writes: > >> dnl Check tr flags to convert from lower to upper case > The results *are* used, in backend/utils/Gen_fmgrtab.sh.in (and > apparently nowhere else). Ah, I see. Substituting into source files directly from configure ... very evil... (Before you ask why: What if I change Ge

Re: [GENERAL] 6.5.3 -> 7.0 upgrade went smoothly, thanks

2000-05-10 Thread Alfred Perlstein
* Bruce Momjian <[EMAIL PROTECTED]> [000510 14:17] wrote: > > * Bruce Momjian <[EMAIL PROTECTED]> [000510 13:35] wrote: > > > > pg_dumpall then using psql to source the file went off perfectly. > > > > > > > > Just a nit, where's the manpages in 7.0? :) > > > > > > > > Thanks for the excellent d

Re: [GENERAL] 6.5.3 -> 7.0 upgrade went smoothly, thanks

2000-05-10 Thread Bruce Momjian
> * Bruce Momjian <[EMAIL PROTECTED]> [000510 13:35] wrote: > > > pg_dumpall then using psql to source the file went off perfectly. > > > > > > Just a nit, where's the manpages in 7.0? :) > > > > > > Thanks for the excellent database system, and best of luck with > > > the recent step up in the

Re: [GENERAL] 6.5.3 -> 7.0 upgrade went smoothly, thanks

2000-05-10 Thread Alfred Perlstein
* Bruce Momjian <[EMAIL PROTECTED]> [000510 13:35] wrote: > > pg_dumpall then using psql to source the file went off perfectly. > > > > Just a nit, where's the manpages in 7.0? :) > > > > Thanks for the excellent database system, and best of luck with > > the recent step up in the business and p

Re: [GENERAL] 7.0 RPM?

2000-05-10 Thread Lamar Owen
"J. Atwood" wrote: > > I have been looking around for the RPM for 7.0 anyone have a quick link? An announcement will be made shortly. Shortly being within a day or two -- possibly tonight. More likely tomorrow night. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11

Re: [GENERAL] 6.5.3 -> 7.0 upgrade went smoothly, thanks

2000-05-10 Thread Bruce Momjian
> pg_dumpall then using psql to source the file went off perfectly. > > Just a nit, where's the manpages in 7.0? :) > > Thanks for the excellent database system, and best of luck with > the recent step up in the business and political open source world! For those that use CVS, you have to downl

Re: [GENERAL] Querying the field types of a table

2000-05-10 Thread Lamar Owen
Charles Tassell wrote: > archives you will find more detail. Generally, the best way to find what > you are looking for is to start psql with the -E option (echo queries sent > At 03:30 PM 5/10/00, Dale Anderson wrote: > >Is there a way to query the field names and types of a table in either 6.5

Re: [GENERAL] Querying the field types of a table

2000-05-10 Thread Charles Tassell
There has been discussion on this topic before, so if you check the archives you will find more detail. Generally, the best way to find what you are looking for is to start psql with the -E option (echo queries sent to the backend) and then issue a \dt or \d tablename command to see the query

[GENERAL] Querying the field types of a table

2000-05-10 Thread Dale Anderson
Is there a way to query the field names and types of a table in either 6.5 or 7.0?? I am writing an application, and in one piece, I need to get the field names and field types of any table. Can this be done??? I have searched both the web and documentation, and I can't seem to find a C func

[GENERAL] PostgreSQL User Groups

2000-05-10 Thread Ron Peterson
Does PostgreSQL have local user groups? I happen to live in Boston, so of course anything around here would interest me most. -Ron-

[GENERAL] 6.5.3 -> 7.0 upgrade went smoothly, thanks

2000-05-10 Thread Alfred Perlstein
pg_dumpall then using psql to source the file went off perfectly. Just a nit, where's the manpages in 7.0? :) Thanks for the excellent database system, and best of luck with the recent step up in the business and political open source world! -- -Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PRO

Re: [GENERAL] Steering committee responce to Great Bridge LLC

2000-05-10 Thread Ned Lilly
Hi Ed, Hmm... viewed through that prism, whether it's "jaded and cynical" or not, I can see your concern. Our chairman, Frank Batten, Jr. understood the power of open source software development when the Red Hat guys came calling several years ago - few other people at Landmark did, and so the c

Re: [HACKERS] Re: [GENERAL] Problems compiling version 7

2000-05-10 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > On Tue, 9 May 2000, Tom Lane wrote: >> dnl Check tr flags to convert from lower to upper case >> Does anyone recall why this test is in there to begin with? > I don't see the results of this test being used anywhere at all, so I'd > say yank it. If

Re: [GENERAL] 7.0 RPM?

2000-05-10 Thread Thomas Lockhart
> My point is that my RPMS use the final release sources Doh! Sorry, I was focused on the RC1 thing... -- Thomas Lockhart [EMAIL PROTECTED] South Pasadena, California

Re: [GENERAL] 7.0 RPM?

2000-05-10 Thread Karl DeBisschop
Thomas Lockhart wrote: > > > 7.0RC5 is database-compatible with the final, earlier betas are *not*. > > > You can use pg_upgrade to update from any 6.5-or-later version if you > > > are feeling adventurous, but I'd definitely suggest making a backup > > > first in case things go wrong and you hav

Re: [GENERAL] Steering committee responce to Great Bridge LLC

2000-05-10 Thread Ned Lilly
Hello all, I responded to Ross' post yesterday, but it looks like my reply didn't make it onto the list. So I'm re-sending... sorry for the delay: -- Thanks for your thoughtful post. Let me refer you (and everyone else) to the Slashdot discussion going on now... I think/hope it will answer a

Re: [GENERAL] textpos() function

2000-05-10 Thread Mike Mascari
Hitesh Patel wrote: > > > If you really don't want to update your app's code just yet, you can > > install a pg_proc entry that defines textpos() with a CREATE FUNCTION > > command. But the long-term answer is to fix your code to conform with > > the standard. > > > > r

Re: [GENERAL] textpos() function

2000-05-10 Thread Hitesh Patel
Tom Lane wrote: > \> Looks like it's called position() now --- that function has the same OID > (849) as 6.5's textpos(), and even more damningly points to a C function > that's still called textpos(): > > regression=# select oid,* from pg_proc where oid=849; > oid | proname | proowner | prola