pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedStrongly typed?
6+ messages / 3 participants
[nested] [flat]
* Strongly typed?
@ 2009-03-13 14:50 Carol Walter <walterc@indiana.edu>
0 siblings, 1 reply; 6+ messages in thread
From: Carol Walter @ 2009-03-13 14:50 UTC (permalink / raw)
To: pgsql-admin
I'm moving from PostgreSQL 8.2.4 to PostgreSQL 8.3.6. When I restore
the databases from the old instance to the new one, I get a lot of
errors where the data types in keys don't match, e.g. the data type is
integer in the base file but defined as numeric in the file that it is
linked to. These are running databases so this situation must have
been negotiated by 8.2 but not my 8.3. Is this something relatively
new that I'm encountering, or is there a parameter someplace that I
have set too tightly.
BTW, I do see the value of the stronger typing; I just need to figure
out what to do to get these user's data to the new instance.
Thanks,
Carol
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Strongly typed?
@ 2009-03-13 15:13 Alvaro Herrera <alvherre@commandprompt.com>
parent: Carol Walter <walterc@indiana.edu>
0 siblings, 1 reply; 6+ messages in thread
From: Alvaro Herrera @ 2009-03-13 15:13 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin
Carol Walter wrote:
> I'm moving from PostgreSQL 8.2.4 to PostgreSQL 8.3.6. When I restore
> the databases from the old instance to the new one, I get a lot of
> errors where the data types in keys don't match, e.g. the data type is
> integer in the base file but defined as numeric in the file that it is
> linked to. These are running databases so this situation must have been
> negotiated by 8.2 but not my 8.3. Is this something relatively new that
> I'm encountering, or is there a parameter someplace that I have set too
> tightly.
It's new -- some casts changed from implicit to explicit in 8.3.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Strongly typed?
@ 2009-03-13 16:17 Carol Walter <walterc@indiana.edu>
parent: Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 1 reply; 6+ messages in thread
From: Carol Walter @ 2009-03-13 16:17 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
Thanks so much. That's what I needed to know. I'm going to have to
make some modifications to my script so that it reports what databases
it's loading, and take steps to change the data types or, at least,
hold them out.
Carol
On Mar 13, 2009, at 11:13 AM, Alvaro Herrera wrote:
> Carol Walter wrote:
>> I'm moving from PostgreSQL 8.2.4 to PostgreSQL 8.3.6. When I
>> restore
>> the databases from the old instance to the new one, I get a lot of
>> errors where the data types in keys don't match, e.g. the data type
>> is
>> integer in the base file but defined as numeric in the file that it
>> is
>> linked to. These are running databases so this situation must have
>> been
>> negotiated by 8.2 but not my 8.3. Is this something relatively new
>> that
>> I'm encountering, or is there a parameter someplace that I have set
>> too
>> tightly.
>
> It's new -- some casts changed from implicit to explicit in 8.3.
>
> --
> Alvaro Herrera http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Strongly typed?
@ 2009-03-13 16:18 Scott Marlowe <scott.marlowe@gmail.com>
parent: Carol Walter <walterc@indiana.edu>
0 siblings, 1 reply; 6+ messages in thread
From: Scott Marlowe @ 2009-03-13 16:18 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin
On Fri, Mar 13, 2009 at 10:17 AM, Carol Walter <walterc@indiana.edu> wrote:
> Thanks so much. That's what I needed to know. I'm going to have to make
> some modifications to my script so that it reports what databases it's
> loading, and take steps to change the data types or, at least, hold them
> out.
It might be easier to change them before dumping them out, in the
source database.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Strongly typed?
@ 2009-03-13 16:21 Carol Walter <walterc@indiana.edu>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Carol Walter @ 2009-03-13 16:21 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
That would be a better plan, but I don't know what they are. Is there
an integrity check utility that will run the databases and check this?
Carol
On Mar 13, 2009, at 12:18 PM, Scott Marlowe wrote:
> On Fri, Mar 13, 2009 at 10:17 AM, Carol Walter <walterc@indiana.edu>
> wrote:
>> Thanks so much. That's what I needed to know. I'm going to have
>> to make
>> some modifications to my script so that it reports what databases
>> it's
>> loading, and take steps to change the data types or, at least, hold
>> them
>> out.
>
> It might be easier to change them before dumping them out, in the
> source database.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Strongly typed?
@ 2009-03-13 16:26 Scott Marlowe <scott.marlowe@gmail.com>
parent: Carol Walter <walterc@indiana.edu>
0 siblings, 0 replies; 6+ messages in thread
From: Scott Marlowe @ 2009-03-13 16:26 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin
On Fri, Mar 13, 2009 at 10:21 AM, Carol Walter <walterc@indiana.edu> wrote:
> That would be a better plan, but I don't know what they are. Is there an
> integrity check utility that will run the databases and check this?
I'd just pg_dump -s (schema only) then restore the schema to an 8.3
and look for errors.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2009-03-13 16:26 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-03-13 14:50 Strongly typed? Carol Walter <walterc@indiana.edu>
2009-03-13 15:13 ` Alvaro Herrera <alvherre@commandprompt.com>
2009-03-13 16:17 ` Carol Walter <walterc@indiana.edu>
2009-03-13 16:18 ` Scott Marlowe <scott.marlowe@gmail.com>
2009-03-13 16:21 ` Carol Walter <walterc@indiana.edu>
2009-03-13 16:26 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox