Harald Krake escribió:
> Hi!
>
> when it comes to portability the right place to implement such
> auditing is in the OR-mapper.
> Most commercial mappers already provide such a feature.
> However, if you don't like "black-boxed" third party
> software, writing your own mapper isn't a big deal.
> I
hello,
how to modify the datatype of column in a table?
i have created table with one coulmn datatype is varchar(200) so i would like to change to text datatype
thanks in advance
mukundDo you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
hello,
how to modify the datatype of column in a table?
i have created table with one coulmn datatype is varchar(200) so i would like to change to text datatype
thanks in advance
mukundDo you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
"Flavio Hallais" <[EMAIL PROTECTED]> writes:
> initdb -D /usr/local/pgsql/data
> ...
> initdb failed
By default, initdb is the strong silent type :-( ... if it fails you
will get no useful indication why. Please try it like this:
initdb -d [other options as usual] 2>init.err
and send u
Upon each postgresql upgrade the copy command seems just not to parse correctly. Of course, you say why not copy data into sql statements... I would however, the files get extremely large for each table approx 1GB.
I would like to hear some strategies or plans of others who have upgraded or are pl
Ian Barwick wrote:
> Short answer: no urgent need.
> Long answer: Unfortunately DBD::Pg is "out of sync" with the PostgreSQL
> release process and hasn't yet been upgraded to take into account of
> the changes in 7.3.
>
> _Basically_ a Perl application using DBD::Pg with 7.3 should work out of t
Thomas O'Connell wrote:
> has anyone put together a Sensible Strategies for Upgrading document
> when moving from 7.2.x to 7.3?
>
> for instance, i've read in a few different places that not all
> dependencies will be appropriately created.
>
> as an admin, my biggest questions are:
>
> 1. is
On Wednesday 11 December 2002 21:43, Thomas O'Connell wrote:
> has anyone put together a Sensible Strategies for Upgrading document
> when moving from 7.2.x to 7.3?
Some replies to some of your questions:
> 2. is it necessary, strongly recommended, recommended, or irrelevant to
> upgrade DBD::Pg
has anyone put together a Sensible Strategies for Upgrading document
when moving from 7.2.x to 7.3?
for instance, i've read in a few different places that not all
dependencies will be appropriately created.
as an admin, my biggest questions are:
1. is it necessary, strongly recommended, recomm
The preferred method is to have a PK and store it in your big table. In
addition to being more "normal" and probably saving a little space, this
gives you the option of changing the corresponding values in one place. So
for instance if your lookup table was "datatypes", and you had entered
"Sting"
Hi all,
After a successful installation of version 7.3,
when I tried the
command:
initdb -D /usr/local/pgsql/data
I got the following messages:
creating directory /usr/local/pgsql/data ...
ok
creating directory /usr/local/pgsql/data/base ...
ok
creating directory /usr/local/pgsql
I have a database in which there is a
particular data tables that has a lot of dictionary (or lookup) tables hanging
off of it. The dictionary tables do not currently have PKs. They consist merely
of a list of values that are used to create drop down lists in an
application.
Would it be mo
In my work with he Progress RDBMS, I had a delta tool to take the schema
changes between an old db and a newer version and make a sql (delta) file to
update the older version.
Is there such a beast for postgresql??
Thanks,
Christian
---(end of broadcast)
Hello all. I recently came into the position of maintaining several SQL
database servers. Having no prior experience other then FileMaker, I'm a
little daunted. :) So one of things I'm doing is moving them to new
servers. In the process I thought it would be a good idea to come up
with a backup
Title: Message
Hi
guys:
I have a function
and I need to make some work with some tables into a cursor. Is posible to
return the result records on the cursor from the function to the client
side?
Any
ideas!
Thanx
Luison
Thanks guys, I've cracked it now... yeah, a lot of syntax errors, but to be
honest, I never got to look at the pl syntax page. Thanks to Jakub for the
link, it helped solve the problem...
thanks again..
Geoff
-Original Message-
From: Robert Treat [mailto:[EMAIL PROTECTED]]
Sent: 11 Dece
On Wed, 2002-12-11 at 07:38, Geoff wrote:
>
> RETURN NULL;
>
> END
>
> ' LANGUAGE 'plpgsql' ;
>
Look over Jakub's email, it's on the right track. FWIW, you also need a
; after your END statement, which I believe is the actual error your
seeing.
Robert Treat
---(end o
On Tue, 2002-12-10 at 14:44, Aravind Babu Guntha wrote:
> i am trying to compile the below c-program.but iam getting the errors as
>
> /usr/lib/crt1.o(.text+0x18): In function `_start':
> : undefined reference to `main'
> collect2: ld returned 1 exit status
You need to show us the command line yo
I am looking at using postgresql for a database to support some dynamic web
site work I am doing.
Can you please let me know if it is at all possible to obtain information
about the number of users connected to a given database and their associated
details i.e. connection time, user name etc...
pg_client_encoding ?
Did you set to unicode ?
C.
Jefim Matskin wrote:
I'm trying to develop an international app that will work for the far east =
countries too.
Working with the PostgreSQL 7.3 and have created a database with the Unicod=
e encoding (createdb -E unicode ...)
I have an external da
Around 12:44 on Dec 4, 2002, Joel Burton said:
# The thread here is about how to raise the *max* value for the sequence,
# not how to set the current value higher. The sequence in question was
# created with a too-low maximum value (see help on CREATE SEQUENCE for
# options); the user now wants to
i am trying to compile the below c-program.but iam getting the errors as
/usr/lib/crt1.o(.text+0x18): In function `_start':
: undefined reference to `main'
collect2: ld returned 1 exit status
#include
#include /* required for atoi */
int main() {
char c[10];
int sum = 0;
FILE *file;
Hi,
I am looking at using postgresql for a database to support some dynamic web
site work I am doing.
Can you please let me know if it is at all possible to obtain information
about the number of users connected to a given database and their associated
details i.e. connection time, user name etc.
Hi!
when it comes to portability the right place to implement such
auditing is in the OR-mapper.
Most commercial mappers already provide such a feature.
However, if you don't like "black-boxed" third party
software, writing your own mapper isn't a big deal.
It's worth the effort!
Some hints:
-
hi,
> I've got this function which works off a trigger.
> The trigger is calling the function ok, but I get this error.
>
> NOTICE: plpgsql: ERROR during compile of mon_sum_update near line 43
> ERROR: parse error at or near ""
>
> Now line 43 is this either the return null or end statement at th
I've got this function which works off a trigger.
The trigger is calling the function ok, but I get this error.
NOTICE: plpgsql: ERROR during compile of mon_sum_update near line 43
ERROR: parse error at or near ""
Now line 43 is this either the return null or end statement at the end of
the funct
26 matches
Mail list logo
