EMAIL PROTECTED]>
Cc: "Andrei Bintintan" <[EMAIL PROTECTED]>;
Sent: Tuesday, April 12, 2005 7:39 PM
Subject: Re: [ADMIN] PostgreSQL replication solution?
John DeSoi wrote:
On Apr 12, 2005, at 2:48 AM, Andrei Bintintan wrote:
I have to do a database replication (of corse pgsql da
Hi to all,
I have to do a database replication (of corse pgsql
database) and I never done something like this. I still read about ...
what replication is.
Can anyone send me some directions, documentation,
ideeas, solutions?
Thanks.
Andy.
Hi,
I wanted to upgrade Postgre Server from 7.4 to
8.0. I downloaded the rpm's and made the upgrade.
I use Suse Linux 9.1. Everything worked fine exept
a single thing: YAST always says that libdb-4.1.so is required by postgresql server( I think it
requires the db4.1). I looked in the B
CREATE TABLE test(
counter SERIAL,
foobar CHAR(18)
DEFAULT to_char(CURRENT_DATE, 'DDMM') ||
trim(to_char(nextval('test_counter_seq'),'00')),
tekst TEXT);
I don't know exactly why the white space is in, but the trim function takes
it out.
Best regards,
Andy.
- Original Message -
CREATE TABLE test(
counter SERIAL,
foobar CHAR(100)
DEFAULT to_char(CURRENT_DATE, 'DDMM') ||
trim(to_char(nextval('test_counter_seq'),'00')),
tekst TEXT);
I don't know exactly why the white space is in, but the trim function takes
it out.
Best regards,
Andy.
- Original Message -
Hi,
I made an update from 7.4.2 to 7.4.7 and pgadmin II
does not connect anymore. The error message is: "The database does not exist on
the server or user authentication failed.". The settings are good, I can connect
with pgadmin III without no problem.
Do you know also any other postgre
Hi,
I have to run some command line commands that I
have to run on a windows machine. Like pgsql, dropdb, createdb etc.
All these commands are runned from a php scripts.
Now, my question is how can I specify a User and
Password to postgresql database system. I found out how can I say
-
We are using these king of comparations and character translations in our
DB.
I really cannot figure out what solution to use.
Best regards,
Andy.
- Original Message -
From: "Ivo Rossacher" <[EMAIL PROTECTED]>
To: "Andrei Bintinta
Hi to all,
We are using pgsql as a "multilanguage" database.
But I noticed yesterday a strange problem with the german umlaut characters. I
cannot convert the in upper case in lowercase. Probably there are also other bad
functionalities.
Now. I searched the internet for answers but th
Hi to all, I have the problem that:
select lower('MöBÜEL') or select upper('MöBÜEL')
are not working well.
I read on some forums that there is some locale
setting that needs to be done here, but could not fix this.
I am using the ASCII encoding.
Please advice.
Thakx.Andy.
Hi to all,
If I create a table with create table and after
that I modify the table(add some columns) in the dump the table is saved in the
same way, I mean, in the dump first the table is created and after that the
column is added.
Is there a possibility to dump the database and the
ta
t for the moment for
diverse reasons, and I would like not to modify any dump anymore.
A strange thing is that this type of dump already worked once
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: "Andrei Bintintan" <[EMAIL PROTECTED]>
Cc:
Hi to all,
I try to dump a database from a 7.4.2 postgre
system and to import it on a 7.3.2. system, but I have a problem with the
sequences in the dump.
This is a seq example:
CREATE SEQUENCE test_id_seq
INCREMENT BY 1 NO MAXVALUE NO
MINVALUE CACHE 1;
This gives me an
Hi to
all,
I have a database, where in the tables I have
around 100 constrains (link to other tables) that don't have a name
"" or they have a name like "$1" "$2". Now, I have a module which
bases on the same structure, but I get some query errors from a
"" constraint. I really don't know
- Original Message -
From: "Tsirkin Evgeny" <[EMAIL PROTECTED]>
To: "Andrei Bintintan" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, September 06, 2004 12:19 PM
Subject: Re: [ADMIN] duplicates
> yes i understand that i can create
- Original Message -
From: "Tsirkin Evgeny" <[EMAIL PROTECTED]>
To: "Andrei Bintintan" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, September 06, 2004 10:57 AM
Subject: Re: [ADMIN] duplicates
> On Mon, 6 Sep 2004, Andrei Bintintan w
I am not sure that I understand clearly your problem. Are you sure that your
query's are written correctly?
For duplicates you can make a uniqe indexing so this will avoid any
dupplicates in your table.
CREATE UNIQUE INDEX table_column_uniqueidx ON table(column);
If the rows are dissapearing, ple
give an example: you have a
table called "person" and you have a columncalled "name" varchar(10) and you
want to change it into varchar(25).alter person add column name_temp
varchar(25);update person set name_temp = name;alter person drop column
name;alter person rename colu
Create a new column
alter add column varchar(25);
Then copy the old column into the new column:
update set = ;
Drop the last column:
alter drop column ;
Rename the column:
alter rename column to ;
Take care for INDEXES if there are any.
This should do it.
Best regards.
- Origin
AIL PROTECTED]>
To: "Andrei Bintintan" <[EMAIL PROTECTED]>
Sent: Monday, December 08, 2003 4:01 PM
Subject: Re: [ADMIN] timestamp field
> On Mon, 2003-12-08 at 19:00, Andrei Bintintan wrote:
>
> thanks for reply
> Yes i want for all the tables.
> But the problem is i
Hi,
I don't know if there is such a command, with my experience I think there
isn't such one.
Do you need it for all the tables?? Put a field like timestamp and put the
default value: now()... it will update automatically, so you don't have to
bother with it.
Best Regards.
Andy.
- Original M
Look in postgresql.conf file:
#
# Message display
#
server_min_messages = info # Values, in order of decreasing detail:
# debug5, debug4, debug3, debug2, debug1,
# info, notice, warning, error, log, fatal,
# panic
client_min_messages = info # Values, in order of decreasing det
Hi,
I have the following table:
CREATE TABLE public.rights (id int4 DEFAULT
nextval('"rights_id_seq"'::text) NOT NULL, id_user int4 NOT NULL, id_modull int4 NOT NULL, CONSTRAINT rights_pkey PRIMARY KEY (id))
and I created the following indexes:
CREATE INDEX right_id_modull_idx ON
rights
Look in postgresql.conf file:
#
# Message display
#
server_min_messages = info # Values, in order of decreasing detail:
# debug5, debug4, debug3, debug2, debug1,
# info, notice, warning, error, log, fatal,
# panic
client_min_messages = info # Values, in order of decreasing det
Hi,
We are developing a management software for our clients. This software si
already used for a year. The database dump is around 40MB(zipped around 10).
Our clients receive every day between 100 - 200 photos(size between
80-200kB). For the moment they have around 3 photos, the overall size o
files, maybe I find there something.
If I found something "strange" I post it.
Thankx to all.
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: "Andrei Bintintan" <[EMAIL PROTECTED]>
Cc: "[ADMIN]" <[EMAIL PROTECTED]>
--- Original Message -----
From:
Andrei
Bintintan
To: [EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 3:04
PM
Subject: [ADMIN] Sensitive sort
problem?
Hi to everyone,
I don't know exactly if i'm sending my problem
in the rig
Are there many images?
I do not suggest to store the images in the database. Better save them on
the disk and in the database save only the path to the image. Think also to
the size of the dump(with images).
It is more easy to handle this way.
This is my opinion.
Best regards.
Andy.
- Orig
files, maybe I find there something.
If I found something "strange" I post it.
Thankx to all.
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: "Andrei Bintintan" <[EMAIL PROTECTED]>
Cc: "[ADMIN]" <[EMAIL PROTECTED]>
sage -----
From:
Andrei
Bintintan
To: [EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 3:04
PM
Subject: [ADMIN] Sensitive sort
problem?
Hi to everyone,
I don't know exactly if i'm sending my problem
in the right place, hope
Hi to everyone,
I don't know exactly if i'm sending my problem in
the right place, hope you can help me.
I use postgresql db. 7.3.2.
Today I noticed that my database does not sort
"case sensitive" anymore. If I have a query like:
Select name from names order by name -- the
names are
31 matches
Mail list logo
