Is the INSERT rule re-ordering mentioned a TODO item?
Bruce Momjian [EMAIL PROTECTED] writes:
I thought an INSERT rule with an UPDATE action would work on the same
table, but that fails. Seems the rule is firing before the INSERT
happens.
Yes, a trigger is the right way to do surgery
Bruce Momjian [EMAIL PROTECTED] writes:
Is the INSERT rule re-ordering mentioned a TODO item?
Darn if I know. I threw the thought out for discussion, but didn't
see any comments. I'm not in a hurry to change it, unless there's
consensus that we should.
regards, tom
Hello list!
Got an issue here with PostgreSQL 7.0...when using
ODBC from a windows machine, I am unable to call the results of a stored
procedure. Using a client that talks directly to the .dll file instead of
going through the ODBC interface I can use the stored procedure without
problem.
Looking at the documentation, David is apparently following this one,
which seems wrong...
http://www.postgresql.org/docs/postgres/app-initlocation.htm
Seems like it should be updated to the following:
$ export PGDATA2=/opt/postgres/data
$ initlocation $PGDATA2
$ createdb
Hello all,
as usual in CS, there can be many ways to do the same thing.
For instance, I can uppercase a string in a function in POstgreSQL or I can
uppercase it before sending the query to the database. I am reading Bruce
Monjian's book right now (page 204, Functions triggers/triggers), and I
Hi everyone, I have to insert a few PDF files into my database, and
I am not able to do it ...
I have to use PHP3, and all I could do was use the lo_import,
but in this case, I am not able to insert any data because I am not an
administrator. Is there any other way of doing it, using, let's
Barnes wrote:
Thank you. This works, and is close to what I need, but if I don't launch
the postmaster from a window with PGDATA2 defined, such as is done with
"/etc/init.d/postgresql start" or on a system boot, then it doesn't work. I
tried to export PGDATA2 within
Hi,
I work in an environment where people can update
the PostgreSQL database from several sites (insert, update, delete
statements).
If two people try to update, insert or delete
the same row at the same time, or if one deletes a row
that the other is viewing and trying to update, in
Hi,
I'm trying to find out if I can store more than 8k characters of data in
one field in a single row. I'm working on a web based app and limiting
myself to 8k posts is problematic. Has this limitation changed in
Postgres 7?
Thanks,
mike
Hi:
Is JSQL available for PostgreSQL 7? If so, can someone point me to vendors
or documentation, etc.?
Thanks
John
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
Hi:
I am running FreeBSD 4.0-STABLE (i386). I want to install PostgreSQL v7.0.2
but the port maintainer is unable to update it (he writes: "I'm busy until
2000/06/27 because of CCIE certification.")
The changes to the port from v7.0.0 to 7.0.2 would appear to be trivial but,
having never
Hi:
Thanks, I check into that. I have assumed, from my own reading of
the release history, that:
1) 7.0.1 fixes some minor bugs, and
2) 7.0.2 was released so quickly after 7.0.1 because some
documentation was left out as an oversight (which was probably
already in of
Ken Causey wrote:
I was wondering if anyone is using or has used PostgeSQL on
a Cobalt Qube2? Or on any MIPs device? Should foresee any
great difficulties?
I've used 6.5.3 and 7.0 on a Cobalt RAQ2 (mips) with no problem. In both
cases it compiled clean from the distribution without any
Hi:
Thanks, I check into that. I have assumed, from my own reading of the
release history, that:
1) 7.0.1 fixes some minor bugs, and
2) 7.0.2 was released so quickly after 7.0.1 because some documentation was
left out as an oversight (which was probably already
in of 7.0.0).
hello,
does postgresql 7.0 support macro substiution ? so that i can
pass tablename
as an argument to a query ?
please reply immediately.i am in dire need of your help.
Hi,
i have tried to find info elsewhere, but did not find anything to my satisfaction, so
I was wondering if anyone on this list could point me into the right direction.
When I create a table
e.g.:
create table xyz
(
idserial PRIMARY KEY,
uvw varchar2(100)
);
I would like to get
Sir,
I am currently using ingres and would like to migrate to postgres.
However the problem is that my existing database is now over 2GB and all of
my scsi disks are only at 2GB. In ingres all I have to do to extend large
tables to multiple locations or file systems (disks) thereby enabling
Hello,
We are in the process of evaluating PostgreSQL ,
we could not perform ROLLBACK function in pgsql .
It got aborted .
Tell us how ROLLBACK is to be executed.
thanks
Kshipra
Does anyone knows how do you send query output to a file???
I tried following but it does not work:
select * from table name \o file name ;
Please let me know if anyone knows!! Thanks in advance
Neeraj
[EMAIL PROTECTED]
Hi,
I have a PostgreSQL 6.5.3 database server working flawlessly under
Red Hat 6.1
However, when I try to use the pg_dump utility, I get this error:
#pg_dump myDatabase backup.db
getTypes(): SELECT failed. Explanation from backend: 'ERROR: cache lookup for
userid 201 failed
On Thu, 8 Jun 2000, Mirko Geffken wrote:
# i have tried to find info elsewhere, but did not find anything to my
# satisfaction, so I was wondering if anyone on this list could point me
# into the right direction.
#
# When I create a table
#
# e.g.:
# create table xyz
# (
# idserial
Hi:
I am running FreeBSD 4.0-STABLE (i386). I want to install
PostgreSQL v7.0.2 but the FreeBSD port maintainer is unable to
update it (he writes: "I'm busy until 2000/06/27 because of CCIE
certification.")
The current port version on FreeBSD is **v7.0.0**
The changes to the needed to alter
My application (in perl) has to portible
between both MySQL and Postgres. Most of
the work is rather easy, but I'm having
trouble with TIMESTAMP.
MySQL allows me to use DATE_FORMAT( col_name, '%D %M %Y' )
to format the data. What function or method does Postgres
provide for formating
23 matches
Mail list logo