ried to do -> finish and -> commit after each
> query, but the messages still appear.
>
> Any hints?
I think that happens if the backend aborted (elogged) with an ERROR
message and you did not start a new transaction. ERROR kills the current
transaction altogether in 6.5.*, IIRC.
Regards,
Ed Loehr
not? The query string is created before prepare is called...
Regards,
Ed Loehr
What is the definition of the table 'some_table'??
Regards,
Ed Loehr
Rick Parker wrote:
>
> Does anyone know why when I am in a particular DB as user postgres and use
> the following statement, why I get this error?"
>
> This is the statement;
> SEL
ear if others have a better/faster solution here.
Regards,
Ed Loehr
mikeo wrote:
>
> is there an equivalent to rownum in oracle?
>
> also, where can one find reference to "hidden columns"
> such as OID or, as in oracle, rownum?
oid is the equivalent. not sure documentation exists for these...
Regards,
Ed Loehr
Ed Loehr wrote:
>
> Vincenzo Passoli wrote:
> >
> > i'm developing a framework (mod_perl+apache) that reads the db-schema and
> > explode html forms.
> >
> > now i read the schema and cache it into perl-hashes to speedup things.
> >
> > my pr
7;t understand very well how
these are used. Maybe someone else can say or you can experiment...
Regards,
Ed Loehr
(PS: Posting to only one of -general or -sql will almost always be
sufficient.)
time we perfomed the query.
>
> then
>
> if (&do_check($ptr_array)){
>fetch rows
>store in cache
> }
> -->use the cache
I haven't seen that syntax before with your use of "as", but I get your
gist. Sounds reasonable, though it looks like a major pain, stealing
most of the pleasure and convenience of SQL. I'd almost be tempted to
build a regex'er to pick out the table names from each query in a layer
between DBI and the app until the regex performance became an issue.
Regards,
Ed Loehr
Chunky wrote:
>
> Could someone please enlightenment me what command in psql i should use
> to show the various triggers and rules that i have created?
These might work...
select tgname from pg_trigger
select rulename from pg_rewrite
Regards,
Ed Loehr
Patrick Kay wrote:
>
> I am looking for a way run an outer join in psql. Can anyone help?
>
> Informix has an "OUTER" keyword. I don't see anything like this in the docs
> for psql.
There are many examples on how to do this in the archives or via
deja.com's power search.
Regards,
Ed Loehr
ven't checked to see if it matters...
Regards,
Ed Loehr
tual day in
> the date field.
>
> Ex.: select * from item where date = '2000-06-%%';
Multiple ways to do it, but here's one:
select *
from item
where date_part('month',mydate) = 6
and date_part('year',mydate) = 2000;
Regards,
Ed Loehr
hours 32 minutes..
Try to_char(). http://www.postgresql.org/docs/postgres/x2976.htm
Regards,
Ed Loehr
t you're after?
select o.date, sum(d.qty * d.price)
from orderdetail d, orders o
where d.orderid = o.orderid
group by o.date
Regards,
Ed Loehr
ve looked though the
> documentation and I am still struggling :-(
You probably don't need to increase the buffer. More likely, there is an
unterminated string constant somewhere in db.out. Yes, that would
probably be a bug in pg_dump, but I do vaguely recall problems in 6.5*
with pg_dump. You might search deja for your error message.
Regards,
Ed Loehr
Jean-Marc Libs wrote:
>
> I have this table:
>
> CREATE TABLE film (
>film_id serial,
> ...
>
> SELECT setval ('film_film_id_seq', 6);
>
> I have this query in PHP:
> insert into film
>
>(film_country_id,film_country_id2,film_country_id3,film_country_id4,film_prod_year,film_ec_certif,film_
http://www.postgresql.org/docs/postgres/index.html
Regards,
Ed Loehr
the vector(s) closest in
N-space to the input vector. You might dig up an old 3-variable calculus
book, find the formula, and write a PL/pgSQL function to compute the
distance between two N-dimensional vectors...
Regards,
Ed Loehr
18 matches
Mail list logo
