Dennis Gearon <[EMAIL PROTECTED]> writes:
> If found this twice in the 7.3.2 User Manual:
> ALTER TABLE products ADD COLUMN description text CHECK (description <> ”);
Where exactly? All I see is description <> '' ...
regards, tom lane
---(end of b
If found this twice in the 7.3.2 User Manual:
ALTER TABLE products ADD COLUMN description text CHECK (description <> â);
Shouldn't there be TWO parenthesis marks?
---(end of broadcast)---
TIP 8: explain analyze is your friend
"Development - multi.art.studio" <[EMAIL PROTECTED]> writes:
> after updating some of my databases, everything works fine, except my
> backupscripts.
> any suggestions?
Set up a ~/.pgpass file for the account that's running the backup job.
Or switch to a non-password-based authentication mechanis
On Mon, May 03, 2004 at 03:42:04AM +0200, Development - multi.art.studio wrote:
> i have a question about backing up my fresh updated databases :)
> after updating some of my databases, everything works fine, except my
> backupscripts.
> i run this script as root from cronjob with su - postgres -
Hello to the List,
i have a question about backing up my fresh updated databases :)
after updating some of my databases, everything works fine, except my
backupscripts.
i run this script as root from cronjob with su - postgres -c "...script..."
it works fine with postgres 7.1, but in 7.4.2 somethi
Alexander Cohen wrote:
> I understand that, but i still really need some kind of reference on
> what files do what. Does anything of that sort exist?
Not really. Read the man pages for the programs, use "strings" to see
what files they might open, use "ldd" to see what libraries are used,
delet
I understand that, but i still really need some kind of reference on
what files do what. Does anything of that sort exist?
thanks!
--
Alexander Cohen
http://www.toomuchspace.com
(819) 348-9237
(819) 432-3443
On May 1, 2004, at 5:01 PM, Peter Eisentraut wrote:
Alexander Cohen wrote:
Im looking to
On Fri, 30 Apr 2004, Rachel McConnell wrote:
> Hello,
>
> I have a Java web application using Hibernate to connect to a PostgreSQL
> backend. I am seeing the below stack trace during processing of a set
> of data consisting of around 1000 objects; for a 200 object set I don't
> see the exce
on 5/1/04 3:11 PM, [EMAIL PROTECTED] purportedly said:
> Keary Suska <[EMAIL PROTECTED]> writes:
>> I received the following errors from an automated full vacuum:
>> vacuumdb: vacuuming of database "milemgr" failed: ERROR: tuple concurrently
>> updated
>
> Hm, could you have had more than one of
Tom Lane wrote:
I've gotten a couple of inquiries lately about a Postgres users' group
in my home town of Pittsburgh PA. There is not one (unless it's very
well camouflaged) but perhaps there is critical mass to create one.
If you think you might come to meetings of such a group, let me know
off-l
On Sun, May 02, 2004 at 03:51:44 -0400,
Ryan Riehle <[EMAIL PROTECTED]> wrote:
> Thanks for your input. Yes, there is a lot more to this part of the schema.
> The current stucture makes the most sense to us so far, after lots of
> thinking. If you are interested I can offer you more details abou
Thanks for your input. Yes, there is a lot more to this part of the schema.
The current stucture makes the most sense to us so far, after lots of
thinking. If you are interested I can offer you more details about the
structure, but for now I am looking for how to implement this type of
constraint
12 matches
Mail list logo
