Thank you for the clarifications.
I wanted to do somthing like this.
say phone_no is a domain defined as varchar(25)
and i want to use this domian in all DDLs. say one fine day
i realize varchar(25) is not sufficient then i was planning
to do something like alter domain phone_no varcahr(100)
so
Bruce Momjian <[EMAIL PROTECTED]> writes:
> No, ALTER DOMAIN will only be in 7.4.
And possibly not then either ;-). There are some rather serious
problems with the current patch --- unless Rod can resolve them
satisfactorily, I think we'll have to back out the feature.
re
Jefim Matskin writes:
> I have an external data source that holds some japaneese data in the
> UTF-8 encoding. I'm managing to read this data source and insert the
> data into my postgres database. The troubles start when I'm try to
> display the data using SJIS client encoding. The data is retur
OK, I wonder if adding -ldl will help. You need to link to the library
containing the ldopen function.
---
Shibashish wrote:
> Thanks for the help. I edited the src/makefiles/Makefile.sco and removed
> the export. But the c
No, ALTER DOMAIN will only be in 7.4.
---
Rajesh Kumar Mallah. wrote:
>
>
> Hi,
>
> Does any patch to 7.3 stable exists for ALTER DOMAIN
> command i vaguely rember someone (mostly bruce) mentioning
> it in a reply.
>
>
Hello Paul:
What user are you using. Remember, you have a
brand new install and haven't created any users yet, except for the
superuser(postgres). Try connecting as the postgres(superuser).
---(end of broadcast)---
TIP 3
hi,
how can I get default username and password
for connecting with PostgreSQL server?
thanks.
To
succeed in life is to wake every morning of each season knowing that my loved ones and I
will be securely provided for!"- Unknown Author
This email could change the direction of your life!
Our program is free to join! If you want to be able to quit your job within a
On Thu, Dec 05, 2002 at 02:18:15PM -0500, Bruce Momjian wrote:
>
> I don't think you can drop/recreate the sequence because the dependency
> code knows other tables depend on it.
Actually, I don't think the current dependency code notices if you use a
sequence in a default clause (other than via
An empty database cluster takes up 20 MB, 16 of which
are dedicated to a WAL file. This seems to be a lot
for a small or low-traffic database. Is there any way
to reduce the size of this WAL file, besides reverting
to version 7.0 (where WAL isn't used)?
Thanks -Erin
___
Just a friendly reminder tedia2sql: DIA ERD diagrams to SQL DDL for
Postgres and many other RDBMSs!
The code must have become quite stable. The mailing list traffic has had
0 messages for some weeks now. The last patch was from Christopher
Bowland to add Win32 friendliness to the script (ie: not m
Around 20:41 on Dec 4, 2002, Hannu Krosing said:
What's wrong with this:
dustin=# create sequence test_seq;
CREATE SEQUENCE
dustin=# select nextval('test_seq');
nextval
-
1
(1 row)
dustin=# select setval('test_seq', );
setval
(1 row)
dustin=# select
I have 2 sites with a wireless link between them.
Is it possible to run a mirror server each side of the connection so that
clients only query those servers locally?
I'm sure this muct have been covered but tbh I'm damned if I can find it.
TIA for any assistance.
---(e
Oliver Elphick kirjutas K, 04.12.2002 kell 19:06:
> On Wed, 2002-12-04 at 12:29, raja kumar thatte wrote:
> > Hai friends,
> > I have a sequence called raj_seq with max value 3000.
> ...
> > now i wanted to increase the max value of the raj_seq
> > to 999.
> > How to do this change?
> > If i dr
Greetings Raj,
I found this to be helpful:
SELECT tgname, tgenabled AS tf, tgconstrname FROM pg_trigger ;
Rajesh Kumar Mallah. wrote:
> Hi ,
>
> What is the correct method of temporarily
> disabling all triggers from a table?
>
>
> also is there any command/function to show the
> trigger
Thanks for the help! That worked just fine.
I also found this (from within psql):
# \l
List of databases
Database | Owner
---+--
template0 | postgres
template1 | postgres
testdb| postgres
(3 rows)
And this from command-line:
$ /usr/local/pgsql/bin/psql -l
Password:
Good day to all, It forgives for the bad English,
I use MS Visual FoxPro 6 and am writing an application using the BD PostGreSQL version 7.2.3, but I am finding problems of communication between the Fox and the ODBC (version 7.02.0004), when I create one view that it uses calculated fields of the n
Hi,
Does any patch to 7.3 stable exists for ALTER DOMAIN
command i vaguely rember someone (mostly bruce) mentioning
it in a reply.
i would want to change the domain def at one place and see
its effect in all the tables using it.
regds
mallah.
--
Rajesh Kumar Mallah,
Project Manager (Deve
UltraMax <[EMAIL PROTECTED]> writes:
> I have upgraded PostgreSQl from version 7.2.2 to 7.3
> All working fine, but in the serverlog I often see following:
> ERROR: 'ksqo' is not a valid option name
> In previous versions I did not see that message
> Could someone clarify this very error
Thanks!!
lemme check it out.
mallah.
On Tuesday 10 December 2002 07:07 pm, Oleg Bartunov wrote:
> known problem and fixed in CVS
> Get patch from http://www.sai.msu.su/~megera/postgres/gist/
>
> Oleg
>
> On Tue, 10 Dec 2002, Rajesh Kumar Mallah. wrote:
> > Hi,
> >
> > tserach seems to have some
Hello pgsql-admin,
I have upgraded PostgreSQl from version 7.2.2 to 7.3
All working fine, but in the serverlog I often see following:
ERROR: 'ksqo' is not a valid option name
In previous versions I did not see that message
Could someone clarify this very error and the way of getting rid
known problem and fixed in CVS
Get patch from http://www.sai.msu.su/~megera/postgres/gist/
Oleg
On Tue, 10 Dec 2002, Rajesh Kumar Mallah. wrote:
>
> Hi,
>
> tserach seems to have some problem with 7.3 Stable.
>
> test=# SELECT version();
> version
> -
Hi,
tserach seems to have some problem with 7.3 Stable.
test=# SELECT version();
version
---
PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
test=# SELECT 'hello&world'::mquery_txt ;
mquery_
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 Unicode encoding
(createdb -E unicode ...)
I have an external data source that holds some japaneese data in the UTF-8 encoding.
I'm mana
Hi, I will do this programatically but I wished to post this question just to
know if somebody have any suggestion, because I am new to server side functions
or rules or trigger programming.
I want to log any data change in one application, for audit reasons, I created a
table for that purpose the
25 matches
Mail list logo
