O A. Kretschmer έγραψε στις Nov 9, 2005 :
am 08.11.2005, um 23:18:35 -0800 mailte Louise Catherine folgendes:
Hi,
I would like to migrating my database from postgresql
7.4.6 to postgresql 8.0.3.
Why not 8.1.0?
Are there any problem during migrating database? a
casting problem
Hi
Can anyone help me out
How can i migrate database from oracle9i to postgreSQL8.0.3 where the table structure may differ in certain way...
Jaime Casanova [EMAIL PROTECTED] wrote:
On 11/8/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]>wrote: Hi Looking the e-mail I remembered a
Hola a todo... necesito ejecutar una consulta Insert que realice en pgsql para ver siinserta correctamente en la tabla asociada, pero con execute me da un erroralguien me puede decir como lo hago
yo trabajo con el editor postgresql manager pro..
Gracias...
Ahh otra cosa: en otra
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Fernando lo que pasa es que postgres siempre pasa a minusculas los
nombres de los campos o tablas excepto si estos se escriben entre
comillas. es decir algo como:
select CAMPO1 ...
postrgres lo pasara a:
select campo1 ..
y algo como
select
When I issue something like this:
SELECT * FROM ads WHERE id=1004;
i get:
id | vpn_id | service_id | ignore_length | start_time |
end_time| ad_text
Mario Splivalo [EMAIL PROTECTED] writes:
When I do:
SELECT * FROM get_ads(1004);
i get:
ERROR: query-specified return row and actual function return row do not
match
The example as given works fine for me in 7.4.9. Maybe you need an
update, or maybe you're not telling us the whole truth
I have thought of this as a possible solution. Unfortunately I want to do
reporting (sum, avg, ect.) queries on this data (for each user) and I can't
imagine that being feasible with casting that many columns.
Zack
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Wed, 2005-11-09 at 13:49 -0500, Tom Lane wrote:
Mario Splivalo [EMAIL PROTECTED] writes:
When I do:
SELECT * FROM get_ads(1004);
i get:
ERROR: query-specified return row and actual function return row do not
match
The example as given works fine for me in 7.4.9. Maybe you need
Mario Splivalo [EMAIL PROTECTED] writes:
Works fine. I remind you again, this is on a newly created database.
Yup, works fine for me too.
When I run it, again the same:pulitzer2=# select * from
get_ad_test(1004);
ERROR: query-specified return row and actual function return row do not
match
On Wed, 2005-11-09 at 17:05 -0500, Tom Lane wrote:
Mario Splivalo [EMAIL PROTECTED] writes:
Works fine. I remind you again, this is on a newly created database.
Yup, works fine for me too.
When I run it, again the same:pulitzer2=# select * from
get_ad_test(1004);
ERROR:
Fernando --
I am not sure about the first question -- my spansih is rusry.
postgres does force all column, table and schema names (I think) to lower case
(there have been recent long discussions about this on this list IIRC). If you
want to preserve case put the column name in double quotes:
11 matches
Mail list logo