[GENERAL] tables filled to 1 Gig each

2009-04-07 Thread Cha Yang
Postgresql 8.2 backend to a Java application with JDBC For whatever reason all of postgresql tables all filled up to 1 gig each Accessing Postgresql through either the application or PGadmin fails any ideas of how to get into Postgresql or a way to clean up these tables? thanks -- Sent v

[GENERAL] importing limited set of rows/tuples

2007-07-02 Thread cha
tell me how to accomplish this? Secondly, like to know how postgresql take care of all the constraints/referential integrity while importing the records from the different tables? Cheers, Cha -- View this message in context: http://www.nabble.com/importing-limited-set-of-rows-tuples-tf4011639.html

[GENERAL] problem importing data with psql

2007-06-25 Thread cha
rather than manually. So Can anyone throw light on this issue? Where am wrong? What's need to be done? Awaiting for the reply. Cheers, Cha -- View this message in context: http://www.nabble.com/problem-importing-data-with-psql-tf3956973.html#a11227923 Sent from the PostgreSQL - general ma

Re: [GENERAL] problem importing data with psql

2007-06-25 Thread cha
Hi All, Am able to resolve the problem by setting PGPASSWORD=password in my environment variables and passing the -q(quiet) command in my ant script. Cheers, Cha cha wrote: > > Hi All, > > Am using the following command to import tables in my database. I got list > of tables

[GENERAL] pg_dump to include multiple tables

2007-06-25 Thread cha
heers, Cha -- View this message in context: http://www.nabble.com/pg_dump-to-include-multiple-tables-tf3944396.html#a11188783 Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---(end of broadcast)--- TIP 4: Have you searche

[GENERAL] Problem adding a record with vb6

2006-06-01 Thread Cha Men Hui
I have visual basic 6 with sp6 and I'm trying to add data to PG table, but it gives a error msg like this:Current recordset doesn't support updating. This may be a limitation of the provider orĀ  of the selected locktype.and I don't know what can it be, this is the code that I use:strSql = "Provider