Thanks for all your help Michael!
I am having one problem I just can't figure out In my dump file I
have something like:
CREATE SEQUENCE testschema.industries_industry_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
);
CREATE TABLE testschema.industries (
industry_i
Hi,
we saw the following problem:
We deleted all rows from a table B referencing table A (~50 records). No
problem, but the following try to delete all records from table A (~18) lead
to a "never ending" statement. We found out, that vacuuming table B after delete
did the trick.
It seem
Hi,
I have windows app written in Borland C++ Builder 5.0. Using ODBC
driver windows app connects to database on linux server. Database is
created with UNICODE encoding.
When pg-server is version 7.1.3 windows app works fine, but when
pg-server is version 7.4.6 or 8.0beta4 under certain condition
On Sun, Nov 21, 2004 at 12:27:11AM -0700, Net Virtual Mailing Lists wrote:
> I am having one problem I just can't figure out In my dump file I
> have something like:
> CREATE SEQUENCE testschema.industries_industry_id_seq
> INCREMENT BY 1
> NO MAXVALUE
> NO MINVALUE
> CACHE 1;
I made something for one of my projects. I'm really not happy with it
(it borders on unmaintainable) but it does work and if you're desperate
I could share. But I wouldn't be unhappy if you rolled your own, so I
could use that. :)
On Nov 20, 2004, at 7:33 PM, Casey Duncan wrote:
Anyone know of
On Sun, 21 Nov 2004, Cornelius Buschka wrote:
> Hi,
>
> we saw the following problem:
>
> We deleted all rows from a table B referencing table A (~50 records). No
> problem, but the following try to delete all records from table A (~18)
> lead
> to a "never ending" statement. We found ou
I'm after a good report generator for a postgresql database. I am
using Rekall at the moment which is quite good but I'm not quite able
to do some of the things I want.
Has anyone got any recommendations for forms/reports generators for
postgresql? I can probably get the forms I want from Rekall
Suppose I have vacuum_values() function, which removes all
"no longer referenced" by parent column. Kind of function
to be run from time to time to clean table from crud.
It looks like this:
CREATE FUNCTION vacuum_values() RETURNS void AS $$
DECLARE
r RECORD;
BEGIN
Alex Guryanow <[EMAIL PROTECTED]> writes:
> When pg-server is version 7.1.3 windows app works fine, but when
> pg-server is version 7.4.6 or 8.0beta4 under certain conditions the
> app receives strings with wrong lengths.
Are both servers set up with the same database encoding? (Is the 7.1
server
See comments below..
>On Sun, Nov 21, 2004 at 12:27:11AM -0700, Net Virtual Mailing Lists wrote:
>
>> I am having one problem I just can't figure out In my dump file I
>> have something like:
>> CREATE SEQUENCE testschema.industries_industry_id_seq
>> INCREMENT BY 1
>> NO MAXVALUE
>>
From: "Net Virtual Mailing Lists" <[EMAIL PROTECTED]>
> See comments below..
>
>
> >> CREATE TABLE testschema.industries (
> >> industry_id integer DEFAULT nextv
> >> al('"testschema.industries_industry_id_seq"'::text) NOT NULL,
> >> [...]
> >>
> >> When I try to insert a value into sche
Suppose I have vacuum_values() function, which removes all
"no longer referenced" by parent column. Kind of function
to be run from time to time to clean table from crud.
It looks like this:
I suppose you have a good reason to not use a foreign key with "ON DELETE
CASCADE" ?
F
"Net Virtual Mailing Lists" <[EMAIL PROTECTED]> writes:
> CREATE TABLE testschema.industries (
> industry_id integer DEFAULT
> nextval('"testschema.industries_industry_id_seq"'::text) NOT NULL,
> pg_dump created it with the double quotes, I have been modifying the dump
> to make it so appropriate
On Mon, 22 Nov 2004 00:16:07 +0100, Pierre-Frédéric Caillaud
<[EMAIL PROTECTED]> wrote:
>
> > Suppose I have vacuum_values() function, which removes all
> > "no longer referenced" by parent column. Kind of function
> I suppose you have a good reason to not use a foreign key with "ON
> DE
I am wondering if it is possible to pick up a database from one computer and
move it over to another and then just plug it back in.
It appears that a database is stored inside of a directory that is named
after the db's OID. The directory contains what I am guessing are
individual files that are
John DeSoi wrote:
>
> On Nov 19, 2004, at 7:13 AM, Jim Seymour wrote:
>
>>
>>>It does
>>> not use Java ...
>> [snip]
>>
>> This is supposed to be an advantage?
>
> Absolutely. The situation on Linux and Windows may be better, but i
There's some basic database issues you should follow, no matter what your
database engine.
Index your columns, but with reason, do not index a column that only
contains several distinct values (such as yes/no fields). Inde xover several
columns if your queries can narrow the resultset using mor
Kenneth Downs <[EMAIL PROTECTED]> writes:
> I am wondering if it is possible to pick up a database from one computer and
> move it over to another and then just plug it back in.
No, unless you do the whole database cluster, and the two machines are
the same architecture and have the same version
i have a table with a 'timstamp with time zone' column.
when i insert into it:
'18 Nov 2004 00:00:00 PST'
...it looks like:
2004-11-18 03:00:00-05
...once stored in the database.
0 o'clock vs. 3 o'clock.
is it storing in the time zone of the actual server or something? not
sure where my db server
On Sun, Nov 21, 2004 at 07:58:37PM -0600, P. George wrote:
> is it storing in the time zone of the actual server or something? not
> sure where my db server actually, physically is.
See the documentation for Date/Time Types and Date/Time Functions
and Operators:
http://www.postgresql.org/docs/
See the documentation for Date/Time Types and Date/Time Functions
and Operators:
http://www.postgresql.org/docs/7.4/static/datatype-datetime.html
http://www.postgresql.org/docs/7.4/static/functions-datetime.html
if so, does that imply that i can translate these stored dates to any
target time zone
On Nov 22, 2004, at 11:30 AM, P. George wrote:
well... the examples in the documentation work, but they only use
static dates (hard-coded, i mean):
SELECT TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-05' AT TIME ZONE
'PST';
but, when i try:
SELECT mydatecolumn FROM mytable AT TIME ZONE 'PST';
oops. that did it. ;-)
thanks.
- philip
On Nov 21, 2004, at 8:42 PM, Michael Glaesemann wrote:
On Nov 22, 2004, at 11:30 AM, P. George wrote:
well... the examples in the documentation work, but they only use
static dates (hard-coded, i mean):
SELECT TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:
On Nov 19, 2004, at 10:14 AM, Kenneth Downs wrote:
It may be simpler to define syntax coloring rules for the popular
editors,
such as vim.
A good PostgreSQL editor is only the first component pgEdit. Version
1.1 will have a psql-like terminal interface with syntax coloring and
full screen editin
USA Homeland Security also uses it, but I can't say how I know. :-)
---
Joshua D. Drake wrote:
> Jeff Amiel wrote:
> > Not to question your data, but where did the info about the navy and
> > army using it come from? I sa
On Sun, Nov 21, 2004 at 07:29:26PM +0100, Dawid Kuroczko wrote:
> Of course I can move all this logic outside of backend, and make
> the backend just 'do' the DELETEs, ignoring errors... But still,
> it should be doable in the procedural languages aswell.
In PostgreSQL 8.0, PL/pgSQL function
I've been spending the last few days converting many databases into a
single schema and have completed the process, but now I'm at somewhat of
an impasse as to the best way to proceed forward
It is important for me to explain that each of these databases has a
rather different structure, going
Am 2004-11-16 14:43:26, schrieb Marco Bizzarri:
> Hi all.
>
> I would like to know if postgresql has any certification for the
> military environment.
You mean "Common Criteria EAL-5". I am working for the french
governement and currently we have only EAL-4 for around 30 packages
from Debian GNU
Am 2004-11-21 21:59:46, schrieb Bruce Momjian:
>
> USA Homeland Security also uses it, but I can't say how I know. :-)
Yes, because you are working for it :-)
And I can tell you, that I was 12 years in the French Legion and
since 1995 I am working in a military internal service (IT).
We are u
On Nov 19, 2004, at 2:37 AM, Jerry III wrote:
Do not use variable length types.
Why do you suggest not using variable length types?
Patrick B. Kelly
--
http://patrickbkelly.org
---(end of broad
30 matches
Mail list logo