Re: [GENERAL] issue with xml functionality and

2008-06-09 Thread Bruce Momjian
Belbin, Peter wrote: > I'm hoping this is the right place to ask. > > If not, please, kindly direct me to the right place. > > I'm having an issue with xml functionality. > > The issue is that the xml value has the following (large chunks have been > removed, but this should be enough to demons

Re: [GENERAL] Bottom Posting

2008-06-09 Thread Bruce Momjian
Andrej Ricnik-Bay wrote: > On 29/05/2008, Bob Pawley <[EMAIL PROTECTED]> wrote: > > > ... get their point across up front without making me wade through > > previous posts which I have already read. > Good for you :} > > > I can understand the concept of bottom posting > No one advocates bottom-

Re: [GENERAL] E_PARSE error ?

2008-06-09 Thread Scott Marlowe
On Tue, Jun 3, 2008 at 10:14 AM, PJ <[EMAIL PROTECTED]> wrote: > I'm using php5, postgresql 8.3, apache2.2.8, FreeBSD 7.0 > I don't understand the message: > > *Parse error*: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting > T_STRING or T_VARIABLE or T_NUM_STRING > > the guilty line i

Re: [GENERAL] pg_dump, COPY and inheritance

2008-06-09 Thread Tom Lane
Andrew Lazarus <[EMAIL PROTECTED]> writes: > I was surprised to find out that in my pg_dumpall, inherited tables > (which have no extra columns) come out empty. All of the data are in > the base table. Well, then, that's where the data was in the source database. I can assure you pg_dump has gott

[GENERAL] pg_dump, COPY and inheritance

2008-06-09 Thread Andrew Lazarus
I was surprised to find out that in my pg_dumpall, inherited tables (which have no extra columns) come out empty. All of the data are in the base table. I was doing a dump to upgrade from 8.2 to 8.3, and this means that I have to split the base table up by hand. (Constraint exclusion on child table

Re: [GENERAL] fitler database list

2008-06-09 Thread Craig Ringer
Tino Wildenhain wrote: Christophe Simonis wrote: Is it a way to filter the database list on the tables containt in the database ? Yes it is. In other words: Maybe you should try to explain more about what you are trying to do and why. Mention the commands you are using. Are you just using

Re: [GENERAL] Application EventLog: could not write to log file: Bad file descriptor

2008-06-09 Thread Alvaro Herrera
Ati Rosselet escribió: > sorry, forgot to cc: to the group..To: Alvaro Herrera < > [EMAIL PROTECTED]> > > > not as far as I can tell... I have log_destination='stderr'. unless csv > logging is enabled in another location? No, that should mean it's disabled. > Since I disabled the following lin

Re: [GENERAL] "connect by"

2008-06-09 Thread Andreas Kretschmer
Roberts, Jon <[EMAIL PROTECTED]> schrieb: > I need a high performing version of Oracle's connect by functionality in > PostgreSQL. I saw some dispute about attempts to add this in the > archives and a reference to an ANSI alternative "with" statement. Is > either of these functions available yet

[GENERAL] "connect by"

2008-06-09 Thread Roberts, Jon
I need a high performing version of Oracle's connect by functionality in PostgreSQL. I saw some dispute about attempts to add this in the archives and a reference to an ANSI alternative "with" statement. Is either of these functions available yet? I'm using 8.3. Jon -- Sent via pgsql-general

Re: [GENERAL] nested view with outer joins - best practices

2008-06-09 Thread Tom Lane
Bohdan Linda <[EMAIL PROTECTED]> writes: > 2) Will my plan get better with new version of pgsql ( currently its 8.0.x ) 8.0 is incapable of reordering outer joins, which is likely the cause of your problem. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-

[GENERAL] nested view with outer joins - best practices

2008-06-09 Thread Bohdan Linda
Hello, I have noted one very strange thing which I would like to discuss with you. I have noted that outer joins on nested views takes heavily longer than the inner ones. Example: REATE VIEW ports_view AS SELECT ports.pid, nodes.nname FROM ports JOIN nodes ON nodes.nid = ports.pnod

Re: [GENERAL] fitler database list

2008-06-09 Thread Tino Wildenhain
Christophe Simonis wrote: Is it a way to filter the database list on the tables containt in the database ? Yes it is. Cheers Tino :-) smime.p7s Description: S/MIME Cryptographic Signature

[GENERAL] fitler database list

2008-06-09 Thread Christophe Simonis
Is it a way to filter the database list on the tables containt in the database ? Thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general