On Friday 19 December 2008 01:29:06 you wrote:
> Aarni writes:
> > "ERROR: operator does not exist: character varying = integer at
> > character 286 HINT: No operator matches the given name and argument
> > type(s). You might need to add explicit type casts."
>
286
HINT: No operator matches the given name and argument type(s). You might need
to add explicit type casts."
Quick fix to sql statements eg.
... WHERE CAST (your_char AS INTEGER) = integer ...
... WHERE CAST (your_char AS INTEGER) IN (1,2,3,...)
BR,
--
Aarni Ruuhimäki
--
2. I had a button that kept me from sending silly messages.
3. Whoops, still not do.
Rock,
Aarni
Received: from mx2.hub.org ([200.46.204.254]:26819 "EHLO mx2.hub.org")
by northstar.iwn.fi with ESMTP id S10843AbYJWU4D (ORCPT
); Thu, 23 Oct 2008 23:56:03 +0300
Received: f
t id 1, 1 pcs product id 234 and so on.
And as mentioned, you have the freedom to choose your preferred API, be it
php, python, perl or what ever.
Please (Andrus) have a look at the shop, LinuxShop, in action at
http://www.linuxkauppa.fi/
It is in finnish but I think you will get the hang
n_path/deep_somewhere_else/dbconnect_app_name.php");
BR,
Aarni
--
Burglars usually come in through your windows.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Please try again.");}
while ($row = pg_fetch_row($product))
{
echo"
$row[1]
";
}
pg_close($conn);
BR,
--
Aarni
Burglars usually come in through your windows.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Monday 21 April 2008 12:08, Monalee Bhandge wrote:
> pg_ctl start -D /var/lib/pgsql/data
> then error is->
> postmaster started.
> Could not open directory "base" No such file or
> directory.
Hi,
Did you initdb in that location ?
Best r
per week
>
>
> 3) What name of initdb do you prefer?
> -- --
>
b) pg_initdb
>
> 4) How do you perform VACUUM?
> -
>
a) vacuumdb - shell command
c) autovacuum
--
Aarni Ruuhimäki
---
Burglars usually come in
he biggest
one has sixty odd tables and the biggest table is holding now around 100.000
rows. But I have seen it reach that from zero, with version upgrades and
without any real db-related problems.
Best regards,
--
Aarni Ruuhimäki
---
Burglars usually come in through your windows.
---
--
> the
> default be sql_ascii? postgres version is 8.2.5
>
> Thanks again
> Steve
Hi Steve,
http://www.postgresql.org/docs/8.2/static/app-initdb.html
Best regards,
--
Aarni
---(end of broadcast)---
TIP 9: In versions below 8.0, the p
y re-invent the wheel ...
All servers are linux + Pg8.2.
I followed the recent thread about 'replication in Postgres' but still any
info on experience of similar circumstances and pointers / comments /
recommendations are more than welcome.
BR,
--
Aarni Ruuhimäki
-
r version has no -E for dumps. Same
output. Also with pg_dumpall.
I tried various encodings with iconv too.
So, what would be the proper way to convert the dumps to UTF-8 ? Or any other
solution ? Any other tool to work with the problem files ?
BR,
Aarni
--
Aarni Ruuhimäki
12 matches
Mail list logo
