Hello,everyone.
sorry to ask again.
I deleted one of my table using delete * from mytable,
anyway to recover it, I searched the mail list archive last week,
there's someone ask this queston before,and someone reply with
a python code to recover it,but I can't search the archive (the
On 10 Jan 2002 17:37:25 -0800, Tony Reina [EMAIL PROTECTED] wrote:
I'm reading the list through Google groups, but I haven't seen much
activity on admin, hackers, sql, etc. over the last few weeks. Are
there just not any posts or is something screwy with Google groups
newsserver?
I was hoping to
Hello,
I' m currently working with the PHPDOC team on maintaining and
keeping up-to-date the PHP manual. I proposed in the PHPDOC
list to include some information about database security issues.
It aims to be an introduction into the very basics of how to
access and manipulate databases
Does anyone know how I can delete a second template database without
blowing all the databses away? What happened was I was running initdb
and the user postgres didn't hvae rights to the db directory or
something and so I had to run it again, and there ended up being two
template databases,
Try pointing your news reader at news.postgresql.org itself ... we just
fixed a permissions problem wiht the posts goign to the lists, so Google
and all them might get a better flow now too ...
On 11 Jan 2002, Jules Alberts wrote:
On 10 Jan 2002 17:37:25 -0800, Tony Reina [EMAIL PROTECTED]
On 01/08/2002 09:17:03 PM Jason Earl wrote:
Why do you want a database where two tables have the same name? When
you do a SELECT * from Table1 what table do you expect PostgreSQL to
use?
I suspect Shamik is trying to do something like having a separate 'schema' (Oracle) for every user, and
Why do you want a database where two tables have the same name? When
you do a SELECT * from Table1 what table do you expect PostgreSQL to
use?
Now, that being said, it's possible to create temporary tables in
different connections with the same name. These tables will dissapear
when the
Tony / Phil,
my 2c on the Primary Key definition / usage. If you have any SQL / DDL code
that disagrees with the definitions below could you please repost them.
Tony Reina [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
[EMAIL PROTECTED] (Phill Kenoyer) wrote
Hi all,
we use postgresql 7.2 for a data logging/supervisor application running
24 hours a day, 7 days a week and 365 (and 6 hours) a year. Data are
inserted/deleted/updated each 1,5 minutes and for performance reason we
have to vacuum each day some tables. The problem is that vacuum
Dear Alls
I cannot get reasonable result for sorting on field with chinese data
Setting as follows :
linux locale : zh_TW.Big5
postgresql client and server : EUC_TW
please advise what's wrong with my setting and what should I do in order
to overcome this sorting problem.
Thanks a lot in
On Fri, 11 Jan 2002 17:39:06 +0900, Yasuo Ohgaki
[EMAIL PROTECTED] wrote:
Jules Alberts wrote:
On 10 Jan 2002 17:37:25 -0800, Tony Reina [EMAIL PROTECTED] wrote:
I'm reading the list through Google groups, but I haven't seen much
activity on admin, hackers, sql, etc. over the last few weeks.
Hi all
My problem is, my filesystem is full and I can't extend it, so can i use a
secondary filesystem ?
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to
help me please, I am using Postgresql, I want to know
if exists a limit in the number of rows to create a
function. I created a function using pgaccess, but
when I try to see it using PgAdmin, I can not see all
the lines I wrote. Thank you for your answers. I am
writting from Colombia (I am still
Greetings,
Is there support for Greek characters using ISO-8859-7 in the latest
production version of Postgres, v7.1.3?
I can see that it is possible to use
./configure --enable-multibyte[=encoding_system] --enable-locale
but the list of available encodings does not seem to include
Hello Everyone,
It has been sometime since I have installed PostgreSQL. It has been
running great with no crashes for like a year! But alas, my faithful
Sparc 20 turned belly-up. It is sad to loose an old friend @* | *@
I now have a Ultra10 :o) I've loaded Solaris 8 with the companion disk
Hello everybody.
Is there any way to check database status, or who is currently connected
to it.
I tried to drop database and got an error saying that other users using
this database.
So Iwanted to see who is connected right now to the database.
One more question is how can I see all tables in
Hi All,
Our application needs to do a moderate level of inserts into
the database as it runs. We can hit 100-200 inserts a second
under certain conditions - and it is not something we can batch up for
later processing. While testing out postgres I noticed
some trobling performance data under
I want to add replication capabilities to my postgresql installation. Can
anyone recommend a good way (open source or otherwise) to do so?
Basically, I have a web tracking application that must quickly and
reliably
store massive amounts of tracking data. Later, I run complex queries to
I did have this problem in the past. I have a table with three fields
set for the primary key. Somehow I would get dups in that table. I'm
not sure how as I am too busy to test it. I changed my insert queries
to check for existing data before the insert so I could get back to
work.
Someone
On Mon, 14 Jan 2002 18:11:59 +0100
Allan C. Huffman [EMAIL PROTECTED] wrote:
Hello Everyone,
It has been sometime since I have installed PostgreSQL. It has been
running great with no crashes for like a year! But alas, my faithful
Sparc 20 turned belly-up. It is sad to loose an old
It looks like the user you are when you install postgres does not know the
path to your compiler. Try installing gcc and use it instead of cc to
compile postgres. Make sure your user's .profile has the path to gcc before
installing.
Heather
- Original Message -
From: Allan C. Huffman
On Wednesday, January 9, 2002, at 10:31 PM, Roman Gavrilov wrote:
Hello everybody.
Is there any way to check database status, or who is currently connected to it.
I tried to drop database and got an error saying that other users using this database.
So I wanted to see who is connected right now
How do I get off this mailing list?
--
Andy Gussie
Network Administrator eFruit International, Inc. http://www.efruitinternational.com
President VI Massive, Inc. http://www.vimassive.net
On Tuesday, January 15, 2002, at 03:24 PM, Andy Gussie wrote:
How do I get off this mailing list?
You should have received an email like this when you subscribed:
From: [EMAIL PROTECTED]
Date: Tue Jul 03, 2001 10:31:54 AM Australia/Sydney
To: [EMAIL PROTECTED]
Subject: Welcome to the
Hi to All,
Can anyone tell me how to create
useable postgres user ID?
Problem
I create the postgres user ID
through postgres's CREATEUSER command. After the creation, I try to
usepsql -U userIDto login this user ID to
postgresql database server. But the server refuse the ID with some
25 matches
Mail list logo
