Reputation
259
Top tag
Next privilege 300 Rep.
Create new tags
Badges
1 6 15
Impact
~39k people reached

  • 0 posts edited
  • 0 helpful flags
  • 8 votes cast
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?
Mar
15
awarded  Popular Question
Dec
26
awarded  Notable Question