On Wednesday 09 Mar 2005 11:57 am, Tom Lane wrote:
> Kenneth Gonsalves <[EMAIL PROTECTED]> writes:
> > i have a website with a postgresql backend. Being a shared site,
> > i have no root access. i do have shell access to the database,
> > but cannot create or drop the database. I access the databas
Kenneth Gonsalves <[EMAIL PROTECTED]> writes:
> i have a website with a postgresql backend. Being a shared site, i
> have no root access. i do have shell access to the database, but
> cannot create or drop the database. I access the database through
> python scripts using the psycopg adapter. My
hi,
i have a website with a postgresql backend. Being a shared site, i
have no root access. i do have shell access to the database, but
cannot create or drop the database. I access the database through
python scripts using the psycopg adapter. My question is, how do i
set the pgdatestyle in the
On Tuesday 08 March 2005 10:55 am, Ian Barwick wrote:
> > (Is this on the mysql gotchas page?)
>
> Nope, although as my plans for the week involve evaluating
> Serendipity using PostgreSQL I'll look into it.
Garvin already made a patch to CVS to fix this in s9y.
See the php-blog-devs list.
LER
>On Tue, 08 Mar 2005 10:37:51 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> Larry Rosenman writes:
> > I have an 8.0.1 server running the Blogging software serendipity, and the
> > following query fails with "relation e not defined", but it is on the first
> > line:
>
> > "SELECT timestamp FROM se
On Tuesday 08 March 2005 09:37 am, Tom Lane wrote:
> Larry Rosenman writes:
> > I have an 8.0.1 server running the Blogging software serendipity, and the
> > following query fails with "relation e not defined", but it is on the
> > first line:
> >
> > "SELECT timestamp FROM serendipity_entries e,
Larry Rosenman writes:
> I have an 8.0.1 server running the Blogging software serendipity, and the
> following query fails with "relation e not defined", but it is on the first
> line:
> "SELECT timestamp FROM serendipity_entries e, serendipity_category c,
> serendipity_entrycat ec LEFT OUTER J
On Tuesday 08 March 2005 06:35 am, Michael Glaesemann wrote:
> On Mar 8, 2005, at 21:28, Larry Rosenman wrote:
> > On Tuesday 08 March 2005 06:21 am, Michael Glaesemann wrote:
> >> Larry,
> >>
> >> Restating your SQL in a more reader-friendly form:
> >
> > [snip]
> >
> > This is from an error page
On Mar 8, 2005, at 21:28, Larry Rosenman wrote:
On Tuesday 08 March 2005 06:21 am, Michael Glaesemann wrote:
Larry,
Restating your SQL in a more reader-friendly form:
[snip]
This is from an error page (and machine generated to boot :) )
Regardless if it's machine-generated or not, I'd still reform
On Tuesday 08 March 2005 06:17 am, Richard Huxton wrote:
> Larry Rosenman wrote:
> > I have an 8.0.1 server running the Blogging software serendipity, and the
> > following query fails with "relation e not defined", but it is on the
> > first line:
> >
> > "SELECT timestamp FROM serendipity_entries
On Tuesday 08 March 2005 06:21 am, Michael Glaesemann wrote:
> Larry,
>
> Restating your SQL in a more reader-friendly form:
[snip]
>
This is from an error page (and machine generated to boot :) )
> I can see you're using a lot of left joins. You are beginning your left
> joins off of ec, so I be
Larry,
Restating your SQL in a more reader-friendly form:
SELECT timestamp
FROM serendipity_entries e
, serendipity_category c
, serendipity_entrycat ec
LEFT OUTER JOIN serendipity_entryproperties ep_cache_extended
ON (e.id = ep_cache_extended.entryid
AND ep_cache_extended.prope
On Tuesday 08 March 2005 05:48 am, Larry Rosenman wrote:
> I have an 8.0.1 server running the Blogging software serendipity, and the
> following query fails with "relation e not defined", but it is on the first
> line:
[snip]
I can put up a pg_dump -s if that would help any
LER
--
Larry Ro
Larry Rosenman wrote:
I have an 8.0.1 server running the Blogging software serendipity, and the
following query fails with "relation e not defined", but it is on the first
line:
"SELECT timestamp FROM serendipity_entries e, serendipity_category c,
serendipity_entrycat ec LEFT OUTER JOIN serendi
I have an 8.0.1 server running the Blogging software serendipity, and the
following query fails with "relation e not defined", but it is on the first
line:
"SELECT timestamp FROM serendipity_entries e, serendipity_category c,
serendipity_entrycat ec LEFT OUTER JOIN serendipity_entryproperties
ep
Jim Buttafuoco mentioned :
=> I use dblink to attach to both databases and query pg_namespace, pg_class,
pg_attribute ... to get the diffs. See
=> attached as an example. look for the dblink_connect lines to specify your
database. You will need to install
=> contrib/dblink. I used this with 7
16 matches
Mail list logo
