"Josué Maldonado" <[EMAIL PROTECTED]> wrote:
>
> El 13/08/2004 10:50 AM, [EMAIL PROTECTED] en su mensaje
> escribio:
> > ...
> > insert into table1 (field1) values (1);
> > insert into table1 (field1) values (1);
> > insert into table1 (field1) values (2);
> >
> > and then select * from table1, you
Wouldn't it be cool if someday psql could do value completion?
# delete from person where lastname = 'Garam
# delete from person where lastname = 'Garamond' _
# delete from person where firstname = 'Da
# delete from person where firstname = 'Da
Damian Darren DaveDavidDawson
# delete
Yep, use the serial datatype. And then use the helpful documention. :)
http://www.postgresql.org/docs/7.4/static/datatype.html#DATATYPE-SERIAL
http://www.postgresql.org/docs/faqs/FAQ.html#4.15.2
On Fri, 13 Aug 2004 [EMAIL PROTECTED] wrote:
> Hi I'm a newbie in postgresql, I came from MSSQL, MySQ
[EMAIL PROTECTED] wrote:
when insert rows:
insert into table1 (field1) values (1);
insert into table1 (field1) values (1);
insert into table1 (field1) values (2);
and then select * from table1, you get:
field1| field2
--+---
1 | 1
1 | 2
2 | 1
--+---
Do you mean:
field
On Fri, Aug 13, 2004 at 13:50:48 -0300,
[EMAIL PROTECTED] wrote:
> Hi I'm a newbie in postgresql, I came from MSSQL, MySQL and now
> I'm testing postgres.
> In mysql there is a way to make a second autoincrement field, just:
Use serial for the type. You probably want to read up on sequences
and
Hello,
El 13/08/2004 10:50 AM, [EMAIL PROTECTED] en su mensaje
escribio:
Hi I'm a newbie in postgresql, I came from MSSQL, MySQL and now
I'm testing postgres.
In mysql there is a way to make a second autoincrement field, just:
create table table1
(field1 integer,
field2 integer autoincrement,
prim
Right, you can not use them both because the statistics per statement
and per-stage can't be done with the one set of system counters we have.
The server logs should show the cause with a description of this.
This wasn't documented in the docs but I just added something.
---
Thanks for the info.
--- Bruce Momjian <[EMAIL PROTECTED]> wrote:
>
> Right, you can not use them both because the
> statistics per statement
> and per-stage can't be done with the one set of
> system counters we have.
>
> The server logs should show the cause with a
> description of this.
>
>
Hi I'm a newbie in postgresql, I came from MSSQL, MySQL and now
I'm testing postgres.
In mysql there is a way to make a second autoincrement field, just:
create table table1
(field1 integer,
field2 integer autoincrement,
primary key (field1,field2))
when insert rows:
insert into table1 (field1)
When I enable log_statement_stats AND log_parser_stats
in my postgresql.conf file and attempt the start the
service I receive the following error:
"Could not start the PostgreSQL Database SErver
8.0-beta1 service on Local Computer. The service did
not return an error."
Attempting to start the se
>
> Does anyone know what's the most reliable platform postgresql can run on?
> With or without scheduled downtime?
This reminded me... Not long ago I was looking at used sun servers. You
can pick up refurbished sun enterprise systems for between $4,000 and
$10,000 fairly easily. For instance
I find 7.3 and 7.4 to be rock solid on dual processor servers of Intel P4 and Xeon
running RH9 and
Xeon running Fedora Core 2.
My systems run heavy load for about 6 hours straight each night when it is syncing
data with legacy
systems (disk io and cpu maxed out).
I don't use replication, just n
Hi ,
can anybody tell me the postgres - syntax for begin excepion end if I
want to ignore the error?
BEGIN
exception ...
EXCEPTION
WHEN OTHERS THEN ?what to write for do nothing?
END;
in oracle it's
WHEN OTHERS THEN null; but this syntax doesn't work in postgres.
thnx
Daniel
Most replication systems add a fair amount of complexity. How reliable are
current replication systems? Are they replication systems for performance
or for reliability+availability?
How much does it cost to make sure that the probability of both master and
failover machines failing is lower or
Hi Tom,
WARNING: Index pg_statistic_relid_att_index: NUMBER OF INDEX' TUPLES
(163) IS NOT THE SAME AS HEAP' (345).
Recreate the index.
Should these errors worry me?
Yeah, they should. A REINDEX will probably get you out of the immediate
problem, but the more interesting question is how
Ulrich Wisser <[EMAIL PROTECTED]> writes:
> WARNING: Index pg_statistic_relid_att_index: NUMBER OF INDEX' TUPLES
> (163) IS NOT THE SAME AS HEAP' (345).
> Recreate the index.
> Should these errors worry me?
Yeah, they should. A REINDEX will probably get you out of the immediate
proble
Ulrich Wisser <[EMAIL PROTECTED]> writes:
> -bash-2.05b$ postgres -D /var/lib/pgsql/data/ -O -P CLIX1
> ...
> backend> REINDEX DATABASE CLIX1
> ERROR: REINDEX DATABASE: Can be executed only on the currently open
> database.
The database name is evidently all upper case, so you need double
quotes
[EMAIL PROTECTED] wrote:
Hi;
I am being asked if the ODBC drivers are "compliant to 3.x
standards with backwards compatibility to 2. x functions". We
are currently using 7.3.5 and the last ODBC driver I downloaded
for use on Windows is psqlodbc-07_03_0200.zip
I have had a peruse about and not
Hi;
I am being asked if the ODBC drivers are "compliant to 3.x
standards with backwards compatibility to 2. x functions". We
are currently using 7.3.5 and the last ODBC driver I downloaded
for use on Windows is psqlodbc-07_03_0200.zip
I have had a peruse about and not found any info about
st
Hello,
yesterday I took our database down and started in single user mode.
After reindexing of three tables I thought a vacuum would be a good idea.
backend> VACUUM FULL VERBOSE ANALYZE
WARNING: Index pg_statistic_relid_att_index: NUMBER OF INDEX' TUPLES
(163) IS NOT THE SAME AS HEAP' (345).
Hello,
the maintainance chapter in the docs gave me the impression that a
reindex of some tables would be a good idea. Last night I took the
database down, started up in single user mode and tried to reindex.
The reindex of tables did work fine, but a reindex of the database
did not. Please see
21 matches
Mail list logo
