Re: [HACKERS] Toast,bytea, Text -blob all confusing

2001-08-27 Thread Frank Joerdens
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

Re: [HACKERS] TOAST

2001-03-13 Thread Frank Joerdens
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

Re: [HACKERS] beta3 Solaris 7 (SPARC) port report

2001-01-26 Thread Frank Joerdens
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

Re: [HACKERS] beta3 Solaris 7 (SPARC) port report

2001-01-26 Thread Frank Joerdens
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

Re: [HACKERS] beta3 Solaris 7 (SPARC) port report [ Was: Looking for . . . ]

2001-01-25 Thread Frank Joerdens
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

Re: [HACKERS] beta3 Solaris 7 (SPARC) port report [ Was: Looking for . . . ]

2001-01-25 Thread Frank Joerdens
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

Re: [HACKERS] beta3 Solaris 7 (SPARC) port report [ Was: Looking for . . . ]

2001-01-25 Thread Frank Joerdens
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

Re: [HACKERS] beta3 Solaris 7 (SPARC) port report [ Was: Looking for . . . ]

2001-01-25 Thread Frank Joerdens
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

[HACKERS] beta3 Solaris 7 (SPARC) port report [ Was: Looking for . . . ]

2001-01-24 Thread Frank Joerdens
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

[HACKERS] beta3 vacuum crash

2001-01-23 Thread Frank Joerdens
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

Re: [HACKERS] beta3 vacuum crash

2001-01-21 Thread Frank Joerdens
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

[HACKERS] beta3 vacuum crash

2001-01-20 Thread Frank Joerdens
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

[HACKERS] Beta2 Vacuum and pg_dump failures and mangled databases

2001-01-12 Thread Frank Joerdens
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:

Re: [HACKERS] Beta2 Vacuum and pg_dump failures and mangled databases

2001-01-12 Thread Frank Joerdens
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

Re: [HACKERS] Beta2 Vacuum and pg_dump failures and mangled databases

2001-01-12 Thread Frank Joerdens
"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

[HACKERS] Re: [INTERFACES] PHP and PostgreSQL

2000-12-27 Thread Frank Joerdens
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 . . .

[HACKERS] Re: [INTERFACES] PHP and PostgreSQL

2000-12-27 Thread Frank Joerdens
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