Reputation
264
Top tag
Next privilege 300 Rep.
Create new tags
Badges
2 6 16
Impact
~53k people reached

  • 0 posts edited
  • 0 helpful flags
  • 8 votes cast
Sep
11
awarded  Famous Question
Aug
4
awarded  Caucus
Apr
22
comment Is it possible to retain access to table that will be dropped and recreated?
@spaghettidba right right and right!
Apr
22
comment Is it possible to retain access to table that will be dropped and recreated?
@spaghettidba yes the user has access over schema!
Apr
22
comment Is it possible to retain access to table that will be dropped and recreated?
@vijayp no it does not it just drops the table and creates a new one.
Apr
22
asked Is it possible to retain access to table that will be dropped and recreated?
Apr
16
comment installing pgagent on centos
Actually i wanted os authentication. I have not set password for postgres.
Apr
15
asked installing pgagent on centos
Nov
6
awarded  Popular Question
Sep
24
awarded  Autobiographer
Sep
18
awarded  Notable Question
Jul
2
awarded  Curious
May
26
awarded  Notable Question
May
7
awarded  Famous Question
Nov
11
awarded  Notable Question
Oct
18
comment Error creating spatial index sqlserver
@ypercube I created the table using select * into to produce the structure but later I am using the same table structure in production as in question. If I run above two code in my development or production environment I will get the same error even after dropping the created table.
Oct
18
comment Error creating spatial index sqlserver
@ypercube I only have create index statement. I tried using ssms as well but the same error. I created the table using "select * into new_tbl from old_tbl" statement.
Oct
10
asked Error creating spatial index sqlserver
Apr
17
awarded  Popular Question
Mar
22
accepted What are the things need to be considered while creating tablespace?