On Fri, 13 May 2005 06:39 pm, [EMAIL PROTECTED] wrote:
> Hi,
> I migrated my db from postgresql 7.4.6 to 8.0.2 but I'm not able to make plsh
> functions working.
> I installed plsh ver. 1.0-7.3 after having installed postgresql 8.0.2 rpms for
> fedora core 2.
> I used the same, succesfull, install
On Fri, May 13, 2005 at 10:34:34AM -0700, Joe Audette wrote:
> Hi,
>
> I have an app that I released with a particular field
> as varchar 255.
If you're using PostgreSQL 8, there is an option to ALTER TABLE that
does this. The docs on ALTER TABLE including man alter_table have
examples :)
Cheer
Right. I should have said "session".
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Andrew Sullivan
> Sent: Friday, May 13, 2005 11:47 AM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] WHERE
>
> On Mon, May 09, 2005 at
On Mon, May 09, 2005 at 12:58:06PM -0700, Dann Corbit wrote:
> Temp tables go away after the transaction completes.
Connection, actually, no?
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The fact that technology doesn't work is no bar to success in the marketplace.
--Philip Greensp
Joe Audette wrote:
Hi,
I have an app that I released with a particular field
as varchar 255.
Can someone give me a script example I can use to make
an upgrade script to change it to text or at least to
larger varchar without losing existing data?
I support 3 different dbs in my app, Postgre is the
Something like
BEGIN;
LOCK table_name;
ALTER TABLE table_name RENAME col_a to col_a_old;
ALTER TABLE table_name ADD COLUMN col_a text;
UPDATE table_name SET col_a=col_a_old;
ALTER TABLE table_name DROP COLUMN col_a_old;
COMMIT;
If you have any referential integrity on the column, you'll have to mes
Hello Tom and Alvaro,
The solution you guys provided is exactly the answer I needed.
Thank you for your help and saving me time,
Darren H.
On 5/13/05, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> On Fri, May 13, 2005 at 10:07:43AM -0600, Darren Houston wrote:
> > Hello everyone,
> >
> > I guess
Hi,
I have an app that I released with a particular field
as varchar 255.
Can someone give me a script example I can use to make
an upgrade script to change it to text or at least to
larger varchar without losing existing data?
I support 3 different dbs in my app, Postgre is the
newest and least
Darren Houston <[EMAIL PROTECTED]> writes:
> PostgreSQL is truncating the column names down to 63 characters, and
> some of my names need to be a little larger than that. Is a 63 column
> name length a limit in PostgreSQL, or is there a
> setting/function/compile time option I can enact to overcome
On Fri, May 13, 2005 at 10:07:43AM -0600, Darren Houston wrote:
> Hello everyone,
>
> I guess I'm not typing in the right search string for my question
> because I can't find any answer on the Internet. So I'm coming to all
> of you for help.
>
> I'm performing a cross-tab type query in PostgreSQ
Yes I had that same experience last evening, I was going to write about that
today. But I second your thoughts !
Luc ROLLAND wrote:
Hello !
I try the update to PG 8.0.3 win32, but the archive is corrupted !?
I obtain the same thing from all the mirrors where I connect...
How can I obtain the new
Alex Turner wrote:
> No.1 Python does not scale well.
> map x=new map();
Whatever that may mean. Reminds me why I deliberately forgot all of C
right after the final test of that class at university.
> vs
> self.d={};
Beep.
Go back to my initial article and read what I wrote. And try to
underst
Hello everyone,
I guess I'm not typing in the right search string for my question
because I can't find any answer on the Internet. So I'm coming to all
of you for help.
I'm performing a cross-tab type query in PostgreSQL where the returned
data in rows become my column names. The problem I'm faci
Magnus Hagander wrote:
Is there a reason that the windows code page 1252 is not supported?
The encoding Latin1 would be the most appropriate, but 1252
is a superset of ISO8859-1 and supports more characters, and
when I want to write them through odbc I get an error.
psqlodbc 8 converts everythin
""Zlatko Matic"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I was using ADO command object and both refresh method and method with
>creating parameter object while working with Access Project...but I didn't
>try to use it with PostgreSQL...
> I would rather like to have all que
On Fri, 13 May 2005, [ISO-8859-1] Victor Spång Arthursson wrote:
> Ciao again!
>
> I just ran into a huge problem with the functions upper and lower
>
> It turns out, that when converting the case of foreign characters,
> like åäö, they stay as they were from the beginning
To help people try to
""Philippe Lang"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> Yes, I'm sure this kind of feature is application-based. There is nothing
> in the driver itself. If I'm not wrong, MS Access uses a timestamp column
> to check if the record was updated meanwhile, or the col
> Is there a reason that the windows code page 1252 is not supported?
> The encoding Latin1 would be the most appropriate, but 1252
> is a superset of ISO8859-1 and supports more characters, and
> when I want to write them through odbc I get an error.
> psqlodbc 8 converts everything to utf-8 and
Hi
I've downloaded the zip binaries of postgresql 8.0.3 from some of the
mirrors.
All of the dowmloaded files are corrupt.
With best regards.
--
Mario Günterberg
mattheis. werbeagentur
IT Engineer / Projektleiter
Zillestrasse 105a. D - 10585 Berlin
Tel#49-(0)30 . 34 80 633 - 0
Fax#49-(0)30 .
Hello Oleg Bartunov,
Oleg Bartunov schrieb:
> On Thu, 12 May 2005, Peter Schmelzer wrote:
>
>> Hi,
>>
>> this is an answer of thread
http://archives.postgresql.org/pgsql-general/2003-08/msg00694.php
>>
>> You say it exist a funktion to fin positions an frequency of lexems
for own calculate of an
Hi,
I migrated my db from postgresql 7.4.6 to 8.0.2 but I'm not able to make plsh
functions working.
I installed plsh ver. 1.0-7.3 after having installed postgresql 8.0.2 rpms for
fedora core 2.
I used the same, succesfull, install procedure I used on postgresql 7.4.6.
Every time I try to run a pl
Hi,
I just downloaded postgresql-8.0.3.zip from all US and
Canada mirror site and they all had corrupt archive
error. I ran the GPG to verify that the sig. was bad.
Is anybody know what going on?
Thanks,
sn
__
Do You Yahoo!?
Tired of spam? Yah
13 maj 2005 kl. 14.45 skrev Richard Huxton:
Richard Huxton wrote:
Victor Spång Arthursson wrote:
Ciao!
Is it possible to get the number of rows that would have been
returned if the LIMIT-clause weren't present in some way after
the query was run?
Reason for asking is that I have a really bi
You could also open a transaction and
SELECT FOR UPDATE.
So a second transaction can't Select the same data for update. That
works fine. (You can try in with pgsql too).
Daniel
Philippe Lang schrieb:
Hi,
I've been testing Delphi 2005 with Postgresql 7.4.5, through ZEOS Lib 6.5.1,
and I have a qu
Richard Huxton wrote:
Victor Spång Arthursson wrote:
Ciao!
Is it possible to get the number of rows that would have been
returned if the LIMIT-clause weren't present in some way after the
query was run?
Reason for asking is that I have a really big chunk of SQL, which
takes time to execute,
Is there a reason that the windows code page 1252 is not supported?
The encoding Latin1 would be the most appropriate, but 1252 is a
superset of ISO8859-1 and supports more characters, and when I want to
write them through odbc I get an error.
psqlodbc 8 converts everything to utf-8 and then send
Victor Spång Arthursson wrote:
Ciao!
Is it possible to get the number of rows that would have been returned
if the LIMIT-clause weren't present in some way after the query was run?
Reason for asking is that I have a really big chunk of SQL, which takes
time to execute, and whoose result is p
I do the same thing with DAO and changing my querydef at run time, but I've
added a few 'enhancements'. First, I use a DSNLess connection - that way I
don't have to set up a DSN on each client's PC. Check out
http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-accessvba for
more in
On Fri, May 13, 2005 at 11:57:08AM +0200,
Stephane Bortzmeyer <[EMAIL PROTECTED]> wrote
a message of 49 lines which said:
> I have 240 countries in the database. Because of a programming error,
> contacts were entered with a country > 240. I thought that the
> "REFERENCES Countries (id)" should
Ciao again!
I just ran into a huge problem with the functions upper and lower…
It turns out, that when converting the case of foreign characters,
like åäö, they stay as they were from the beginning…
Example:
SQL = select 'test åÄöØ', upper('test åÄöØ'), lower('test åÄöØ')
Result:
?column?upp
Hi,
Our FC2 x86_64 bit FC2 packager (Joe Conway) is on a long trip; I'm not sure
that we will be able to prepare RPMs for that arch/distro right now :(
However, if someone can step up the plate for that, I can send the guidelines
about building the RPM from SRPM...
Regards,
--
Devrim GUNDUZ
Ciao!
Is it possible to get the number of rows that would have been
returned if the LIMIT-clause weren't present in some way after the
query was run?
Reason for asking is that I have a really big chunk of SQL, which
takes time to execute, and whoose result is paginated using a LIMIT-
claus
I have a table to store localization information:
CREATE TABLE Localization (
...
zipcode TEXT NOT NULL,
...
country INTEGER REFERENCES Countries (id) NOT NULL
The table Countries is like:
CREATE TABLE Countries (
id SERIAL UNIQUE,
name TEXT UNIQUE NOT NULL,
code CHAR(2) UNIQUE NOT NULL);
Kurt Gibson wrote:
> One important solution I created in Filemaker Pro requires very
> detailed and exact replication of official court forms with database
> data entered on the forms. Imagine a form with small type, boxes and
> spacing that must be exactly as on the official form and data from
>
Hi
Why not take a look at Rekall - http://www.totalrekall.co.uk. Rekall is a
RAD tool for building database applications. It is similar to both
FileMaker and MS Access but costs a faction of the price. Rekall supports
PostreSQL natively as well as several other database engines. An ODBC
interfa
Hello !
I try the update to PG 8.0.3 win32, but the archive is corrupted !?
I obtain the same thing from all the mirrors where I connect...
How can I obtain the new Win32 release ?
Luc
- Original Message -
From: "Neil Conway" <[EMAIL PROTECTED]>
To: "Marc G. Fournier" <[EMAIL PROTECTED]>
C
Many thanks to Philippe Lang and Hervé Inisan for
all these very interseting tips !
I've solved all my problems...
Best regards.
Luc
- Original Message -
From:
Ets ROLLAND
To: pgsql-general@postgresql.org
Sent: Thursday, May 12, 2005 5:28
PM
Subject: [GENERA
Hi,
You can use pass-through queries with parameters. You have to edit the
pass-through querydef at run-time before opening it, and it works. That's fine
if you want to use this query as a datasource for a form or a report.
Sub search_store(query As String, p As String) On Erro
38 matches
Mail list logo
