According to my test, it does not:
test=# set default_tablespace = testsp;
SET
test=# create table a (i int);
CREATE TABLE
test=# select * into b from a;
SELECT
test=# \d+ b
Table "public.b"
Column | Type | Modifiers | Description
+-+---+-
i
Title: bigserial coloumn
I have a table in which one attribute "id" is a bigserial
when i say
select setval('table_id_seq', 0);
it says: values 0 is out of bounds.
what should i do?
Regards
Surabhi Ahuja
Actually, I would find this to be an interesting project, but we're
on the verge of moving to 8.0 via Slony and will have a replicated
cluster, reducing the need for live dumps on the primary read/write
database.
It's too bad round tuits are so expensive!
I was trying to think of a way tod
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
> I'd like to use pg_dump to grab a live backup and, based on the
> documentation, this would seem to be a realistic possibility. When I
> try, though, during business hours, when people are frequently
> logging in and otherwise using the appl
So the search_path can not substitute the Oracle synonyms function which in a single way allow us to write generic queries for an application no matter the schema which is being used.I can not find a solution on this matter in PostgreSQL.I hope anybody can help me on this subject. The problem is no
On Mon, 2005-05-23 at 16:54, Chris Kratz wrote:
> Hello Thomas,
>
> We've had and have the exact same issue and have been unable to find a
> satisfactory solution to the problem. Currently we "just live with it". We
> do periodic backups with pg_dump on an hourly basis. During the dump, other
Hello Thomas,
We've had and have the exact same issue and have been unable to find a
satisfactory solution to the problem. Currently we "just live with it". We
do periodic backups with pg_dump on an hourly basis. During the dump, other
accesses to the db are incredibly slow making our web ap
The real problem is that with 7.4's buffering algorithm, the sequential
scans blow the other data out of the internal buffers of postgresql.
And, since a backup needs all the data in the tables, it's gonna seq
scan them anyway. the tables can still be accessed, just the access is
going to be slow
A note about database design, though: there are thousands of tables
in this database, most of them inherited. I haven't looked at the
internals of pg_dump, but generally, how do the sequential scans
work? Why would these prevent the tables from being accessed by
queries that don't require e
Okay, I collated the three replies I got below for ease in replying.I vacuum full analyze and reindexdb approximately once a month, but I use pg_autovacuum as a matter of ongoing maintenance, and it seems to hit equilibrium pretty well and seems to prevent bloat. The last time I checked a vacuum an
Bingo -
Thanks!
On May 23, 2005, at 1:14 PM, Scott Marlowe wrote:
On Mon, 2005-05-23 at 14:58, Scott Frankel wrote:
After a server crash forced a reboot, `pg_ctl start` fails with a
FATAL
error. Log output says that the lock file, postmaster.pid, already
exists.
Can I just su to root and
On Mon, 2005-05-23 at 16:17 +0300, Postgres General wrote:
> I am trying to setup a "hot standby" on a second machine.
> I have created a "recovery.conf" file and started a restore with logs
> from the primary machine. everything was OK.
>
> now a have new transaction logs generated by the primar
What's you pg_dump command? Some options may take a lot of memory.
If you list the processes while this is going on, do you see one
chewing all your memory? i.e what's really causing the problem...
Hope this helps,
On Mon, May 23, 2005 at 02:54:46PM -0500, Thomas F. O'Connell wrote:
> I have a w
Thomas F. O'Connell wrote:
I have a web application backed by a PostgreSQL 7.4.6 database. It's
an application with a fairly standard login process verified against
the database.
I'd like to use pg_dump to grab a live backup and, based on the
documentation, this would seem to be a realistic
On Mon, 2005-05-23 at 14:54, Thomas F. O'Connell wrote:
> I have a web application backed by a PostgreSQL 7.4.6 database. It's
> an application with a fairly standard login process verified against
> the database.
>
> I'd like to use pg_dump to grab a live backup and, based on the
> documentation,
On Mon, 2005-05-23 at 14:58, Scott Frankel wrote:
> After a server crash forced a reboot, `pg_ctl start` fails with a FATAL
> error. Log output says that the lock file, postmaster.pid, already
> exists.
>
> Can I just su to root and delete the .pid file to relaunch? Or will
> this have nasty
After a server crash forced a reboot, `pg_ctl start` fails with a FATAL
error. Log output says that the lock file, postmaster.pid, already
exists.
Can I just su to root and delete the .pid file to relaunch? Or will
this have nasty side-effects?
Thanks in advance!
Scott
I have a web application backed by a PostgreSQL 7.4.6 database. It's an application with a fairly standard login process verified against the database.I'd like to use pg_dump to grab a live backup and, based on the documentation, this would seem to be a realistic possibility. When I try, though, du
You can buy the SQL Standard from ANSI in PDF format for $18 per book
(there are several books).
http://webstore.ansi.org/ansidocstore/find.asp?
Under "Search" type in SQL and hit the go button.
You can get draft versions for free. For instance:
http://www.cse.iitb.ac.in/dbms/Data/Papers-Other/S
On Mon, 2005-05-23 at 12:18, Mark Harrison wrote:
> So, I was trying to figure out which was close to standard sql:
>
> select * from foo limit 10
> or
> set rowcount 10 select * from foo
>
> and couldn't find much relevant information via google.
>
> Is the sql standard on the web, an
So, I was trying to figure out which was close to standard sql:
select * from foo limit 10
or
set rowcount 10 select * from foo
and couldn't find much relevant information via google.
Is the sql standard on the web, and is there some document
about the syntax variations between sybase,
Scott Marlowe wrote:
On Thu, 2005-05-19 at 15:10, Mark Harrison wrote:
Sadly, lots of people in positions of power still want scape goats,
rather than proven results.
No, it could be that the OP's organization is looking for some proof
of postgresql's results.
That's a bit out of context.
On Mon, 2005-05-23 at 10:14, Douglas McNaught wrote:
> Postgres General <[EMAIL PROTECTED]> writes:
>
> > what is the procedure for creating a "hot standby" (continuously
> > feeding a series of WAL files created by the primary machine into the
> > secondary one) ?
>
> There currently isn't one.
I f you are using Apache, also check the max connections in the
httpd.conf. You really can't allow more Apache children than your max
number of Postgres connections. At least it solved the problem in my
case.
On May 23, 2005, at 9:47 AM, Richard Huxton wrote:
Shaun Clements wrote:
Thanks. G
You are perfectly right, the file still exists and here are the last lines
in the Server log before the crash occured.
Sorry for the length of this mail. Tell me if you prefer an attached file
for such traces next time...
ERROR: duplicate key violates unique constraint
"pg_class_relname_nsp_in
On Mon, May 23, 2005 at 09:07:08AM -0300, [EMAIL PROTECTED] wrote:
> Thank you very much for your answer.
>
> What happens if there are more than one table with the same name in the
> "search_path" ?
It takes the first one.
There is no explicit relationship between users and schemas, however
man
Douglas McNaught <[EMAIL PROTECTED]> writes:
> Kelly Burkhart <[EMAIL PROTECTED]> writes:
>> I used C++ and noticed that some Postgres headers contain C++ keywords.
>> Is there any interest among PG developers in making the C-language
>> interface C++ clean? Or, is there hostility to this idea?
greg landrum <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> text = DatumGetCString(DirectFunctionCall1(varcharout, text_datum));
> This form of dealing with arguments is interesting to learn about. Is
> there any documentation of this stuff or do I need to dive into the source?
The original mo
On Mon, May 23, 2005 at 04:40:12PM +0200, Patrik Kudo wrote:
> Hi!
>
> I've got a problem I can't seem to find an answer to. The problem is
> simplified by this example:
>
> 1. We have two tables:
>
> create table asdf (id serial primary key,
> data text);
> create table qwert (id serial,
> data
On Mon, May 23, 2005 at 09:13:00AM -0500, Kelly Burkhart wrote:
> I used C++ and noticed that some Postgres headers contain C++ keywords.
> Is there any interest among PG developers in making the C-language
> interface C++ clean? Or, is there hostility to this idea?
Hmm, it seems C++ is joining
[EMAIL PROTECTED] writes:
> Do you have any idea on the reason of this situation ?
No, I was hoping we might see some clues but there wasn't much. Both
the pg_depend entries and the pg_type row should have been deleted by
the same transaction that deleted the pg_class row. Partially applied
tran
Postgres General <[EMAIL PROTECTED]> writes:
> what is the procedure for creating a "hot standby" (continuously
> feeding a series of WAL files created by the primary machine into the
> secondary one) ?
There currently isn't one. I think someone may be working on it.
-Doug
Kelly Burkhart <[EMAIL PROTECTED]> writes:
> I used C++ and noticed that some Postgres headers contain C++ keywords.
> Is there any interest among PG developers in making the C-language
> interface C++ clean? Or, is there hostility to this idea?
Postgres is written in C. AIUI it's somewhat dan
Tom Lane wrote:
"Felix E. Klee" <[EMAIL PROTECTED]> writes:
BTW, a more future-proof way of doing what you want:
VarChar *text = PG_GETARG_VARCHAR_P(0);
int text_len = VARSIZE(text)-VARHDRSZ;
char *tmp_text = (char *)malloc(text_len+1);
if (tmp_text == NULL)
; /* What now?
Thanks for the help.
Do you have any idea on the reason of this situation ?
Is there any information I can provide if the problem happens again to help
find the problem : any log level to raise ?
Patrick
---
[EMAIL PROTECTED] writes:
> classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype
> -++--++--+-+
> -
> 1247 | 463559 |0 | 1259 | 463558 | 0 | i
> 1259 | 463558 |0 |
Hi!
I've got a problem I can't seem to find an answer to. The problem is
simplified by this example:
1. We have two tables:
create table asdf (id serial primary key,
data text);
create table qwert (id serial,
data integer references asdf
on delete cascade on update cascade);
2. We populate bot
You can manually add the npgsql dll to the toolbar so that you can use
the npgsql ado.net data objects in the same way as ado.net oledb
objects.
To do this right click on the toolbar.
Select Add/Remove Items
Browse to and add the npgsql.dll
Click ok and the npgsql objects will have been added to
alis=# select * from pg_depend where objid in ( 463558, 463559 ) or refobjid
in ( 463558, 463559 );
classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype
-++--++--+-+
-
1247 | 463559 |0 | 1259
I've written a simple function to return a list of processes running on
the server. The function uses the Linux /proc filesystem, so is not
portable. Usage is like this:
tradebot01@ [local] => select * from tb_ps() where command like
'%post%';
pid | username |command
[EMAIL PROTECTED] writes:
> The error happens when I try to create other temporary tables.
> Here is a part of my Server Log :
> ERROR: cache lookup failed for relation 463558
> CONTEXT: SQL statement "CREATE TEMP TABLE Tmp_MsgRxOrder ( EventId int4,
> CodeRef int4 )"
> PL/pgSQL function
Paolo Tavalazzi <[EMAIL PROTECTED]> writes:
> My feeling is that having to only confront the value key venue_code with a
> variable value and a constant value "*",
> it can be possible to create an operator that it manages this type of query
> using a hashjoin clause.
> Is it possible??
No.
The Npgsql driver does have windows forms integration, but I do not use
this part or know if it is compatible with VS 2005. Try the
documentation or check the npgsql user list
([EMAIL PROTECTED]).
Howard Cole.
www.selestial.com
Philippe Lang wrote:
Is there a way to install the npgsql driver
The error happens when I try to create other temporary tables.
Here is a part of my Server Log :
ERROR: cache lookup failed for relation 463558
CONTEXT: SQL statement "CREATE TEMP TABLE Tmp_MsgRxOrder ( EventId int4,
CodeRef int4 )"
PL/pgSQL function "adm_ne" line 248 at SQL statement
S
I'd like to understand if it is possible to find a
solution to the problem that we have on ours DB in production.
I make an example simplified in order to explain
itself better:
We have 2 table :
TABLE vendor ( group TEXT, client
TEXT, vdr_venue_code CHAR(8), vdr_location_code
CHAR(8))
> Hi,
>
> Does anyone successfully use a .Net Data provider for Postgresql? I was
> able to find two of them:
>
> - npsgsql open-source driver
Npgsql is very good. Francisco on the mailing lists is very helpful.
However you may have to watch timezone issues when using .net. All
timestamps are conv
Shaun Clements wrote:
Thanks. Great idea.
I assume there is more than one connection per user.
As judging by the scope of the system, more than one connection is made.
Would you suggest I increase the size of the connections.
What kind of performance decrease would I see, even if 100 isnt always
Hi,
Is there a way to install the npgsql driver under Visual Studio so it appears
as a set of visual controls we can drop on a form, or is it a code library only?
-Message d'origine-
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Howard Cole
Envoyé : lundi, 23. mai 2005 1
Title: RE: [GENERAL] Postgres PHP error
Thanks. Great idea.
I assume there is more than one connection per user.
As judging by the scope of the system, more than one connection is made.
Would you suggest I increase the size of the connections.
What kind of performance decrease would I see, eve
Shaun Clements wrote:
Hi All
Im receiving the following error, on a php page, conneting to postgres 7.4,
installed on Mandrake 10.0
Error Description: pg_connect(): Unable to connect to PostgreSQL server:
FATAL: sorry, too many clients already .
Can anyone tell me what this means?
It mean
I have been using the npgsql driver on both .NET and Mono for over 6
months now with no problems.
Howard Cole
www.selestial.com
Philippe Lang wrote:
Does anyone successfully use a .Net Data provider for Postgresql? I was
able to find two of them:
---(end of broadc
Title: [GENERAL] Postgres PHP error
Hi All
Im receiving the following error, on a php page, conneting to postgres 7.4, installed on Mandrake 10.0
Error Description: pg_connect(): Unable to connect to PostgreSQL server: FATAL: sorry, too many clients already .
Can anyone tell me what this
[EMAIL PROTECTED] writes:
> I have a server installed with Postgres 8.0.2 on Solaris.
> Since two days, I get the error : "ERROR: cache lookup failed for =
> relation
> 463558"
What SQL command(s) produce that error, exactly?
> When I look with the pgAdmin at my database, I see that I have in =
hello,
I am trying to setup a "hot standby" on a second machine.
I have created a "recovery.conf" file and started a restore with logs
from the primary machine. everything was OK.
now a have new transaction logs generated by the primary machine and I
want to "play" them on the secondary one.
I'd like to understand if it is possible to find a solution to the problem
that we have on ours DB in production.
I make an example simplified in order to explain itself better:
We have 2 table :
TABLE vendor (
group TEXT,
client TEXT,
vdr_venue_code CHAR(8),
vdr_location_code CHAR(8)
)
Of course! Maybe I am mixing users and schemas, because in Oracle they are the same, the schema has the name of the user which is the owner of the database tables and objects.So the problem can be described as follows :1. Let be Ent01 an enterprise, and Ent02 a different one.2. At Ent01 the databas
Em Dom 22 Mai 2005 20:13, Panos Tsapralis escreveu:
> I would like to avoid compiling the POSTGRESQL source files in order to
> install it on my new Mandrake 10.1 Community system (I am relatively new
> to Linux "tactics" and I am afraid I will have to spend too much time
> trying to get it to work
Hi,
Does anyone successfully use a .Net Data provider for Postgresql? I was
able to find two of them:
- npsgsql open-source driver
- crlab provider (which does not install correctly for me)
Any recommendation?
Thanks
--
Philippe Lang
---
Thank you very much for your answer.What happens if there are more than one table with the same name in the "search_path" ?Jayme Jeffman FilhoGSEE-PUCRS+55 51 91123422
On Thu, May 19, 2005 at 10:38:27AM -0400,
Hrishikesh Deshmukh <[EMAIL PROTECTED]> wrote
a message of 12 lines which said:
> If someone can email Postgresql 7.4.7 docs(PDF). It will be a big
> help. I am unable to get pdf docs for this version on debian system.
Beginner in Debian system adminis
Hi,
I have a server
installed with Postgres 8.0.2 on Solaris.
Since two days, I
get the error : "ERROR: cache lookup failed for relation
463558"
When I look with the
pgAdmin at my database, I see that I have in pg_temp_4 schema, a type called
"tmp_d_alarm" which is the name of a tempor
61 matches
Mail list logo
