On Monday 10 April 2006 07:18, sandhya wrote:
> Hi...
> I want to know more about alter user /creating users.I am facing error if
> i give user with Login/Nologin..Why is it so? But it is working fine for
> Createdb/NoCreatedb.etc.
>
> sample=# ALTER user sandhya with LOGIN;
> ERROR: syntax error
Hi, How can I change “System Language” in
the Postgres Database ?
I Have PostGes Server 8.1 for Windows and I use
Postgres SQL Tool version 1.4.1
Thanks
Andrea De Santi
it was postgresql version 7.3.10 and we recovered access
by dumping and recreating (new initdb) the database.
everything is allright now.
we had never used the vacuum before (database was up
for about two months). after doing that too things were
speeding up again. but that couldn't be the caus
Bruce Momjian writes:
> Tom Lane wrote:
>> It definitely is a pain in the neck that GNU tar complains about files
>> changing underneath it --- I've looked for a way to disable that, or at
>> least reduce it to a warning instead of an error condition, but gtar
>> doesn't seem to have such a switch
Tom Lane wrote:
> It definitely is a pain in the neck that GNU tar complains about files
> changing underneath it --- I've looked for a way to disable that, or at
> least reduce it to a warning instead of an error condition, but gtar
> doesn't seem to have such a switch. You should try alternative
Jim C. Nasby wrote:
> On Mon, Mar 27, 2006 at 09:28:43AM -0800, Sriram Dandapani wrote:
> > I was referring to the logs in the archive folder specified when WAL
> > archiving is turned on...not the pg_xlog folder.
> >
> > I assume postgres will not use the logs in the archive folder
>
> Correct.
TODO already has:
* Improve speed with indexes
For large table adjustments during VACUUM FULL, it is faster to
reindex rather than update the index.
---
Tom Lane wrote:
> Peter E
Hi...
I want to know more about alter user /creating users.I
am facing error if i give user with Login/Nologin..Why is it so?
But it is working fine for
Createdb/NoCreatedb.etc.
sample=# ALTER user sandhya with LOGIN;ERROR: syntax
error at or near "LOGIN" at character 25LINE 1: ALTER user
Hi..
If i want to change the datatype of a column in a
table.What are all the thigs i need to take care off.
After somany records insertion if i change the datatype of the
column..What will be the effect of it.
Please tell me /give suggestion what needs to be cosider at
the time of chan
mySQL uses a weird CREATE TABLE syntax (with added options like table engine
type etc) that Postgres errors on - so some manual editing of the SQL dump
will be necessary. An export tool is probably the best way to go, that'll
read data from one ODBC driver and write it to another. www.sqlmanager
10 matches
Mail list logo
