Re: [ADMIN] About System Catalogs

2004-10-22 Thread Thomas Swan
Tom Lane wrote: [EMAIL PROTECTED] writes: 2) As i had a very large pg_largeogject, i deleted rows e now i have a clean, small table. The table is empty but its index pg_largeogject_loid_pn_index lasts to retain a lot of bytes. REINDEX should fix this. Is REI

Re: [ADMIN] Transactions and HTTP

2003-01-21 Thread Thomas Swan
Raj Mathur wrote: Hi, Writing a web-based application using PostgreSQL as the back-end database. The master create functions look something like this: 1. Accept ID from user. 2. Verify that ID doesn't exist in database. Start transaction. Create blank record with ID as key. 3. Accept remain

Re: [ADMIN] Can't connect to PGSQL

2002-11-08 Thread Thomas Swan
ferdinan firmansyah wrote: We have installed LinuxRedhat+PgSQL in our server. We can ping the server's IP. But we cannot connect our database through PGAdmin or our application. We have already set the port to the default. 1. What seems to be the problem? Check to see if you installed RedHat w

Re: [ADMIN] time stamp

2002-06-21 Thread Thomas Swan
Tom Lane wrote: Thomas Swan <[EMAIL PROTECTED]> writes: No, it won't. If the user has TimeZone set to -05, as he should, then his input of '2002-06-20 12:00:00' will be read as '2002-06-20 12:00:00-05'. And it will be displayed to him that wa

Re: [ADMIN] time stamp

2002-06-21 Thread Thomas Swan
Tom Lane wrote: Felipe Nascimento <[EMAIL PROTECTED]> writes: let's imagine that my server resides in Time Zone(TZ) "-00", and one user resides in TZ "-05". Let=B4s say that 12p.m. to the user is 3p.m. to the server, on the same day. Let's say that the user inp