Hello,
I sometimes define some access rights on table columns instead of whole
table. Everything works fine except when I perform a dump.
When I dump a databse that contains such access rights, the pg_dump utility
generates commands like this one :
GRANT SELECT(Login) ON TABLE Clients TO
Hi,
I have need of a statement that updates the sequence but uses a max() to find
the number.
alter sequence somename restart with (select max(pk) from sometable).
I need this for automating an ETL (using pentaho).
Postgres 8.4
Thanks in advance,
Johnf
--
Sent via pgsql-sql mailing list
On Tue, Nov 15, 2011 at 8:06 AM, John Fabiani jo...@jfcomputer.com wrote:
alter sequence somename restart with (select max(pk) from sometable).
I need this for automating an ETL (using pentaho).
http://www.postgresql.org/docs/9.1/interactive/functions-sequence.html#FUNCTIONS-SEQUENCE-TABLE
On Nov 15, 2011 9:46 PM, Brice André br...@famille-andre.be wrote:
Hello,
I sometimes define some access rights on table columns instead of whole
table. Everything works fine except when I perform a dump.
When I dump a databse that contains such access rights, the pg_dump
utility generates
On Tuesday, November 15, 2011 08:33:54 am Richard Broersma wrote:
On Tue, Nov 15, 2011 at 8:06 AM, John Fabiani jo...@jfcomputer.com wrote:
alter sequence somename restart with (select max(pk) from sometable).
I need this for automating an ETL (using pentaho).
On Tue, Nov 15, 2011 at 4:28 PM, John Fabiani jo...@jfcomputer.com wrote:
On Tuesday, November 15, 2011 08:33:54 am Richard Broersma wrote:
On Tue, Nov 15, 2011 at 8:06 AM, John Fabiani jo...@jfcomputer.com
wrote:
alter sequence somename restart with (select max(pk) from sometable).
On Tue, Nov 15, 2011 at 5:33 PM, Samuel Gendler
sgend...@ideasculptor.com wrote:
On Tue, Nov 15, 2011 at 4:28 PM, John Fabiani jo...@jfcomputer.com wrote:
On Tuesday, November 15, 2011 08:33:54 am Richard Broersma wrote:
On Tue, Nov 15, 2011 at 8:06 AM, John Fabiani jo...@jfcomputer.com
On Tue, Nov 15, 2011 at 8:46 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Tue, Nov 15, 2011 at 5:33 PM, Samuel Gendler
sgend...@ideasculptor.com wrote:
On Tue, Nov 15, 2011 at 4:28 PM, John Fabiani jo...@jfcomputer.com wrote:
On Tuesday, November 15, 2011 08:33:54 am Richard Broersma
Sent from my iPhone
On Nov 15, 2011, at 7:49 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Tue, Nov 15, 2011 at 8:46 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
On Tue, Nov 15, 2011 at 5:33 PM, Samuel Gendler
sgend...@ideasculptor.com wrote:
On Tue, Nov 15, 2011 at 4:28 PM,