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 PRIMAR
Hi,
Please add to the COPY command the option FIXED_WIDTH for the purpose of
exporting fixed width files.
TIA,
Kurt Miller
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
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
__
Does anyone knows how do you send query output to a file???
I tried following but it does not work:
select * from \o ;
Please let me know if anyone knows!! Thanks in advance
Neeraj
[EMAIL PROTECTED]
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
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
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 the
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 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 Fre
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).
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 e
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
> > alread
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 done
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,
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 post
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 /etc/init.d/postgr
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 sa
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 a
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 times
> 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
> $ creat
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
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
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 d
24 matches
Mail list logo
