Good morning.
Since I asked this question before psql question, I would mention other
aspects as well. I had same problem, history not working etc. So I was
told to install readline. I checked, and readline rpm was installed. So
next thing, I was told, was to upgrade my postgres. I checked for up
at the psql prompt do this:
\i
On Sun, 19 Nov 2000 [EMAIL PROTECTED] wrote:
> hi everyone,
> just wanna ask how I could execute an sql script to feed into the
> database?
>
> Jess Emerson Uy
> [EMAIL PROTECTED]
>
/.
# I
On Sun, 19 Nov 2000, Joe Conway wrote:
> On machines where I've installed PostgreSQL 7.0.2 from RPM, psql allows use
> of the up arrow key for history and the escape/tab key for command
> completion, but on my remote web host (webpipe.net) those keys don't work.
> What do I need to do to get thes
Joe Conway wrote:
>
> > > On machines where I've installed PostgreSQL 7.0.2 from RPM, psql allows
> use
> > > of the up arrow key for history and the escape/tab key for command
> > > completion, but on my remote web host (webpipe.net) those keys don't
> work.
> > > What do I need to do to get the
> > On machines where I've installed PostgreSQL 7.0.2 from RPM, psql allows
use
> > of the up arrow key for history and the escape/tab key for command
> > completion, but on my remote web host (webpipe.net) those keys don't
work.
> > What do I need to do to get these features working on my remote
On Mon, Nov 20, 2000 at 01:24:32PM +1000, Sean Weissensee wrote:
> Why does this error come up
>
> ionsol=> update quickstock set ItemDesc = '1',Qty = 0.0,salesprice = 0
> .0 where StockID = '8597' \g
> ERROR: Relation 'quickstock' does not have attribute 'itemdesc'
>
> when ItemDesc do
Hi.
MySQL->Postgres dump converter is now available at
http://ziet.zhitomir.ua/~fonin/code/my2pg.pl.
Still beta and bugsome version but working, supports MySQL ENUMs, near the end are SET
emulation.
Please help me to test.
Max Rudensky.
On Thu, Nov 23, 2000 at 07:31:36PM +0100, Peter Eisentraut allegedly wrote:
> Joe Conway writes:
>
> > On machines where I've installed PostgreSQL 7.0.2 from RPM, psql allows use
> > of the up arrow key for history and the escape/tab key for command
> > completion, but on my remote web host (webp
Why does this error come up
ionsol=> update quickstock set ItemDesc =
'1',Qty = 0.0,salesprice = 0.0 where StockID = '8597' \gERROR:
Relation 'quickstock' does not have attribute 'itemdesc'
when ItemDesc does exist.
Sean
Hello,
I've been searching off-and-on for an answer to this question, but I haven't
found anything but fleeting references.
Here's the problem/question:
On machines where I've installed PostgreSQL 7.0.2 from RPM, psql allows use
of the up arrow key for history and the escape/tab key for command
hi everyone,
just wanna ask how I could execute an sql script to feed into the
database?
Jess Emerson Uy
[EMAIL PROTECTED]
Hi.
> > Can give a link ?
> can do :
> http://freshmeat.net/projects/mysql2pgsql/?highlight=convert+sql
Thank you.
BTW, if you interested in this tool, I may send you fresh versions or place it on the
web.
Maybe you will or somebody help me with one problem ? Do you know PL/pgSQL and how to
c
Max Fonin wrote:
>
> Hi.
>
> I'm writing MySQL->Postgres dump converter. E.g. it will convert only database dumps
>produced by mysqldump.
> It's almost ready, problems are ENUM and SET types. I have problems with types
>emulation.
> Maybe someone help me guys ?
>
> Anyway, some half-working v
Can give a link ?
On Fri, 17 Nov 2000 13:45:37 -0800
clayton cottingham <[EMAIL PROTECTED]> wrote:
> Max Fonin wrote:
> >
> > Hi.
> >
> > I'm writing MySQL->Postgres dump converter. E.g. it will convert only database
>dumps produced by mysqldump.
> > It's almost ready, problems are ENUM and S
Hi.
I'm writing MySQL->Postgres dump converter. E.g. it will convert only database dumps
produced by mysqldump.
It's almost ready, problems are ENUM and SET types. I have problems with types
emulation.
Maybe someone help me guys ?
Anyway, some half-working version attached.
Max Rudensky.
my
On Thu, 23 Nov 2000, Tomasz Gralewski wrote:
> I'd like to create a few tables in one SQL query, is that possible.
> What tools I have to use, Perl, Tcl, or maybe is there block command
> separator that I can write:
> CREATE TABLE abd
> (
> atype,
> btype,
> ctype
> ) an
"Rob Burne" <[EMAIL PROTECTED]> writes:
> I am trying to perform a query that will:
> 1. Return all user defined attributes from a relation.
> 2. Also return the datatypes of each relation.
> So far I can only achieve part 1 with the following:
> select attname from pg_class,pg_attribute
> where
"Luis Farfán" wrote:
>
> ello there,
> I'm looking for a (free, shareware) SQL parser and I
> haven't had much
> luck. I was wandering whether it's feasible to get
> postgresql and
> "separate" the parser from the rest of the code and
> use it
> stand-alone. Any experience, suggestions or commen
On Sat, 18 Nov 2000 01:13:23 +0200, Max Fonin said:
> Can give a link ?
>
can do :
http://freshmeat.net/projects/mysql2pgsql/?highlight=convert+sql
i havent tried their's
did try yours
it was nice to have the transactions!
> On Fri, 17 Nov 2000 13:45:37 -0800
> clayton cottingham <[EM
Help,
Does someone know how to get data from an other database using a select
statement?
In sybase I could use select * from otherdatabase..table;
But with PostgreSQL I haven't found a way yet to do this.
T.i.a
Ronnie
Hello,
Tomasz Gralewski
I'd like to create a few tables in one SQL query, is that possible.
What tools I have to use, Perl, Tcl, or maybe is there block command
separator that I can write:
CREATE TABLE abd
(
atype,
btype,
ctype
) and I whant to add the next table here, h
I am trying to perform a query that will:
1. Return all user defined attributes from a relation.
2. Also return the datatypes of each relation.
So far I can only achieve part 1 with the following:
select attname from pg_class,pg_attribute
where relname=relation_name and
attrelid = pg_class.oid
Hello,
I have some problem with too long statement.
In 'psql', the error returned for my insert statement is
ERROR: Tuple is too big: size 10436
In fact, I use JDBC driver to insert a long long string into a 'text'
field. The exception is
The SQL Statement is too long - INSERT
Hello,
subject says it all, wanted to give plperl a try, but the lib doesn't
seem installed... now i installed all through debian packaging system,
and the lib surely is somewhere, but i didn't found it yet...
so i anybody could point on on where to search for it...
--
ciao bboett
=
Please, help me.
I configure/compile perl with option ( other options stay default ):
./Configure -Dprefix=/usr/local/perl -Duseshrplib
make
make install
I add string '/usr/local/perl/lib/5.6.0/i686-linux/CORE'
in file /etc/ld.so.conf and call program 'ldconfig'.
Environment:
ello there,
I'm looking for a (free, shareware) SQL parser and I
haven't had much
luck. I was wandering whether it's feasible to get
postgresql and
"separate" the parser from the rest of the code and
use it
stand-alone. Any experience, suggestions or comments,
please e-mail
them to: [EMAIL PROTEC
Sorry for my previos letter, it was wrong.
Deal ( question ) are consist of:
[plperl]# make
mkdir blib
mkdir blib/lib
mkdir blib/arch
mkdir blib/arch/auto
mkdir blib/arch/auto/plperl
mkdir blib/lib/auto
mkdir blib/lib/auto/plperl
gcc -c -I../../../src/include -I../../../src/backend -fno-strict-
hai,
I encountered the following error While I was trying
to pg_dump the database using the command
pg_dump -z dbname > bkfilename
PQendcopy: resetting connection
SQL query to dump the contents of Table 'sarehits' did
not execute correctly. A
fter we read all the table contents from the ba
28 matches
Mail list logo
