Re: [SQL] id and ID in CREATE TABLE

2002-07-19 Thread Josh Jore
Joshua b. Jore ; http://www.greentechnologist.org On Sat, 20 Jul 2002 [EMAIL PROTECTED] wrote: > Why is like this ? Why not letting them upper case if they are not quoted > ? > > stefan Well.. this is because pgadmin created the attribute as "ID" originally so for you - it's always been doubl

Re: [SQL] [GENERAL] id and ID in CREATE TABLE

2002-07-19 Thread stefan
Thanks all for comments. In Oracle and DB2 as far as I know the upper case column names are used when you have no columns quoted.. Indeed it is recommended to use lower cases to avoid mistakes and confusion during porting. Is that right ? But anyway this is not so important, but why upper cas

[SQL] Regarding replication

2002-07-19 Thread Charitha
Hello all, May i know while performing replication what will slave do when master goes off the network is there any timeout or retries and all so that the slave will be trying to contact master and is two-way replication possible?? Pls. let me know Thanks in advance -- Regards, Charitha. C. -

Re: [SQL] [GENERAL] id and ID in CREATE TABLE

2002-07-19 Thread Martijn van Oosterhout
On Sat, Jul 20, 2002 at 10:39:52AM +0300, [EMAIL PROTECTED] wrote: > > I forgot about "" Sorry. So if I would use names quoted then my questions > are obsolete. Except one: > > So actually the only strange part would be PostgreSQL is folding to lower > cases a column name ... [snip] > Why is