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
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
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
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
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