Обсуждение: Why SELECT OWNER.TABLENAME.COLUMNNAME not working ?
Can anybody tell me why i can't specify OWNER then i select a pack of tuples ? If i set only TABLENAME.COLUMNNAME all is work, but when i adding to this OWNER it's fail.
"Zuev Dmitry" wrote: >Can anybody tell me why i can't specify OWNER then i select a pack of tuples >? >If i set only TABLENAME.COLUMNNAME all is work, but when i adding to this >OWNER it's fail. This syntax is not (yet) supported. If it were supported, the first element (according to SQL specs) would be SCHEMA not OWNER, though I suppose by implication they might be the same. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "The LORD is my light and my salvation; whom shall I fear? the LORD is the strength of my life; of whom shall I be afraid?" Psalms 27:1
Hello everyone, in Postgresql RDBMS , how can i get informations about acces permissions on existing objects ? I alredy know that ( psql \z ) do this ; but 'w' means update OR delete ! (it's not the same thing) can someone , please, tell me if it is possible ? thanks a lot
Hi I guess this is because postgresql doesnt yet support the concept of schemas. Such a select statement will make sense when the database supports schemas.. Hope this helps Anand On Mon, Mar 05, 2001 at 03:01:42PM +0600, Zuev Dmitry wrote: >Can anybody tell me why i can't specify OWNER then i select a pack of tuples >? >If i set only TABLENAME.COLUMNNAME all is work, but when i adding to this >OWNER it's fail. > > > > >---------------------------(end of broadcast)--------------------------- >TIP 3: if posting/reading through Usenet, please send an appropriate >subscribe-nomail command to majordomo@postgresql.org so that your >message can get through to the mailing list cleanly