On Thu, Aug 23, 2001 at 01:09:14PM -0400, [EMAIL PROTECTED] wrote:
> I'm trying my best to convert from MySQL to PgSQL but I cant get a good
> answer about
> certian questions. It was an easy task in mysql but all this talk about
> , text , toast and bytea is just confusing me.
> I cant get a cle
Adam Lang wrote:
>
> I'd say the most important thing would be to get it upto speed with 7.1.
> Make sure PHP supports large objects and the TOAST properly.
What would be the problem there? As I understand TOAST, the application shouldn't take
any
notice of it's inner workings whatsoever . . .
Adam Lang wrote:
>
> I thought I saw mention on the interfaces list that the ODBC driver needed
> to be modified to properly use the large objects.
You normally wouldn't use ODBC to access Postgres from PHP but rather
the Postgres-specific interface. You _can_ use ODBC as well but normally
that
Tom Lane wrote:
[ . . . ]
> A general-purpose connection-reuse facility on the server end cannot
> eliminate these overheads, whereas it's trivial to avoid them within
> the context of a multi-threaded client.
PHP 4.04 does provide support for AOLServer now (which is multithreaded). I haven't had
First I tried to dump out a database like:
frank@limedes:~ > pg_dump mpi > dump.mpi
getTables(): relation 'institute': 6 Triggers were expected, but got 0
The database mpi does contain a table 'institute' and a few foreign key constraints.
Then
I tried to dump another database, as in:
postgres
On Fri, Jan 12, 2001 at 06:05:09PM +0100, Frank Joerdens wrote:
[ . . . ]
> Does this make any sense to anyone?
Are questions related to 7.1 beta versions best directed to hackers or to
general?
- Frank
Frank Joerdens wrote:
[ . . . ]
> Restarting the server didn't make a difference.
I upgraded to beta3 just now and the problem persists. I didn't do an initdb obviously
cuz
I cannot save the data via pg_dump. Beta3 will read beta2 data OK (I guess this means
that
an initdb is not
"Mikheev, Vadim" wrote:
>
> > [ . . . ]
> > > Restarting the server didn't make a difference.
> >
> > I upgraded to beta3 just now and the problem persists. I
> > didn't do an initdb obviously cuz
> > I cannot save the data via pg_dump. Beta3 will read beta2
> > data OK (I guess this means that
>
I haven't tried everything to recover from this yet, but will quickly try to document
the
crash before I lose track of what exactly went into it and what I did: Basically I
deleted
a table and then ran vacuum verbose, with the net result that I cannot connect to this
database anymore with the er
On Sat, Jan 20, 2001 at 05:35:41PM -0500, Tom Lane wrote:
> Frank Joerdens <[EMAIL PROTECTED]> writes:
> > I haven't tried everything to recover from this yet, but will quickly
> > try to document the crash before I lose track of what exactly went
> > into it and w
I haven't tried everything to recover from this yet, but will quickly try to document
the
crash before I lose track of what exactly went into it and what I did: Basically I
deleted
a table and then ran vacuum verbose, with the net result that I cannot connect to this
database anymore with the er
On Tue, Jan 23, 2001 at 11:57:52AM -0500, Tom Lane wrote:
[ . . . ]
> After you build PG and test it, send us a port report, and we'll add
> Solaris 7 to the list of recently tested platforms. That's how it
> works ...
The installation by simply running configure, make, make install went
complet
On Thu, Jan 25, 2001 at 12:42:45AM +0100, Peter Eisentraut wrote:
> Frank Joerdens writes:
>
> [randomly varying set of regression tests fail]
>
> > Running the tests on my Linux box gives no failed tests. Must I assume
> > that those failed tests indicate some issue t
On Thu, Jan 25, 2001 at 05:12:02PM +0100, Peter Eisentraut wrote:
> Frank Joerdens writes:
>
> > > I have experienced before that Unix sockets will cause random connection
> > > abortions on Solaris [ . . . ]
> >
> > Isn't that _really_ bad? Random conn
On Thu, Jan 25, 2001 at 05:12:02PM +0100, Peter Eisentraut wrote:
> Frank Joerdens writes:
>
> > > I have experienced before that Unix sockets will cause random connection
> > > abortions on Solaris [ . . . ]
> >
> > Isn't that _really_ bad? Random conn
On Thu, Jan 25, 2001 at 12:04:40PM -0800, Ian Lance Taylor wrote:
[ . . . ]
> > for the /tmp directory, which looks distinctly odd to me. What kind of
> > device is swap (I know what swap is normally but I didn't know you could
> > mount stuff there . . . )??
>
> That is a tmpfs file system which
On Fri, Jan 26, 2001 at 03:29:59PM +, Patrick Welche wrote:
> On Thu, Jan 25, 2001 at 10:13:29PM -0500, Tom Lane wrote:
> > Frank Joerdens <[EMAIL PROTECTED]> writes:
> > > I just did that and ran make check 4 times. 3 times went completely
> > > smoothly, on
On Fri, Jan 26, 2001 at 11:15:45AM -0500, Tom Lane wrote:
> Frank Joerdens <[EMAIL PROTECTED]> writes:
> > Now I get:
>
> > select_distinct_on ... FAILED
> > select_implicit ... FAILED
> > random ... failed (ignored)
>
On Fri, Mar 09, 2001 at 01:54:40PM +1100, Pam Withnall wrote:
> hi,
> I an using postgresql-7.1beta4 and am trying to use the large text fields.
> I have heard of TOAST. There is little documentation.
> I found one section about creating a data type,
> then creating two functions to convert th
19 matches
Mail list logo
