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 clear
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 the
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, once I had random fail. This is the same
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)
portals ... FAILED
test misc
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 that is is detrimental
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 connection abortions when going over
Unix sockets?? My
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 connection abortions when going over
Unix sockets?? My
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 uses
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
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
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 what I did: Basically I deleted a table
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
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:
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 required when
"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
an initdb is
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
17 matches
Mail list logo