[SQL] Changing datatype of a column
Title: Changing datatype of a column Hi, I would like to Know if there any way (and what is the command for that) to convert a column datatype from int4 to numeric(11) of an existing table that have data in it? Thanks, Ilan _ ILAN FAIT Tel: 972-9-9519133 Ex.247 iWeb Technologies Fax: 972-9-9519134 91 Medinat Ha'Yehudim St. Herzliya 46120 IL mailto:[EMAIL PROTECTED] www.iweb.com
[SQL] TEXT field size
Hallo. Maybe its not the right list, but does the Postgres 7.1 support now unlimited text field? In previous versions it was limited to max 31k, or even less, depending on the compilation etc. Greetings, Antti ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[SQL] Nested Transactions
Can anyone give me an estimate of when we might expect to see nested transactions implemented? -- John Hasler [EMAIL PROTECTED] (John Hasler) Dancing Horse Hill Elmwood, WI ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [SQL] Problems using a rule with the WHERE clause
Luis Sousa <[EMAIL PROTECTED]> writes: > I think this code is OK ! You probably don't want the second and third rules to be INSTEAD. However, > But I got the error message bellow in line 11 > of my script, that corresponds to the rule updateturnodocente_default > > psql:dev/pessoal/def/views_rules/teste_update:11: pqReadData() -- backend > closed the channel unexpectedly. that shouldn't happen, in any case. If this is the current release (7.1.2) then I'd like to see a complete script to reproduce the problem. (I don't have time to guess at your table declarations...) regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [SQL] loosing connection after function call
Markus Wagner <[EMAIL PROTECTED]> writes: > I would like to put one table create command into a C function > "my_init", just to provide a simple interface for all tables where these > tables are needed. When I execute "select my_init();" I loose the > database connection (pgaccess). What Postgres version? regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[SQL] Storing image contents in TEXT fields
Hi, I wanted to know if it's possible to store an image content in a TEXT field, or if another type is needed (in this case, then which one ?). I don't want to use BLOBs, because I modify an existing application which also works with MySQL, and I can't update to postgresql-7.1.x (I don't admin this server) in a TEXT field the image seems to be truncated at the first nul byte. Thanks in advance for any help. bye, Jerome Alet ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [SQL] Plsql Function with error: No space left on device.
"David M. Richter" <[EMAIL PROTECTED]> writes: > The query works, but not right.(apart from the timeaspect) > UPDATE image SET seriesoid = r.parentoid > FROM image i JOIN relseries_image000 r ON i.chilioid=r.childoid; You shouldn't mention "image i" in the FROM clause --- since image is already implicitly part of the FROM list, you are getting a self-join, and an unconstrained one at that. Try just UPDATE image SET seriesoid = r.parentoid FROM relseries_image000 r WHERE image.chilioid = r.childoid; regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
