Oracle is positively minuscule (at least as far as its "installation
footprint" goes). I've run PostgreSQL, MySQL, DB2 and Oracle on the
same development machine without any issues. Of course if another
application is in constant use on a production server Postg
umn relacl.
See:
http://www.postgresql.org/idocs/index.php?catalog-pg-class.html
HTH
Ian Barwick
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
y are both VARCHARs they could
contain differing amounts of trailing spaces or other
'invisible' characters which would not be obvious from the
console, but would represent valid and unique values
to the constraint checker. These could result from
unfiltered input
dumpfiles?
This:
http://www.postgresql.org/idocs/index.php?backup.html#BACKUP-DUMP-LARGE
may be of some use to you
Ian Barwick
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
, column relacl.
See:
http://www.postgresql.org/idocs/index.php?catalog-pg-class.html
HTH
Ian Barwick
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ary containing fdatasync... (cached) none required
> checking for pam_start in -lpam... no
> configure: error: library 'pam' is required for PAM
The message is in the error... Maybe your system (you don't say what
flavour) doesn't have the pam libraries ins
distributors don't know very much about
your particular production environment).
Ian Barwick
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
y much depends on you and your hardware.
HTH
Ian Barwick
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
ng is 32, which gives a maximum length of 31
characters).
Changing NAMEDATALEN to a greater value is on the todo-list, see:
http://archives.postgresql.org/pgsql-general/2002-01/msg00941.php
Ian Barwick
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
atting
functions; those are provided by individual client
applications.
In psql you can use \echo to print a line to standard
output. \? shows other available options.
Ian Barwick
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Monday 25 November 2002 10:48, Somasekhar wrote:
> Hi,
>
> I have a postgres database running on a english linux box.what settings
> need to be done , so that i can insert japanese characters into the
> database.
Insertion of Japanese text should work regardless of however
files
before restoring. Maybe someone more knowledgable will come up with
a more qualified answer.
> 4. are there other important considerations i might be overlooking?
I would recommend thorough testing before you commit to an upgrade ;-)
Ian Barwick
[EMAIL PROTECTED]
entire PostgreSQL source; the smallest available
package is "postgresql-base-x.x.tar.gz" which doesn't include the docs. etc.
This page:
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/install-procedure.html
contains info on installing the standard client apps without th
remote database?
What didn't work, and how?
> BTW, I run RedHat Linux 8..does that make a difference?
Only if you give some more details ;-)
Ian Barwick
[EMAIL PROTECTED]
>
> > Ian Barwick wrote:
> >> On Friday 13 December 2002 00:52, Aravind Vinnakota wrote:
> >>
d in atttypmod.
> Is it possible to change the value of atttypmod and is it safe to change
> this value?
Possible but probably not safe. No doubt someone will be along shortly
with a more accurate opinion ;-).
Ian Barwick
[EMAIL PROTECTED]
---(end of broadcast)
On Friday 24 January 2003 09:26, Ian Barwick wrote:
> On Friday 24 January 2003 07:37, Andre Schubert wrote:
> > i have a little question on changing the length of a varchar field.
> > Is there another way than dump and reload if i want to change the length
> > of a varch
mail: does your test database ever get VACUUMed?
Ian Barwick
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can ge
hand ;-) "urlopie" means
"holiday". I would contact Adam Wojtkiewicz if you have any
more detailed questions ;-)
Ian Barwick
[EMAIL PROTECTED]
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 20, 2003 11:51 PM
> T
m user. This can be done e.g. by passing the appropriate
parameters to pg_ctl along these lines:
/usr/local/pgsql-733/bin/pg_ctl -D /db/pgsql-1 -l /db/pgsql-1.log
-o '-i -p 5431' start
/usr/local/pgsql-733/bin/pg_ctl -D /db/pgsql-2 -l /db/pgsql-2.log
-o '-i -p 5432' start
etc.
r
> I do not specify a schema name?
SET search_path TO ...
http://www.postgresql.org/docs/7.3/static/ddl-schemas.html
You can also use
ALTER USER user_name SET search_path to ...;
to make the setting permanent.
Ian Barwick
[EMAIL PROTECTED]
---(e
ick search. Unfortunately
index seems to be about a month behind.
Ian Barwick
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Wednesday 03 September 2003 09:42, Ian Barwick wrote:
> On Wednesday 03 September 2003 00:26, Marc G. Fournier wrote:
> > okay, first off ... what URL? I've been working on, and testing,
> > archives all week, and altho getting things down below a 2min search
> > app
o insert the value of the varchar column
> in the bytea column, but the conversion won't work.
>
> Something like the following:
>
> update webuser set ccnum = ccnumstring::bytea where userid=userid;
>
> Any ideas how to do this?
Does
update webuser set ccnum = decode(c
23 matches
Mail list logo
