Hi,
I observed the following on PostgreSQL 8.1.3 (on Windows 2000).
(1) alter table invoice add column active boolean default true;
This will add a new column "active" with a default clause as "true" and also
sets the value "true" to all existing rows of the table.
BUT
(2) ALTER TABLE invoice
I'm planning to migrate database from Oracle to PostgreSQL.
I think there are some challenges in migrating Pro*C/COBOL, binary
data(especially move to different endian platform), stored procedures.
I think that I can apply swissql to PL/SQL, but I don't have any idea to
migrate Pro*C/COBOL wit
ECPG can be a good replcement for Pro*C You can see the detailed documentation for that at http://www.postgresql.org/docs/8.1/interactive/ecpg.html
Hope this helps.../ShoaibOn 4/19/06, koji osada <[EMAIL PROTECTED]> wrote:
I'm planning to migrate database from Oracle to PostgreSQL.I think there are
Hi,
I have an app developed with Delphi, and
when I just start tha app it start a process (a connection) on the db
server and the status stay 'IDLE IN TRANSACTION' until the end of the
application. The app is developed by other people and I don't know much about
how it was programmed!
No problem really, all it means is the
application has issued a start of transaction command, it just isn’t
doing anything at the moment.
Transactions allow any data added during the application’s running to be
rolled back should, for example, the application crash – it’ll
prevent half-wr
Rodrigo Sakai wrote:
> But I want to know if this kind of connection (idle in
> transaction) can cause locks and deadlocks on the db?
Certainly. Make sure the application is closing the transactions
quickly.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
On Wed, 19 Apr 2006, Thusitha Kodikara wrote:
> Hi,
>
> I observed the following on PostgreSQL 8.1.3 (on Windows 2000).
>
> (1) alter table invoice add column active boolean default true;
>
> This will add a new column "active" with a default clause as "true" and
> also sets the value "true" to al
We’re in the process of development between model updating
and database implementation, and
It’s been done by 2 different groups. I am wondering how
I could find out what’s the last time
The table structure has been updated (such as rename column
name , add new columns…)
I looked the
The Idle-in transaction process will prevent VACUUM
from removing dead rows. I think you should have them fix the client such that
they dont issue a begin unless they need to do something on the
database. Also have the client commit as early as it can. It is safe to
leave the database connec
Hi all,
I have several databases that I have to synchronize their schemas. I
have been testing several programs like EMS PostgreSQL Comparer and
Navicat PostgreSQL but none of them does all I need. Any advise about
what is the best way to sync the schemas?
Thanks
--
Arnau
>No problem really,
all it means is the application has issued a start of transaction command, it
just isnt doing anything at the moment.
>Transactions
allow any data added during the applications running to be rolled back should,
for example, the application crash itll prevent half-wr
On Wed, 2006-04-19 at 13:51, Rodrigo Sakai wrote:
> >No problem really, all it means is the application has issued a start
> of transaction command, it just isn’t doing anything at the moment.
>
>
> >Transactions allow any data added during the application’s running to
> be rolled back should, fo
Recently, I upgraded one of my server from FC4 to FC5. This also upgraded
postgresql to 8.1.3. The upgrade was flawless. Unfortunately, I cannot get
dblink to work in this version of postgresql. I created two fresh databases
and tried... still no luck. I keep getting the following error:
bulb
On Apr 18, 2006, at 2:15 PM, Tom Lane wrote:
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
I would've expected the RAID to protect postgres from the possibility
of data corruption, but I guess not.
Ooops :-(. It might be interesting to get pg_filedump dumps of the
corrupted pages, just to se
"Manish Gupta" <[EMAIL PROTECTED]> writes:
> bulbulbo=# select dblink_connect('hostaddr=127.0.0.1 dbname=bulbulfo
> user=bulbul password=password');
> ERROR: could not establish connection
> DETAIL: could not connect to server: Permission denied
>Is the server running on host "127.0.0.1"
I was able to solve this issue by disabling SELinux.
Still, there has got to be a way to use dblink with SELinux.
Thanks
Manish
"An informed citizenry is the bulwark of a democracy"
http://www.SUNITI.org : Self-governance for an informed citizen
From: "Manish Gupta" <[EMAIL PROTECTED]>
To
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
> Any tips on turning "ERROR: invalid page header in block 34 of
> relation" into a pg_filedump command that would yield something useful
> or interesting? If so, I'll post the results of all three relations
> known to be corrupt so far.
For me, t
"Manish Gupta" <[EMAIL PROTECTED]> writes:
> I was able to solve this issue by disabling SELinux.
> Still, there has got to be a way to use dblink with SELinux.
Please file a bugzilla entry at bugzilla.redhat.com against the
selinux-policy-targeted component (or whichever policy you're using)
(NOT
On Apr 19, 2006, at 2:26 PM, Arnau wrote:
I have several databases that I have to synchronize their
schemas. I have been testing several programs like EMS PostgreSQL
Comparer and Navicat PostgreSQL but none of them does all I need.
Any advise about what is the best way to sync the schema
19 matches
Mail list logo
