Doing it by the psql the comand DROP TABLE vendas_item_orcamento; Message: ERRO: table "vendas_item_orcamento" doesnt exist.
The \d vendas_item_orcamento; Message: Didn't find any relation called "vendas_item_orcamento". Any ideas? -- Lucas Sanabio ----------------------------------------------------------------------------- Sun Certified Programmer for the Java 2 Platform Consultor Java - Marx Tecnologia URL: http://www.marx.com.br Email: [EMAIL PROTECTED] Tel: (62) 3281-9889 ou (62) 8117-5266 On Fri, Feb 22, 2008 at 8:14 AM, Decibel! <[EMAIL PROTECTED]> wrote: > Yes. And see what \d tablename shows. > > On Thu, Feb 21, 2008 at 09:37:19PM -0300, Lucas Sanabio wrote: > > I'm sorry, but what do you mean? Try to delete it using psql? > > > > Thanks, > > > > -- > > Lucas Sanabio > > > ----------------------------------------------------------------------------- > > Sun Certified Programmer for the Java 2 Platform > > Consultor Java - Marx Tecnologia > > URL: http://www.marx.com.br > > Email: [EMAIL PROTECTED] > > Tel: (62) 3281-9889 ou (62) 8117-5266 > > > > On Thu, Feb 21, 2008 at 8:32 PM, Decibel! <[EMAIL PROTECTED]> wrote: > > > > > On Feb 21, 2008, at 4:26 PM, Lucas Sanabio wrote: > > > > I got a weird problem that I have no idea how to solve it. The > > > > problem is that I have a table on my database which I can see it > > > > (pgAdmin III), but when I click on it, it pop's an error telling me > > > > that the table does't exist, but right after it it shows me all the > > > > table details on the other panel. If I click to see the properties, > > > > I can see all the table properties, but anything besides it always > > > > give me an "relation "vendas_orcamento_item" doesn't exist". > > > > > > > > I tried to vacumm all the data base, to refresh the view, drop the > > > > table, but everything gives me that message. > > > > > > > > Does anyone have any idea what could I do to solve this problem? > > > > > > > > The postgres version is: 7.4_7.4.16 > > > > > > > > > What's it do in psql? > > > -- > > > Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED] > > > Give your computer some brain candy! www.distributed.net Team #1828 > > > > > > > > > > > -- > Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED] > Give your computer some brain candy! www.distributed.net Team #1828 >
