[GENERAL] upgrade 8.0.4 to 8.1.4 breakage

2006-05-28 Thread brian ally
fedora core 2, upgrade from 8.0.4 -> 8.1.4 via RPM I've just upgraded, everything /seemed/ to go swimmingly, but now i cannot connect via PHP. I can connect fine through psql, and all my tables have been restored fine. Using PEAR MDB2 wrappers (MDB2-2.0.3). Has anyone else seen this? Is this

Re: [GENERAL] upgrade 8.0.4 to 8.1.4 breakage SOLVED

2006-05-28 Thread brian ally
~ahem~ I'd forgotten to adjust pg_hba.conf All is good. Carry on. brian brian ally wrote: fedora core 2, upgrade from 8.0.4 -> 8.1.4 via RPM I've just upgraded, everything /seemed/ to go swimmingly, but now i cannot connect via PHP. I can connect fine through psql, and all my

Re: [GENERAL] National Number to text conversion

2006-05-29 Thread brian ally
Bob Pawley wrote: Make a table that you can reference. Fill it with Arabic, English or any language that you wish. Make it available to the list so those who wish can particpate and receive a copy of the finished product. Bob - Original Message - From: Samer Abukhait To: pgsq

Re: [GENERAL] List of countries (WAS: National Number to text conversion)

2006-05-29 Thread brian ally
Nis Jorgensen wrote: brian ally wrote: I was thinking the same. But Bob's reply has me wondering if there are any online resources for this sort of thing. Specifically, i have a look-up table, with most (possibly all - i don't know) countries' 2-letter ISO codes and english n

Re: [GENERAL] Querying for strings that match after prefix

2006-06-02 Thread brian ally
John Sidney-Woollett wrote: I need to locate all the entries in a table that match , but only after a number of characters have been ignored. I have a table of email addresses, and someone else has erroneously entered some addresses prefixed with 'mailto:', which I'd like to ignore. > Or someth

Re: [GENERAL] Querying for strings that match after prefix

2006-06-02 Thread brian ally
John Sidney-Woollett wrote: brian ally wrote: John Sidney-Woollett wrote: I need to locate all the entries in a table that match , but only after a number of characters have been ignored. I have a table of email addresses, and someone else has erroneously entered some addresses prefixed with

Re: [GENERAL] What is the point of create or replace view command

2006-06-04 Thread brian ally
Chris Velevitch wrote: On 6/5/06, Tom Lane wrote: "Chris Velevitch" <[EMAIL PROTECTED]> writes: > What is the point of the create or replace view command if you can't > change the column and data types ? You might as well ask what's the point of CREATE OR REPLACE FUNCTION, when it doesn't let

Re: [GENERAL] not valid character for Unicode

2006-06-09 Thread brian ally
Adam Witney wrote: Martijn van Oosterhout wrote: On Fri, Jun 09, 2006 at 03:59:52PM +0100, Adam Witney wrote: Hi, Im trying to upgrade from 7.4 -> 8.1 but it is failing with Unicode errors. The offending character is the greek character mu (often used for micro). Here is an offending stri

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully

2006-06-13 Thread brian ally
2) Re: "still-vaporware Relational Model"- the relational model is a mathematical model for data representation. Your comment makes as much sense as claiming that "Newtonian physics" is vaporware. If we're discussing the "luminiferous aether", then, yes, vaporware seems /somewhat/ appropriate.

Re: [GENERAL] Help from Havana

2006-06-22 Thread brian ally
Giraldo Leon wrote: I want to know how to print a database eschema with the information of tables, fields,keys,etc Have a look at PostgreSQL Autodoc http://www.rbt.ca/autodoc/ b ---(end of broadcast)--- TIP 5: don't forget to increase your

[GENERAL] oh dear - have i messed up my OIDs?

2006-06-25 Thread brian ally
I have a table which required some modifications, but making these changes meant that i had to adjust some functions and types, as well. As the DB is not "live" yet, i simply dumped everything, and copied the bits that needed changes to a new file, made the changes, and ran that. Unfortunately,