Martijn van Oosterhout wrote:
>
> We used pg_dump in various ways, all with the date style "iso"
> but always some of the dates appeared to be translated wrong.
> Eventually we worked out that even though the datestyle was
> set to "iso" on both machines, the old postgres read it as
> "ISO with e
many thanks both andrew and ryan =)
- Original Message -
From: "ryan" <[EMAIL PROTECTED]>
To: "Mike Sears" <[EMAIL PROTECTED]>
Cc: "pgsql-general" <[EMAIL PROTECTED]>
Sent: Tuesday, August 22, 2000 2:40 PM
Subject: Re: [GENERAL] php update problems
> > Mike Sears wrote:
> >
> > Having
> Mike Sears wrote:
>
> Having a slight problem w/ my postgres database. for some reaons its
> no longer updating anymore, and for what reason I'm unsure
>
> if I'm right then the below "should" update the table I'm working in,
> though it doesn't. Is ther indeed something wrong here?
>
> requ
Having a slight problem w/ my postgres database.
for some reaons its no longer updating anymore, and for what reason I'm
unsure
if I'm right then the below "should" update the
table I'm working in, though it doesn't. Is ther indeed something wrong
here?
require("dbconect.inc.php");
$resu
On Tue, 22 Aug 2000, Darrin Ladd wrote:
> Hi,
>
> I was wondering if there is a way to have a foreign key reference to the
> primary key column of all tables throughout an inheritance tree. For
> example, I have a parent_table with a unique_id (type serial) and a child
> table which inherits
See http://www.greatbridge.com/news/p_081620001.html - we increased the
cache, ran a vacuum analyze, a few minor things.
Regards,
Ned
"Poul L. Christiansen" wrote:
> It would be interesting to see how well PostgreSQL performed when it was
> tuned.
>
> Or has it allready been tuned?
>
> Ned Lill
I've wondered that myself, actually. What are the benefits and
drawbacks to going with one over the other, besides the obvious 255-char
field length limit for varchar? The reason to stay away from "memo"
fields in other serious RDBMSs are typically more difficult maintenance,
significantly lower
On Tue, 22 Aug 2000, Tom Lane wrote:
> Tressens Lionel <[EMAIL PROTECTED]> writes:
> > Le 22.08.00 a 09:37, "Roderick A. Anderson" m'ecrivait :
> > )I was able to get the table format by using MS Access. Only question left
> > )is what is the corresponding field type in PostgreSQL for a memo fie
> I've seen brief posts regarding server loads, distrubution for heavy
loads,
> etc, but don't recall if there were any solutions...
>
> Anyways...We are running a Postgres DB against multiple frontend
> webservers. For most of the time, everything runs fine. Then, all of a
> sudden, everything
"Arthur M. Kang" <[EMAIL PROTECTED]> writes:
> When I log onto the DB server and try to do anything, I get "Too many open
> files in system."
Sounds like you need to regenerate your kernel with larger NFILE and/or
NINODE parameters. Can't give you details about how to do this since
every Unix p
you could "hide" or mask columns through views...
mikeo
At 02:10 PM 8/22/00 -0700, Mike Sears wrote:
In mysql you can make some data apear to be garbled or hiddne, I'm wondering if this can be done using psql?
Hi,
I was wondering if there is a way to have a foreign key reference to the
primary key column of all tables throughout an inheritance tree. For
example, I have a parent_table with a unique_id (type serial) and a child
table which inherits the parent_table (inheriting the unique_id). I woul
I've seen brief posts regarding server loads, distrubution for heavy loads,
etc, but don't recall if there were any solutions...
Anyways...We are running a Postgres DB against multiple frontend
webservers. For most of the time, everything runs fine. Then, all of a
sudden, everything will sta
Tressens Lionel <[EMAIL PROTECTED]> writes:
> Le 22.08.00 a 09:37, "Roderick A. Anderson" m'ecrivait :
> )I was able to get the table format by using MS Access. Only question left
> )is what is the corresponding field type in PostgreSQL for a memo field in
> )SQL Server/Access (varchar())?
>
In mysql you can make some data apear to be garbled
or hiddne, I'm wondering if this can be done using
psql?
I hate it when I do this. See an answer I want and run with it rather
than find the real answer.
Turned out the data files (.mdb) _didn't_ belong to the database. They
were a piece of the database that was used for a report.
Back to the old grind wheel.
Rod
--
Roderick A. Anderson
[EMAIL PRO
At 4:26 PM -0400 8/21/2000, Tom Lane wrote:
>Michael Blakeley <[EMAIL PROTECTED]> writes:
>> Do I need to tell postgres to rebuild pg_language, perhaps?
>
>See the createlang utility script. PL languages aren't installed
>by default (due to possibly-overzealous concern about security).
Thanks -
Le 22.08.00 a 09:37, "Roderick A. Anderson" m'ecrivait :
)I was able to get the table format by using MS Access. Only question left
)is what is the corresponding field type in PostgreSQL for a memo field in
)SQL Server/Access (varchar())?
'text' type perhaps ?
Lionel
A thanks to everyone on this list and especially; Jeffery Rhines, Chris
Knight, Chris Bitmead, and Sevo Stille.
The solution turned out to be very simple. After catching a SCSI BUS
speed mismatch problem which caused a NT Backup 'Restore' failure I
discovered that the actual data was in .mdb fil
It would be interesting to see how well PostgreSQL performed when it was
tuned.
Or has it allready been tuned?
Ned Lilly wrote:
> Folks,
>
> We posted the following announcement on our website today, at
> http://www.greatbridge.com/news/press.html.
>
> Please feel free to email me off-list with
Folks,
We posted the following announcement on our website today, at
http://www.greatbridge.com/news/press.html.
Please feel free to email me off-list with any questions.
Thanks,
Ned
UPDATE, August 22, 2000:
MySQL performance improves with tuning suggestions from development
team;
PostgreSQ
On Tue, Aug 22, 2000 at 01:50:26PM +0400, Alex Guryanow wrote:
> Hi,
>
> postgresql 7.0.2. Why by executing the following query
>
> select * from magazine
> where id in (
> select mag_id from dict where word = 'akademie' intersect
> select mag_id from dict where word = 'der' intersec
Hi,
postgresql 7.0.2. Why by executing the following query
select * from magazine
where id in (
select mag_id from dict where word = 'akademie' intersect
select mag_id from dict where word = 'der' intersect
select mag_id from dict where word = 'klasse' )
I receive the followin
23 matches
Mail list logo
