Re: [GENERAL] Great Bridge ceases operations

2001-09-06 Thread Andy
This is a very sad news. What can I say ? Wish you all the best ! And also the best for PostgreSQL projects. - Original Message - From: "Bruce Momjian" <[EMAIL PROTECTED]> To: "PostgreSQL-general" <[EMAIL PROTECTED]> Sent: Friday, September 07, 2001 1:09 AM Subject: [GENERAL] Great Bri

Re: [GENERAL] [ANNOUNCE] Great Bridge ceases operations

2001-09-06 Thread Bruce Momjian
> > Tom, Jan, and I have enjoyed working for Great Bridge, and will continue > > our involvement with PostgreSQL. > > So what's going to happen to you guys then? We will cease existing tomorrow at noon. :-) Well, actually, we will stay with PostgreSQL and see what happens in the future. We wo

[GENERAL] Status of greatbridge.org

2001-09-06 Thread Tom Lane
I'd just like to reassure everyone that the projects currently hosted by greatbridge.org will be taken care of; there's no need for people to scramble around looking for new sites. The physical hosting will be picked up by hub.org. We still have to work out what the site name will be and the det

Re: [GENERAL] Great Bridge ceases operations

2001-09-06 Thread Joshua Drake
Hello, This is very unfortunate. I wish all of the Great Bridge employees the best. Sincerely, Joshua Drake Command Prompt, Inc. Author: http://stage.linuxports.com/projects/practicalpostgresql/book1.htm> Practical PostgreSQL [EMAIL PROTECTED] (Bruce Momjian) wrote in message news:<[EMAIL P

[GENERAL] SQL Server to PostgreSQL HOWTO

2001-09-06 Thread Ian Harding
Someone asked me to do this, and I have a draft now. While it is clearly lacking in some areas, it might be of help generally. Ian Ian A. Harding Programmer/Analyst II Tacoma-Pierce County Health Department (253) 798-3549 mailto: [EMAIL PROTECTED] The Microsoft SQL Server to PostgreSQL M

Re: [GENERAL] template0 and template1 databases

2001-09-06 Thread Andrew Gould
Thanks! Andrew --- Jeff Eckermann <[EMAIL PROTECTED]> wrote: > No. "template0" is new for version 7.1. No doubt a > developer can tell you > exactly why dropping "template0" would be a very bad > idea; I am just getting > in quickly to make sure you don't do so in the > interim :-) > > -

[GENERAL] Great Bridge ceases operations

2001-09-06 Thread Bruce Momjian
Effective tomorrow, Great Bridge LLC will cease operations. Full information can be obtained from: http://www.greatbridge.com/ Great Bridge .org, http://greatbridge.org/, will remain in place until projects are migrated to a new site. Tom, Jan, and I have enjoyed working for Great Brid

[GENERAL] Some changes to CVSup and AnonCVS access ...

2001-09-06 Thread Marc G. Fournier
In order to allow us to split easily across multiple machines, and move things transparently, there following changes are being made: AnonCVS - to access the repository via anon-cvs, please connect to a CVSROOT of: :pserver:[EMAIL PROTECTED]:/projects/cvsroot

Re: [GENERAL] getting inherited table name

2001-09-06 Thread Nico
Eric Kolve wrote: > In the pgsql tutorial two tables are created capitals inherits cities. > > When you do SELECT * FROM cities, you get both capitals and cities. Is > there anyway to get get the name of the table so I could possibly know > the 'type' it was? Or should this be maintained as a

Re: [GENERAL] Bug in createlang?

2001-09-06 Thread Bruce Momjian
> Bruce Momjian writes: > > > Does anyone have a comment on this? I wrote it a month ago. > > The fact that the database server is wide-open in the default installation > is surely not good, but the problem is that we don't have a universally > accepted way to lock it down. We could make passw

Re: [GENERAL] template0 and template1 databases

2001-09-06 Thread Jeff Eckermann
No. "template0" is new for version 7.1. No doubt a developer can tell you exactly why dropping "template0" would be a very bad idea; I am just getting in quickly to make sure you don't do so in the interim :-) - Original Message - From: "Andrew Gould" <[EMAIL PROTECTED]> To: "J.H.M. Das

[GENERAL] template0 and template1 databases

2001-09-06 Thread Andrew Gould
I notice that template0 can't be vacuumed; and that template1 gets vacuumed but has "no relations" per \d. What do these databases do? I have a python script that finds all database names per 'psql -l', vacuums and analyzes them ('vacuumdb -a -z'), and then pg_dumps them through gzip into separa

[GENERAL] getting inherited table name

2001-09-06 Thread Eric Kolve
In the pgsql tutorial two tables are created capitals inherits cities. When you do SELECT * FROM cities, you get both capitals and cities. Is there anyway to get get the name of the table so I could possibly know the 'type' it was? Or should this be maintained as a separate column 'city_type' t

[GENERAL] Primary keys and speed

2001-09-06 Thread Rob Brown-Bayliss
Hello. I am looking at useing uuid's as primary keys rather than a normal sequence of numbers. The uuids are long text strings like so: 7559e648-a29c-11d5-952f-00c026a18838 The reason for useing them is that it's almost gaurenteed that imported data from another site is going to have a uni

Re: [GENERAL] MySQL's (false?) claims... (was: Re: PL/java?)

2001-09-06 Thread Colin 't Hart
Null asks: > Would you elaborate on the alternatives that you see to cross-db queries? > > Are you saying that it would better to duplicate the same data in several > databases or put everything in one huge database or what ...? > > "Jan Wieck" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTEC

[GENERAL] a simple programming question

2001-09-06 Thread Jefim Matskin
I have the following problem; The client of the DB issues a lot of the SQL commands over a network , the statements are of the simple form - select an integer from some table(s) using some criteria. I want to create a function that will accept the string containing all the statements to be execut

Re: [GENERAL] Bug in createlang?

2001-09-06 Thread Peter Eisentraut
Bruce Momjian writes: > Does anyone have a comment on this? I wrote it a month ago. The fact that the database server is wide-open in the default installation is surely not good, but the problem is that we don't have a universally accepted way to lock it down. We could make password authentica

[GENERAL] problem with selects based on dates

2001-09-06 Thread Mike Withers
Hi everyone I have a problem with SELECTs using dates and WHERE. Some examples: SELECT * FROM emp; empno | ename|job | mgr | hiredate | sal | comm | deptno ---+++--++--+--+ 7499 | ALLEN | SALESMAN | 7698 | 19

[GENERAL] update set from where... with count

2001-09-06 Thread Jason Donald
Hi. I am having trouble getting the following to work. Please find a complete cut-paste-run example below between the lines that demonstrates the problem. ___ CREATE TABLE items ( recdate DATE, itemTEXT )

Re: [GENERAL] embedded SQL cursos declare fails

2001-09-06 Thread Bruce Momjian
I have committed these changes to ecpg.sgml. You can see the result in the development docs tomorrow. > > OK, I have backed out that patch. Would you review that section of the > SGML and either commit a patch or send me one. Thanks. > > > > On Fri, Aug 24, 2001 at 02:07:48PM -0400, Bruce