Costin Grigoras <[EMAIL PROTECTED]> writes:
> how could duplicate records appear when the unique index existed ?
Good question. I have a sneaking suspicion that your trigger might be a
contributing factor, but I'm not sure how. Can you provide a
self-contained test sequence to reproduce the prob
Frank Illner <[EMAIL PROTECTED]> writes:
> [ initdb fails on suse 8.2 ]
That seems quite odd. I don't know what's going on, but I can suggest
how to find out. Please rebuild with
./configure --enable-debug --enable-cassert
Then run the initdb with -n added to the command line. The seg
Hello !
I just find out that if i try to use VACUUM inside the transaction
block, than it's fail (VACUUM cannot run inside a transaction block).
Ok, I'll vacuum after transaction, but why commit proceed without
errors,
so I can think that my update committed :
isbs=# begin;
BEGIN
isbs=# upda
Jari Aalto wrote:
> Thank you. That did it. May I suggest adding this:
>
>
> --- INSTALL.old 2004-01-17 13:34:22.0 +0200
> +++ INSTALL 2004-01-17 13:33:32.0 +0200
> @@ -15,6 +15,7 @@
>mkdir /usr/local/pgsql/data
>chown postgres /usr/local/pgsql/data
>su - postgre
I originally sent to this to the pgsql-general mailing list as I was
not sure if this was a bug or not. It seems likely that it is so I am
sending it on to here.
I create a table called wibble:
CREATE TABLE wibble (a integer, b integer);
I insert some data:
INSERT INTO wibble VALUES (1,1);
I d
hello,
i encountered the following problem :
mail=# \d user_preferences
Table "public.user_preferences"
Column | Type | Modifiers
--+-+---
up_uid | integer |
up_id| integer |
up_value | text|
Indexes:
"user_preferences_id_uid_uidx" unique, btree (up
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
> I tried to install all from fresh with:
> ...
> But that dind't affect the groups or users. This was verified by running
> select from pg_group and pg_users immedately after total recreation.
Tom Lane:
Your trace s
hi,
i try to install the pgsql versin 7.3.4. on a new computer.
The installing steps where sucsessful:
./configure
gmake
su
gmake install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
when i try to create thr db-cluster with "/usr/local/pgsql/bin
POSTGRESQL BUG REPORT TEMPLATE
Your name : Mauro Folcarelli
Your email address : [EMAIL PROTECTED]
System Confi
On Sun, 11 Jan 2004, Peter Eisentraut wrote:
PE> Denis N. Stepanov wrote:
PE> > snprintf()/vsnprintf() functions are not ANSI-compliant
PE>
PE> Yes, they are.
Sorry, I was talking about ANSI X3.159-1989, which certainly does not declare
snprintf(). In practice it is diffucult to count on, say, C9
Dear Sir/Madam,
For professional s/w development, I want to use PostgreSQL. According to documentation (FAQ_MSWIN), I have installed cygwin on my PC. After installation I have started ipc-daemon2 by command on cygwin shell. it worked fine. Then used initdb command to create new database cluster us
This *might* be a case where you want to define table B using the LIKE
clause, rather than inheritance. Then you could modify table B as you
please: dropping constraints or columns, etc.
== Ezra Epstein
---(end of broadcast)---
TIP 3: if posting/
[EMAIL PROTECTED] ("PostgreSQL Bugs List") writes:
> Description:Configuration should be in /etc/postgres
>
> Details:
>
> It would be better if postgres kept the configurations files in
> standard /etc location. Like under /etc/postgres
This "fix" would prevent people from having multipl
The following bug has been logged online:
Bug reference: 1054
Logged by: Jim Donovan
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4
Operating system: linux
Description:inefficient compression of doco html files
Details:
In the bzip2 tarballs, the doco
14 matches
Mail list logo
