available from www.greatbridge.org
HTH,
Poul L. Christiansen
Mateusz Mazur wrote:
>
> Hello.
>
> Could you help me? I have database in psql and my boss want to have this
> base also is MS Access (only like client - main base will be psql). He wants
> to use access like viewer
Yes, there is.
When you create a serial column a sequence is created, which does the
counting.
You can create a serial column, drop the associated sequence and create
a new one with the command:
"CREATE SEQUENCE seqname START 1000".
See also "\h CREATE SEQUENCE".
HTH,
Poul L. Christansen
cbel
Use the "serial" column type.
create table myTable (row_no serial,column1 varchar(10),column2
varchar(20));
HTH,
Poul L. Christiansen
On Wed, 11 Apr 2001, Kovacs Zoltan wrote:
> Maybe a trivial question, maybe it's foreign from SQL, I'dont know...
> How to add a c
understand the output of a vacuum verbose, but I'm sure other
people on this list do :-)
Poul L. Christiansen
On Wed, 28 Mar 2001, A James Lewis wrote:
>
> I have a vacuum which has been running for about a week, is that too long?
>
> On Wed, 28 Mar 2001, Poul L. Christiansen w
long have you
waited? Is there any error message?
Poul L. Christiansen
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Log into PostgreSQL using psql and run the help command:
"\h create trigger".
See also:
http://www.postgresql.org/users-lounge/docs/6.5/postgres/sql-createtrigger.htm
HTH,
Poul L. Christiansen
On Sun, 25 Mar 2001, [iso-8859-1] Mohamed ebrahim wrote:
> Hi
> I am an user
Could you post the SQL/CF code?
What type of field is the field in the database?
I've used Cold Fusion and PostgreSQL and it seems to work fine for me.
Poul L. Christiansen
[EMAIL PROTECTED] wrote:
> Hello there
>
> Using coldfusion 4.5.1 together with postgreSQL 7.0.3 I try
I have a bash script in crontab with the following line:
"lynx -dump
http://127.0.0.1/postgres/myPhpFile.php>${currentDir}php_output.html"
You can also just put that line directly into crontab.
Poul L. Christiansen
Bernie Huang wrote:
> Hello,
>
> My boss wants me
ore PostgreSQL starts because the change will be set
back to the default value when Linux restarts.
Poul L. Christiansen
[EMAIL PROTECTED] wrote:
>
> Hi,
> how can I configure my kernel to make it work with shared memory blocks of
> 8Mb?
> I'm using RedHat 6.2
>
> Than
My guess is that you don't have enough RAM.
Maybe it can work if you first unzip the file, then log into database
internal and use the command "\i data.dump" to load the data.
If that doesn't work, try splitting up the file and load the files
separatly.
Poul L. Christia
ezone' | LOCAL | DEFAULT }
SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE }
test=# show transaction isolation level;
NOTICE: TRANSACTION ISOLATION LEVEL is READ COMMITTED
SHOW VARIABLE
test=#
HTH,
Poul L. Christiansen
Keith Wong wrote:
>
> Hi all,
>
> Does anybo
Jan Wieck wrote:
> Poul L. Christiansen wrote:
> > I've just split the text up (in 8 pieces), so it fits into 8K rows. But thats
> > only a viable solution if your text is less than a couple of 100K's.
> >
> > You could try to be a daredevil and use the Toa
1
plc=# update radius set destinationip = '212.055.059.001';
ERROR: query rewritten 10 times, may contain cycles
This means that it's going in a loop, because the rule triggers itself.
Is there another way to do this?
Thanks,
Poul L. Christiansen
I'm not familiar with rules. Could you please post the SQL for creating the rule
that you've created?
I going to make such a setup in the near future and this seems to .
Joerg Hessdoerfer wrote:
> Hi!
>
> Thanks all for your input...
>
> At 09:15 17.08.00 -0700, you wrote:
> [...]
> > > Questio
Isn't easier to reduce the table every day and make a daily vacuum which only
lasts a few seconds?
Joerg Hessdoerfer wrote:
> Hi!
>
> I have an application, where I have to insert data into a table at several
> rows per second, 24 hours a day, 365 days a year.
>
> After some period (a week, mayb
I've just split the text up (in 8 pieces), so it fits into 8K rows. But thats
only a viable solution if your text is less than a couple of 100K's.
You could try to be a daredevil and use the Toast code, even if it's beta. But
I don't know how far the Toast project has come.
Keith Wong wrote:
>
You could possibly use grep and awk to filter the output.
See "man grep" and "man awk" for details.
"Brian C. Doyle" wrote:
> Hello all,
>
> I am trying to out put the tables of a database. I have
>
> psql -d mydb -c "\d"
>
> This works but I am looking at turning on the html out put which it w
Use the command "pg_dumpall" to dump all databases to disk in SQL
format.
I don't know if there is any function for taking a backup of the work
done during the day.
We just dump all databases every day, to make a backup.
Poul L. Christiansen
GANESH KUMAR wrote:
> I WANT TO
18 matches
Mail list logo
