[SQL] Re: where's ALTER TABLE table DROP [ COLUMN ] column???

Bruno Boettcher wrote: > > Hello! > > as far as i can tell, i can add columns to a table, but can't remove > them later on. > > is this true? My thought would be that somebody must have written an automated version of select [all columns except named] from [named table] into droptemp;

Re: [SQL] ports in use question

Two thoughts: 1. Did you start the postmaster with "-i" to allow non-local connections? 2. Did you add the remote host to the "pg_hba.conf" file? See: http://www.postgresql.org/idocs/index.php?client-authentication.html Kate postgresql wrote: > I have started my pg installation using port

[SQL] Select help

Hi, I am trying to do a 2 joins between 3 tables. ie) select , coalesce(TRR.ABC, SOC.ABC) as newABC, ... from A join (B join C on (..)) on (..)) as TRR left join (D join E on (..)) as SOC on (TRR.Field1=SOC.Field2) When I run this it says that there is an ambiguous field. Yes after

[SQL] ports in use question

I have started my pg installation using port 5444 (with the -p 5444 switch). Everything is working fine inside my installation with the internal ip number (a 192.168 number). I created a tunnel in my firewall to point to the linux box running pg with the port 5444 open. I can not seem to get t

[SQL] photos and OID's

Hi all, Thanks for the great product. We store photos in the db and serve them up from web servers. We're using java servlets on separate web server boxes that are load balanced. NFS is not an option for us (unless nothing else is available). This works with byte streams using SQL Server from

[SQL] Recursive select

> "Martin" == Martin Smetak <[EMAIL PROTECTED]> writes: Martin> Hi all! Anyone know if it's possible to make a recursive Martin> select from a table ? My problem: I got a table of "some Martin> categories" which all points to its parrent Martin> one(tree)...shown below. And

Re: [SQL] Stored Procedures?

> I read something about stored procedures in the Great Bridge User's Manual > (Page 74 under "PG_LANGUAGE"). It is only mentioned briefly and there are no > explanations of how it works. > > Can anybody let me know, how I can write a stored procedure and how to run > it? Postgres doesn't have st

[SQL] Stored Procedures?

I read something about stored procedures in the Great Bridge User's Manual (Page 74 under "PG_LANGUAGE"). It is only mentioned briefly and there are no explanations of how it works. Can anybody let me know, how I can write a stored procedure and how to run it? Best regards, Chris