In postgresql 7.3.2 if the server shuts down
abruptly then sequence does not behave properly.
Next val after rebooting server shows gsp between
last number & next val
Hello,
I am a student at the university of Bradfordat the department of Computing. In
the labs we use postgeSQL. If it is possible can you please inform me how I can
create .dat files with the information of the tables of the existing database
and a .sql file which will have the tables that are cr
Hi,
I am having problems with my connectivity for any of the users other
than the post gres. Let me elaborate on the situation
I am using OSX and i have changed the pg_hba.conf file to reflect
ident_authentication. I have attached my pg_hba.conf file. When i try
connecting as a user i get
Hi all, im new in this and my question can sound stupid, here is the
thing, i have a server wich have 3 databases, each one with different
users(user1, user2 and user3)
user1 have : db1, db2 and db3
user2 have : example1
and user3 have : pgadmin
Im trying this :
I want that user1 have access
Hi, all
I have a postgresql 7.4 running on mandriva linux 10.1 with 512M RAM & AMD
2000+ CPU. I increased system share memory to 128M, buffer to 64M, sort memory
to 32M. A single query do finish much faster. Now I need to analyze some weekly
data involving hundred queries with 'group by order by'
Hello,
We use the PostgreSQL ODBC to track our
released software. We have several Windows (XP, 2000)
desktops and laptops with the PostgreSQL clients. I have
tried, several times, to install the client on my Windows XP
laptop without success.
The process I have used is the same one tha
I'm sure this is a simple question but the docs only go as far as "For all
indexes except the shared system catalogs, REINDEX is crash-safe and
transaction-safe."
I have a transaction that imports about 2.3 GB of data as pairs of DELETE
FROM / COPY.
What is the difference between reindexing ta
> Hello all,
>
> I am trying to install PG through a program for which i need
> to create a user on Windows programmatically. As I understand
> the Postgres installer does a similar thing. Can someone help
> me with the commands/exe that can be used on Windows 2k,XP,2003.
If you want to creat
I've found pg_diff, a ruby script, wich does the job - not quite.
The issue is like this:
I have a database on few production servers, some 40 tables with 60
views, 120 types and 250 functions. The functions are used for internal
application bussines logic, as for the interface to the application
Assuming your New.dt is a date type and NEW.months is an integer, you
probably want to change your expression to something like:
NEW.dt + (NEW.months * INTERVAL '1 month')
Also a good read:
http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html
Jason Minion
-Original Mess
Hello all, I am trying to install PG through a program for which i need to create a user on Windows programmatically. As I understand the Postgres installer does a similar thing. Can someone help me with the commands/exe that can be used on Windows 2k,XP,2003. Regards Mohamed FazilMohame
August,I am currently tracing them using google mail alerts, proven fast and easy to setup/tune.Regards,G.-On 2/28/06, August Zajonc
<[EMAIL PROTECTED]> wrote:Great idea. Thanks!
Marc G. Fournier wrote:>> Best thing to do is setup a filter looking for anything from> @postgresql.org, since any rele
dear All
I am use Trigger in my database . In This trigger i want to add months
in date.
date and no of month come from insert query mean NEW.dt or NEW.months
new date = NEW.dt + NEW.months
I dont know how to add month in a date in trigger.
Please help me
Ramesh Patel
System Dept.
Banasdai
13 matches
Mail list logo
