On Mon, 2004-11-29 at 12:57 -0500, Tom Lane wrote:
> Scott Cain <[EMAIL PROTECTED]> writes:
> > After dropping a database, recreating it and trying to add a table to
> > it, I am getting this message:
>
> > ERROR: could not access status of transaction 210
> >
t. Also, when I do a '\dt' in
that empty database, I get a similar message:
chado=# \dt
ERROR: could not access status of transaction 45
DETAIL: could not open file "/opt/postgres/data/pg_clog/": No such
file or directory
Thanks much,
Scott
--
---
Column name changes lose history of the field name too.
>
> Queries are a PITA with my schema, I can see where they would be easier
> with yours. I can imagine a pivot function that would make life easier
> with my schema though.
>
> Any thoughts would be appreciated, I might
[% table.name %] ();
[% END %]
On Fri, 2004-10-15 at 11:02, Tom Lane wrote:
> Scott Cain <[EMAIL PROTECTED]> writes:
> > Heck! So
e
SQL::Translator.
Thanks,
Scott
On Thu, 2004-10-14 at 14:07, Richard Huxton wrote:
> Scott Cain wrote:
> > I feel like I am getting very close, but I am still not quite there. I
> > rewrote the trigger function below to use execute, but now I get the
> > following error:
> >
,''''U'''')'';
return NEW;
END
'
LANGUAGE plpgsql;
Thanks again,
Scott
On Thu, 2004-10-14 at 11:16, Ian Harding wrote:
> I think you want to EXECUTE that sql so it doesn't get compiled into the
> function.
>
> http
x27;audit_' prepended to it). Is this not a valid
thing to do?
Thanks,
Scott
On Wed, 2004-10-13 at 23:59, Tom Lane wrote:
> Scott Cain <[EMAIL PROTECTED]> writes:
> > I am trying to create audit tables for all of the tables in my
> > database. The function, table and tri
CREATE TRIGGER tableinfo_audit_d
BEFORE DELETE ON tableinfo
FOR EACH ROW
EXECUTE PROCEDURE audit_delete('tableinfo');
--
Scott Cain, Ph. D.
; );
>
>
> I get a parse error:
> ERROR: parser: parse error at or near "(" at character 279
>
>
> ---(end of broadcast)-------
> TIP 8: explain analyze is your friend
--
--
traints on this table.
Thanks,
Scott
On Wed, 2003-07-30 at 00:46, Joe Conway wrote:
> Scott Cain wrote:
> > I am wondering about the implementation of substring for very large
> > strings. I've got strings that are several million characters long and
> > frequently ne
10 matches
Mail list logo
