"Justin Dearing" <[EMAIL PROTECTED]> writes:
> It seems I can feed a default value to a domain that won't fit in the
> underlying base type. I have the domain html_colors as so:
> CREATE DOMAIN html_color AS char(7) CHECK (VALUE ~ '^#[A-Fa-f0-9]{6}$');
> I then defined a column of html_colors as
I have a table with 15 cols , there is an joint index on 5 of them
there are ~15million records in the table, and it gets heavy use via
update & insert
i recently noticed that after a day of use, the index is no longer
being respected in some/all queries and a seq scan on the table is use
It seems I can feed a default value to a domain that won't fit in the
underlying base type. I have the domain html_colors as so:
CREATE DOMAIN html_color AS char(7) CHECK (VALUE ~ '^#[A-Fa-f0-9]{6}$');
I then defined a column of html_colors as so:
ALTER TABLE users ALTER COLUMN profile_color SET
Login in as administrator, take ownership using NTFS permissions, and
cane it.
~BAS
On Sat, 2007-03-31 at 12:26 -0300, Jonathan Barbero wrote:
> Hello.
>I installed Pg some time ago. Now i desinstalled it and try to
> reinstall, but the instalation program can´t finish. It throw a
> proble
"Eric B. Ridge" <[EMAIL PROTECTED]> wrote:
>
> Hi! We've got a Postgres 8.1.5 installation with a 60GBish database:
>
> =# select version();
> version
>
> ---
> PostgreSQ
On Sat, Mar 31, 2007 at 03:18:35PM -0400, Eric B. Ridge wrote:
> Anyways, we run a VACUUM FULL ANALYZE VERBOSE every night, and it's
> now taking 3+ hours to complete. We also have autovacuum turned on
> with default settings. This 3+ hour vacuum time is cutting into our
> production hours.
Please send specific error messages and schemas if possible. ~BAS
On Sat, 2007-03-31 at 16:47 -0400, Harpreet Dhaliwal wrote:
> Hi,
> Upto the point when i don't have FKs in my database, things work fine.
> As soon as i put FK in all the tables referencing to a field of one
> single table, nothi
Hi,
Upto the point when i don't have FKs in my database, things work fine.
As soon as i put FK in all the tables referencing to a field of one single
table, nothing is inserted.
Is it an indexing issue?
Can anyone throw some light on this?
~Harpreet
how do u do reindexing?
On 3/31/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Jasbinder Singh Bali" <[EMAIL PROTECTED]> writes:
> DBD::Pg::st execute failed: ERROR: duplicate key violates unique
constraint
> "pk_verify_mx"
> I don't know whats goin on.
Corrupt index maybe? Does REINDEXing the pk
Hi! We've got a Postgres 8.1.5 installation with a 60GBish database:
=# select version();
version
---
PostgreSQL 8.1.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
4
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/31/07 12:48, Joshua D. Drake wrote:
>
>> H. Maybe I'm just in a grumpy mood today, but that really
>> Grinds My Gears.
>>
>> Anyone who an figure out how to use PostgreSQL can figure out how to
>> use apt-build.
>
> Hardly. I have more tha
"Jasbinder Singh Bali" <[EMAIL PROTECTED]> writes:
> DBD::Pg::st execute failed: ERROR: duplicate key violates unique constraint
> "pk_verify_mx"
> I don't know whats goin on.
Corrupt index maybe? Does REINDEXing the pk index help?
regards, tom lane
On 4/1/07, Mikko Partio <[EMAIL PROTECTED]> wrote:
> Subject says it all. Doing a source compile under Debian or
> Debian-like condition is not an option for the end user. They need
> an apt-get (the ubuntu equivalent to rpm AFAICT) version.
>
> Unfortunately, the latest I can find is 8.1.8
> W
Hi
I have a compostie primary key in my table comprising of 3 fields.
My systems tries to enter records in this table for which the combination of
these 3 fields is not there at all
The new record gets inserted but with the following error being displayed on
console
DBD::Pg::st execute failed:
H. Maybe I'm just in a grumpy mood today, but that really
Grinds My Gears.
Anyone who an figure out how to use PostgreSQL can figure out how to
use apt-build.
Hardly. I have more than my fair share of customers that:
1. Develop on windows (in php)
2. Only use winscp
3. Couldn't configur
Csaba Kalman <[EMAIL PROTECTED]> writes:
> Tom Lane writes:
>> Hm, what can you say about the data that goes into the three columns
>> that have hash indexes? I'm going to try testing this with random data,
>> but it'd likely be more useful if I could reproduce your data
>> distribution.
> [ some
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/31/07 11:51, Alexander Staubo wrote:
> On Mar 31, 2007, at 12:19, Ron wrote:
>
> Subject says it all. Doing a source compile under Debian or Debian-like
> condition is not an option for the end user. They need an apt-get (the
> ubuntu equivale
On Mar 31, 2007, at 12:19, Ron wrote:
Subject says it all. Doing a source compile under Debian or Debian-
like condition is not an option for the end user. They need an apt-
get (the ubuntu equivalent to rpm AFAICT) version.
Ubuntu has 8.2.3 in the upcoming Feisty distribution; in the
mea
Doing a source compile under Debian or Debian-like condition is not an option
for the end user.
Oh, it is not? Is that because of the outdated tool chain Debian ships
with or the user being uncomfortable in typing 3 commands at a shell prompt?
Unfortunately, the latest I can find is 8.1.8
Hello.
I installed Pg some time ago. Now i desinstalled it and try to
reinstall, but the instalation program can´t finish. It throw a problem and
say that i can see the log file. When i want to see it I can´t access to the
directory that I created to install Pg.
I did this two times. I restart
I've never worked with a database with arrays, so I'm curious what the
advantages and disadvantages of using it are. For example:
-- METHOD 1: The "usual" way --
Items table:
item_id int,
item_data1 ...,
item_data2 ...
Primary Key = item_id
ItemSet table: <-- Join table
item_id int,
Hi!
Try this one:
SELECT
a.ug_id,
b.ug_users[a.generate_series]
FROM
(SELECT
ug_id,
generate_series(1, array_upper(ug_users, 1))
FROM
user_group
) AS a,
user_group AS b
WHERE
a.ug_id = b.ug_id;
veejar wrote:
Hi!
I have such table:
user_group
Tom Lane writes:
csaba <[EMAIL PROTECTED]> writes:
Here is the CREATE script of the table which is most likely to be one
source of the error. The last error happened after an insert into this
table.
Hm, what can you say about the data that goes into the three columns
that have hash indexes? I
Hi!
I have such table:
user_group
-
ug_id -> serial primary key
ug_users -> int4[]
For example table has such rows:
ug_id | ug_users
---+--
1| { 2,5,6 }
2| { 3,4,9 }
I want to write SQL-query or write user defined function to get suc
> Subject says it all. Doing a source compile under Debian or
> Debian-like condition is not an option for the end user. They need
> an apt-get (the ubuntu equivalent to rpm AFAICT) version.
>
> Unfortunately, the latest I can find is 8.1.8
> Where's 8.2.3?
>
What ubuntu version do you have? I
Subject says it all. Doing a source compile under Debian or
Debian-like condition is not an option for the end user. They need
an apt-get (the ubuntu equivalent to rpm AFAICT) version.
Unfortunately, the latest I can find is 8.1.8
Where's 8.2.3?
Help?
Ron
---(end of
26 matches
Mail list logo
