[ADMIN] PostgreSQL and phppgadmin woody backports

2004-03-01 Thread Christian Frabel
I look for theese backports, someone could help? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[ADMIN] Commercial PostgreSQL support

2004-03-01 Thread Louie Kwan
We are looking for some sort of commercial PostgreSQL support, but we have limited budget. Email based type support may be enough. Any pointer will be appreciated. Thanks. Regards, Louie Kwan ---(end of broadcast)--- TIP 3: if posting/reading thr

Re: [ADMIN] Commercial PostgreSQL support

2004-03-01 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 1 Mar 2004, Louie Kwan wrote: > We are looking for some sort of commercial PostgreSQL support, but we have > limited budget. AFAICS, you're located in Canada. Both hub.org and Lanux Limited are located on Canada. You can find their ad

[ADMIN] Row data corruption under 7.3.5

2004-03-01 Thread Marc Mitchell
We are running a highly transaction-intensive application in the following environment: Postgres Version 7.3.5 built off the source tree, not RPMs Operating System: Red Hat Enterprise Linux AS (v 2.1) Kernel: 2.4.9-e.34smp Hardware: Dell PE 2600-Dual 2.8 Ghz Xeon w/2GB RAM and Dual 36GB Mirrors us

Re: [ADMIN] PostgreSQL and phppgadmin woody backports

2004-03-01 Thread Peter Eisentraut
Am Montag, 1. März 2004 14:49 schrieb Christian Frabel: > I look for theese backports, someone could help? For postgresql, see http://people.debian.org/~elphick/. About phppgadmin, I don't know of one. I happened to look at building one yesterday, but it would seem to entail an update of php4,

Re: [ADMIN] Row data corruption under 7.3.5

2004-03-01 Thread Tom Lane
"Marc Mitchell" <[EMAIL PROTECTED]> writes: > In each case, by examining the copy table output up to the point where > it errors out, a single row could be identified that contained corrupted > char/varchar values but could be queried using primary key or numeric > lookups. We've been able to work

[ADMIN] SYSDATE in PostgreSQL !?

2004-03-01 Thread Louie Kwan
How can I define a table with columns with sysdate as the default value.. If there is no SYSDATE defined in PostgreSQL , what can I do ? Any help is appreciated. CREATE TABLE channels( channelID NUMBER PRIMARY KEY, name VARCHAR2(64) NOT NULL, st

Re: [ADMIN] SYSDATE in PostgreSQL !?

2004-03-01 Thread Bjoern Metzdorf
Louie Kwan wrote: If there is no SYSDATE defined in PostgreSQL , what can I do ? > > createTimeStamp DATE default (SYSDATE) Perhaps NOW() ist what you are looking for? createTimeStamp DATE default 'NOW()' Regards, Bjoern ---(end of broadcast)--

Re: [ADMIN] SYSDATE in PostgreSQL !?

2004-03-01 Thread scott.marlowe
On Mon, 1 Mar 2004, Bjoern Metzdorf wrote: > Louie Kwan wrote: > > > If there is no SYSDATE defined in PostgreSQL , what can I do ? > > > > createTimeStamp DATE default (SYSDATE) > > Perhaps NOW() ist what you are looking for? > > createTimeStamp DATE default 'NOW()' I do

Re: [ADMIN] Problems with pg_dump

2004-03-01 Thread Stefan Holzheu
[ pg_dump shows data corruption over local socket but not TCP ] That is really odd. Anyway, we can live with that solution. But still I'd be curious to know what is the problem with local connections. Is there a way to capture traffic of local socket connections? No, not that I know of. Yo